DW_EB_X_EBS_COMMON_W_PRODUCT_GROUP_ADDL_D
No table description is available in the supplied metadata.
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 |
|---|---|---|---|---|---|---|
| BASE_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 | ||||
| BASE_EFFECTIVE_FROM_DT | TIMESTAMP | 6 | ||||
| BASE_EFFECTIVE_TO_DT | TIMESTAMP | 6 | ||||
| BASE_SRC_EFF_FROM_DT | TIMESTAMP | 6 | ||||
| BASE_SRC_EFF_TO_DT | TIMESTAMP | 6 | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CREATED_BY_WID | NUMBER | 38 | ||||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | ||||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | ||||
| PROD_GRP_ATTR_CHAR_001 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_002 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_003 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_004 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_005 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_006 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_007 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_008 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_009 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_010 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_011 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_012 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_013 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_014 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_015 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_016 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_017 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_018 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_019 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_020 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_021 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_022 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_023 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_024 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_025 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_026 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_027 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_028 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_029 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_030 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_031 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_032 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_033 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_034 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_035 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_036 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_037 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_038 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_039 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_040 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_041 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_042 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_043 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_044 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_045 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_046 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_047 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_048 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_049 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_050 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_051 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_052 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_053 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_054 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_055 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_056 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_057 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_058 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_059 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_060 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_061 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_062 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_063 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_064 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_065 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_066 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_067 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_068 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_069 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_070 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_071 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_072 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_073 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_074 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_075 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_076 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_077 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_078 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_079 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_080 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_081 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_082 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_083 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_084 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_085 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_086 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_087 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_088 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_089 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_090 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_091 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_092 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_093 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_094 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_095 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_096 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_097 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_098 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_099 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_100 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_101 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_102 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_103 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_104 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_105 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_106 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_107 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_108 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_109 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_110 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_111 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_112 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_113 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_114 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_115 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_116 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_117 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_118 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_119 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_120 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_121 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_122 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_123 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_124 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_CHAR_125 | VARCHAR2 | 1500 CHAR | ||||
| PROD_GRP_ATTR_DATE_001 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_002 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_003 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_004 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_005 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_006 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_007 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_008 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_009 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_010 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_011 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_012 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_013 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_014 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_015 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_016 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_017 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_018 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_019 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_DATE_020 | TIMESTAMP | 6 | ||||
| PROD_GRP_ATTR_NUM_001 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_002 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_003 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_004 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_005 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_006 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_007 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_008 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_009 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_010 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_011 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_012 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_013 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_014 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_015 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_016 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_017 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_018 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_019 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_020 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_021 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_022 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_023 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_024 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_025 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_026 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_027 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_028 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_029 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_030 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_031 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_032 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_033 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_034 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_035 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_036 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_037 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_038 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_039 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_040 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_041 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_042 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_043 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_044 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_045 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_046 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_047 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_048 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_049 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_050 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_051 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_052 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_053 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_054 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_055 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_056 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_057 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_058 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_059 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_060 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_061 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_062 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_063 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_064 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_065 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_066 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_067 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_068 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_069 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_070 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_071 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_072 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_073 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_074 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_075 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_076 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_077 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_078 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_079 | NUMBER | |||||
| PROD_GRP_ATTR_NUM_080 | NUMBER | |||||
| ROW_WID | NUMBER | 38 | ||||
| SCD1_WID | NUMBER | 38 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| X_CUSTOM | VARCHAR2 | 80 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |