| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TREAC_DFLOWTYPE | Treasury: Specify Update Types for Central Clearing | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
2 | TREAT_STATEM_ITM | Clearing Account Statement Detail | 11 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPBack Office |
3 | TRFC_DFTYPE_MP | TRF: Update Types for Manual Posting | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
4 | TRFC_PM_FT | Treasury: Assignment of Update Type to Flow Category | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
5 | TRFT_FLOW | Treasury: Table with TRF Flows | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
6 | TRFT_MAN_PT_FLOW | TRF: Flows for Manual Posting | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
7 | TRFT_MATCH_FLOW | Treasury: Table with Matching Process Flows | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
8 | TRFT_PACC_BANK | Payment Information | 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
9 | TRSC_DFLOWTYPE | Treasury: Attributes of Update Type for TRS | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
10 | TRSC_DFTYPE_IP | CFM: Update Types for Incoming Payments | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
11 | TRSC_DFTYPE_MP | CFM: Update Types for Manual Posting | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
12 | TRSC_REF_DISFLO | Treasury: Referenced Update Types (Incoming payment) | 3 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
13 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 14 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
14 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 14 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
15 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 12 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
16 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 22 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
17 | TRST_SECACC_BANK | Payment Details for Securities Account | 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
18 | TRST_SECACC_PAY | Downport Payment Information for Securities Management | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPMarket Risk Analyzer |
19 | FTBB_FTYPE_CFKZ | Assign Update Types to Securities Cash Flow Indicator | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPPortfolio Analyzer |
20 | PFAIM_TR_UTMATCH | Assignment of Update Type to Flow Types in PA | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
21 | PFAIM_UMATCH_TRL | Assignment of Flow Types to PA Flow Types | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPTransaction Management |
22 | TIDX_INDEX_DFLOW | Relation Between the Indexes and the Distribution Flow Type | 3 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
23 | AT210 | Rules for Determining a Taxes for CFM postings | 7 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
24 | ATFTA | CFM: Assign Transaction Flow Type to Update Type | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
25 | ATFTA_MIGR | Migration: Assignment of Flow Type to Update Type | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
26 | IDCFM_FRCR_DFT_M | CFM: Update Types for Manual Posting | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
27 | SLDT_FLOW | Subledger Distributor Transactions | 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
28 | TRDC_DFLOWTYPE | Definition of Update Types | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
29 | TRDC_DFLOWTYPE_T | Treasury: Update Type Texts | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
30 | TRDC_DFT_ASSIGN | Assignment of Flow Types to Update Types | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
31 | TRDT_FLOW | Persistent distributor flows | 4 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
32 | TRGC_DFTSOURCASS | Assign Update Types to Usages | 3 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
33 | TRGC_DF_QUANTCAT | Prel. Solution: Assignm.: Update Type - Pos.Mgmnt Cat. Units | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
34 | TRGC_PAY_REL | Payment Relevance of Update Type | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
35 | TRGC_PL_ASGNFTYP | Assignment of Profit/Loss Types to Flow Type | 2 | DIS_FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
36 | TRGC_PL_ASSIGN | Assign Profit/Loss Types to Update Type and Valuation Area | 3 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
37 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 22 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
38 | TRQT_FLOW | Treasury: Flow Data Quantity Ledger | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
39 | TRQT_INIT_LOT | (obsolete) | 11 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
40 | VWFL_FT_DE | CFM: Assign Update Type to Flow Type | 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
41 | TLVT_VAL_FLOW | Treasury: Valuation Flow | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
42 | TRACC_DFT_REL | Posting Relevant Update Types | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
43 | TRACC_MIG_ACCDET | Table for Migration of Account Determination | 8 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
44 | TRACT_ACCITEM | Accounting Items | 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
45 | TRAC_DFTRULE1 | Treasury: Assignment of Update Type to Posting Specs | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
46 | TRAC_DFTRULE2 | Treasury: Assgmt of Update Type to Post. Specs per Valn Area | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
47 | TRATT_FLOW | Transfer Flows | 4 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
48 | TRILT_DFLOW | Derived Flows in the Income Ledger | 4 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
49 | TRLAC_DFT_PMC | Assignment of Update Type to Position Change Category Value | 2 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
TOPTreasury and Risk Management |
50 | TREAT_EXT_ACC_PM | Treasury: External Account Payment Details | 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
51 | TREAT_FLOW | Treasury: TREA Flows | 11 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |