| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | TBKK_CLS_BAL | Settings for accnt. balancing date during accnt. closure | 2 | BANKAREA | Bank Area | nvarchar | 4 | 0 | | |
| 2 | TBKK_CLS_OBJ_TMN | Settings for accnt. dependant objects during account closure | 2 | BANKAREA | Bank Area | nvarchar | 4 | 0 | | |
| TOPMaster Data |
| 3 | CMS_AST | Asset Details | 56 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| 4 | CMS_CAG | Collateral Agreement Details | 14 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| 5 | TCMS_BANKAREA | CMS: Bankarea | 2 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| 6 | TCMS_BANKAREA_T | Text: Bankarea | 2 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| TOPMovables |
| 7 | CMS_MOVABLES | Movable Details - Vehicles, Devices & Aircraft | 62 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| TOPReal Estate |
| 8 | CMS_RE_OBJ | Real estate header details | 24 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| TOPRights |
| 9 | CMS_INS | Insurance Application Table | 77 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| 10 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 30 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| TOPSecurities |
| 11 | CMS_SEC_ACC | Securities account details | 11 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
| TOPShip |
| 12 | CMS_SHP | Description of a Ship - Master Table | 75 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | |
