DW_EB_X_EBS_COMMON_W_PRODUCT_D

Product entity stores information about the Products of various product types viz., Finished Goods, Raw Material and other types of Products from the CRM, ERP & other source systems.The grain of this table is at the level of Unique Product defined in the source system¿s Product Master. In some source systems, that support multiple plants/Orgs, a master plant/ Org is maintained to define the master list of products that can be further copied into other plants/ Orgs where some attributes can be changed. In such cases, this entity would hold the Products defined in the Master Plant/ Org.This table is designed to be a slowly changing dimension that supports Type-2 changes.

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER		38	True	Surrogate key to uniquely identify a record .
APPLICATION_FLG	VARCHAR2	1 CHAR			Application Flag
APPROVAL_STATUS_CODE	VARCHAR2	80 CHAR
AUX1_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AVG_SALES_CYCLE	NUMBER		22
BASE_UOM_CODE	VARCHAR2	80 CHAR			Standard Unit Of Measure Code
BASIC_PRODUCT	VARCHAR2	30 CHAR			Basic Product
BATCH_IND	VARCHAR2	1 CHAR			Batch indicator flag
BODY_STYLE_CODE	VARCHAR2	80 CHAR
BRAND	VARCHAR2	30 CHAR			Brand
CASE_PACK	NUMBER		28,10		Case Pack
CHANGED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was last modified in the source system.
COLOR	VARCHAR2	30 CHAR			Color
CONFIG_CAT_CODE	VARCHAR2	80 CHAR			Config Cat Code
CONFIG_PROD_IND	VARCHAR2	1 CHAR			Config Prod Ind
CONTAINER_CODE	VARCHAR2	80 CHAR			Container Code
CREATED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was initially created in the source system.
CTLG_CAT_ID	VARCHAR2	30 CHAR			Catalog category id for building CS hierarchy
CURRENT_FLG	VARCHAR2	1 CHAR			This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
CUSTOM_PROD_FLG	VARCHAR2	1 CHAR			Custom Product Flag (Y/N) : If the Product is configurable then it is set to Y otherwise to N
C_BASE_UOM_CODE	VARCHAR2	80 CHAR			Standard Unit Of Measure Code
DATASOURCE_NUM_ID	NUMBER		10		This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
DEALER_INV_PRICE	NUMBER		28,10		Vehicle model dealer invoice price
DELETE_FLG	VARCHAR2	1 CHAR			This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
DETAIL_TYPE_CODE	VARCHAR2	80 CHAR
DISCONTINUATION_DT	TIMESTAMP		6		Date the product was Discontinued
DOORS_TYPE_CODE	VARCHAR2	80 CHAR
DRIVE_TRAIN_CODE	VARCHAR2	80 CHAR
ECO_FRIENDLY_FLG	VARCHAR2	1 CHAR
EFFECTIVE_FROM_DT	TIMESTAMP		6		This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EFFECTIVE_TO_DT	TIMESTAMP		6		This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
ENGINE_TYPE_CODE	VARCHAR2	80 CHAR
ETL_PROC_WID	NUMBER		38		Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FRU_FLG	VARCHAR2	1 CHAR			Field-Replaceable Unit flag
FUEL_TYPE_CODE	VARCHAR2	80 CHAR
GROSS_MRGN	NUMBER		28,10		Gross Margin
HAZARD_MTL_CODE	VARCHAR2	80 CHAR			Hazardous material code
INDUSTRY_CODE	VARCHAR2	80 CHAR			Industry Code
INTEGRATION_ID	VARCHAR2	80 CHAR			This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
INTRODUCTION_DT	TIMESTAMP		6		Product Introduction Date
INVENTORY_FLG	VARCHAR2	1 CHAR			Inventory Flag
ITEM_CLASS_CODE	VARCHAR2	200 CHAR
ITEM_SIZE	NUMBER		28,10		Item Size
LAST_PURCH_DT	TIMESTAMP		6
LEAD_TIME	VARCHAR2	30 CHAR			Lead Time for Product Delivery
LOC_CURRENCY_CODE	VARCHAR2	80 CHAR
LOW_LEVEL_CODE	VARCHAR2	80 CHAR			Low Level Code
MAKE_BUY_IND	VARCHAR2	1 CHAR			Make Buy Indicator
MAKE_CODE	VARCHAR2	80 CHAR
MARKET_PRICE	NUMBER		22,10
MODEL_CODE	VARCHAR2	80 CHAR
MODEL_YR	NUMBER		28,10		Vehicle model year
MSRP	NUMBER		28,10		MSRP
MTBF	NUMBER		28,10		Mean time between failures
MTTR	NUMBER		28,10		Mean time to repair
NRC_FLG	VARCHAR2	1 CHAR			Non Recurring Charge Flag
NUM_OF_ACCT_OWNING	NUMBER		22
ORDERABLE_FLG	VARCHAR2	1 CHAR			Orderable Flag
PACKAGED_PROD_FLG	VARCHAR2	1 CHAR			Packaged Product Flag (Y/N) : If the product is part of the bundle then it is set to Y otherwise to N
PACK_FLG	VARCHAR2	1 CHAR
PART_NUM	VARCHAR2	80 CHAR			Part Number
PAR_INTEGRATION_ID	VARCHAR2	80 CHAR			Id of the parent of the object
PREDICTED_REVENUE	NUMBER		22
PRICE_TYPE_CODE	VARCHAR2	80 CHAR
PROCESS_QUALITY_ENABLED_FLG	VARCHAR2	1 CHAR			Process Quality Enabled Flag (Manufacturing)
PRODUCT_CATEGORY_FLG	VARCHAR2	1 CHAR			This flag identifies whether the current record is a Product Category(Y) or an Item.
PRODUCT_CLASS	VARCHAR2	50 CHAR
PRODUCT_GROUP_FLG	VARCHAR2	1 CHAR
PRODUCT_PARENT_CLASS	VARCHAR2	50 CHAR
PRODUCT_PHASE	VARCHAR2	30 CHAR
PRODUCT_TYPE_CODE	VARCHAR2	80 CHAR			Product Type Code
PROD_CAT1	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT1_WID.
PROD_CAT10	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT10_WID.
PROD_CAT10_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT10_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT10_WID_AS_WAS	NUMBER		10
PROD_CAT1_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT1_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is mapped to the Purchasing hierarchy.
PROD_CAT1_WID_AS_WAS	NUMBER		10
PROD_CAT2	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT2_WID.
PROD_CAT2_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT2_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is mapped to the General Category hierarchy.
PROD_CAT2_WID_AS_WAS	NUMBER		10
PROD_CAT3	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT3_WID.
PROD_CAT3_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT3_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT3_WID_AS_WAS	NUMBER		10
PROD_CAT4	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT4_WID.
PROD_CAT4_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT4_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT4_WID_AS_WAS	NUMBER		10
PROD_CAT5	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT5_WID.
PROD_CAT5_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT5_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT5_WID_AS_WAS	NUMBER		10
PROD_CAT6	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT6_WID.
PROD_CAT6_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT6_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT6_WID_AS_WAS	NUMBER		10
PROD_CAT7	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT7_WID.
PROD_CAT7_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT7_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT7_WID_AS_WAS	NUMBER		10
PROD_CAT8	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT8_WID.
PROD_CAT8_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT8_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT8_WID_AS_WAS	NUMBER		10
PROD_CAT9	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the PROD_CAT9_WID.
PROD_CAT9_AS_WAS	VARCHAR2	80 CHAR
PROD_CAT9_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is not mapped.
PROD_CAT9_WID_AS_WAS	NUMBER		10
PROD_GRP_CODE	VARCHAR2	80 CHAR			Product Group Code
PROD_GRP_EFF_END_DT	TIMESTAMP		6
PROD_GRP_EFF_START_DT	TIMESTAMP		6
PROD_LIFE_CYCL_CODE	VARCHAR2	80 CHAR
PROD_NDC_ID	VARCHAR2	30 CHAR			NDC Number
PROD_NUM	NUMBER		10
PROD_REPRCH_PERIOD	NUMBER		10		Prod Reprch Period
PROD_STRUCTURE_TYPE	VARCHAR2	80 CHAR			Product Structure Type
PROFIT_RANK_CODE	VARCHAR2	80 CHAR
PR_EQUIV_PROD_NAME	VARCHAR2	100 CHAR			Equivalent Product
PR_PROD_LN	VARCHAR2	100 CHAR			Primary product line
REFERRAL_FLG	VARCHAR2	1 CHAR			Referral Flag
ROUNDING_FACTOR	NUMBER		22,10
RTRN_DEFECTIVE_FLG	VARCHAR2	1 CHAR			Return defective flag
RX_AVG_PRICE	NUMBER		28,10		Prescription Conversion Average Price
R_TYPE_CODE	VARCHAR2	80 CHAR
SALES_PRODUCT_TYPE	VARCHAR2	80 CHAR
SALES_PROD_CAT_ID	VARCHAR2	80 CHAR
SALES_PROD_CAT_WID	NUMBER		38			DW_EB_X_EBS_COMMON_W_PROD_CAT_DH
SALES_PROD_FLG	VARCHAR2	1 CHAR			Sales Product Flag
SALES_REFERENCE_CNT	NUMBER		22
SALES_SRVC_FLG	VARCHAR2	1 CHAR			Service Flag
SALES_UOM_CODE	VARCHAR2	80 CHAR			Sales Unit of Measure
SCD1_WID	NUMBER		38
SERIALIZED_COUNT	NUMBER		10		Serialized Count
SERIALIZED_FLG	VARCHAR2	1 CHAR			Serialized Flag
SERVICE_CAT_ID	VARCHAR2	80 CHAR
SERVICE_CAT_WID	NUMBER		38
SERVICE_TYPE_CODE	VARCHAR2	80 CHAR
SET_ID	VARCHAR2	30 CHAR			This column represents an unique identifier often used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
SHELF_LIFE	NUMBER		10		Shelf Life
SHIP_MTHD_GRP_CODE	VARCHAR2	80 CHAR			Ship Mthd Grp Code
SHIP_MTL_GRP_CODE	VARCHAR2	80 CHAR			Ship Mtl Grp Code
SHIP_TYPE_CODE	VARCHAR2	80 CHAR			Ship Type Code
SOURCE_OF_SUPPLY	VARCHAR2	30 CHAR			Source Of Supply
SPRT_WITHDRAWL_DT	TIMESTAMP		6		Date on the which Product Support is Withdrawn
SRC_EFF_FROM_DT	TIMESTAMP		6		This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DT	TIMESTAMP		6		This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
STATUS_CODE	VARCHAR2	80 CHAR
STORAGE_TYPE_CODE	VARCHAR2	80 CHAR			Storage Type Code
SUB_TYPE_CODE	VARCHAR2	80 CHAR
TENANT_ID	VARCHAR2	80 CHAR			This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
TGT_CUST_TYPE_CODE	VARCHAR2	80 CHAR
TLA_FLAG	VARCHAR2	1 CHAR
TOT_EXST_PROD_REV	NUMBER		22
TRANSMISSION_CODE	VARCHAR2	80 CHAR
TRIM_CODE	VARCHAR2	80 CHAR
UNIT_CONV_FACTOR	NUMBER		28,10		Unit Conversion Factor
UNIT_GROSS_WEIGHT	NUMBER		28,10		Units for Gross Weight
UNIT_NET_WEIGHT	NUMBER		28,10		Units for Net Weight
UNIT_VOLUME	NUMBER		28,10		Unit Volume
UNIV_PROD_CODE	VARCHAR2	80 CHAR			Univ Prod Code
UNSPSC_CODE	VARCHAR2	80 CHAR			This field maps to the INTEGRATION_ID of the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. It is used as a lookup to identify the UNSPSC_PROD_CAT_WID. In general, do not connect this port in the SDE or SIL mapping. A PLP mapping updates this column from a flat file where users classify a Product to its UNSPSC Code.
UNSPSC_PROD_CAT_WID	NUMBER		38		FK to the DW_EB_X_EBS_COMMON_W_PROD_CAT_DH table. This field identifies the Product Category Hierarchy. Out of the box, it is mapped to UNSPSC Category Hierarchy. In general, do not connect this port in the SDE or SIL mapping. A PLP mapping updates this column from a flat file where users classify a Product to its UNSPSC Code.
UOM_CODE	VARCHAR2	80 CHAR
UOV_CODE	VARCHAR2	80 CHAR			Uov Code
UOW_CODE	VARCHAR2	80 CHAR			Uow Code
U_DEALER_INV_PRICE	NUMBER		28,10		U Dealer Inv Price
U_DELPRI_CURCY_CD	VARCHAR2	20 CHAR			U Delpri Curcy Cd
U_DELPRI_EXCH_DT	TIMESTAMP		6		U Delpri Exch Dt
U_MSRP	NUMBER		28,10		U Msrp
U_MSRP_CURCY_CD	VARCHAR2	20 CHAR			U Msrp Curcy Cd
U_MSRP_EXCH_DT	TIMESTAMP		6		U Msrp Exch Dt
U_RXAVPR_CURCY_CD	VARCHAR2	20 CHAR			U Rxavpr Curcy Cd
U_RXAVPR_EXCH_DT	TIMESTAMP		6		U Rxavpr Exch Dt
U_RX_AVG_PRICE	NUMBER		28,10		U Rx Avg Price
VENDOR_LOC	VARCHAR2	50 CHAR			Vendor location
VENDOR_LOC1	VARCHAR2	50 CHAR			Vendor location history1
VENDOR_LOC2	VARCHAR2	50 CHAR			Vendor location history2
VENDOR_LOC3	VARCHAR2	50 CHAR			Vendor location history3
VENDOR_NAME	VARCHAR2	100 CHAR			Vendor name
VENDR_PART_NUM	VARCHAR2	50 CHAR			Vendor Cat Number
VER_DT	TIMESTAMP		6		Version Date
VER_DT1	TIMESTAMP		6		Vendor location history1 date
VER_DT2	TIMESTAMP		6		Vendor location history2 date
VER_DT3	TIMESTAMP		6		Vendor location history3 date
W_STATUS_CODE	VARCHAR2	80 CHAR
X_CUSTOM	VARCHAR2	10 CHAR			This column is used as a generic field for customer extensions.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6