| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMS_ARC_SEC_ACC | Securities Account Archiving Table | 2 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | |
TOPSecurities |
2 | CMS_SEC_ACC | Securities account details | 2 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | |
3 | CMS_SEC_ACC_BP | Link between securities account and BuPa is stored here | 3 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | |
4 | CMS_SEC_ACC_DOC | Link between securities account and Documents is stored here | 3 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | |
5 | CMS_SEC_ACC_POS | Securities position details | 3 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | |