| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BI0/SRATE_TYPE | Master Data IDs: InfoObject Exchange rate type | 1 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
2 | TLRC_THM_SCHEME | Threshold Scheme Definition | 7 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
3 | TYC_BSPRD_MD | Basis Spreads: Market Data | 4 | RATE_TYPE | Rate Type | nvarchar | 1 | 0 | | |
4 | TYC_CSPRD_MD | Credit Spreads: Market Data | 5 | RATE_TYPE | Rate Type | nvarchar | 1 | 0 | | |
5 | VTVSZBS | Scenario Database: Basis Spreads | 5 | RATE_TYPE | Rate Type | nvarchar | 1 | 0 | | |
6 | VTVSZCS | Scenario Database: Credit Spreads | 6 | RATE_TYPE | Rate Type | nvarchar | 1 | 0 | | |
TOPBack Office |
7 | TRFT_CLASS_POS | Treasury: TRF Class Position | 10 | RATE_TYPE | Rate/Price Type - Treasury Instruments | nvarchar | 2 | 0 | | |
TOPBusiness Partner |
8 | TP39 | Selection Variants | 4 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPChargeback |
9 | WCOCOH | Condition Contract: Header | 33 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
10 | T8JOH_FORMULAS | Formulas used by each overhead in Overhead Organizer | 5 | RATE_TYPE | Type of rate used in the formula | nvarchar | 1 | 0 | | |
TOPTransaction Management |
11 | FTR_AVG_SCHEDULE | Schedule with Rates | 4 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
12 | TRLIC_AD_HEAD | Customizing Accrual/Deferral: Differentiation | 8 | RATE_TYPE | Exch. Rate Type for Translating Accr/Deferral to Local Crcy | nvarchar | 4 | 0 | | |
13 | TRTFC_DFTASS | Update Types for Transfer Posting | 12 | RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | | |
TOPTravel Planning |
14 | FTPT_IMR_HTL | IMR - Hotel | 18 | RATE_TYPE | Room type code for Hotels | nvarchar | 4 | 0 | | |