| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_ECF_PCO | RBD ECF - Provision Collateral | 21 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
2 | /IBS/TRB_ECF_VCO | RBD ECF - Value Adjustment - Collateral | 19 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
3 | /IBS/TRB_ECH_PCO | RBD ECF - Provision History - Collateral | 22 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
4 | /IBS/TRB_ECH_VCO | RBD ECF - Value Adjustment History - Collateral | 20 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
5 | /IBS/TRB_ECI_CO | RBD ECF - Import Table for Collateral | 15 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
6 | CMS_ARC_RBL | Receivables Archiving Table | 3 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
7 | CMS_BLK_PACK_ITM | Package Parameter Item for Blocking report | 8 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPAsset |
8 | CMS_FOB | Financed object details | 4 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPCalculations |
9 | CMS_BCM_CGP_RES | Coverage gap calculated results-BCM | 3 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
10 | CMS_BCM_RBL_CGP | CMS BCM: Receivables Coverage Gap | 2 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPCollateral Management System |
11 | CMS_RBL_SYNC | RBL Sync Data | 2 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPInformation System |
12 | CMS_LIQ_CFL | CMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0) | 8 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPMaster Data |
13 | CMS_CAG_RBL | Collateral Agreement - Receivable Link Details | 4 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
14 | TCMS_PRD | Product description | 5 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
15 | TCMS_RBL_SYS_A | Creditsystem attributes | 2 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPReceivable |
16 | CMS_RBL | Receivable Details | 3 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
TOPValue Adjustment |
17 | /IBS/TRB_IASCOL | RBD IAS-GATE Collateral Data | 10 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
18 | /IBS/TRB_SCHIST | RBD IAS - History Value Adjustment Collateral | 18 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
19 | /IBS/TRB_SCHISTR | RBD IAS - History Provision Collaterals | 22 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
20 | /IBS/TRB_SHCOL | RBD IAS - Value Adjustment Collateral | 17 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |
21 | /IBS/TRB_SHCOL_R | RBD IAS - Provision Collaterals | 21 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | | |