| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CMS_ARC_CAG | CAG Archiving table | 4 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| TOPInformation System |
| 2 | CMS_LIQ_CFL | CMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0) | 7 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| TOPLand Register |
| 3 | TCMS_LR_DE_TY2 | Section II Charge/Restriction Type | 5 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 4 | TCMS_LR_DE_TY3 | Section III ChargeType - Customizing table | 4 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| TOPMaster Data |
| 5 | CMS_CAG | Collateral Agreement Details | 4 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 6 | TCMS_CAG_GRP | Agreement type - Relationship Group mapping | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 7 | TCMS_CAG_ORG | Group table for Collateral Agreement Number ranges | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 8 | TCMS_CAG_ORG_T | Text table for number range group element | 3 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 9 | TCMS_CAG_TYP | Collateral Agreement type Description | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 10 | TCMS_CAG_TYP_T | Collateral Agreement type text elements | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 11 | TCMS_CHG_TYP | Asset - Collateral agreement type relationship | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 12 | TCMS_PRD_CAG | Product type -Collateral Agreement type Relationship | 2 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
| 13 | TCMS_TRANSACTION | Details for the CMS programs to start | 7 | CAGMT_TYPE | Collateral Agreement Type | nvarchar | 6 | 0 | | |
