| 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 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | CHAR | (N' ') | No | | JV_JOA | Allow NULL? |
| 4 | CONTRACT | JV Contract Number | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_CONTRAC | Allow NULL? |
| 5 | PAYSET | Set of Accounts to Which Payroll Burden Clearing Applies | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_PAYSET | Allow NULL? |
| 6 | DFPAY | % Drilling Payroll Burden in U.S. | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_DFPAY | |
| 7 | NDPAY | Non-Drilling % to Apply for U.S. Payroll Burden Clearing | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_NDPAY | |
| 8 | XSETCON | Set of Accounts to Exclude from Construction Overhead Calc. | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_XSETCON | Allow NULL? |
| 9 | XSETCAT | Set of Accounts to Exclude from Catastrophe Overhead Calc. | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_XSETCAT | Allow NULL? |
| 10 | CONRULE | Construction Overhead Rule | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8J8B | JV_CONRULE | Allow NULL? |
| 11 | CATRULE | Catastrophe Overhead Rule | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8J8B | JV_CATRULE | Allow NULL? |
| 12 | PER1 | Percent 1 (% Producing U.S., % Regular Canada) (JVA) | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_PER1 | |
| 13 | XPER1 | Exclusion Set of Accounts - Percent 1 (JVA) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_XPER1 | Allow NULL? |
| 14 | PER2 | Percent 2 (% Development U.S., % Special Canada) (JVA) | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_PER2 | |
| 15 | XPER2 | Exclusion Set of Accounts - Percent 2 (JVA) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_XPER2 | Allow NULL? |
| 16 | EXPRULE | Exploration Overhead Rule | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8J8B | JV_EXPRULE | Allow NULL? |
| 17 | DRLRULE | Drilling Overhead Rule | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8J8B | JV_DRLRULE | Allow NULL? |
| 18 | XSETCAP | Set of Accounts to Exclude from Capital Overhead Calc. | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | JV_XSETCAP | Allow NULL? |
| 19 | OFFCC | Overhead Offset Cost Centre - JV | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | JV_OFFCC | Allow NULL? |
| 20 | JOAPRTH | Perform Producing Well Threshold Calculation at JOA Level | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_JOAPRTH | Allow NULL? |
| 21 | RECDOC | Recurring Document Number - JV overheads | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | JV_RECDOC | Allow NULL? |
| 22 | FLATRATE | Flat Rate - JV overheads | decimal | 13 | 2 | CURR | ((0)) | Yes | | JV_FLATRAT | |
| 23 | ESCAL | Escalatable | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_ESCAL | Allow NULL? |
| 24 | ACLASS | Joint operating agreement class | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8J9F | JV_ACLASS | Allow NULL? |
| 25 | CRUSER | User who Created | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JV_CRUSER | Allow NULL? |
| 26 | CRTIME | Time Created | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | JV_CRTIME | Allow NULL? |
| 27 | CRDATE | Date Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JV_CRDATE | Allow NULL? |
| 28 | CHUSER | User who Last Changed | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JV_CHUSER | Allow NULL? |
| 29 | CHTIME | Time Last Changed | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | JV_CHTIME | Allow NULL? |
| 30 | CHDATE | Date Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JV_CHDATE | Allow NULL? |
| 31 | NONCOMP | Non-compulsory benefits rate for payroll burden clearing | decimal | 5 | 2 | DEC | ((0)) | Yes | | JV_NONCOMP | |
| 32 | DRILLP | Calculate Drilling Days using prior period. | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_DRILLP | Allow NULL? |
| 33 | ALLWBS | Calculate all WBS elements for overhead | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_ALLWBS | Allow NULL? |
