| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDANT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SHEETNR | RBD: Fair Value Sheet | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POSIT | RBD: Sequence Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | LIQ_PERIOD | RBD: Liquidation Period in Months | int | 10 | 0 | | | | Allow NULL? |
| 6 | DISCDATE | RBD: Discount Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | CURRENCY | RBD: Currency of Risk Provision | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | VALUE | RBD: Amount in Transaction Currency | decimal | 23 | 2 | | | | |
| 9 | RCCOL | RBD: Liquidation Costs Collateral (Amount) | decimal | 23 | 2 | | | | |
| 10 | VALUEVT | RBD: Collateral Value Including Liquidation Costs | decimal | 23 | 2 | | | | |
| 11 | VEANT | RBD: Recoverable Proportion of Collateral in Percent | decimal | 5 | 2 | | | | |
| 12 | EXPECT | RBD: Expected Amount of Collateral Recovery | decimal | 23 | 2 | | | | |
| 13 | RS_PROP | RBD: Probability of Risk Provision Usage | decimal | 5 | 2 | | | | |
| 14 | EXPCOL_W | RBD: Expected Amount Collateral Liquidation (Weighted) | decimal | 23 | 2 | | | | |
| 15 | DISC_RATE | RBD: Discount Interest Rate AP 1 | decimal | 15 | 10 | | | | |
| 16 | PRESENT_VAL | RBD: Net Present Value AP 1 in Contract Currency | decimal | 23 | 2 | | | | |
| 17 | DISC_RATE2 | RBD: Discount Interest Rate AP 2 | decimal | 15 | 10 | | | | |
| 18 | PRESENT_VAL2 | RBD: Net Present Value AP 2 in Contract Currency | decimal | 23 | 2 | | | | |
| 19 | COLLTYPE | RBD: Collateral Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | SIGN_MAN | RBD: Indicator for Manually Entered Collateral | char | 1 | 0 | | | | Allow NULL? |
| 21 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | RECEIVABLE_ID | RBD: Receivable ID | nvarchar | 64 | 0 | | | | Allow NULL? |
| 23 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | | | Allow NULL? |
| 24 | RATING | RBD: Credit Standing of Collateral Provider | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | | | Allow NULL? |
| 26 | ANUSR | RBD: User Who Made First Entry | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | ANDAT | RBD: Date of First Entry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ANUHR | RBD: Time First Entry Was Made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | ANHER | RBD: Origin of First Entry | nvarchar | 20 | 0 | | | | Allow NULL? |
| 30 | AEUSR | RBD: User who Made the Change | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | AEDAT | RBD: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | AEUHR | RBD: Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | AEHER | RBD: Origin of Last Change | nvarchar | 20 | 0 | | | | Allow NULL? |
