DW_EB_X_EBS_COMMON_W_UOM_CONVERSION_G
This table stores the class conversion rate between different Unit Of Measures. Conversion values like Kilograms to Pounds, Kilometers to Miles etc.
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 |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | Data source number Identifier | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration ID | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on date ¿ 1 | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on date ¿ 2 | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on date ¿ 3 | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on date ¿ 4 | |||
| CHANGED_BY_WID | NUMBER | 38 | Record Changed by | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Changed on Date | |||
| CONVERSION_RATE | NUMBER | Conversion Rate | ||||
| CREATED_BY_WID | NUMBER | 38 | Record Created by | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Created in Date | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Warehouse Identifier | |||
| FROM_UOM_CODE | VARCHAR2 | 80 CHAR | ||||
| INVENTORY_ORG_ID | VARCHAR2 | 80 CHAR | Organization for which the Conversion Rate is stored. This is applicable only to certain ERP systems like JDE. The column will be null for EBS, PSFT data. | |||
| PRODUCT_ID | VARCHAR2 | 80 CHAR | Inventory Item Id | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Identifier | |||
| TO_UOM_CODE | VARCHAR2 | 80 CHAR | ||||
| W_FROM_UOM_CODE | VARCHAR2 | 50 CHAR | From Unit of measure Code | |||
| W_TO_UOM_CODE | VARCHAR2 | 50 CHAR | To Unit of measure Code | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |