| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | COMPANY | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | CHAR | (N' ') | No | T8JU | JV_JOA | Allow NULL? |
| 4 | OVERHEAD_KEY | Overhead Key in Overhead Organzier | nvarchar | 10 | 0 | CHAR | (N' ') | No | T8JOH_OVERHEADS | JV_OVERHEAD_KEY | Allow NULL? |
| 5 | VENTURE | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | No | T8JV | JV_VENTURE | Allow NULL? |
| 6 | BASE_CONDT_KEY | A key that links the overhead to its base amount conditions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T8JOH_BASE_CONDT | JV_BASE_AMT_CONDITION_KEY | Allow NULL? |
| 7 | FORMULA_KEY | A key that links the overhead to its formula | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T8JOH_FORMULAS | JV_FORMULA_KEY | Allow NULL? |
| 8 | EXPENSE_ACCT | Expense Posting Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | JV_EXPENSE_POSTING_ACCOUNT | Allow NULL? |
| 9 | OFFSET_ACCT | Offset Posting Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | JV_OFFSET_POSTING_ACCOUNT | Allow NULL? |
| 10 | ADJUSTMENT_ACCT | Adjustment Posting Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | JV_ADJUSTMENT_POSTING_ACCOUNT | Allow NULL? |
| 11 | EXPENSE_RI | Recovery Indicator for expense line | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_EXPENSE_RECOVERY_INDICATOR | Allow NULL? |
| 12 | OFFSET_RI | Recovery Indicator for offset line | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_OFFSET_RECOVERY_INDICATOR | Allow NULL? |
| 13 | ADJUSTMENT_RI | Recovery Indicator for adjustment line | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_ADJUST_RECOVERY_INDICATOR | Allow NULL? |