| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAsset |
| 1 | TCMS_FOB_TYP | Financed object: Asset type - Product id relationship | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| TOPMaster Data |
| 2 | CMS_AST | Asset Details | 4 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 3 | TCMS_AST_FLDS | Table for Asset field names | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 4 | TCMS_AST_FLDS_T | Text Table for Asset field names | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 5 | TCMS_AST_ORG | Group table for Asset Number ranges | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 6 | TCMS_AST_ORG_T | Text table for number range group element | 3 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 7 | TCMS_AST_TYP | Asset Type Details | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 8 | TCMS_AST_TYP_T | Asset Type (Text Table) | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 9 | TCMS_CHG_TYP | Asset - Collateral agreement type relationship | 3 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 10 | TCMS_SAS_TYP | Sub-asset type details | 5 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| TOPMovables |
| 11 | TCMS_MOV_TYP | Customizing table for Movable Type | 14 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| TOPRights |
| 12 | TCMS_INS_TYP | Customizing table for Insurance Type | 12 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| 13 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 13 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
| TOPSecurities |
| 14 | TCMS_SEC_AST | Asset type for securities accounts | 2 | AST_TYP | Asset Type | nvarchar | 6 | 0 | | |
