DW_EB_X_EBS_COMMON_W_GLOBAL_CURR_G
This table stores the five Global Currencies that are configured in CM.
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 |
|---|---|---|---|---|---|---|
| TENANT_ID | VARCHAR2 | 30 CHAR | True | Tenant Id which will be useful in Multi Tenancy Environments. | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | DataSource Number | |||
| DEFAULT_LOC_RATE_TYPE | VARCHAR2 | 30 CHAR | Default Local Currency Rate Type | |||
| GLOBAL1_CURR_CODE | VARCHAR2 | 30 CHAR | Global 1 Currency Code | |||
| GLOBAL1_RATE_TYPE | VARCHAR2 | 30 CHAR | Global 1 Rate Type | |||
| GLOBAL2_CURR_CODE | VARCHAR2 | 30 CHAR | Global 2 Currency Code | |||
| GLOBAL2_RATE_TYPE | VARCHAR2 | 30 CHAR | Global 2 Rate Type | |||
| GLOBAL3_CURR_CODE | VARCHAR2 | 30 CHAR | Global 3 Currency Code | |||
| GLOBAL3_RATE_TYPE | VARCHAR2 | 30 CHAR | Global 3 Rate Type | |||
| GLOBAL4_CURR_CODE | VARCHAR2 | 30 CHAR | Global 4 Currency Code | |||
| GLOBAL4_RATE_TYPE | VARCHAR2 | 30 CHAR | Global 4 Rate Type | |||
| GLOBAL5_CURR_CODE | VARCHAR2 | 30 CHAR | Global 5 Currency Code | |||
| GLOBAL5_RATE_TYPE | VARCHAR2 | 30 CHAR | Global 5 Rate Type | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |