| 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 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | No | | JV_NAME | Allow NULL? |
| 4 | PAYTERMS | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 5 | BMETHOD | Billing Method | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8J0C | JV_BMETHOD | Allow NULL? |
| 6 | VTYPE | Venture Type | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_VTYPE | Allow NULL? |
| 7 | OPERATOR | Operator for Non-Operated Venture | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | JV_OPERAT | Allow NULL? |
| 8 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ | Allow NULL? |
| 9 | VCLASS | Venture class | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JT | JV_VCLASS | Allow NULL? |
| 10 | ITD | Inception to Date | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_ITD | Allow NULL? |
| 11 | CRUSER | User who Created | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JV_CRUSER | Allow NULL? |
| 12 | CRTIME | Time Created | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | JV_CRTIME | Allow NULL? |
| 13 | CRDATE | Date Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JV_CRDATE | Allow NULL? |
| 14 | CHUSER | User who Last Changed | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JV_CHUSER | Allow NULL? |
| 15 | CHTIME | Time Last Changed | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | JV_CHTIME | Allow NULL? |
| 16 | CHDATE | Date Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JV_CHDATE | Allow NULL? |
| 17 | BFORMAT | JV Billing Format | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8J0R | JV_BFORM | Allow NULL? |
| 18 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8JU | JV_JOA | Allow NULL? |
| 19 | VACTIVE | Block Joint Venture for Cutback and Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_PROCESS | Allow NULL? |
| 20 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | TTXJ | TXJCD | Allow NULL? |
| 21 | OUTPAYTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 22 | OUTTAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ | Allow NULL? |
| 23 | TXJCD2 | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | TTXJ | TXJCD | Allow NULL? |
| 24 | NBFORMAT | Joint Venture Non-billing Form | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8J3A | JV_NBFORM | Allow NULL? |
| 25 | BFREQ | JV Billing Frequency | char | 1 | 0 | NUMC | (N'0') | Yes | | JV_BFRQ | Allow NULL? |
| 26 | OVRDF | % Drilling Payroll Burden in U.S. | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_DFPAY | |
| 27 | OVRND | Non-Drilling % to Apply for U.S. Payroll Burden Clearing | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_NDPAY | |
| 28 | PCOCOSTC | Cost Centre for posting PCO expense | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | JV_PCOCC | Allow NULL? |
| 29 | PCOPROJK | Parent Company Overhead Expense WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | JV_PCOWBS | Allow NULL? |
| 30 | PCOORDNR | Parent Company Overhead Expense Order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | JV_PCOORD | Allow NULL? |
| 31 | KOSTL | Substitute Cost Centre | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | JV_VKOSTL | Allow NULL? |
| 32 | FUNDGROUP | JV Funding group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8JM | JV_FUNDGP | Allow NULL? |
| 33 | CHECKFC | Check Funding Currencies | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_CHECKFC | Allow NULL? |
| 34 | PROPERTY | JV Property ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_PROPERT | Allow NULL? |
| 35 | BILLTHRES | Billing threshold (debit) | decimal | 13 | 2 | CURR | ((0)) | Yes | | JV_BILL_THRESH | |
| 36 | BILLTHRESC | Billing threshold (credit) | decimal | 13 | 2 | CURR | ((0)) | Yes | | JV_BILL_THRESH_C | |
| 37 | BILLTHRESA | Billing threshold active | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_BILL_THRESH_ACTIVE | Allow NULL? |
| 38 | PSCHEM | Payment term schema | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8JPTS | JV_PSCHEM | Allow NULL? |
