| 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 | IDCFM_BST_CFMA | BUKRS | Allow NULL? |
| 3 | VALUATION_AREA | Valuation Area | nvarchar | 3 | 0 | CHAR | (N' ') | No | IDCFM_BST_CFMA | TPM_VAL_AREA | Allow NULL? |
| 4 | GSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | IDCFM_BST_CFMA | VVSART | Allow NULL? |
| 5 | RANTYP | Contract Type | char | 1 | 0 | CHAR | (N' ') | No | IDCFM_BST_CFMA | RANTYP | Allow NULL? |
| 6 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BP_PARTNR_NEW | Allow NULL? |
| 7 | RREFKONT | Account Assignment Reference of Position Management | nvarchar | 12 | 0 | CHAR | (N' ') | No | TRACC_AA_REF | TPM_AA_REF | Allow NULL? |
| 8 | TRAN_CAT | Transaction Category | nvarchar | 3 | 0 | NUMC | (N'000') | No | IDCFM_BST_CFMA | TB_SFGTYP | Allow NULL? |
| 9 | POST_TYPE | Posting identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | IDPST_TYP | Allow NULL? |
| 10 | DIRECTION | Direction of flow | char | 1 | 0 | CHAR | (N' ') | No | | TB_SSIGN | Allow NULL? |
| 11 | TOLONG | Update Type for Transfer to Long-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRAN2L | Allow NULL? |
| 12 | TOMEDIUM | Update Type for Transfer to Medium-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRAN2M | Allow NULL? |
| 13 | TOSHORT | Update Type for Transfer to Short-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRAN2S | Allow NULL? |
| 14 | L2S | Update Type for Transfer from Long- to Short-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANL2S | Allow NULL? |
| 15 | M2S | Update Type for Transfer from Medium- to Short-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANM2S | Allow NULL? |
| 16 | L2M | Update Type for Transfer from Long- to Medium-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANL2M | Allow NULL? |
| 17 | S2M | Update Type for Transfer from Short- to Medium-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANS2M | Allow NULL? |
| 18 | M2L | Update Type for Transfer from Medium- to Long-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANM2L | Allow NULL? |
| 19 | S2L | Update Type for Transfer from Short- to Long-Term Account | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | IDCFM_TRANS2L | Allow NULL? |
| 20 | EXCLG | Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FAGL_LDGRP | Allow NULL? |
