| 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 | LIBUE | RBD: Source Accounting Unit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | VERTV | RBD: Contract Number Source System | nvarchar | 100 | 0 | | | | Allow NULL? |
| 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BWAGR | RBD: Risk Provision Position | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 8 | WAEVS | RBD: Contract Currency of in Source System Contract | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | BOOK_VAL | RBD: Book Value for Srce System Contract in Contract Currncy | decimal | 23 | 2 | | | | |
| 10 | RS_BASIS | RBD: Open Contingent Liability in Contract Currency | decimal | 23 | 2 | | | | |
| 11 | RS_PROP | RBD: Probability of Risk Provision Usage | decimal | 5 | 2 | | | | |
| 12 | PERC_EXP | RBD: Higher-Level Percentage Expectation Used | decimal | 5 | 2 | | | | |
| 13 | INT_RATE | RBD: Initial Discount Interest Rate | decimal | 15 | 10 | | | | |
| 14 | INT_RATE_ACT | RBD: Current Discount Interest Rate | decimal | 15 | 10 | | | | |
| 15 | INT_METH | RBD: Interest Calculation Method (Financial Mathematics) | char | 1 | 0 | | | | Allow NULL? |
| 16 | LOSS_AP | RBD: Source System Loss Amount | decimal | 23 | 2 | | | | |
| 17 | LOSS_PP | RBD: Source System Loss Amount Previous Year | decimal | 23 | 2 | | | | |
| 18 | INIT_AP | RBD: Initialization (Current Period) | decimal | 23 | 2 | | | | |
| 19 | INIT_PP | RBD: Initialization (Previous Periods) | decimal | 23 | 2 | | | | |