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