| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 7 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
2 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 7 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
3 | TRST_CLASPOS | Treasury: Class position in Securities Account | 9 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
4 | TRST_POS_CHG | CFM: Securities Account Position Change | 5 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
5 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 28 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
TOPLoans Management |
6 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 138 | COM_VAL_CLASS | Allgemeine Bewertungsklasse | nvarchar | 4 | 0 | | |
7 | VDARL | Loans | 124 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
8 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 8 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
9 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 9 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
10 | DIFT_POS_IDENT | Persistent Flow Selectors | 7 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
11 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 5 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
12 | MIGC_COM_VALCLS | Derive General Valuation Class for Migration to CFM 1.0 | 6 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
13 | POGT_POS_GUARD | Lock Objects | 21 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
14 | SLDT_FLOW | Subledger Distributor Transactions | 12 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
15 | TCAT_FLOW | Flow Table of the Corporate Actions | 11 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
16 | TERT_FLOW | Flow Table for Rights that can be Exercised | 12 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
17 | TERT_TRANSACTION | Business Transaction: Exercise of Rights | 7 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
18 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
19 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
20 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
21 | TRDTT_POS_ADMIN | Legacy Data Transfer Admin. Entries Subledger Positions | 4 | COM_VAL_CLASS | Valuation Class | nvarchar | 4 | 0 | | |
22 | TRDTT_POS_SEC | Position Information for Securities | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
23 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
24 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
25 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
26 | TRDT_FLOW | Persistent distributor flows | 10 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
27 | TRGC_COM_VALCL | General valuation class | 2 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
28 | TRGC_COM_VALCL_T | Treasury: General Valuation Class (Text) | 2 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
29 | TRGC_CVC_GR_ASS | Assignment of General Valuation Class to Group | 3 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
30 | TRGC_OLDVALCLASS | Treasury: Rel. Betw. Previous and General Valuation Classes | 3 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
31 | TRGC_VALCLS_MAP | Treasury: Asst of Gen. ValnCl. to ValnCl. for each Valn Area | 2 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
32 | TRGT_TRANS_REVAL | Table with Revaluation Structures for Transfer to TR Ledger | 10 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
33 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 6 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
34 | TRQC_POS_IND_3 | Treasury: Quantity Ledger Position Description | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
35 | TRQC_POS_IND_4 | Treasury: Quantity Ledger Position Description | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
36 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 7 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
TOPTreasury |
37 | TZPAB | Financial Assets Management product types | 59 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
TOPTreasury and Risk Management |
38 | TREAT_CLEAR_ACC | Treasury: Clearing Account Specific Data | 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |
39 | TREAT_FLOW | Treasury: TREA Flows | 17 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | |