| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 16 | RATETYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPBank Customer Accounts |
2 | TBKK01 | Bank Area Table | 12 | RATETYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPBasic Market Data |
3 | /BA1/F4_FXRATES | Exchange Rates | 3 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
4 | /BA1/TF4_APPL | Partner Applications | 4 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
5 | /BA1/TF4_FXCVFCT | Exchange Rate Factors for Exchange Rates | 3 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
6 | /BA1/TF4_FXFWDYC | Yield Curve Types for Forward Exchange Rates | 3 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
7 | /BA1/TF4_FXKURST | Map Exchange Rate Category to Rate Type | 3 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
8 | /BA1/TF4_FXRTTPT | Text Table for Exchange Rate Categories | 4 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
9 | /BA1/TF4_FXRTTYP | Rate Categories for Exchange Rates | 3 | RATETYPE | Exchange Rate Category | nvarchar | 4 | 0 | | |
TOPCollateral Management System |
10 | TCMS_CLNT | CMS: Clientdependent Customizing Data | 6 | RATETYPE | Exchange Rate Type for Currency Conversion | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
11 | TIVCACTRULE | Currency Translation Rule | 4 | RATETYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
12 | T8JOVR | Overhead burden rate | 3 | RATETYPE | Burden rate type | nvarchar | 1 | 0 | | |
13 | T8JOVRP | Overhead burden rate percentages | 4 | RATETYPE | Burden rate type | nvarchar | 1 | 0 | | |
14 | T8JOVRT | Overhead burden rate text | 4 | RATETYPE | Burden rate type | nvarchar | 1 | 0 | | |
15 | T8JVORP | Overhead burden rate percentages (venture level) | 4 | RATETYPE | Burden rate type | nvarchar | 1 | 0 | | |
TOPMaster Data |
16 | TCMS_BANKAREA | CMS: Bankarea | 4 | RATETYPE | Exchange Rate Type for Currency Conversion | nvarchar | 4 | 0 | | |
TOPMulti Currency Accounting |
17 | GLE_MCA_RV_HSTRY | FX Revaluation History | 16 | RATETYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPSAP Utilities |
18 | TECONTYP | Concession Type | 14 | RATETYPE | Rate Type | nvarchar | 8 | 0 | | |
TOPTravel Planning |
19 | TA21H | Hotel Rates | 3 | RATETYPE | Hotel Rate Type | nvarchar | 1 | 0 | | |