| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | CMS_AST | Asset Details | 24 | LENDING_RATE_IND | Indicator to specify if Asset has a Default Lending Rate | nvarchar | 2 | 0 | | |
TOPReal Estate |
2 | CMS_RE_OBJ | Real estate header details | 44 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | |
3 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 23 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | |
TOPSecurities |
4 | CMS_SEC_ACC | Securities account details | 21 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | |
5 | CMS_SEC_ACC_POS | Securities position details | 23 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | |