RIB Mappings Report Release: 13.0.1

Retail Integration Bus Mappings Report

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item	Yes	The unique identifier of the main item on the message.
item_parent	item_master	item_parent	No	The item at the level above this item. This value must be predefined as an item on the ITEM_MASTER table. The item parent cannot be modified.
item_grandparent	item_master	item_grandparent	No	The item two levels above this item. This value must be predefined as an item on the ITEM_MASTER table. The item grandparent cannot be modified.
pack_ind	item_master	pack_ind	No	Indicates if the item is a pack item. Valid values are Y (yes) and N (no). This value cannot be modified.
item_level	item_master	item_level	No	The level of the item. Valid values are 1 (single level or pack item), 2 (child item), and 3 (grandchild item). This value cannot be modified.
tran_level	item_master	tran_level	No	The transaction level of the item. Valid values are 1, 2, and 3. If this is a transaction item this will equal the item level. If the item is a pack this will equal 1. This value cannot be modified.
diff_1	item_master	diff_1	No	A differentiator id which differentiates a transaction level item from its parent item. If the item on the message is a parent this field may hold a differentiator group id. This value must be predefined on the DIFF_IDS or DIFF_GROUP_HEAD table.
diff_2	item_master	diff_2	No	See description for diff_1.
diff_3	item_master	diff_3	No	See description for diff_1.
diff_4	item_master	diff_4	No	See description for diff_1.
dept	item_master	dept	No	The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified.
class	item_master	class	No	The number of the class to which the item belongs. This value must be predefined on the CLASS table. It cannot be modified.
subclass	item_master	subclass	No	The number of the subclass to which the item belongs. This value must be predefined on the SUBCLASS table. It cannot be modified.
item_desc	item_master	item_desc	Yes	The long description of the item.
iscloc_hier_level	*	*	No	The level of the organizational hierarchy used to create item\supplier\country\location relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse).
izp_hier_level	*	*	No	The level of the organizational hierarchy used to create item\zone\price relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). This value should be null if the item is a non sellable pack.
short_desc	item_master	short_desc	No	The short description of the item. If this field is not populated it will default from the long description.
retail_zone_group_id	item_master	retail_zone_group_id	No	The zone group on the price_zone_group table to which this item belongs. It is required except for non sellable packs. This value cannot be modified.
cost_zone_group_id	item_master	cost_zone_group_id	No	The cost zone from the cost_zone_group table to which the item belongs. This should be null if landed cost is not being used in the system or the item is an orderable buyer pack.
standard_uom	item_master	standard_uom	No	The unit of measure at which the item is tracked at the corporate level. This will be defaulted to EA (eaches) if not populated on the message. It cannot be modified.
store_ord_mult	item_master	store_ord_mult	Yes	The unit type of merchandise shipped from the warehouse to the store for this item. Valid values are C (cases), I (inners), and E (eaches).
forecast_ind	item_master	forecast_ind	Yes	Indicates whether the item is forecastable. Valid value are Y (yes) and N (no). This value should be N if the item is a pack.
simple_pack_ind	item_master	simple_pack_ind	No	Indicates if the item is a simple pack. This field is required if the item is a pack. Valid values are Y (yes) and N (no). This value cannot be modified.
contains_inner_ind	item_master	contains_inner_ind	No	This should be Y (yes) if the item is a pack and at least one component item is a pack; otherwise it should be N (no).
sellable_ind	item_master	sellable_ind	No	If the item is a pack, this value indicates if the pack can be sold as a unique unit. Valid values are Y (yes) and N (no). This value cannot be modified. It should be Y for a non-pack item.
orderable_ind	item_master	orderable_ind	No	If the item is a pack, this field indicates if it can be placed on orders. Valid values are Y (yes) and N (no). This field cannot be modified. It should be Y for a non-pack item.
pack_type	item_master	pack_type	No	If the item is a pack, this field will indicate what type of pack it is. Valid values are B (buyer) and V (vendor). This field cannot be modified. If the item is not a pack this value should be null.
order_as_type	item_master	order_as_type	No	If the item is an orderable buyer pack, this indicates how it will be ordered. Valid values are E (eaches) and P (pack). This field cannot be modified. If the item is not a pack, this should be null.
comments	item_master	comments	No	Comments associated with the item.
create_datetime	item_master	create_datetime	No	Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated.
XItemSupDesc	*	*	No	Child node.
XItemBOMDesc	*	*	No	Child node.
XItemVATDesc	*	*	No	Child node.
XIZPDesc	*	*	No	Child node.
XItemUDADtl	*	*	No	Child node that is not used.
XItemSeason	*	*	No	Child node that is not used.
XItemImage	*	*	No	Child node that is not used.
status	*	*	No	Not used.
uom_conv_factor	*	*	No	Not used.
package_size	*	*	No	Not used.
handling_temp	*	*	No	Not used.
handling_sensitivity	*	*	No	Not used.
mfg_rec_retail	*	*	No	Not used.
waste_type	*	*	No	Not used.
waste_pct	*	*	No	Not used.
item_number_type	*	*	No	Not used.
catch_weight_ind	*	*	No	Not used.
const_dimen_ind	*	*	No	Not used.
gift_wrap_ind	*	*	No	Not used.
ship_alone_ind	*	*	No	Not used.
ext_source_system	*	*	No	Not used.
size_group1	*	*	No	Not used.
size_group2	*	*	No	Not used.
size1	*	*	No	Not used.
size2	*	*	No	Not used.
color	*	*	No	Not used.
system_ind	*	*	No	Not used.
upc_supplement	*	*	No	Not used.
upc_type	*	*	No	Not used.
primary_upc_ind	*	*	No	Not used.
primary_repl_ind	*	*	No	Not used.
item_aggregate_ind	*	*	No	Not used.
diff_1_aggregate_ind	*	*	No	Not used.
diff_2_aggregate_ind	*	*	No	Not used.
diff_3_aggregate_ind	*	*	No	Not used.
diff_4_aggregate_ind	*	*	No	Not used.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemSupDesc

Tag Name	Table Name	Column Name	API Req	Description
supplier	item_supplier	supplier	Yes	The identifier of the supplier who sources the item. This value must be predefined on the SUPS table.
primary_supp_ind	item_supplier	primary_supp_ind	Yes	Indicates if the supplier is the primary supplier for the item. Valid values are Y (yes) and N (no).
vpn	item_supplier	vpn	No	The vendor product number associated with the item.
supp_label	item_supplier	supp_label	No	The supplier label for the item.
XItemSupCtyDesc	*	*	Yes	Child node.
consignment_rate	*	*	No	Not used.
supp_discontinue_date	*	*	No	Not used.
direct_ship_ind	*	*	No	Not used.
pallet_name	*	*	No	Not used.
case_name	*	*	No	Not used.
inner_name	*	*	No	Not used.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemSupCtyDesc

Tag Name	Table Name	Column Name	API Req	Description
origin_country_id	item_supp_country	origin_country_id	Yes	The identifier for the country where the item is sourced. This value must be predefined on the COUNTRY table.
primary_country_ind	item_supp_country	primary_country_ind	Yes	This indicates if the country is the primary country for the item\supplier. Valid values are Y (yes) and N (no).
unit_cost	item_supp_country	unit_cost	No	The current corporate unit cost for the item in the supplier's currency. This field will only be used to establish the item\supplier\country unit cost; it cannot be modified.
XISCLocDesc	*	*	No	Child node.
lead_time	*	*	No	Not used.
pickup_lead_time	*	*	No	Not used.
min_order_qty	*	*	No	Not used.
max_order_qty	*	*	No	Not used.
supp_hier_lvl_1	*	*	No	Not used.
supp_hier_lvl_2	*	*	No	Not used.
supp_hier_lvl_3	*	*	No	Not used.
default_uop	*	*	No	Not used.
supp_pack_size	*	*	No	Not used.
inner_pack_size	*	*	No	Not used.
ti	*	*	No	Not used.
hi	*	*	No	Not used.
XISCDimDesc	*	*	No	Child node that is not used..

Application Name: Retail Merchandising System

XML-Schema or Node Name:XISCLocDesc

