| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FTBCVA_GUID2KEY | Mapping table GUID - semantic key | 5 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
2 | TLRT_TARO_ADM | Trade Repository Object Administrative Data | 5 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
3 | TLRT_TARO_PFIELD | Trade Repository: Protected Fields | 5 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
4 | TLRT_TRADE_ID | Trade Identifier for Financial Transactions | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
5 | TRTM_CHG_PARTNER | Treasury: Change partner | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPBasic Functions |
6 | FDT1 | CMF Line Items for Forex, Money Market, Derivatives | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPInformation System |
7 | FTI_MARKET_VALS | Reporting: Buffer Table for Market Values - Position Crcy | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
8 | FTI_MARKET_VALST | Reporting: Buffer Table for Market Values - Evaluation Crcy | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPLoans Management |
9 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 254 | RFHA | Finanzgeschäft | nvarchar | 13 | 0 | | |
10 | VDZV | Payment Details for the Loan | 3 | RFHA | Contract Number | nvarchar | 13 | 0 | | |
TOPMarket Risk Analyzer |
11 | VTVBAR | NPVs of OTC transactions | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransaction Data Pool |
12 | JBDEURO | Indicator Table for EURO Conversion (CC) | 9 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
13 | JBDGSCH | IS-B: Transaction Master Data | 30 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransaction Management |
14 | FTR_AVG_RATE | Average Rates | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
15 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 11 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
16 | TPM_SECACC_GRD2 | Zuordnung Geschäft Depot-Bestandssperre | 4 | RFHA | Finanzgeschäft | nvarchar | 13 | 0 | | |
17 | VTBPA | Fin. Transaction: Assignment of Further Business Partners | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
18 | VTBRATING | Rating for Financial Transaction | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
19 | VTBRELE1 | Transaction release: Change history | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
20 | BCKVTBFHAPO | Backup: Transaction Flows | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
21 | BCK_VTIFHAPO | Backup for Currency Changeover of Bond Underlying | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
22 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
23 | IDCFMBRSETX_HST | History table for taxation | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
24 | IDCFM_BST_HIST | History table for balance sheet transfer for Brazil | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
25 | MIGT_EXCL1 | Transactions to be Excluded from Migration | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
26 | OTC_CONV_AFINKO | Backup Table for Fin. Transaction Alternative Conditions | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
27 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
28 | OTC_CONV_FHAZU | Backup Table for Financial Transaction Activities | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
29 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
30 | OTC_CONV_IAFINKO | Backup Table for Transaction Underlying Old Conditions | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
31 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
32 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
33 | TCAT_TRANSACTION | Business Transaction: Corporate Action | 28 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
34 | TCORT_CODDP | Deal: Dividend Plan | 5 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
35 | TCORT_CODRP | Deal: Rollover Plan | 5 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
36 | THAHRT_ASS_PROSP | Retrospective effectiveness assessment result | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
37 | THAHRT_EXT_RETRO | External Retrospective Assessment | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
38 | THMEXT_PLANNER | E-HA: Hedge Plan | 17 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
39 | THMHRT_ASS_RETRO | Retrospective effectiveness assessment result | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
40 | THMHRT_CASH_FLOW | Calculated cash flows for effectiveness | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
41 | THMHRT_EXT_PROS | External Prospective Assessment | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
42 | THMHRT_HI_MEAS | Fair value change of the hedge comp. in an effective hedge | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
43 | THMHRT_HR | Hedge Relationship | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
44 | THMHRT_HR_STRAT | Effectiveness strategy for the hedging relationship | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
45 | THMHRT_HR_VAL | Valuation details for the hedging relationship | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
46 | THMHRT_MEASURE | Effectiveness measurement result | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
47 | TPMHRT_EXT_RETRO | External Retrospective Assessment | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
48 | VTB2TRD | Link Between Financial Transaction Flow and Distributor Flow | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
49 | VTBAFINKO | Alternative Conditions | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
50 | VTBDIVIDEND | Dividend Data for Forward Securities Transaction | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
51 | VTBFHA | Transaction | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
52 | VTBFHAPO | Transaction Flow | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
53 | VTBFHAPO_MIGR | Migrated Financial Flows | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
54 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
55 | VTBFHAZU | Transaction Activity | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
56 | VTBFINKO | Transaction Condition | 4 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
57 | VTBFKTLOG | Treasury: Sequence of Functions for Activity Processing | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
58 | VTBKORES | Correspondence Data | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
59 | VTBPFHAPO | Treasury: Flow Shells | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
60 | VTBRATE | Rate for Activity | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
61 | VTBROLLOVER | Rollover Periods for Forward Securities Transactions | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
62 | VTBSIZU | Hedge Allocation | 42 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
63 | VTBTEKAL | Treasury: Due Date Management | 6 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
64 | VTBZV | Payment Details for Transaction | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
65 | VTB_ADJUSTMENT | Fiduciary deposit adjustment flow | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
66 | VTIAFINKO | Alternative Conditions Underlying | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
67 | VTIFHA | Underlying transaction | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
68 | VTIFHAPO | Underlying transaction flows | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
69 | VTIFHAZU | Underlying transaction status table | 2 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
70 | VTIFINKO | Underlying transaction conditions | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
71 | VTIOF | Additional Option Data | 6 | RFHA | Transaction (underlying) if only one | nvarchar | 13 | 0 | | |
72 | VTIOFZU | Allocation of Option/Future to Underlying | 3 | RFHA | Transaction (underlying) if only one | nvarchar | 13 | 0 | | |
73 | VWBEKI | Treasury Securities: Actual Flows - Header | 60 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
74 | VWBEPP | Treasury Securities: Planned Flows | 161 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
75 | VWFL3 | Assign Transaction Number to Position Number | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
76 | VWORDE | Order Data | 104 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransfer to Financial Accounting |
77 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 6 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTreasury |
78 | FLQITEMT1_FC | Liquidity Calculation: Forecast Line Items from TR Trans. | 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | | |