| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_ECF_PCO | RBD ECF - Provision Collateral | 23 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
2 | /IBS/TRB_ECF_VCO | RBD ECF - Value Adjustment - Collateral | 21 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
3 | /IBS/TRB_ECH_PCO | RBD ECF - Provision History - Collateral | 24 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
4 | /IBS/TRB_ECH_VCO | RBD ECF - Value Adjustment History - Collateral | 22 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
5 | /IBS/TRB_ECI_CO | RBD ECF - Import Table for Collateral | 17 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
6 | CMS_ARC_CAG | CAG Archiving table | 3 | CAGMTID | Archiving - Collateral Agreement ID | nvarchar | 40 | 0 | | |
TOPInformation System |
7 | CMS_LIQ_CFL | CMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0) | 6 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
TOPMaster Data |
8 | CMS_CAG | Collateral Agreement Details | 3 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
TOPValue Adjustment |
9 | /IBS/TRB_IASCOL | RBD IAS-GATE Collateral Data | 18 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
10 | /IBS/TRB_SCHIST | RBD IAS - History Value Adjustment Collateral | 20 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
11 | /IBS/TRB_SCHISTR | RBD IAS - History Provision Collaterals | 24 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
12 | /IBS/TRB_SHCOL | RBD IAS - Value Adjustment Collateral | 19 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |
13 | /IBS/TRB_SHCOL_R | RBD IAS - Provision Collaterals | 23 | CAGMTID | Collateral Agreement ID | nvarchar | 40 | 0 | | |