| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TREAT_NOVATION | Treasury: Novation | 16 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | TRQT_OTC_LOT | Treasury: OTC Lot (Subposition of OTC Lot Position) | 7 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPBack Office |
3 | TRST_POS_CHG | CFM: Securities Account Position Change | 10 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPTransaction Manager |
4 | TRQT_FLOWGROUP | Treasury: Transaction Flow Groups | 8 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
5 | TRQT_LOT | Treasury: Lot | 9 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTransfer to Financial Accounting |
6 | BCKTRLT_FLOW | Treasury Ledger Flows | 7 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
7 | TLVT_VAL_TRANS | Treasury: Valuation Business Transactions | 16 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
8 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 14 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
9 | TRLT_DERIVFLOWS | Treasury: Flows for Derived Business Transactions | 4 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
10 | TRLT_FIXINGSUM | TR Ledger Transaction Figures | 6 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
11 | TRLT_FLOW | Treasury Ledger Flows | 36 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
12 | TRLT_LOCK | Treasury Ledger Position Lock | 3 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
13 | TRLT_SUBPOSITION | Treasury Ledger: Subposition | 11 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
14 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 49 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | |
TOPTreasury and Risk Management |
15 | TREAT_FLOW | Treasury: TREA Flows | 5 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
16 | TREAT_POSITION | Treasury: TREA Position | 2 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |
17 | TREAT_SUBTOTAL | TREA: Position Subtotal | 3 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | | |