DW_EB_X_EBS_COMMON_W_PRODUCT_ADDL_ATTR_D
This is a sister table to DW_EB_X_EBS_COMMON_W_PRODUCT_D. It stores the Additional Attributes of a Product.
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 | Source System Identifier | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Business Key of the table | |||
| SCD1_WID | NUMBER | 38 | Primary Key of the table | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Dates | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Dates | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Dates | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary Changed on Dates | |||
| CHANGED_BY_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_USER_D for Changed By User | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Changed On Date | |||
| CREATED_BY_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_USER_D for Created By User | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Created On Date | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Identifier | |||
| PRODUCT_ATTR10_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR10_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR10_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR11_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR11_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR12_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR12_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR13_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR13_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR14_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR14_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR15_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR15_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR16_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR16_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR17_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR17_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR18_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR18_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR19_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR19_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR1_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR1_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR1_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR20_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR20_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR21_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR22_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR23_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR24_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR25_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR26_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR27_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR28_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR29_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR2_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR2_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR2_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR30_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR3_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR3_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR3_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR4_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR4_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR4_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR5_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR5_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR5_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR6_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR6_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR6_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR7_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR7_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR7_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR8_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR8_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR8_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| PRODUCT_ATTR9_CHAR | VARCHAR2 | 255 CHAR | Additional Varchar Attribute | |||
| PRODUCT_ATTR9_DATE | TIMESTAMP | 6 | Additional Date Attribute | |||
| PRODUCT_ATTR9_NUM | NUMBER | 20,4 | Additional Number Attribute | |||
| SET_ID | VARCHAR2 | 80 CHAR | Set Identifier | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | Source Effective From Date | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | Source Effective To Date | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Identifier | |||
| X_CUSTOM | VARCHAR2 | 80 CHAR | Extensible Custom Attribute | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |