DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D

DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D dimension table is used to maintain information on products supplied by specific suppliers for a specific purchasing organization. The information maintained is similar to product catalog information that includes pricing, order lead times for the product etc. 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. Cricital sourcing information related to the supplier like product lot size, commodity code, standard price, payment terms etc. are maintained in DW_EB_X_EBS_COMMON_W_SUPPLIER_PRODUCT_D. The information in this table is mostly expected to be static in nature with changes usually happening every time the supplier refreshes product catalog information. Type II information is enabled for this dimension table. Products can enter this table when a business organization starts establishing a relation with a new supplier (supplier development activity) to source the needed products.

Details

Module: Common Tables (EBS_COMMON)

Business Name: Supplier Product

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.
ACTIVE_FLG	VARCHAR2	1 CHAR			This identifies whether the source record is Active/Enabled or not
ASL_STATUS_CODE	VARCHAR2	50 CHAR
ATTR_SCOPE_TYPE_CODE	VARCHAR2	50 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.
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.
COMMON_COMMODITY_CODE	VARCHAR2	50 CHAR			The industry standard commodity code under which this product is classified at this business location.The code is used for statistical purposes by authorities such as European Union or the Automated Export System for import and export transactions.
COMMON_COMMODITY_NAME	VARCHAR2	80 CHAR			The detailed description of the common commodity code.
COST_CURR_CODE	VARCHAR2	30 CHAR			NOT USED
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.
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.
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.
FIXED_LOT_MULTIPLE	NUMBER		10
INCO_TERMS_CODE	VARCHAR2	50 CHAR			Commonly used terms used in trade contracts or material delivery that comply with standards established by the International Chamber of Commerce.Example: FOB -Free on Board, CIF Cost,Insurance and Freight.
INCO_TERMS_NAME	VARCHAR2	80 CHAR			Description of the Inco terms.
INTEGRATION_ID	VARCHAR2	300 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.
INVENTORY_ORG_WID	NUMBER		38		Identifies the inventory organization.	DW_EB_X_EBS_COMMON_W_INT_ORG_D
LEAD_TIME	NUMBER		10		The average number of calendar days needed by the supplier to obtain the material or service. This is the minimum time that the supplier expects from purchase order date to product receipt date for the product. Products are usually shipped to single/multiple business locations as specified by the purchasing organization on the purchase order.
MAX_LOT_SIZE	NUMBER		28,10		The maximum quantity of the material that may be ordered. The maximum quantity that the supplier honors for every order of this product from the purchasing organization.
MIN_ORDER_QTY	NUMBER		28,10		The smallest quantity of the material that can be ordered. The minimum quantity that the supplier expects for every order of this product from the purchasing organization. The order quantity in each purchase order item relating to the material must not be less than the minimum order quantity.
PLANT_LOC_WID	NUMBER		38		This indicates the business location which usually receives the products sourced from this supplier. The "plant" need not be a physical plant -- it could be any other location descriptor. The link to the "PLANT" type of rows within W_BUSN_LOC_D dimension table. Lookup: W_BUSN_LOC_D. Example : Carolina plant, Nevada facility etc.	DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D
PRICE_CURR_CODE	VARCHAR2	30 CHAR			The currency in which the product unit price is maintained for the supplier product. This may be the same as the regional or local currency of the purchasing organization deadling with the supplier.
PRICE_UOM_CODE	VARCHAR2	50 CHAR			Indicates the unit of measurement to which the purchase order price relates. This could be different from the order quantity and orderring unit. Example: 10 LTRS of a material or commodity (for example, oil) can be ordered but the vendors invoice shows a price of 2 dollars per KG. The purchase order price and purchase order price unit.is 2 dollars per kg while the the order quantity is 10 and the order unit is 1.
PRICE_UOM_NAME	VARCHAR2	80 CHAR			The detailed description of the unit of measure.
PROC_PROD_WID	NUMBER		38
PRODUCT_DESC	VARCHAR2	255 CHAR			This is the detailed description of a specific product as stored in the source system. All important reports around products are expected to feature this column. Example : COMPAQ PRESARIO 5000T, HP PRINTER CARTRIDGE X27, 6" INDUSTRIAL SCREWS etc.
PRODUCT_NUM	VARCHAR2	40 CHAR			This is a unique number assigned to a product within a business organization. These numbers could be used in reports for reporting on individual products, their sales numbers, their spend budget etc. Example: IBM LAPTOP T-172, CRIMSON RED AUTO SPRAY, A4 FAX PAPER etc. Many organizations evolve a detailed coded system (may also be bar code numbers) to identify their products. These could be a series of numeric digits with some inbuilt string position logic within them.
PRODUCT_WID	NUMBER		38		This indicates the product against which supplier pricing information is maintained in this table. Lookup: DW_EB_X_EBS_COMMON_W_PRODUCT_D	DW_EB_X_EBS_COMMON_W_PRODUCT_D
PURCHASING_UOM_CODE	VARCHAR2	50 CHAR
PURCH_ORG_CODE	VARCHAR2	50 CHAR			An organizational unit that subdivides an enterprise according to the requirements of Purchasing. A purchasing organization procures materials and services, negotiates conditions of purchase with vendors, and bears responsibility for such transactions.
PURCH_ORG_NAME	VARCHAR2	80 CHAR			The detailed description of the purchasing organization
PURCH_ORG_WID	NUMBER		38		This is the purchasing organization that deals with this supplier and places purchase orders by looking up items in the supplier catalog. This link to the "PURCH" type rows within DW_EB_X_EBS_COMMON_W_INT_ORG_D dimension table. Lookup: DW_EB_X_EBS_COMMON_W_INT_ORG_D (BUSN_ORG_TYPE = "PURCH") Example: North Americas Procurement	DW_EB_X_EBS_COMMON_W_INT_ORG_D
REQ_BU_ID	VARCHAR2	80 CHAR
ROUNDING_RULE	VARCHAR2	80 CHAR
SET_ID	VARCHAR2	30 CHAR
SPLR_CATALOG_NUM	VARCHAR2	30 CHAR			The catalog number of the supplier against which the individual products and prices are listed. This could be a simple price list containing product lines in many situations.
SPLR_COMMODITY_CODE	VARCHAR2	50 CHAR			The commodity code classification under which the supplier classifies the supplier product.
SPLR_COMMODITY_NAME	VARCHAR2	80 CHAR			The detailed description of the supplier commodity code classification.
SPSC_COMMODITY_CODE	VARCHAR2	50 CHAR			The Standard Products and Services Code (SPSC) commodity classification under which the supplier product can be classified.
SPSC_COMMODITY_NAME	VARCHAR2	80 CHAR			The detailed description of the SPSC commodity code.
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)
STD_ORDER_QTY	NUMBER		28,10		The quantity of the material that is normally ordered from this vendor. In vendor analysis , it is useful to know what the usual quantity that is purchased from the vendor for evaluating source of supply and for placing orders. Depending on the usual quantity, the prices can be bid. Example: Standard is 100 pieces of a certain material at $10 a piece or $9 a piece for 200 pieces
SUPPLIER_NAME	VARCHAR2	240 CHAR			This is the detailed description of a specific supplier as stored in the source system. All important reports around suppliers are expected to feature this column. Example : GE MEDICAL SYSTEMS, CISCO SYSTEMS, INTEGRATED STEEL, SOLECTRON etc.
SUPPLIER_NUM	VARCHAR2	30 CHAR			This is a unique number assigned to a supplier within a business organization. These numbers could be used in reports for reporting on individual suppliers, their outstanding supplies, their percentage of the ORGANIZATIONS spend budget etc. Example: GE MEDICAL SYSTEMS, CISCO SYSTEMS, INTEGRATED STEEL, SOLECTRON etc. Many organizations evolve a detailed coded system to identify their suppliers. These could be a series of numeric digits with some inbuilt string position logic within them.
SUPPLIER_PART_NUM	VARCHAR2	50 CHAR			The product number used by the vendor. The vendor may use a different number for the product which can be quoted in a purchase order for identification purposes. This would be the reference by which the supplier can more easily and quickly identify the product being supplied at his end. The invoices made out by the supplier would have cross references to this supplier product/part number.
SUPPLIER_PRODUCT_HIER1_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER1_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER2_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER2_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER3_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER3_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER4_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER4_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER5_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER5_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER6_CODE	VARCHAR2	50 CHAR			General product categorization column(short text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_PRODUCT_HIER6_NAME	VARCHAR2	80 CHAR			General product categorization column(long text/string) provided to categorize supplier products for further analysis. This column can be looked at as a member of a flattened hierarchy if it exists for a supplier product; otherwise it could be used as extension column for storing general categorization. If a supplier product belongs to multiple hierarchies, these set of columns can be used to represent the most frequently used one.
SUPPLIER_SITE_ID	VARCHAR2	80 CHAR
SUPPLIER_WID	NUMBER		38		This indicates the supplier for whose product the pricing information is maintained in this table. The link to the W_SUPPLIER_D dimension. Lookup: W_SUPPLIER_D Example : Eelctronic equipment retailers like Circuit City, Good Guys	DW_EB_X_EBS_COMMON_W_PARTY_ORG_D
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.
UNIT_PRICE	NUMBER		28,10		The price per unit of the product on the supplier catalog.
UNIT_STD_COST	NUMBER		38,10		The standard cost per unit ot the product on the supplier catalog.
UNSPSC_COMMODITY_CODE	VARCHAR2	50 CHAR			The Universal Standard Products and Services Classification (UNSPSC) under which the supplier product can be classified.
UNSPSC_COMMODITY_NAME	VARCHAR2	80 CHAR			The detailed description of the UNSPSC commodity code.
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