| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | CMS_AST | Asset Details | 19 | UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | nvarchar | 2 | 0 | | |
2 | TCMS_AST_TYP | Asset Type Details | 6 | UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | nvarchar | 2 | 0 | | |
3 | TCMS_SAS_TYP | Sub-asset type details | 8 | UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | nvarchar | 2 | 0 | | |
TOPMovables |
4 | TCMS_MOV_TYP | Customizing table for Movable Type | 7 | UNIT_VALN_FREQ | Indicator for frequency of Valuation | nvarchar | 2 | 0 | | |
5 | TCMS_MVTY_PRTY | Relation between Object Types -> Part Types | 6 | UNIT_VALN_FREQ | Indicator for frequency of Valuation | nvarchar | 2 | 0 | | |
TOPReal Estate |
6 | CMS_RE_OBJ | Real estate header details | 39 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | |
7 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 18 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | |
8 | TCMS_RE_OBJ_ACS | Real Estate object type - Accessories relationship | 6 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | |
9 | TCMS_RE_OBJ_PRT | Real Estate object type - Building Parts relationship | 6 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | |
10 | TCMS_RE_TYP | Customizing table for real estate types | 7 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | |
TOPRights |
11 | TCMS_INS_TYP | Customizing table for Insurance Type | 6 | UNIT_VALN_FREQ | Indicator for frequency of Valuation | nvarchar | 2 | 0 | | |
12 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 6 | UNIT_VALN_FREQ | Indicator for Frequency of Valuation | nvarchar | 2 | 0 | | |
TOPSecurities |
13 | CMS_SEC_ACC | Securities account details | 17 | UNIT_VALN_FREQ | Indicator : Valuation Frequency of Securities Account | nvarchar | 2 | 0 | | |
14 | TCMS_SEC_AST | Asset type for securities accounts | 4 | UNIT_VALN_FREQ | Indicator : Valuation Frequency of Securities Account | nvarchar | 2 | 0 | | |
15 | TCMS_SEC_CL_TYP | Securities classification types | 5 | UNIT_VALN_FREQ | Indicator : Valuation Frequency of Securities Account | nvarchar | 2 | 0 | | |
TOPShip |
16 | TCMS_SHP_TYP | Customizing table for Ship type | 6 | UNIT_VALN_FREQ | Indicator for frequency of Valuation | nvarchar | 2 | 0 | | |