| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMaster Data |
| 1 | CMS_AST | Asset Details | 29 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
| 2 | TCMS_AST_TYP | Asset Type Details | 18 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
| 3 | TCMS_SAS_TYP | Sub-asset type details | 15 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
| TOPMovables |
| 4 | TCMS_MOV_TYP | Customizing table for Movable Type | 19 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| 5 | TCMS_MVTY_PRTY | Relation between Object Types -> Part Types | 16 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| TOPReal Estate |
| 6 | CMS_RE_OBJ | Real estate header details | 49 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| 7 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 28 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| 8 | TCMS_RE_OBJ_ACS | Real Estate object type - Accessories relationship | 13 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| 9 | TCMS_RE_OBJ_PRT | Real Estate object type - Building Parts relationship | 13 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| 10 | TCMS_RE_TYP | Customizing table for real estate types | 17 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | |
| TOPRights |
| 11 | TCMS_INS_TYP | Customizing table for Insurance Type | 17 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
| 12 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 18 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
| TOPShip |
| 13 | TCMS_SHP_TYP | Customizing table for Ship type | 17 | LENDING_RATE5 | Lending Rate 5 | decimal | 10 | 6 | | |
