| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | PARTN | JV partner | nvarchar | 10 | 0 | CHAR | (N' ') | No | | JV_PARTN | Allow NULL? |
| 4 | INTCOCD | Intercompany code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | JV_INTCOCD | Allow NULL? |
| 5 | CCTHRESH | Cash Call Threshold | decimal | 13 | 0 | DEC | ((0)) | Yes | | JV_CCTHRES | |
| 6 | PAPER | Indicator: Hardcopy billings | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_PAPER | Allow NULL? |
| 7 | EDI | Indicator: EDI to Owner | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_EDI | Allow NULL? |
| 8 | CONVNETIND | JV Convenience Netting Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_CONVNID | Allow NULL? |
| 9 | BFORMAT | JV Billing Format | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8J0R | JV_BFORM | Allow NULL? |
| 10 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ | Allow NULL? |
| 11 | EDICOMP | EDI Partner Code | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JV_EDICOMP | Allow NULL? |
| 12 | PPGROUP | Partner process group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8JOG | JV_PPGROUP | Allow NULL? |
| 13 | VECCTHRESH | Partner/Venture/Equity Group Cash Call Threshold | decimal | 13 | 0 | DEC | ((0)) | Yes | | JV_VETHRES | |
| 14 | PJCCTHRESH | Partner/Project Cash Call Threshold | decimal | 13 | 0 | DEC | ((0)) | Yes | | JV_PJTHRES | |
| 15 | PERSON | Name of employee responsible | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | NAME_ZPERS | Allow NULL? |
| 16 | TELFN | Telephone number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | JVA_TELFN | Allow NULL? |
| 17 | T819_ONLY | JV Generate 819 Transaction Set Only (no 810) | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_GEN_819 | Allow NULL? |
| 18 | BILLTHRES | Billing threshold (debit) | decimal | 13 | 2 | CURR | ((0)) | Yes | | JV_BILL_THRESH | |
| 19 | BILLTHRESC | Billing threshold (credit) | decimal | 13 | 2 | CURR | ((0)) | Yes | | JV_BILL_THRESH_C | |
| 20 | BILLTHRESA | Billing threshold active | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_BILL_THRESH_ACTIVE | Allow NULL? |
| 21 | BILLTHRESX | All billing reports suppressed | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_BILL_THRESH_SUPPR | Allow NULL? |
| 22 | BILLTHRESS | Prepare separate reports for suppressed periods | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_BILL_THRESH_SEP | Allow NULL? |
