| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | YVWDNR | CHD Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 3 | VBKL | Agreement Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | RI | Rule Identifier | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | VBIN | Agreement Entity | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | DATE_TO | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | DATE_FROM | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SL_GROUP1 | CH: Payment in Kind Group 1 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | SL_TYPE1 | CH: Payment in Kind Type 1 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | AMOUNT_SL1 | CH: Value of Payment in Kind 1 | decimal | 16 | 2 | | | | |
| 11 | SL_CURRENCY_1 | CH: Currency Indicator of Payment in Kind 1 | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | QUANTITY | Quantity | decimal | 15 | 5 | | | | |
| 13 | UNIT | CH: Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | ANLN1 | Main asset number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | EQUNR | Equipment number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 18 | DATLEIHE | Date Loan | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | DATRUECK | Date Repossession | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | AMOUNT_BS | CH: Guaranty | decimal | 16 | 2 | | | | |
| 21 | BS_CURRENCY | CH: Currency Indicator of Guaranty | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | AMOUNT_BS_ACT | CH: Reported Guarantee Amount | decimal | 16 | 2 | | | | |
| 23 | DAT_BS_ACT | Date Balance Notification | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | LS_DAT_FROM | CH: Performance Period - From-Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | LS_DAT_TO | CH: Peformance Period - To-Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | EITR | Subrogation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | RESIDENT_VAL1 | Cumulative acquisition and production costs | decimal | 13 | 2 | | | | |
| 28 | RVAL_CURR1 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | RESIDENT_VAL2 | Cumulative acquisition and production costs | decimal | 13 | 2 | | | | |
| 30 | RVAL_CURR2 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | RESIDENT_VAL3 | Cumulative acquisition and production costs | decimal | 13 | 2 | | | | |
| 32 | RVAL_CURR3 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | EVAL_DATE | Date of Valuation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | | | Allow NULL? |
