| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAssetLiability Management |
1 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 40 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
2 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 40 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPBack Office |
3 | TRFT_CLASS_POS | Treasury: TRF Class Position | 15 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
4 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 16 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPBasic Functions |
5 | FDT1 | CMF Line Items for Forex, Money Market, Derivatives | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPBusiness Partner |
6 | VTBSTA1 | Allocation of Payment Details as Standing Instructions | 11 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
7 | VTBSTA2 | Standing Instructions for Correspondence | 9 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
8 | VTBSTA3 | SI for Business Partner: Transaction Authorizations | 8 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
9 | VTBSTA4 | SI for Business Partner: Derived Flows | 8 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
10 | VTBSTC1 | Components of Payment Details for Standing Instruction | 19 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPDefault Risk and Limit System |
11 | KLARP | Default Risk Line Items | 39 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
12 | KLSDCPROT0 | Log Generation for Single Transaction Check: Meta Data | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
13 | KLZUEXTOBJ | Assignment of External Administration Key to Object Number | 15 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPLoans Management |
14 | VDZV | Payment Details for the Loan | 9 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPRisk Analysis |
15 | JBRBDSLFNS | RM-BDS: Run Number Status | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
16 | JBRBPGENUE | Generated Views for an RM Area | 8 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
17 | JBRDBKO | RM: DB Table Header Information Extended Risk Object | 21 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
18 | JBRHKO | RM: Version Table: Header Information: Extended Risk Object | 22 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
19 | JBRKNZ | RM: External Key Figures for Financial Object | 15 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
20 | JBRMZBG | RM: Assignment of Transactions to Business Partners | 9 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
21 | JBROBJ1 | RM: Definition of Fields/Characteristics Specific to RM | 12 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
22 | JBROZPROTKOPF | RM Gap: Log Information from OI Determination (Header) | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
23 | JBRPH | Portfolio hierarchy | 11 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
24 | JBRRMBBF | Analysis Structure | 20 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
25 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 40 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPTransaction Data Pool |
26 | JBDOBJ1 | Object Table for Financial Transactions, General Part | 30 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
27 | JBDVTMD | Variable transaction - master data | 14 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
28 | BCKVTBFHAPO | Backup: Transaction Flows | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
29 | BCK_VTIFHAPO | Backup for Currency Changeover of Bond Underlying | 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
30 | OTC_CONV_AFINKO | Backup Table for Fin. Transaction Alternative Conditions | 13 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
31 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
32 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
33 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 11 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
34 | OTC_CONV_IAFINKO | Backup Table for Transaction Underlying Old Conditions | 12 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
35 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
36 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 10 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
37 | REFCC | References between CO object numbers, currency differences | 7 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
38 | REFH | References between CO object numbers, header table | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
39 | REFON | References between object numbers (CO object no.) | 7 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
40 | TCORT_CO | Correspondence Administrative Data | 41 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
41 | TCORT_CONOTES | Treasury correspondence object: Notes | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
42 | TPMTVMFL | Position management variation margin flows at sec. account | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
43 | VTB2TRD | Link Between Financial Transaction Flow and Distributor Flow | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
44 | VTBAFINKO | Alternative Conditions | 13 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
45 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 13 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
46 | VTBFATHD | Acct Assmt Templates for PS Mult. Acct Assmts: Header Info. | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
47 | VTBFHA | Transaction | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
48 | VTBFHAPO | Transaction Flow | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
49 | VTBFHAPO_MIGR | Migrated Financial Flows | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
50 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
51 | VTBFHAZU | Transaction Activity | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
52 | VTBFINKO | Transaction Condition | 11 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
53 | VTBFSEC | Securities Collateral | 10 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
54 | VTBKORES | Correspondence Data | 6 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
55 | VTBMA | Master Agreement | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
56 | VTBPFHAPO | Treasury: Flow Shells | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
57 | VTBRATE | Rate for Activity | 7 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
58 | VTBSI | Hedges | 24 | DCRDAT | Entry date | nvarchar | 8 | 0 | | |
59 | VTBSIANF | **Caution! Do not use. Will be deleted!! | 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
60 | VTBSIZU | Hedge Allocation | 17 | DCRDAT | Entry date | nvarchar | 8 | 0 | | |
61 | VTBTRA1 | Transaction Authoriz. for Traders | 8 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
62 | VTBZV | Payment Details for Transaction | 9 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
63 | VTB_TRADER_AUTH | Transparent Table for Trader Authorizations | 8 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
64 | VTIAFINKO | Alternative Conditions Underlying | 12 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
65 | VTIFHA | Underlying transaction | 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
66 | VTIFHAPO | Underlying transaction flows | 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
67 | VTIFHAZU | Underlying transaction status table | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
68 | VTIFINKO | Underlying transaction conditions | 10 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |
TOPTreasury |
69 | FLQITEMT1_FC | Liquidity Calculation: Forecast Line Items from TR Trans. | 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | | |