| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TREAT_FUT_DIFF | Treasury: TREA Differentiation for Deal Position | 7 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
TOPBack Office |
2 | TPMT_LOT_HEADER | Single Position Master Data for TR Position Management | 23 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
3 | TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows | 4 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 11 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 11 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
TOPInformation System |
6 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 18 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
TOPRegulatory reporting for insurance companies |
7 | ISSR_BASI_RG | Registrierungseintrag | 13 | LOT_ID | Identifikator des Lots | nvarchar | 32 | 0 | | |
8 | ISSR_BASI_RGDONE | Erledigter Registrierungseintrag | 13 | LOT_ID | Identifikator des Lots | nvarchar | 32 | 0 | | |
TOPTransaction Manager |
9 | DIFT_POS_IDENT | Persistent Flow Selectors | 20 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
10 | IDCFM_FRIM_DATA | Impairment Main Data | 13 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
11 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 13 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
12 | POGT_POS_GUARD | Lock Objects | 34 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
13 | SLDT_FLOW | Subledger Distributor Transactions | 24 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
14 | TRDT_FLOW | Persistent distributor flows | 20 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
15 | TRQT_ASSIGN_ITEM | Treasury: Assignment Position | 3 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
16 | TRQT_INIT_LOT | (obsolete) | 15 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
17 | TRQT_LOT | Treasury: Lot | 6 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
18 | VWBEPI | Treasury Securities: Actual Flows - Item | 112 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
19 | VWBEPP | Treasury Securities: Planned Flows | 171 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
TOPTransfer to Financial Accounting |
20 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 11 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
21 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 8 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
22 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 9 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
23 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 7 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
24 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 8 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |
25 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 13 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | |