| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMS_ARC_CAG | CAG Archiving table | 5 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
2 | CMS_ARC_INS | Insurance Archiving table | 6 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
3 | CMS_ARC_MOVABLES | Movables Archiving Table | 6 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
4 | CMS_ARC_RBL | Receivables Archiving Table | 5 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
5 | CMS_ARC_RE_OBJ | Real Estate Archiving Table | 5 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
6 | CMS_ARC_RIG | RightsArchiving table: Includes claims and patents also | 6 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
7 | CMS_ARC_SEC_ACC | Securities Account Archiving Table | 5 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
8 | CMS_ARC_SHP | Ship Archiving Table | 5 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
9 | CMS_BLK_PACK_ITM | Package Parameter Item for Blocking report | 7 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPCollateral Management System |
10 | CMS_RBL_SYNC | RBL Sync Data | 10 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPMaster Data |
11 | CMS_AST | Asset Details | 55 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
12 | CMS_CAG | Collateral Agreement Details | 13 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
13 | TCMS_AST_ORG | Group table for Asset Number ranges | 3 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
14 | TCMS_AST_ORG_T | Text table for number range group element | 4 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
15 | TCMS_CAG_ORG | Group table for Collateral Agreement Number ranges | 3 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
16 | TCMS_CAG_ORG_T | Text table for number range group element | 4 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPMovables |
17 | CMS_MOVABLES | Movable Details - Vehicles, Devices & Aircraft | 61 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPReal Estate |
18 | CMS_RE_OBJ | Real estate header details | 23 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPReceivable |
19 | CMS_RBL | Receivable Details | 13 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPRights |
20 | CMS_INS | Insurance Application Table | 76 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
21 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 29 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPSecurities |
22 | CMS_SEC_ACC | Securities account details | 10 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |
TOPShip |
23 | CMS_SHP | Description of a Ship - Master Table | 74 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | |