| 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 | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 4 | ID | Line Item Identifier | nvarchar | 10 | 0 | CHAR | (N' ') | No | | J_3RF_TP_ID | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 7 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 8 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 9 | CNTTYPE | Transfer Pricing Contract Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_3RF_CNTTYPE | Allow NULL? |
| 10 | REASON_121 | Reason for Control of Transaction (121) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_121 | Allow NULL? |
| 11 | REASON_122 | Reason for Control of Transaction (122) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_122 | Allow NULL? |
| 12 | REASON_123 | Reason for Control of Transaction (123) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_123 | Allow NULL? |
| 13 | REASON_124 | Reason for Control of Transaction (124) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_124 | Allow NULL? |
| 14 | REASON_132 | Reason for Control of Transaction (132) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_132 | Allow NULL? |
| 15 | REASON_133 | Reason for Control of Transaction (133) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_133 | Allow NULL? |
| 16 | REASON_134 | Reason for Control of Transaction (134) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_134 | Allow NULL? |
| 17 | REASON_135 | Reason for Control of Transaction (135) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_REASON_135 | Allow NULL? |
| 18 | DESCR | Parameter Value Description | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_DESCR | Allow NULL? |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 20 | BC_TURNOVER | Turnover w/o VAT (Base criteria) | decimal | 21 | 2 | CURR | ((0)) | Yes | | J_3RF_TP_TURNOVER_WO_VAT_BC | |
| 21 | NBC_TURNOVER | Turnover w/o VAT (Non-Base criteria) | decimal | 21 | 2 | CURR | ((0)) | Yes | | J_3RF_TP_TURNOVER_WO_VAT_NBC | |
| 22 | BC_LIMIT | Controlled Transaction Amount Limit | decimal | 21 | 2 | CURR | ((0)) | Yes | | J_3RF_TP_LIMIT_AMOUNT | |
| 23 | NBC_LIMIT | Controlled Transaction Amount Limit | decimal | 21 | 2 | CURR | ((0)) | Yes | | J_3RF_TP_LIMIT_AMOUNT | |
| 24 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 25 | LDESC | Limit Description | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | J_3RF_TP_LIMIT_DESCRIPTON | Allow NULL? |
| 26 | NO_IN_TP | General Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FLAG | Allow NULL? |
