| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICL_FUND_ITM | Fund Items | 16 | ISIN | International Securities Identification Number of Fund | nvarchar | 12 | 0 | | |
2 | ICS_FUND_ITM | Shadow Table for Fund Items (ICL_FUND_ITM) | 16 | ISIN | International Securities Identification Number of Fund | nvarchar | 12 | 0 | | |
TOPSecurities |
3 | CMS_SEC_ACC_POS | Securities position details | 6 | ISIN | Unique ID for a Position in a Securities Account | nvarchar | 20 | 0 | | |
4 | CMS_SEC_CL_MST | Class master data in external system for every ISIN number | 2 | ISIN | Unique identification number for every position | nvarchar | 20 | 0 | | |
5 | CMS_SEC_VALUE | Securities value details for every ISIN | 2 | ISIN | Unique ID for a Position in a Securities Account | nvarchar | 20 | 0 | | |