DW_EB_X_EBS_COMMON_W_GLOBAL_EXCH_RATE_G
This Exchange Rate table stores the conversions from Local Currencies to all 5 Global Currencies. There are 5 'To Currency' columns in this table and Facts which require these can use this table instead of Exch Rate Table (DW_EB_X_EBS_COMMON_W_EXCH_RATE_G)
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate Key of the Table | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Date Columns | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Date Columns | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Date Columns | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Date Columns | |||
| CHANGED_BY_WID | NUMBER | 38 | Foreign Key to DW_EB_X_EBS_COMMON_W_USER_D table for Changed By User | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Last Updated Date from Source | |||
| CREATED_BY_WID | NUMBER | 38 | Foreign Key to DW_EB_X_EBS_COMMON_W_USER_D table for Created By User | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Creation Date | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXCH_DATE | TIMESTAMP | 6 | Exchange Date for which the Currency Conversions are stored. | |||
| GLBL1_EXCH_RATE | NUMBER | Exchange Rate for Global 1 Currency Code. | ||||
| GLBL2_EXCH_RATE | NUMBER | Exchange Rate for Global 2 Currency Code. | ||||
| GLBL3_EXCH_RATE | NUMBER | Exchange Rate for Global 3 Currency Code. | ||||
| GLBL4_EXCH_RATE | NUMBER | Exchange Rate for Global 4 Currency Code. | ||||
| GLBL5_EXCH_RATE | NUMBER | Exchange Rate for Global 5 Currency Code. | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| W_FROM_CURRENCY_CODE | VARCHAR2 | 30 CHAR | Warehouse Code Column for From Currency | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |