| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRST_POS_CHG | CFM: Securities Account Position Change | 12 | USER_DATA_CLS | Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 17 | USER_DATA_CLS | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPTransaction Management |
3 | THXT_HINST | Hedge Instrument | 11 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
4 | THXT_HITEM | Hedge Item DB table | 12 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
5 | THXT_HREL | Hedging Relationship | 9 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
6 | THXT_HR_TRANS | Treasury: Hedging Relationship Transactions | 10 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTransaction Manager |
7 | SLDT_TRANSACTION | Subledger Distributor Business Transactions | 3 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
8 | TRDT_TRDBUSTRANS | Treasury: Persistent distributor business transaction | 3 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
9 | TRDT_TRDDOCUMENT | (Obsolete as of CFM 1.0) Distributor Documents | 5 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTransfer to Financial Accounting |
10 | ADJT_TRANSACTION | Treasury: Reconciliation business transactions | 3 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
11 | TLVT_VAL_TRANS | Treasury: Valuation Business Transactions | 19 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
12 | TRATT_TRANS | Account Assignment Reference Transfer Business Transactions | 9 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
13 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 17 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
14 | TRLT_DERIVTRANS | Derived Business Transactions | 3 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
15 | TRLT_DOCUMENT | Treasury Ledger Documents | 8 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
16 | TRLT_TRANSACTION | Treasury Ledger Business Transactions | 26 | USER_DATA_CLS | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTreasury and Risk Management |
17 | TREAT_FLOW | Treasury: TREA Flows | 45 | USER_DATA_CLS | Globally Unique Identifier | varbinary | 16 | 0 | | |