| 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 | 13 | USER_DATA_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 18 | USER_DATA_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPTransaction Management |
3 | THXT_HINST | Hedge Instrument | 10 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
4 | THXT_HITEM | Hedge Item DB table | 11 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
5 | THXT_HREL | Hedging Relationship | 8 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
6 | THXT_HR_TRANS | Treasury: Hedging Relationship Transactions | 9 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTransaction Manager |
7 | SLDT_TRANSACTION | Subledger Distributor Business Transactions | 4 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
8 | TRDT_TRDBUSTRANS | Treasury: Persistent distributor business transaction | 4 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
9 | TRDT_TRDDOCUMENT | (Obsolete as of CFM 1.0) Distributor Documents | 6 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTransfer to Financial Accounting |
10 | ADJT_TRANSACTION | Treasury: Reconciliation business transactions | 4 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
11 | TLVT_VAL_TRANS | Treasury: Valuation Business Transactions | 18 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
12 | TRATT_TRANS | Account Assignment Reference Transfer Business Transactions | 8 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
13 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 16 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
14 | TRLT_DERIVTRANS | Derived Business Transactions | 4 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
15 | TRLT_DOCUMENT | Treasury Ledger Documents | 7 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
16 | TRLT_FLOW | Treasury Ledger Flows | 35 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
17 | TRLT_TRANSACTION | Treasury Ledger Business Transactions | 25 | USER_DATA_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTreasury and Risk Management |
18 | TREAT_FLOW | Treasury: TREA Flows | 44 | USER_DATA_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |