| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 31 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
2 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 31 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
3 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 23 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
4 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 46 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
5 | SLDT_FLOW | Subledger Distributor Transactions | 68 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
6 | TERT_FLOW | Flow Table for Rights that can be Exercised | 47 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
7 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 45 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |
8 | TRDT_FLOW | Persistent distributor flows | 66 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | nvarchar | 1 | 0 | | |