| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SV_STATE_ID | RM: ID of a Saved Data Status | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 4 | NGIDNR | Sequence Number for a Transaction ID in Primary Transaction | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | NCFNR | Consecutive Number for a Flow of an FGET | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | CFKNZ | Cash Flow Indicator | char | 1 | 0 | | | | Allow NULL? |
| 7 | RKONDGR | Direction of Transaction | char | 1 | 0 | | | | Allow NULL? |
| 8 | SSIGN | Direction of flow | char | 1 | 0 | | | | Allow NULL? |
| 9 | SCWHR | Currency of cash flow | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | BCWHR | Cash Flow Amount in Currency | decimal | 17 | 2 | | | | |
| 11 | DFAELL | Due date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | DDISPO | Payment Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DBERVON | 'Calculate From' Date (Inclusive of that date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | DBERBIS | 'Calculate Through To' Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | SZBMETH | Interest Calculation Method | char | 1 | 0 | | | | Allow NULL? |
| 16 | ABASTAGE | Number of base days in a calculation period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | ATAGE | Number of Days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | CF_ASTCK | Number of units for unit-quoted securities | decimal | 15 | 5 | | | | |
| 19 | SNWHR | Currency of nominal amount base | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | BNWHR | Nominal amount base for cash flow determination | decimal | 17 | 2 | | | | |
| 21 | PKOND | Interest rate as a percentage | decimal | 10 | 7 | | | | |
| 22 | SZSREF | Reference Interest Rate | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | SZSREFVZ | +/- sign / reference interest rate operator | char | 1 | 0 | | | | Allow NULL? |
| 24 | SOFFSET | Fixer offset for variable interest rate reference | decimal | 10 | 7 | | | | |
| 25 | SFORMREF | Formula Reference | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | DZFEST | Interest rate fixing date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | JSOFVERR | Immediate settlement | char | 1 | 0 | | | | Allow NULL? |
| 28 | OPPZINS | Opportunity Interest | decimal | 10 | 7 | | | | |
| 29 | FIKTKZ | Include Fictitious Cash Flows | char | 1 | 0 | | | | Allow NULL? |
| 30 | SBWHR | Position Currency/Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | BBWHR | Amount in transaction currency | decimal | 17 | 2 | | | | |
| 32 | XKURSKNZ | X - Fixed exchange rate agreed | char | 1 | 0 | | | | Allow NULL? |
| 33 | KKURS | Exchange Rate | decimal | 13 | 7 | | | | |
| 34 | SZINSART | RM: Indicator for the Type of Interest Rate | char | 1 | 0 | | | | Allow NULL? |
