| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | AT14 | Status Transfers | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
2 | IDCFM_FRCR_PDVA | Capitalization Reserve - Product Type | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
3 | IDCFM_ICLTXFLDIR | Flow Types for Tax Types with Sign | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
4 | TD06U | Document groups dependent on statuses of transaction types | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
5 | TLRC_TARO_TAR_AS | Assignment of Trade Repository | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
6 | TLRT_TARO_ADM | Trade Repository Object Administrative Data | 14 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPAssetLiability Management |
7 | JBNIPL | ALM Non Interest Profit and Loss | 8 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPBack Office |
8 | TRIL_BWGART | OLD!!! Flow types for Hedge Accounting | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPBasic Functions |
9 | AT85 | CMF - Generating pmnt advices (prod./trans.type) | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPBusiness Partner |
10 | VTBSTA1 | Allocation of Payment Details as Standing Instructions | 7 | SGSART | Product Type | nvarchar | 3 | 0 | | |
11 | VTBSTA2 | Standing Instructions for Correspondence | 6 | SGSART | Product Type | nvarchar | 3 | 0 | | |
12 | VTBSTA3 | SI for Business Partner: Transaction Authorizations | 6 | SGSART | Product Type | nvarchar | 3 | 0 | | |
13 | VTBSTA4 | SI for Business Partner: Derived Flows | 6 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPDefault Risk and Limit System |
14 | KLARRZU02 | Define Default Risk Rule, Limit Product Group for Accounts | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
15 | KLBESTZU | Assignment of Product Type to CL Default Risk Rule | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
16 | KLEGZU | Assignment of TR Product/Tran. Type to CL Default Risk Rule | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
17 | KLLIMITEXCEEDED | Management of Exceeded Limits per Product/Transaction Type | 5 | SGSART | Product Type | nvarchar | 3 | 0 | | |
18 | KLMAXLIMIT | Limit per Product Type/Transaction Type | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
19 | KLORDERZU | Assign Prod. Type to CL DRR for Sec. Order and For.Sec. | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
20 | KLORDERZUARR | Assign Prod. Type to CL DRR for Sec. Order and For.Sec. | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPMarket Risk Analyzer |
21 | ATVMO | Calculation Methods Risk Management | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
22 | VTVTRBW | RM: Link TR Product Type to Valuation Rule | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPRegulatory reporting for insurance companies |
23 | TZB7V | AT Großkreditevidenz: Finanzgeschäftsvogangstyp zu melden | 2 | SGSART | Produktart | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
24 | JBRSVABEST | RM: Header Table SDTFT (Additional Info.) for Saved Datasets | 10 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPSingle Transaction Costing |
25 | JBTKREG | Costing Rule | 3 | SGSART | Type of Transaction (Costing-Based) | nvarchar | 2 | 0 | | |
TOPTransaction Management |
26 | ATALRT | Treasury: Alert Category Assignment | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
27 | ATFWDUL | Assignment of Underlying to Transaction | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
28 | ATRELE1 | Transaction release: Release procedure | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
29 | ATRELE2 | Transaction release: Release procedure for detail parameters | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
30 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 30 | SGSART | Product Type | nvarchar | 3 | 0 | | |
31 | VTBMDEX | CFM: Mirror Transaction - Initial Table | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
32 | VTBMDINFKT | CFM: Mirror Transaction Mapping Functions | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
33 | VTBMDMAP | CFM: Mirror Transaction - Map PType/TType in Meta Name | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
34 | VTBMDMAPFLW | CFM: Mirror Transaction - Map Flows | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
35 | VTBMDMAPKOND | CFM: Mirror Transaction - Map Conditions | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
36 | VTB_FMOD_BASIC | Field Modification Values | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
37 | VTB_FMOD_SFGZUST | Field Modification at Activity Category Level | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
38 | VTB_FMOD_SFHAART | Field Modification Values | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
39 | VTB_FMOD_SFUNKTL | Field Modification Values | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
40 | VTB_RULESET_TT | FTR Rule Management: Transaction Type Rules | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
41 | AT10 | Transaction Types | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
42 | AT10B | Treasury: Customizing for Valuation | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
43 | AT10S | Securities | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
44 | AT10T | Name of Transaction Type | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
45 | AT10X | Forex Attributes for Transaction Types | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
46 | AT11 | Allocation of Condition Types to Transaction Types | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
47 | AT13 | Allocation of Flow Types to Transaction Types | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
48 | AT13U | Flow types for transfer posting for activity transition | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
49 | AT16 | Treasury: Fixing Settings for Forex Transactions | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
50 | AT16B | Treasury: Settings for mirror transaction types | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
51 | AT50 | Future/Option Groups | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
52 | AT80 | Treasury: Correspondence Control MM, FX, DE, SE | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
53 | ATPA | Treasury: Product Type Supplements | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
54 | IDCFMBRSETX_HST | History table for taxation | 16 | SGSART | Product Type | nvarchar | 3 | 0 | | |
55 | IDCFMFLOWCALC | Flow calculation using condition technique | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
56 | IDCFMFLOWCALCIN | Flow calculation using conditions: map CFM data to KOMK/KOMP | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
57 | IDCFMFLOWCALCOUT | Flow calc.using conditions:map KOMK/KOMP fields to flow data | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
58 | IDCFMSETX_CUST | Cusotmizing for tax posting to FI for funds - Brazil | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
59 | IDCFMSETX_RATE | Tax rates for tax reports TRM Brazil | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
60 | IDCFM_FRAM_DICPT | Assign Product Types for Alternate Position Mngt. Procedure | 4 | SGSART | Product Type | nvarchar | 3 | 0 | | |
61 | IDCFM_FRCR_PD | Capitalization Reserve - Product Type | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
62 | IDCFM_ICLTXCALC | Intercompany Loan Tax Calculation Method | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
63 | IDCFM_ICLTXCAT | Intercompany Loan Tax Calculation Category | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
64 | IDCFM_ICLTXFLOWS | Intercompany loan tax flow types for different product type | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
65 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 11 | SGSART | Product Type | nvarchar | 3 | 0 | | |
66 | THMHRT_HR | Hedge Relationship | 23 | SGSART | Product Type | nvarchar | 3 | 0 | | |
67 | THMHRT_HR_FLAGS | E-HA: Flags that trigger the HR events | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
68 | TRGC_TAX | CFM: Derivation Rules for Tax Flows | 9 | SGSART | Product Type | nvarchar | 3 | 0 | | |
69 | TW19 | Securities: Correspondence Forms (Used Up To Release 4.5B) | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
70 | VTBFHA | Transaction | 13 | SGSART | Product Type | nvarchar | 3 | 0 | | |
71 | VTBFHAZU | Transaction Activity | 11 | SGSART | Product Type | nvarchar | 3 | 0 | | |
72 | VTBFININ | Header Table for Financial Products | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
73 | VTBMADT | Mast. Agreement: Permitted Trans. Types | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |
74 | VTBSIZU | Hedge Allocation | 45 | SGSART | Product Type | nvarchar | 3 | 0 | | |
75 | VTBTRA1 | Transaction Authoriz. for Traders | 6 | SGSART | Product Type | nvarchar | 3 | 0 | | |
76 | VTB_FRGST | Control parameter for Release - Status management | 2 | SGSART | Product Type | nvarchar | 3 | 0 | | |
77 | VTB_TRADER_AUTH | Transparent Table for Trader Authorizations | 6 | SGSART | Product Type | nvarchar | 3 | 0 | | |
78 | VTIFHA | Underlying transaction | 12 | SGSART | Product Type | nvarchar | 3 | 0 | | |
79 | VTIFHAZU | Underlying transaction status table | 10 | SGSART | Product Type | nvarchar | 3 | 0 | | |
80 | VTIOF | Additional Option Data | 5 | SGSART | Product Type | nvarchar | 3 | 0 | | |
TOPTreasury |
81 | VTIDERI | Master Data Listed Options and Futures | 3 | SGSART | Product Type | nvarchar | 3 | 0 | | |