| 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 | CODUL2FL_UUID | Correspondence object deal's 2nd underlying's flow UUID | varbinary | 16 | 0 | RAW | | No | | FTR_CODUL2FLID | |
| 3 | CODMD_UUID | Correspondence Object Deal's main data UUID | varbinary | 16 | 0 | RAW | | Yes | | FTR_CODMDID | |
| 4 | CODUL_UUID | Correspondence object deal's underlying data UUID | varbinary | 16 | 0 | RAW | | Yes | | FTR_CODULID | |
| 5 | CODUL2_UUID | Correspondence object deal's 2nd underlying data UUID | varbinary | 16 | 0 | RAW | | Yes | | FTR_CODUL2ID | |
| 6 | COMPANYCODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 7 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | FTI_POSRFHA | Allow NULL? |
| 8 | UL_NUMBER | Number of Underlying Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | FTI_RFHA_UL | Allow NULL? |
| 9 | FLOW_NO | Transaction flow | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TB_RFHAZB | Allow NULL? |
| 10 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TB_SFHAZBA | Allow NULL? |
| 11 | FLOWCLASS | Classification of flows and conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBKKLAS | Allow NULL? |
| 12 | FLOWCAT | Category of Flows and Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TB_SBKTYP | Allow NULL? |
| 13 | FLOWDIRECTION | Direction of flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSIGN | Allow NULL? |
| 14 | FLOW_DIR_TRANS | Direction of Transaction | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_RKONDGR | Allow NULL? |
| 15 | HOUSEBANK | Short key for own house bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_RHABKI | Allow NULL? |
| 16 | HOUSEBANKACC | Short key for house bank account | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_RHKTID | Allow NULL? |
| 17 | PAYER_PAYEE | Payer/payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_RPZAHL_NEW | Allow NULL? |
| 18 | PBANK | Partner bank details | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_RPBANK | Allow NULL? |
| 19 | PAYMT_TRANS | Payment transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SZART | Allow NULL? |
| 20 | PAYMT | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSCH | Allow NULL? |
| 21 | PAYMT_METHSUPP | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 22 | PAYMENT_DATE | Payment or Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZTERM | Allow NULL? |
| 23 | PAYMENT_AMT | Payment amount in payment currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BZBETR | |
| 24 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WZBETR | Allow NULL? |
| 25 | DUEDATE | Due date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DFAELL | Allow NULL? |
| 26 | LOCAMOUNT | Payment Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_HWBETR | |
| 27 | LOCRATE | Local currency rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | TB_KHWKURS | |
| 28 | NO_UNITS | No. of Units for Financial Instruments | decimal | 15 | 5 | DEC | ((0)) | Yes | | TB_ASTUECK | |
| 29 | UNIT_CURR | Price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WPRICE | Allow NULL? |
| 30 | CALC_DATE | Calculation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVALUT | Allow NULL? |
| 31 | INCL_VAL | Inclusive indicator for value date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSVINCL | Allow NULL? |
| 32 | MTHEND_VAL | Month-End Indicator for Value Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSVULT | Allow NULL? |
| 33 | ASS_NO | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 34 | LOC_CURR | Currency of Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_WGSCHFT | Allow NULL? |
