| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | AT14 | Status Transfers | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
2 | IDCFM_ICLTXFLDIR | Flow Types for Tax Types with Sign | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
3 | TLRC_TARO_TAR_AS | Assignment of Trade Repository | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
4 | TLRT_TARO_ADM | Trade Repository Object Administrative Data | 15 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
5 | ZCMM_MTM_01 | MtM Persistency per Transaction | 67 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPAssetLiability Management |
6 | JBNIPL | ALM Non Interest Profit and Loss | 9 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPBack Office |
7 | TRIL_BWGART | OLD!!! Flow types for Hedge Accounting | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPBasic Functions |
8 | AT85 | CMF - Generating pmnt advices (prod./trans.type) | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPBusiness Partner |
9 | VTBSTA1 | Allocation of Payment Details as Standing Instructions | 8 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
10 | VTBSTA2 | Standing Instructions for Correspondence | 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
11 | VTBSTA3 | SI for Business Partner: Transaction Authorizations | 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
12 | VTBSTA4 | SI for Business Partner: Derived Flows | 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPDefault Risk and Limit System |
13 | KLEGZU | Assignment of TR Product/Tran. Type to CL Default Risk Rule | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
14 | KLLIMITEXCEEDED | Management of Exceeded Limits per Product/Transaction Type | 6 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
15 | KLMAXLIMIT | Limit per Product Type/Transaction Type | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
16 | JBRSVABEST | RM: Header Table SDTFT (Additional Info.) for Saved Datasets | 12 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPTransaction Data Pool |
17 | JBDFUNCDEAKT | Deactivate Datapool Functions | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPTransaction Management |
18 | ATALRT | Treasury: Alert Category Assignment | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
19 | ATRELE1 | Transaction release: Release procedure | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
20 | ATRELE2 | Transaction release: Release procedure for detail parameters | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
21 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 32 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
22 | VTBMDEX | CFM: Mirror Transaction - Initial Table | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
23 | VTBMDINFKT | CFM: Mirror Transaction Mapping Functions | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
24 | VTBMDMAP | CFM: Mirror Transaction - Map PType/TType in Meta Name | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
25 | VTBMDMAPFLW | CFM: Mirror Transaction - Map Flows | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
26 | VTBMDMAPKOND | CFM: Mirror Transaction - Map Conditions | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
27 | VTB_FMOD_SFGZUST | Field Modification at Activity Category Level | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
28 | VTB_FMOD_SFHAART | Field Modification Values | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
29 | VTB_FMOD_SFUNKTL | Field Modification Values | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
30 | VTB_RULESET_TT | FTR Rule Management: Transaction Type Rules | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
31 | AT10 | Transaction Types | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
32 | AT10B | Treasury: Customizing for Valuation | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
33 | AT10S | Securities | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
34 | AT10T | Name of Transaction Type | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
35 | AT10X | Forex Attributes for Transaction Types | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
36 | AT11 | Allocation of Condition Types to Transaction Types | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
37 | AT13 | Allocation of Flow Types to Transaction Types | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
38 | AT13U | Flow types for transfer posting for activity transition | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
39 | AT16 | Treasury: Fixing Settings for Forex Transactions | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
40 | AT16B | Treasury: Settings for mirror transaction types | 5 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
41 | AT200 | Rules for Determining a Tax Indicator | 6 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
42 | AT210 | Rules for Determining a Taxes for CFM postings | 6 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
43 | AT80 | Treasury: Correspondence Control MM, FX, DE, SE | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
44 | IDCFMBRSE_PST | Customizing for creation of sales transactions for tax pmnts | 6 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
45 | IDCFMFLOWCALC | Flow calculation using condition technique | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
46 | IDCFMFLOWCALCIN | Flow calculation using conditions: map CFM data to KOMK/KOMP | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
47 | IDCFMFLOWCALCOUT | Flow calc.using conditions:map KOMK/KOMP fields to flow data | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
48 | IDCFM_ICLTXCALC | Intercompany Loan Tax Calculation Method | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
49 | IDCFM_ICLTXCAT | Intercompany Loan Tax Calculation Category | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
50 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 12 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
51 | THMHRT_HR | Hedge Relationship | 24 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
52 | THMHRT_HR_FLAGS | E-HA: Flags that trigger the HR events | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
53 | TW19 | Securities: Correspondence Forms (Used Up To Release 4.5B) | 4 | SFHAART | Transaction Type in Securities Management | nvarchar | 3 | 0 | | |
54 | VTBFHA | Transaction | 14 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
55 | VTBFHAZU | Transaction Activity | 12 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
56 | VTBMADT | Mast. Agreement: Permitted Trans. Types | 4 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
57 | VTBSIZU | Hedge Allocation | 46 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
58 | VTBTRA1 | Transaction Authoriz. for Traders | 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
59 | VTB_FRGST | Control parameter for Release - Status management | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
60 | VTB_TRADER_AUTH | Transparent Table for Trader Authorizations | 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
61 | VTIFHA | Underlying transaction | 13 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
62 | VTIFHAZU | Underlying transaction status table | 11 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |
63 | VWFL_FT_DE | CFM: Assign Update Type to Flow Type | 3 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | | |