| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Components |
| 1 | JBSSICH | Regulatory Reporting - Collateral | 3 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| TOPLoans Management |
| 2 | VDARLSIC | Collateral for loan (relationship table) | 4 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 3 | VDHGRPF | Encumbrances on real estate table | 3 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 4 | VDLV | Contracts/Credit (life ins., build.savings etc) basic data | 2 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 5 | VDLVABL | Maturity data for collateral (Life insurances) | 2 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 6 | VDSDV4 | Loan collateral in acc. with BAV/PRF4 | 2 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 7 | VDSDV5 | Collateral in securities in acc. with BAV/PRF5 | 2 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
| 8 | VDSONSI | Special Arrangements for Collateral | 4 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | | |
