| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Asset | ||||||||||
| 1 | TCMS_FOB_TYP | Financed object: Asset type - Product id relationship | 3 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| Calculations | ||||||||||
| 2 | CMS_BCM_CGP_RES | Coverage gap calculated results-BCM | 6 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 3 | CMS_BCM_RBL_CGP | CMS BCM: Receivables Coverage Gap | 6 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| Collateral Management System | ||||||||||
| 4 | CMS_RBL_SYNC | RBL Sync Data | 4 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 5 | TCMS_IFL_MCLASS | Mapping of product category and classes | 3 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| Master Data | ||||||||||
| 6 | TCMS_PRD | Product description | 2 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 7 | TCMS_PRD_CAG | Product type -Collateral Agreement type Relationship | 3 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 8 | TCMS_PRD_PRD_SET | Product set table for product combinations | 4 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 9 | TCMS_PRD_T | Product(Text Table) | 2 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 10 | TCMS_TRANSACTION | Details for the CMS programs to start | 6 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| Receivable | ||||||||||
| 11 | CMS_RBL | Receivable Details | 7 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||
| 12 | TCMS_PRD_FSTAT | Product field status | 2 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | ||