DW_EB_X_EBS_PROC_W_PROC_PROD_D
No table description is available in the supplied metadata.
Details
Module: Procurement (EBS_PROC)
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 | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CATEGORY_ID | VARCHAR2 | 80 CHAR | ||||
| CAT_SET_CATEGORY_ID | VARCHAR2 | 80 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CMP_PROC_PROD_ID | VARCHAR2 | 300 CHAR | ||||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | ||||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| INTEGRATION_ID | VARCHAR2 | 300 CHAR | ||||
| ITEM_DESC | VARCHAR2 | 250 CHAR | ||||
| LOC_CURRENCY_CODE | VARCHAR2 | 30 CHAR | ||||
| MARKET_PRICE | NUMBER | 28,10 | ||||
| PART_NUM | VARCHAR2 | 80 CHAR | ||||
| PROC_PROD_CODE | VARCHAR2 | 300 CHAR | ||||
| PROC_PROD_ID | VARCHAR2 | 300 CHAR | ||||
| PROC_PROD_TYPE | VARCHAR2 | 80 CHAR | ||||
| REJECT_FLG | VARCHAR2 | 1 CHAR | ||||
| ROUNDING_FACTOR | NUMBER | 28,10 | ||||
| STANDARD_UOM_CODE | VARCHAR2 | 30 CHAR | ||||
| SUPPLIER_ID | VARCHAR2 | 80 CHAR | ||||
| SUPPLIER_NAME | VARCHAR2 | 250 CHAR | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| UNSPSC_CODE | VARCHAR2 | 80 CHAR | ||||
| VENDOR_ITEM | VARCHAR2 | 300 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |