| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCollateral Management System |
| 1 | TCMS_BDT_FSTAT | Field Status Variant | 2 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 2 | TCMS_BDT_FSTAT_T | Field Status Variant (Text Table) | 2 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 3 | TCMS_PCN_ACTVT | Business activity definition | 8 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 4 | TCMS_PCN_CR_TY | Change Request Type | 6 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPLiquidation |
| 5 | TCMS_LIQ_TYP | Liquidation types | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPMaster Data |
| 6 | TCMS_AST_TYP | Asset Type Details | 11 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 7 | TCMS_CAG_TYP | Collateral Agreement type Description | 9 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 8 | TCMS_PRD | Product description | 9 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPMovables |
| 9 | TCMS_MOV_TYP | Customizing table for Movable Type | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPReal Estate |
| 10 | TCMS_RE_OBJ_ACS | Real Estate object type - Accessories relationship | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 11 | TCMS_RE_OBJ_PRT | Real Estate object type - Building Parts relationship | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 12 | TCMS_RE_TYP | Customizing table for real estate types | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPRights |
| 13 | TCMS_INS_TYP | Customizing table for Insurance Type | 4 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| 14 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 4 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPSecurities |
| 15 | TCMS_SEC_AST | Asset type for securities accounts | 12 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
| TOPShip |
| 16 | TCMS_SHP_TYP | Customizing table for Ship type | 5 | FSTAT_VAR | Object Screen (Field Status Variant) | nvarchar | 10 | 0 | | |
