| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | VDARC_RET | Retention table for Loans Management | 8 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| TOPBank Components |
| 2 | JBSSTSIC | Control Table for Formatting Collateral | 1 | SSICH | RR Type of Collateral | nvarchar | 3 | 0 | | |
| TOPGermany |
| 3 | TZBSA | Name of grouping table acc.to R11/76 app.4 - Coll.sec.type | 2 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| TOPLoans Management |
| 4 | TD01 | Table for collateral keys | 2 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 5 | TD01T | Text elements for TD01 Collat.sec.type | 3 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 6 | VDARLSIC | Collateral for loan (relationship table) | 13 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 7 | VDHGRPF | Encumbrances on real estate table | 4 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 8 | VDLV | Contracts/Credit (life ins., build.savings etc) basic data | 11 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 9 | VDSDV4 | Loan collateral in acc. with BAV/PRF4 | 11 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| 10 | VDSDV5 | Collateral in securities in acc. with BAV/PRF5 | 11 | SSICH | Collateral type | nvarchar | 4 | 0 | | |
| TOPValue Adjustment |
| 11 | /IBS/CRB_CSG | RBD Collateral Types Encumbrances | 2 | SSICH | RBD: Collateral Types | nvarchar | 4 | 0 | | |
