| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAsset |
1 | CMS_FOB | Financed object details | 10 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPCollateral Management System |
2 | CMS_PCN_CR | Change Requests | 20 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
3 | CMS_REL | Relationship details | 18 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
4 | CMS_TSK | Tasks | 19 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPLand Register |
5 | CMS_LR_DE_2 | Grundbuch - Section II | 15 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
6 | CMS_LR_DE_A | Grundbuch - Section A | 13 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
7 | CMS_LR_DE_B | Grundbuch - Section B | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPLiquidation |
8 | CMS_LIQ | Liquidation Details | 23 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
9 | CMS_LIQ_CFLOW | Liquidation cashflow | 12 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
10 | CMS_LIQ_PROC | Process details for an enforcement measure | 15 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPMaster Data |
11 | CMS_ACG | Approved Coverage Gap Details | 11 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
12 | CMS_ACG_CRITERIA | Approved Coverage Gap: Criteria Details | 9 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
13 | CMS_ACG_PROPOSAL | Approved Coverage Gap: Proposal Details | 13 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
14 | CMS_AST | Asset Details | 66 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
15 | CMS_AST_BP | Asset -Business Partner Relationship | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
16 | CMS_AST_DOC | Asset Documents | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
17 | CMS_AST_HIST | Asset Value History | 19 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
18 | CMS_CAG | Collateral Agreement Details | 109 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
19 | CMS_CAG_BP | Collateral Agreement-Business Partner Relationship | 13 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
20 | CMS_CAG_DOC | Collateral Agreement Documents | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
21 | CMS_CAG_POR | Collateral Agreement Portion details | 22 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
22 | CMS_CAG_RBL | Collateral Agreement - Receivable Link Details | 23 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
23 | CMS_CAG_RULES | Rule Details | 15 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
24 | CMS_CAG_SA | Special Arrangements | 25 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
25 | CMS_CAG_TRMCST | Termination and Cost details for Agreement/Agreement BP | 18 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
26 | CMS_CHG | Asset - Collateral Agreement Relationship | 21 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
27 | CMS_OMS_BP_LNK | Business Partner Link | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
28 | CMS_OMS_DOC_LNK | Documents Link | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
29 | CMS_OMS_INS_LNK | Object - Insurance Link Data | 14 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
30 | CMS_OMS_VAL_LNK | Value Link | 17 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
31 | CMS_PRD_BP | Product- Business Partner Relationship | 10 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPMovables |
32 | CMS_MOVABLES | Movable Details - Vehicles, Devices & Aircraft | 67 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
33 | CMS_OMS_PRT_LNK | Part-Link Data | 11 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPReceivable |
34 | CMS_RBL | Receivable Details | 55 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
35 | CMS_RBL_BP | Receivable-Business Partner Relationshio | 10 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPRights |
36 | CMS_INS | Insurance Application Table | 82 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
37 | CMS_INS_PSN | Insurance - Specifications of Persons | 18 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
38 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 35 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |
TOPShip |
39 | CMS_SHP | Description of a Ship - Master Table | 80 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | | |