DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D

DW_EB_X_EBS_COMMON_W_INVENTORY_PRODUCT_D dimension table is used to maintain information on the inventory policies and processes followed for handling products at a specific business location such as a plant, warehouse, and so on. The products that are featured in this table would usually be a subset of all products available in the DW_EB_X_EBS_COMMON_W_PRODUCT_D dimension table. For example, Production raw materials used within a manufacturing plant, Goods purchased and traded for a premium at a warehouse, and so on. Critical inventory process information maintained about a product at the business location includes the ABC indicator, the sourcing method, reorder policies, MRP profiles and buyer information. This table does not contain inventorial information about the product such as inventory location, current stock, andso on. The information in this table is mostly expected to be static in nature and would not represent information related to the current stock levels of the product (such information is maintained in the inventory balance table). Type II information is enabled for this dimension table. Products can enter this table when a business organization expands its operations to included new business locations from where products are shipped out or sourced into.

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.
ABC_IND	VARCHAR2	1 CHAR			ABC Indicator ( Indicator that classifies a material as an A, B, or C part according to its consumption value )
ACTIVE_FLG	VARCHAR2	1 CHAR			This identifies whether the source record is Active/Enabled or not
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.
BACKFLUSH_IND	VARCHAR2	1 CHAR			Backflush Indicator ( Determines whether the backflush indicator is set in the production order)
BULK_ITEM_IND	VARCHAR2	1 CHAR			Bulk item Indicator
BUYER_CODE	VARCHAR2	80 CHAR			Buyer Code
BUYER_NAME	VARCHAR2	80 CHAR
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.
COMMODITY_CODE	VARCHAR2	80 CHAR			Commodity Code
COMMODITY_NAME	VARCHAR2	80 CHAR			Commodity Name
COMMODITY_UOM_CODE	VARCHAR2	80 CHAR			Unit of measure of commodity
COMMODITY_UOM_NAME	VARCHAR2	80 CHAR			Commodity Unit of Measure Name
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.
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER		22
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.
C_PRIMARY_UOM_CODE	VARCHAR2	80 CHAR			Primary 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.
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.
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.
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.
EXT_PROCURE_TIME	NUMBER		28,10		Time needed to obtain the material or service if it is procured externally.
EXT_STORE_LOC_CODE	VARCHAR2	80 CHAR			External storage location Code
EXT_STORE_LOC_NAME	VARCHAR2	80 CHAR			External Store Location Name
FIXED_LEAD_TIME	NUMBER		22
FIXED_LOT_SIZE	NUMBER		28,10		Fixed lot size
FORECAST_PERIOD	VARCHAR2	30 CHAR			Forecast period ( Like Weekly , Monthly etc)
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.
INTERNAL_MFG_TIME	NUMBER		28,10		Internal manufacturing time
INT_STORE_LOC_CODE	VARCHAR2	80 CHAR			Internal storage location Code
INT_STORE_LOC_NAME	VARCHAR2	80 CHAR			Internal Store Location Name
INVENTORY_ORG_WID	NUMBER		38		Identifies the inventory organization.	DW_EB_X_EBS_COMMON_W_INT_ORG_D
INVOICEABLE_ITEM_FLAG	VARCHAR2	1 CHAR			Determines if the item is invoiceable, to determine if an order line contributes to financial backlog.
INVOICE_ENABLED_FLAG	VARCHAR2	1 CHAR			Determines if the item is invoice enabled to determine if an order line contributes to financial backlog.
INV_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.
INV_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.
INV_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.
INV_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 Inventory hierarchy.	DW_EB_X_EBS_COMMON_W_PROD_CAT_DH
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
INV_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.
ISSUE_UOM_CODE	VARCHAR2	80 CHAR			Unit of measure in issues
ISSUE_UOM_NAME	VARCHAR2	80 CHAR			Issue Unit of Measure Name
LOADING_TYPE_CODE	VARCHAR2	80 CHAR			Loading type Code
LOADING_TYPE_NAME	VARCHAR2	80 CHAR			Loading Type Name
LOT_ORDERING_COST	NUMBER		28,10		Cost of ordering a lot
LOT_SIZE_CODE	VARCHAR2	80 CHAR			Lot size Code
LOT_SIZE_NAME	VARCHAR2	80 CHAR			Lot Size Name
MAKE_BUY_IND	VARCHAR2	1 CHAR
MANUFACTURING_PLACE	VARCHAR2	80 CHAR			Place of manufacturing
MAX_LOT_SIZE	NUMBER		28,10		Maximum lot size
MAX_STOCK_LEVEL	NUMBER		28,10		Maximum stock level
MAX_STORAGE_DAYS	NUMBER		28,10		Maximum storage period in days
MFG_UOM_CODE	VARCHAR2	80 CHAR			Unit of measure in manufacturing, Primary Unit of Measure Code
MFG_UOM_NAME	VARCHAR2	80 CHAR			Manufacturing Unit of Measure
MIN_LOT_SIZE	NUMBER		28,10		Minimum lot size
MRP_GRP_CODE	VARCHAR2	80 CHAR			Planning group Code
MRP_GRP_NAME	VARCHAR2	80 CHAR			MRP Group Name
MRP_PROFILE_CODE	VARCHAR2	80 CHAR			Planning profile Code
MRP_PROFILE_NAME	VARCHAR2	80 CHAR			MRP Profile Name
MRP_TIME_FENCE	NUMBER		28,10		Planning time fence
MRP_TYPE_CODE	VARCHAR2	80 CHAR			Planning type Code
MRP_TYPE_NAME	VARCHAR2	80 CHAR			MRP Type Name
PLANNER_CODE	VARCHAR2	80 CHAR			Planner Code
PLANNER_NAME	VARCHAR2	80 CHAR			Planner Name
PLANT_LOC_WID	NUMBER		38		Key to the business location dimension	DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D
POSTPROCESSING_LEAD_TIME	NUMBER		22
PREPROCESSING_LEAD_TIME	NUMBER		22
PRIMARY_UOM_CODE	VARCHAR2	80 CHAR			Primary Unit of Measure Code
PRIMARY_UOM_NAME	VARCHAR2	80 CHAR			Primary Unit of Measure
PROCESS_QUALITY_ENABLED_FLG	VARCHAR2	1 CHAR
PROCUREMENT_TYPE_CODE	VARCHAR2	80 CHAR			Procurement Type Code
PROCUREMENT_TYPE_NAME	VARCHAR2	80 CHAR			Procurement Type Name
PRODUCT_NUM	VARCHAR2	40 CHAR			Product Number
PRODUCT_TYPE_CODE	VARCHAR2	80 CHAR
PRODUCT_WID	NUMBER		38		Key to product dimension.	DW_EB_X_EBS_COMMON_W_PRODUCT_D
PROFIT_CENTER_NAME	VARCHAR2	80 CHAR			Profit Center Name
PROFIT_CENTER_NUM	VARCHAR2	30 CHAR			Profit center number
QA_INSPECT_IND	VARCHAR2	1 CHAR			QA Inspection Indicator
REORDER_POINT	NUMBER		28,10		Reorder point quantity (If the stock falls below this quantity, the system flags the material for requirements planning)
REPETITIVE_MFG_IND	VARCHAR2	1 CHAR			Repetitive manufacturing Indicator
SAFETY_STOCK_LEVEL	NUMBER		28,10		Safety stock quantity ( Quantity whose purpose is to satisfy unexpectedly high demand in the coverage period. )
SPC_PROC_TYPE_CODE	VARCHAR2	80 CHAR			Special Procurement Type Code
SPC_PROC_TYPE_NAME	VARCHAR2	80 CHAR			SPC Procurement Type Name
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
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.
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.
UNSPSC_INV_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.
VARIABLE_LEAD_TIME	NUMBER		22
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