| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDANT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MODID | RBD: Component ID Source System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | VERTV | RBD: Contract Number Source System | nvarchar | 100 | 0 | | | | Allow NULL? |
| 4 | LIBUE | RBD: Source Accounting Unit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SANLF | RBD: Product Category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | PDAVS | RBD: Product Type Source System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | VEAVS | RBD: Contract Type Previous System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | REFEV | RBD: Reference from Source System | nvarchar | 100 | 0 | | | | Allow NULL? |
| 9 | VKREF | RBD: Account Assignment Reference Source System | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | FINRV | RBD: Finance Project Number Source System | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | PARTV | RBD: Partner Reference Source System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | WAEVS | RBD: Contract Currency of in Source System Contract | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | DELFZ | RBD: End of Term for Source System Contract | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | DEFSZ | RBD: End of Fixed Interest Period in Source System Contract | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DVERW | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | INTCM | RBD: Interest Calculation Method (Financial Mathematics) | char | 1 | 0 | | | | Allow NULL? |
| 17 | BOOK_VAL | RBD: Book Value for Srce System Contract in Contract Currncy | decimal | 23 | 2 | | | | |
| 18 | BENDV | RBD: Remaining Capital at End of Cash Flow | decimal | 23 | 2 | | | | |
| 19 | PZINS | RBD: Initial Eff. Interest Rate in Source System Contract | decimal | 15 | 10 | | | | |
| 20 | PERCCF | RBD: Percentage Expectation Used for Cash Flow | decimal | 5 | 2 | | | | |
| 21 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | STIZE | RBD: Time of Cash Flow Generation | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | WBKNZ | RBD: Value Adjustment Indicator | nvarchar | 30 | 0 | | | | Allow NULL? |
| 24 | SUM_ARREAR | RBD: Amount in Arrears in Contract Currency (IAS) | decimal | 23 | 2 | | | | |
| 25 | DELINQ_SINCE | RBD: Date Since Which Contract Is in Arrears | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | SUM_LOSSES | RBD: Total Loss Amount for Contract in Source System | decimal | 23 | 2 | | | | |
| 27 | SUM_LOSSES_PY | RBD: Reserves Field for IAS Gate | decimal | 23 | 2 | | | | |
| 28 | XCF_DIFF | RBD: Control CF Position Remaining Capital | char | 1 | 0 | | | | Allow NULL? |
| 29 | XCF_DELFZ | RBD: Reserve Indicator for IAS Gate | char | 1 | 0 | | | | Allow NULL? |
| 30 | PROCTYPE | RBD: Processing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | RS_BASIS | RBD: Open Contingent Liability in Contract Currency | decimal | 23 | 2 | | | | |
| 32 | RS_PROP | RBD: Probability of Risk Provision Usage | decimal | 5 | 2 | | | | |
| 33 | WB_INIT | RBD: Amount for Initializ. of Value Adjustment (Curr. Per.) | decimal | 23 | 2 | | | | |
| 34 | WB_INIT_PY | RBD: Amount for Initializ. of Value Adjustment (Prev. Per.) | decimal | 23 | 2 | | | | |
| 35 | RS_INIT | RBD: Amount for Initialization of Provision (Current Period) | decimal | 23 | 2 | | | | |
| 36 | RS_INIT_PY | RBD: Amt for Initialization of Provision (Previous Periods) | decimal | 23 | 2 | | | | |