Tag Name	Table Name	Column Name	API Req	Description
hier_id	item_supp_country_loc	loc	Yes	The specific location id for this Item Supplier Country Loc message. Corresponds with the value used in the iscloc_hier_level field.
unit_cost	item_supp_country_loc	unit_cost	No	The unit cost for the item at the item\supplier\country\loc level in the supplier's currency. This field will be used for creating new records, not updating existing records.
primary_loc_ind	item_supp_country_loc	primary_loc_ind	No	Indicates if the location is the primary location for the item\supplier\country. Valid values are Y (yes) and N (no).
pickup_lead_time	*	*	No	Not used.
round_lvl	item_supp_country_loc	round_lvl	No	This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
round_to_case_pct	item_supp_country_loc	round_to_case_pct	No	The Case Rounding Threshold value. Used to determine whether to round partial case quantities up or down.
round_to_layer_pct	item_supp_country_loc	round_to_layer_pct	No	The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down.
round_to_pallet_pct	item_supp_country_loc	round_to_pallet_pct	No	The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XISCDimDesc

Tag Name	Table Name	Column Name	API Req	Description
dim_object	*	*	No	This entire node is not used.
tare_weight	*	*	*	*
tare_type	*	*	*	*
lwh_uom	*	*	*	*
length	*	*	*	*
width	*	*	*	*
dim_height	*	*	*	*
liquid_volume	*	*	*	*
liquid_volume_uom	*	*	*	*
stat_cube	*	*	*	*
weight_uom	*	*	*	*
weight	*	*	*	*
net_weight	*	*	*	*
presentation_method	*	*	*	*

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemBOMDesc

Tag Name	Table Name	Column Name	API Req	Description
component_item	packitem	item	Yes	The component item within the pack. This value must be predefined on ITEM_MASTER. It will only be populated if the item on the message is a pack item. This value cannot be modified. Only transaction level items can be pack components.
pack_qty	packitem	pack_qty	Yes	The quantity of the component item. This value cannot be modified.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemVATDesc

Tag Name	Table Name	Column Name	API Req	Description
vat_type	vat_item	vat_type	Yes	Indicates if the VAT rate is used for purchasing or selling. Valid values are C (cost) and R (retail).
vat_region	vat_item	vat_region	Yes	The identifier for the VAT region. This value must be predefined on the VAT_REGION table. This node is optional, if it is included this field is required.
vat_code	vat_item	vat_code	Yes	The identifier for the VAT code. This node is optional, if it is included in the message this field is required.
active_date	vat_item	active_date	Yes	The date that the VAT rate became active for the item/VAT region combination.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XIZPDesc

Tag Name	Table Name	Column Name	API Req	Description
hier_id	*	*	Yes	The specific hierarchy id for this Item Zone Price message. Corresponds with value used in izp_hier_level field.
base_retail_ind	*	*	No	Not used.
selling_unit_retail	rpm_item_zone_price	selling_retail	Yes	The selling unit retail value in the currency and the selling UOM on the message. This field cannot be modified.
selling_uom	rpm_item_zone_price	selling_uom	Yes	The selling unit of measure for the item's single unit retail. This field cannot be modified.
multi_selling_uom	rpm_item_zone_price	multi_selling_uom	No	The selling unit of measure for the item's multi unit retail. This field cannot be modified.
country_id	*	*	No	Not used.
currency_code	*	*	No	The code of the currency the retail value and zones are in. Item\zone\price records will only be created for stores with the same currency as the retail value on the message.
multi_units	rpm_item_zone_price	multi_units	No	The multi units for the item\zone. This field cannot be modified.
multi_unit_retail	rpm_item_zone_price	multi_unit_retail	No	The multi unit retail in the currency and the multi unit UOM specified on the message. This field cannot be modified.

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemUDADtl

Tag Name	Table Name	Column Name	API Req	Description
uda_id	*	*	No	This entire node is not used.
display_type	*	*	*	*
uda_date	*	*	*	*
uda_value	*	*	*	*
uda_text	*	*	*	*
create_datetime	*	*	*	*
last_update_datetime	*	*	*	*
last_update_id	*	*	*	*

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemSeason

Tag Name	Table Name	Column Name	API Req	Description
season_id	*	*	No	This entire node is not used.
phase_id	*	*	*	*
item_season_seq_no	*	*	*	*
diff_id	*	*	*	*
create_datetime	*	*	*	*
last_update_datetime	*	*	*	*
last_update_id	*	*	*	*

Application Name: Retail Merchandising System

XML-Schema or Node Name:XItemImage

Tag Name	Table Name	Column Name	API Req	Description
image_name	*	*	No	This entire node is not used.
image_addr	*	*	*	*
image_desc	*	*	*	*
create_datetime	*	*	*	*
last_update_datetime	*	*	*	*
last_update_id	*	*	*	*