| 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) | 44 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
2 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 44 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPBack Office |
3 | TRFT_CLASS_POS | Treasury: TRF Class Position | 19 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
4 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 20 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPBusiness Partner |
5 | VTBSTA1 | Allocation of Payment Details as Standing Instructions | 15 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
6 | VTBSTA2 | Standing Instructions for Correspondence | 13 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
7 | VTBSTA3 | SI for Business Partner: Transaction Authorizations | 12 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
8 | VTBSTA4 | SI for Business Partner: Derived Flows | 12 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
9 | VTBSTC1 | Components of Payment Details for Standing Instruction | 23 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPLoans Management |
10 | VDZV | Payment Details for the Loan | 13 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPRisk Analysis |
11 | JBRBDSLFNS | RM-BDS: Run Number Status | 9 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
12 | JBRDBKO | RM: DB Table Header Information Extended Risk Object | 25 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
13 | JBRHKO | RM: Version Table: Header Information: Extended Risk Object | 26 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
14 | JBRPH | Portfolio hierarchy | 7 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
15 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 44 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPTransaction Data Pool |
16 | JBDGSCH | IS-B: Transaction Master Data | 34 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
17 | JBDKKOF_BACKUP | Backup Table for the Conversion of JBDKKOF | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
18 | JBDOBJ1 | Object Table for Financial Transactions, General Part | 28 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
19 | JBDVTMD | Variable transaction - master data | 18 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
20 | OTC_CONV_AFINKO | Backup Table for Fin. Transaction Alternative Conditions | 17 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
21 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
22 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
23 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 15 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
24 | OTC_CONV_IAFINKO | Backup Table for Transaction Underlying Old Conditions | 16 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
25 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
26 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 14 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
27 | REFCC | References between CO object numbers, currency differences | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
28 | REFH | References between CO object numbers, header table | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
29 | REFON | References between object numbers (CO object no.) | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
30 | TCORT_CO | Correspondence Administrative Data | 45 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
31 | TPMTVMFL | Position management variation margin flows at sec. account | 27 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
32 | VTBAFINKO | Alternative Conditions | 17 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
33 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 17 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
34 | VTBFATHD | Acct Assmt Templates for PS Mult. Acct Assmts: Header Info. | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
35 | VTBFHA | Transaction | 9 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
36 | VTBFHAPO | Transaction Flow | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
37 | VTBFHAPO_MIGR | Migrated Financial Flows | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
38 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
39 | VTBFHAZU | Transaction Activity | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
40 | VTBFINKO | Transaction Condition | 15 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
41 | VTBFSEC | Securities Collateral | 14 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
42 | VTBKORES | Correspondence Data | 39 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
43 | VTBPFHAPO | Treasury: Flow Shells | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
44 | VTBRATE | Rate for Activity | 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
45 | VTBSI | Hedges | 28 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
46 | VTBSIANF | **Caution! Do not use. Will be deleted!! | 19 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
47 | VTBSIZU | Hedge Allocation | 21 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
48 | VTBTRA1 | Transaction Authoriz. for Traders | 12 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
49 | VTBZV | Payment Details for Transaction | 13 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
50 | VTB_TRADER_AUTH | Transparent Table for Trader Authorizations | 12 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
51 | VTIAFINKO | Alternative Conditions Underlying | 16 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
52 | VTIFHA | Underlying transaction | 8 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
53 | VTIFHAPO | Underlying transaction flows | 10 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
54 | VTIFHAZU | Underlying transaction status table | 9 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |
55 | VTIFINKO | Underlying transaction conditions | 14 | TUPTIM | Time changed | nvarchar | 6 | 0 | | |