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