| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Market Data |
1 | /BA1/F4_FXRATES | Exchange Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
2 | /BA1/F4_INTRATE2 | Interest Rates for Reference | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
3 | /BA1/F4_INTSPRD | Interest Rates for Reference | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
4 | /BA1/F4_SEC_CLAS | Map Charactistic Value for GUID | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
5 | /BA1/F4_VOL_FX | Key Table for Exchange Rate Volatilities | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
6 | /BA1/F4_VOL_IR | Key Table for Reference Interest Rate Volatilities | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
7 | /BA1/F4_VOL_SEC | Key Table for Security Price Volatilities | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
8 | /BA1/TF4_APPL | Partner Applications | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
9 | /BA1/TF4_EXCH | Definition of Stock Exchanges | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
10 | /BA1/TF4_EXCHT | Definition of Stock Exchanges | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
11 | /BA1/TF4_FXCVFCT | Exchange Rate Factors for Exchange Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
12 | /BA1/TF4_FXFWDYC | Yield Curve Types for Forward Exchange Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
13 | /BA1/TF4_FXKURST | Map Exchange Rate Category to Rate Type | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
14 | /BA1/TF4_FXRTTPT | Text Table for Exchange Rate Categories | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
15 | /BA1/TF4_FXRTTYP | Rate Categories for Exchange Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
16 | /BA1/TF4_MDC | Market Data Area | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
17 | /BA1/TF4_MDCT | Market Data Area | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
18 | /BA1/TF4_MDSET | Market Data Records | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
19 | /BA1/TF4_MDSETRY | Forward Yield Curves for Reference Interest Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
20 | /BA1/TF4_MDSETT | Market Data Records | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
21 | /BA1/TF4_MDSETV | Underlying Independent Volatilities per Currency | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
22 | /BA1/TF4_MDSETYP | Market Data Types in the Market Data Set | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
23 | /BA1/TF4_PADDON | Definition of Price Symbols | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
24 | /BA1/TF4_PADDONT | Definition of Price Symbols | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
25 | /BA1/TF4_PRINFO | Definition of Price Information | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
26 | /BA1/TF4_PRTYPE | Definition of Price Types | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
27 | /BA1/TF4_PRTYPET | Text Table for /BA1/TF4_PRTYPET | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
28 | /BA1/TF4_RCALCB | Assignment of Calculation Bases to Reference Interest Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
29 | /BA1/TF4_REFRATE | Reference Interest Rates: Attributes | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
30 | /BA1/TF4_REFRATT | Reference Interest Rates: Name (Language-Dependent) | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
31 | /BA1/TF4_RPLTYPE | Replacement Types for Yield Curves | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
32 | /BA1/TF4_RPLTYPT | Text Table for Replacement Types | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
33 | /BA1/TF4_RRATES | Reference Interest Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
34 | /BA1/TF4_SCEN | Market Date Scenarios | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
35 | /BA1/TF4_SCENPGP | Grid Points of a Scenario Progression | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
36 | /BA1/TF4_SCENSQC | Grid Points for Scenario Sequences | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
37 | /BA1/TF4_SCENT | Market Date Scenarios | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
38 | /BA1/TF4_SCFX | Scenario Exchange Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
39 | /BA1/TF4_SCFXV | Scenarios for Exchange Rate Volatility | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
40 | /BA1/TF4_SCIRV | Interest Volatility Scenarios | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
41 | /BA1/TF4_SCREFR | Scenario Interest Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
42 | /BA1/TF4_SCREFSP | Scenario nterest Rate Spreads | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
43 | /BA1/TF4_SCSEC | Security Price Scenarios | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
44 | /BA1/TF4_SCSECV | Security Volatility Scenarios | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
45 | /BA1/TF4_SCS_FX | Exchange Rate Shifts | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
46 | /BA1/TF4_SCS_SEC | Security Price Shifts | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
47 | /BA1/TF4_SCS_VOL | Volatility Shifts | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
48 | /BA1/TF4_SCS_YC | Zero Shifts for Yield Curves | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
49 | /BA1/TF4_SCTYPE | Spread Curve Types | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
50 | /BA1/TF4_SEQUCE | Definition of Read Sequence | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
51 | /BA1/TF4_SPRDTYP | Spread Types | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
52 | /BA1/TF4_SPRDTYT | Spread Types: Names (Language-Dependent) | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
53 | /BA1/TF4_STDYC | Standard Yield Curves | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
54 | /BA1/TF4_STRTGY | Definition of Read Strategy | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
55 | /BA1/TF4_STRTGYT | Definition of Price Symbols | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
56 | /BA1/TF4_SYCGRID | Standard Yield Curves: Grid Points for Reference Int. Rates | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
57 | /BA1/TF4_UNIT | Definition of Exchange Rate Units | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
58 | /BA1/TF4_UNITT | Definition of Price Symbols | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
59 | /BA1/TF4_VCLUS | Volatility Cluster | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
60 | /BA1/TF4_VTYP | Volatility Types | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
61 | /BA1/TF4_VTYPT | Text Table for Volatility Types | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
62 | /BA1/TF4_YCRPLMT | Yield Curve Replacement | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
63 | /BA1/TF4_YCTYPE | Yield Curve Types | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
64 | /BA1/TF4_YCTYPET | Yield Curve Types: Name (Language-Dependent) | 3 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
65 | /BA1/TF4_YCURVE | Yield Curves: General Properties | 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |
TOPMulti Currency Accounting |
66 | GLE_MCA_RV_HSTRY | FX Revaluation History | 15 | MDCODE | Market Data Area | nvarchar | 4 | 0 | | |