Product Mapping
The item dimension and product hierarchy data is loaded mainly from the PRODUCT.csv file or from RMFCS.
The primary data warehouse table for item data is W_PRODUCT_D while the hierarchy comes from W_PROD_CAT_DH, but several temporary tables are used to pre-calculate the values before export. The mapping below is used by the interface
program to move data from the data warehouse to RDX. The temporary table W_RTL_ITEM_PARENT_TMP is generated
using data from W_PROD_CAT_DH, W_PRODUCT_ATTR_D, W_PRODUCT_D_TL, W_RTL_IT_SUPPLIER_D, and W_DOMAIN_MEMBER_LKP_TL. The export filters out non-pack items that have SELLABLE_FLG=N on the interface file or from Merchandising.
There is a configuration that alters the behavior of the ITEM_DESC, ITEM_PARENT_DIFF_DESC, and ITEM_PARENT_DESC fields. You may optionally update the C_ODI_PARAM_VW parameter PDS_PROD_INCLUDE_ITEM_ID to Y. When you do, the item ID will be concatenated into the description
field on W_PDS_PRODUCT_D for all 3 levels of item.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Item |
W_PDS_PRODUCT_D |
ITEM |
W_RTL_ITEM_PARENT_TMP.PROD_IT_NUM |
|
Item Desc |
W_PDS_PRODUCT_D |
ITEM_DESC |
W_RTL_ITEM_PARENT_TMP.PRODUCT_NAME |
|
Item Parent Diff |
W_PDS_PRODUCT_D |
ITEM_PARENT_DIFF |
CASE WHEN W_RTL_ITEM_PARENT_TMP.DIFF_AGGREGATE_ID = ''-1'' THEN W_RTL_ITEM_PARENT_TMP.PARENT_PROD_NUM ELSE W_RTL_ITEM_PARENT_TMP.PARENT_PROD_NUM||''_''||W_RTL_ITEM_PARENT_TMP.DIFF_AGGREGATE_ID END |
|
Item Parent Diff Desc |
W_PDS_PRODUCT_D |
ITEM_PARENT_DIFF_DESC |
CASE WHEN W_RTL_ITEM_PARENT_TMP.DIFF_AGGREGATE_ID = ''-1'' THEN W_RTL_ITEM_PARENT_TMP.PARENT_PRODUCT_NAME ELSE W_RTL_ITEM_PARENT_TMP.PARENT_PRODUCT_NAME||''_''||W_RTL_ITEM_PARENT_TMP.DIFF_AGGREGATE_ID END |
|
Item Parent |
W_PDS_PRODUCT_D |
ITEM_PARENT |
W_RTL_ITEM_PARENT_TMP.PARENT_PROD_NUM |
|
Item Parent Desc |
W_PDS_PRODUCT_D |
ITEM_PARENT_DESC |
W_RTL_ITEM_PARENT_TMP.PARENT_PRODUCT_NAME |
|
Subclass ID |
W_PDS_PRODUCT_D |
SUBCLASS_ID |
W_RTL_ITEM_PARENT_TMP.SUBCLASS_ID |
|
Subclass Label |
W_PDS_PRODUCT_D |
SUB_NAME |
W_RTL_ITEM_PARENT_TMP.PROD_SC_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.SBC_DESC |
|
Class ID |
W_PDS_PRODUCT_D |
CLASS_ID |
W_RTL_ITEM_PARENT_TMP.CLASS_ID |
|
Class Label |
W_PDS_PRODUCT_D |
CLASS_NAME |
W_RTL_ITEM_PARENT_TMP.PROD_CL_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.CLS_DESC |
|
Department |
W_PDS_PRODUCT_D |
DEPT |
W_RTL_ITEM_PARENT_TMP.PROD_DP_NUM |
|
Department Label |
W_PDS_PRODUCT_D |
DEPT_NAME |
W_RTL_ITEM_PARENT_TMP.PROD_DP_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.DP_DESC |
|
Group |
W_PDS_PRODUCT_D |
GROUP_NO |
W_RTL_ITEM_PARENT_TMP.PROD_GP_NUM |
|
Group Label |
W_PDS_PRODUCT_D |
GROUP_NAME |
W_RTL_ITEM_PARENT_TMP.PROD_GP_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.GRP_DESC |
|
Division |
W_PDS_PRODUCT_D |
DIVISION |
W_RTL_ITEM_PARENT_TMP.PROD_DV_NUM |
|
Division Label |
W_PDS_PRODUCT_D |
DIV_NAME |
W_RTL_ITEM_PARENT_TMP.PROD_DV_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.DIV_DESC |
|
Company |
W_PDS_PRODUCT_D |
COMPANY |
W_RTL_ITEM_PARENT_TMP.CMP_NUM |
|
Company Label |
W_PDS_PRODUCT_D |
CO_NAME |
W_RTL_ITEM_PARENT_TMP.CMP_NUM||'' ''||W_RTL_ITEM_PARENT_TMP.CMP_DESC |
|
Forecastable Flag |
W_PDS_PRODUCT_D |
FORECAST_IND |
W_RTL_ITEM_PARENT_TMP.FORECAST_IND |
|
Class |
W_PDS_PRODUCT_D |
CLASS_DISPLAY_ID |
W_RTL_ITEM_PARENT_TMP.PROD_CL_NUM |
|
Subclass |
W_PDS_PRODUCT_D |
SUBCLASS_DISPLAY_ID |
W_RTL_ITEM_PARENT_TMP.PROD_SC_NUM |
|
Brand |
W_PDS_PRODUCT_D |
BRAND_NAME |
W_RTL_ITEM_PARENT_TMP.BRAND |
|
Brand Label |
W_PDS_PRODUCT_D |
BRAND_DESCRIPTION |
W_RTL_ITEM_PARENT_TMP.BRAND_DESC |
|
Supplier |
W_PDS_PRODUCT_D |
SUPPLIER |
NVL(W_PARTY_ORG_D.SUPPLIER_NUM''-1'') |
|
Supplier Label |
W_PDS_PRODUCT_D |
SUP_NAME |
NVL(W_PARTY_ORG_D.ORG_NAME''N/A'') |
|
Diff 1 |
W_PDS_PRODUCT_D |
DIFF_1 |
W_PRODUCT_D.DIFF_1 |
|
Diff 1 Type |
W_PDS_PRODUCT_D |
DIFF_1_TYPE |
W_PRODUCT_D.DIFF_1_TYPE |
|
Diff 2 |
W_PDS_PRODUCT_D |
DIFF_2 |
W_PRODUCT_D.DIFF_2 |
|
Diff 2 Type |
W_PDS_PRODUCT_D |
DIFF_2_TYPE |
W_PRODUCT_D.DIFF_2_TYPE |
|
Diff 3 |
W_PDS_PRODUCT_D |
DIFF_3 |
W_PRODUCT_D.DIFF_3 |
|
Diff 3 Type |
W_PDS_PRODUCT_D |
DIFF_3_TYPE |
W_PRODUCT_D.DIFF_3_TYPE |
|
Diff 4 |
W_PDS_PRODUCT_D |
DIFF_4 |
W_PRODUCT_D.DIFF_4 |
|
Diff 4 Type |
W_PDS_PRODUCT_D |
DIFF_4_TYPE |
W_PRODUCT_D.DIFF_4_TYPE |
|
Cost Zone Group ID |
W_PDS_PRODUCT_D |
COST_ZONE_GROUP_ID |
W_PRODUCT_D.COST_ZONE_GROUP_ID |
|
UOM Conv Factor |
W_PDS_PRODUCT_D |
UOM_CONV_FACTOR |
W_PRODUCT_D.UOM_CONV_FACTOR |
|
Store Order Multiple |
W_PDS_PRODUCT_D |
STORE_ORD_MULT |
W_PRODUCT_D.STORE_ORD_MULT |
|
Retail Label Type |
W_PDS_PRODUCT_D |
RETAIL_LABEL_TYPE |
W_PRODUCT_D.RETAIL_LABEL_TYPE |
|
Retail Label Value |
W_PDS_PRODUCT_D |
RETAIL_LABEL_VALUE |
W_PRODUCT_D.RETAIL_LABEL_VALUE |
|
Handling Temp |
W_PDS_PRODUCT_D |
HANDLING_TEMP |
W_PRODUCT_D.HANDLING_TEMP |
|
Handling Sensitivity |
W_PDS_PRODUCT_D |
HANDLING_SENSITIVITY |
W_PRODUCT_D.HANDLING_SENSITIVITY |
|
Catch Weight Flag |
W_PDS_PRODUCT_D |
CATCH_WEIGHT_IND |
W_PRODUCT_D.CATCH_WEIGHT_IND |
|
Waste Type |
W_PDS_PRODUCT_D |
WASTE_TYPE |
W_PRODUCT_D.WASTE_TYPE |
|
Waste Percent |
W_PDS_PRODUCT_D |
WASTE_PCT |
W_PRODUCT_D.WASTE_PCT |
|
Default Waste Percent |
W_PDS_PRODUCT_D |
DEFAULT_WASTE_PCT |
W_PRODUCT_D.DEFAULT_WASTE_PCT |
|
Item Service Level |
W_PDS_PRODUCT_D |
ITEM_SERVICE_LEVEL |
W_PRODUCT_D.ITEM_SERVICE_LEVEL |
|
Gift Wrap Flag |
W_PDS_PRODUCT_D |
GIFT_WRAP_IND |
W_PRODUCT_D.GIFT_WRAP_IND |
|
Ship Alone Flag |
W_PDS_PRODUCT_D |
SHIP_ALONE_IND |
W_PRODUCT_D.SHIP_ALONE_IND |
|
Order Type |
W_PDS_PRODUCT_D |
ORDER_TYPE |
W_PRODUCT_D.ORDER_TYPE |
|
Sales Type |
W_PDS_PRODUCT_D |
SALE_TYPE |
W_PRODUCT_D.SALE_TYPE |
|
Deposit Item Type |
W_PDS_PRODUCT_D |
DEPOSIT_ITEM_TYPE |
W_PRODUCT_D.DEPOSIT_ITEM_TYPE |
|
Container Item |
W_PDS_PRODUCT_D |
CONTAINER_ITEM |
W_PRODUCT_D.CONTAINER_ITEM |
|
Deposit Price Per UOM |
W_PDS_PRODUCT_D |
DEPOSIT_IN_PRICE_PER_UOM |
W_PRODUCT_D.DEPOSIT_IN_PRICE_PER_UOM |
|
AIP Case Type |
W_PDS_PRODUCT_D |
AIP_CASE_TYPE |
W_PRODUCT_D.AIP_CASE_TYPE |
|
Perishable Flag |
W_PDS_PRODUCT_D |
PERISHABLE_IND |
W_PRODUCT_D.PERISHABLE_IND |
|
Catch Weight UOM |
W_PDS_PRODUCT_D |
CATCH_WEIGHT_UOM |
W_PRODUCT_D.CATCH_WEIGHT_UOM |
|
Orderable Flag |
W_PDS_PRODUCT_D |
ORDERABLE_FLG |
W_PRODUCT_D.ORDERABLE_FLG |
|
Inventoried Flag |
W_PDS_PRODUCT_D |
INVENTORIED_FLG |
W_RTL_ITEM_PARENT_TMP.INVENTORIED_FLG |
|
Flexible Attribute 1 |
W_PDS_PRODUCT_D |
FLEX1_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX1_CHAR_VALUE, W_PRODUCT_D.FLEX1_CHAR_VALUE) |
|
Flexible Attribute 2 |
W_PDS_PRODUCT_D |
FLEX2_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX2_CHAR_VALUE, W_PRODUCT_D.FLEX2_CHAR_VALUE) |
|
Flexible Attribute 3 |
W_PDS_PRODUCT_D |
FLEX3_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX3_CHAR_VALUE, W_PRODUCT_D.FLEX3_CHAR_VALUE) |
|
Flexible Attribute 4 |
W_PDS_PRODUCT_D |
FLEX4_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX4_CHAR_VALUE, W_PRODUCT_D.FLEX4_CHAR_VALUE) |
|
Flexible Attribute 5 |
W_PDS_PRODUCT_D |
FLEX5_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX5_CHAR_VALUE, W_PRODUCT_D.FLEX5_CHAR_VALUE) |
|
Flexible Attribute 6 |
W_PDS_PRODUCT_D |
FLEX6_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX6_CHAR_VALUE, W_PRODUCT_D.FLEX6_CHAR_VALUE) |
|
Flexible Attribute 7 |
W_PDS_PRODUCT_D |
FLEX7_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX7_CHAR_VALUE, W_PRODUCT_D.FLEX7_CHAR_VALUE) |
|
Flexible Attribute 8 |
W_PDS_PRODUCT_D |
FLEX8_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX8_CHAR_VALUE, W_PRODUCT_D.FLEX8_CHAR_VALUE) |
|
Flexible Attribute 9 |
W_PDS_PRODUCT_D |
FLEX9_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX9_CHAR_VALUE, W_PRODUCT_D.FLEX9_CHAR_VALUE) |
|
Flexible Attribute 10 |
W_PDS_PRODUCT_D |
FLEX10_CHAR_VALUE |
COALESCE(W_PRODUCT_FLEX_D.FLEX10_CHAR_VALUE, W_PRODUCT_D.FLEX10_CHAR_VALUE) |
|
Flexible Attribute 11 |
W_PDS_PRODUCT_D |
FLEX11_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX11_CHAR_VALUE |
|
Flexible Attribute 12 |
W_PDS_PRODUCT_D |
FLEX12_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX12_CHAR_VALUE |
|
Flexible Attribute 13 |
W_PDS_PRODUCT_D |
FLEX13_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX13_CHAR_VALUE |
|
Flexible Attribute 14 |
W_PDS_PRODUCT_D |
FLEX14_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX14_CHAR_VALUE |
|
Flexible Attribute 15 |
W_PDS_PRODUCT_D |
FLEX15_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX15_CHAR_VALUE |
|
Flexible Attribute 16 |
W_PDS_PRODUCT_D |
FLEX16_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX16_CHAR_VALUE |
|
Flexible Attribute 17 |
W_PDS_PRODUCT_D |
FLEX17_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX17_CHAR_VALUE |
|
Flexible Attribute 18 |
W_PDS_PRODUCT_D |
FLEX18_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX18_CHAR_VALUE |
|
Flexible Attribute 19 |
W_PDS_PRODUCT_D |
FLEX19_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX19_CHAR_VALUE |
|
Flexible Attribute 20 |
W_PDS_PRODUCT_D |
FLEX20_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX20_CHAR_VALUE |
|
Flexible Attribute 21 |
W_PDS_PRODUCT_D |
FLEX21_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX21_CHAR_VALUE |
|
Flexible Attribute 22 |
W_PDS_PRODUCT_D |
FLEX22_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX22_CHAR_VALUE |
|
Flexible Attribute 23 |
W_PDS_PRODUCT_D |
FLEX23_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX23_CHAR_VALUE |
|
Flexible Attribute 24 |
W_PDS_PRODUCT_D |
FLEX24_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX24_CHAR_VALUE |
|
Flexible Attribute 25 |
W_PDS_PRODUCT_D |
FLEX25_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX25_CHAR_VALUE |
|
Flexible Attribute 26 |
W_PDS_PRODUCT_D |
FLEX26_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX26_CHAR_VALUE |
|
Flexible Attribute 27 |
W_PDS_PRODUCT_D |
FLEX27_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX27_CHAR_VALUE |
|
Flexible Attribute 28 |
W_PDS_PRODUCT_D |
FLEX28_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX28_CHAR_VALUE |
|
Flexible Attribute 29 |
W_PDS_PRODUCT_D |
FLEX29_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX29_CHAR_VALUE |
|
Flexible Attribute 30 |
W_PDS_PRODUCT_D |
FLEX30_CHAR_VALUE |
W_PRODUCT_FLEX_D.FLEX30_CHAR_VALUE |
|
Image Filename |
W_PDS_PRODUCT_D |
PRODUCT_IMAGE_NAME |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_NAME |
|
Image Address |
W_PDS_PRODUCT_D |
PRODUCT_IMAGE_ADDR |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_ADDR |
|
Attr Image Filename |
W_PDS_PRODUCT_D |
PRODUCT_ATTR_IMAGE_NAME |
W_PRODUCT_ATTR_D. PRODUCT_ATTR_IMAGE_NAME |
|
Attr Image Address |
W_PDS_PRODUCT_D |
PRODUCT_ATTR_IMAGE_ADDR |
W_PRODUCT_ATTR_D. PRODUCT_ATTR_IMAGE_ADDR |
|
Image URL |
W_PDS_PRODUCT_D |
PRODUCT_IMAGE |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_ADDR || W_PRODUCT_ATTR_D. PRODUCT_IMAGE_NAME |
|
Parent Image Filename |
W_PDS_PRODUCT_D |
ITEM_PARENT_IMAGE_NAME |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_NAME (for parent style item) |
|
Parent Image Address |
W_PDS_PRODUCT_D |
ITEM_PARENT_ADDR |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_ADDR (for parent style item) |
|
Parent Image URL |
W_PDS_PRODUCT_D |
ITEM_PARENT_IMAGE |
W_PRODUCT_ATTR_D. PRODUCT_IMAGE_ADDR || W_PRODUCT_ATTR_D. PRODUCT_IMAGE_NAME (for parent style item) |
|
Sellable Flag |
W_PDS_PROUCT_D |
SELLABLE_FLG |
W_PRODUCT_ATTR_D.PRODUCT_ATTR4_NAME |