RIB Mappings Report Release: 13.0.1

Retail Integration Bus Mappings Report Release: 13.0.1

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
ItemHdrDesc	*	*	*	*
ItemSupDesc	*	*	*	*
ItemSupCtyDesc	*	*	*	*
ISCDimDesc	*	*	*	*
ItemUDALOVDesc	*	*	*	*
ItemUDAFFDesc	*	*	*	*
ItemUDADateDesc	*	*	*	*
ItemImageDesc	*	*	*	*
ItemUPCDesc	*	*	*	*
ItemBOMDesc	*	*	*	*
ItemTcktDesc	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemHdrDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item_id	Yes	*
item_number_type	*	*	*	*
format_id	n/a	n/a	No	Not used in RWMS.
prefix	n/a	n/a	No	Not used in RWMS.
item_parent	n/a	n/a	No	Not used in RWMS.
item_grandparent	n/a	n/a	No	Not used in RWMS.
pack_ind	n/a	n/a	No	Not used in RWMS.
item_level	n/a	n/a	No	Not used in RWMS.
tran_level	n/a	n/a	No	Not used in RWMS.
diff_1	item_differentiator	diff_id	No	*
diff_1_type	item_differentiator	diff_type	No	*
diff_2	item_differentiator	diff_id	No	*
diff_2_type	item_differentiator	diff_type	No	*
diff_3	item_differentiator	diff_id	No	*
diff_3_type	item_differentiator	diff_type	No	*
diff_4	item_differentiator	diff_id	No	*
diff_4_type	item_differentiator	diff_type	No	*
dept	item_master	department	No	*
dept_name	n/a	n/a	No	Not used in RWMS.
class	item_master	class	No	*
class_name	n/a	n/a	No	Not used in RWMS.
subclass	item_master	sub_class	No	*
sub_name	n/a	n/a	No	Not used in RWMS.
status	n/a	n/a	No	Not used in RWMS.
item_desc	item_master	description	No	*
short_desc	n/a	n/a	No	Not used in RWMS.
desc_up	n/a	n/a	No	Not used in RWMS.
primary_ref_item_ind	n/a	n/a	No	Not used in RWMS.
retail_zone_group_id	n/a	n/a	No	Not used in RWMS.
cost_zone_group_id	n/a	n/a	No	Not used in RWMS.
standard_uom	item_master	standard_uom	No	*
uom_conv_factor	item_master	uom_conv_factor	No	*
package_size	*	*	No	*
package_uom	*	*	No	*
merchandise_ind	*	*	No	*
store_ord_mult	*	*	No	*
forecast_ind	*	*	No	*
mfg_rec_retail	n/a	n/a	No	Not used in RWMS.
retail_label_type	n/a	n/a	No	Not used in RWMS.
retail_label_type_desc	n/a	n/a	No	Not used in RWMS.
retail_label_value	n/a	n/a	No	Not used in RWMS.
handling_temp	n/a	n/a	No	Not used in RWMS.
handling_temp_desc	n/a	n/a	No	Not used in RWMS.
handling_sensitivity	n/a	n/a	No	Not used in RWMS.
handling_sensitivity_desc	*	*	*	*
catch_weight_ind	item_master	catch_weight	No	*
waste_type	n/a	n/a	No	Not used in RWMS.
waste_type_desc	n/a	n/a	No	Not used in RWMS.
waste_pct	n/a	n/a	No	Not used in RWMS.
default_waste_pct	n/a	n/a	No	Not used in RWMS.
const_dimen_ind	n/a	n/a	No	Not used in RWMS.
simple_pack_ind	n/a	n/a	No	Not used in RWMS.
contains_inner_ind	n/a	n/a	No	Not used in RWMS.
sellable_ind	n/a	n/a	No	Not used in RWMS.
orderable_ind	n/a	n/a	No	Not used in RWMS.
pack_type	n/a	n/a	No	Not used in RWMS.
order_as_type	n/a	n/a	No	Not used in RWMS.
comments	n/a	n/a	No	Not used in RWMS.
unit_retail	item_master	retail_price	No	*
item_service_level	n/a	n/a	No	Not used in RWMS.
gift_wrap_ind	n/a	n/a	No	Not used in RWMS.
ship_alone_ind	item_master	ship_alone	No	*
vendor_style	item_master	vendor_style	No	*
std_unit_weight	item_master	std_unit_weight	No	*
single_price_flag	item_master	single_price_flag	No	*
preticket_flag	item_master	preticket_flag	No	*
planned_residual	item_master	planned_residual	No	*
autopackable	item_master	autopackable	No	*
sortable	item_master	sortable	No	*
item_master_uda1	item_master	item_master_uda1	No	*
item_master_uda2	item_master	item_master_uda2	No	*
item_master_uda3	item_master	item_master_uda3	No	*
item_master_uda4	item_master	item_master_uda4	No	*
item_master_uda5	item_master	item_master_uda5	No	*
item_master_uda6	item_master	item_master_uda6	No	*
item_master_uda7	item_master	item_master_uda7	No	*
item_master_uda8	item_master	item_master_uda8	No	*
item_master_uda9	item_master	item_master_uda9	No	*
item_master_uda10	item_master	item_master_uda10	No	*
item_master_uda11	item_master	item_master_uda11	No	*
item_master_uda12	item_master	item_master_uda12	No	*
item_master_uda13	item_master	item_master_uda13	No	*
item_master_uda14	item_master	item_master_uda14	No	*
item_master_uda15	item_master	item_master_uda15	No	*
ship_alone	item_master	ship_alone	No	*
slottable	item_master	slottable	No	*
freight_class	item_master	freight_class	No	*
new_item	item_master	new_item	No	*
brand	item_master	brand	No	*
break_case_ups	item_master	break_case_ups	No	*
rigid	item_master	rigid	No	*
fragile	item_master	fragile	No	*
container_type	item_master	container_type	No	*
conveyable_flag	item_master	conveyable_flag	No	*
hazard_matl_code	item_master	hazard_matl_code	No	*
velocity	item_master	velocity	No	*
high_value_ind	item_master	high_value_ind	No	*
ticket_type	item_master	ticket_type	No	*
color	item_master	color	No	*
size1	item_master	size1	No	*
fit	item_master	fit	No	*
shade	item_master	shade	No	*
single_contain_bulk	item_master	single_contain_bulk	No	*
unit_pick_system_code	item_master	unit_pick_system_code	No	*
roundable_flag	item_master	roundable_flag	No	*
perishable_ind	item_master	perishable_ind	No	*
division	item_master	division	No	*
vendor_nbr	item_master	vendor_nbr	No	*
kitting_wip_code	item_master	kitting_wip_code	No	*
unit_ticket_qty	item_master	unit_ticket_qty	No	*
item_length	item_master	item_length	No	*
item_width	item_master	item_width	No	*
item_height	item_master	item_height	No	*
item_weight	item_master	item_weight	No	*
item_cube	item_master	item_cube	No	*
std_unit_factor	item_master	std_unit_factor	No	*
std_unit_qty	item_master	std_unit_qty	No	*
expiration_days	item_master	expiration_days	No	*
putaway_by_volume	item_master	putaway_by_volume	No	*
putaway_plan	item_master	putaway_plan	No	*
item_type	item_master	item_type	No	*
sorter_group	item_master	sorter_group	No	*
sku_optimization	item_master	sku_optimization	No	*
ext_source_system	*	*	*	*
item_xform_ind	*	*	*	*
inventory_ind	*	*	*	*
order_type	*	*	*	*
sale_type	*	*	*	*
deposit_item_type	*	*	*	*
container_item	*	*	*	*
deposit_in_price_per_uom	*	*	*	*
transport_ind	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemSupDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_supplier	item_id	*	*
supplier	item_supplier	vendor_nbr	*	*
primary_supp_ind	item_supplier	primary_supp_ind	*	*
vpn	*	*	*	*
supp_label	*	*	*	*
consignment_rate	*	*	*	*
supp_diff_1	*	*	*	*
supp_diff_2	*	*	*	*
supp_diff_3	*	*	*	*
supp_diff_4	*	*	*	*
pallet_name	item_supplier	pallet_name	*	*
case_name	item_supplier	case_name	*	*
inner_name	item_supplier	inner_name	*	*
supp_discontinue_date	*	*	*	*
direct_ship_ind	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemSupCtyDesc

Tag Name	Table Name	Column Name	API Req	Description
item	*	*	*	*
supplier	*	*	*	*
origin_country_id	*	*	*	*
primary_supp_ind	*	*	*	*
primary_country_ind	*	*	*	*
unit_cost	n/a	n/a	No	Not used in RWMS.
lead_time	item_supp_country	lead_time	No	*
pickup_lead_time	n/a	n/a	No	Not used in RWMS.
supp_pack_size	item_supp_country	supp_pack_size	No	*
inner_pack_size	*	*	*	*
round_lvl	n/a	n/a	No	Not used in RWMS.
min_order_qty	n/a	n/a	No	Not used in RWMS.
max_order_qty	n/a	n/a	No	Not used in RWMS.
packing_method	item_supp_country	packing_method	No	*
default_uop	n/a	n/a	No	Not used in RWMS.
ti	*	*	*	*
hi	*	*	*	*
cost_uom	*	*	*	*
tolerance_type	*	*	*	*
max_tolerance	*	*	*	*
min_tolerance	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ISCDimDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country_dim	item_id	Yes	*
supplier	item_supp_country_dim	vendor_nbr	Yes	*
origin_country	item_supp_country_dim	origin_country_id	Yes	*
dim_object	item_supp_country_dim	dim_object	Yes	*
object_desc	item_supp_country_dim	dim_object_desc	No	*
presentation_method	n/a	n/a	No	Not used in RWMS.
method_desc	n/a	n/a	No	Not used in RWMS.
length	item_supp_country_dim	length	No	*
width	item_supp_country_dim	width	No	*
height	item_supp_country_dim	height	No	*
lwh_uom	item_supp_country_dim	lwh_uom	No	*
weight	item_supp_country_dim	weight	No	*
net_weight	n/a	n/a	No	Not used in RWMS.
weight_uom	item_supp_country_dim	weight_uom	No	*
liquid_volume	item_supp_country_dim	liquid_volume	No	*
liquid_volume_uom	item_supp_country_dim	liquid_volume_uom	No	*
stat_cube	n/a	n/a	No	Not used in RWMS.
tare_weight	item_supp_country_dim	tare_weight	No	*
tare_type	item_supp_country_dim	tare_type	No	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemUDALOVDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_attributes	item_id	Yes	*
uda_id	item_attributes	attribute_type	Yes	*
uda_value	item_attributes	attribute	Yes	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemUDAFFDesc

Tag Name	Table Name	Column Name	API Req	Description
item	*	*	*	*
uda_id	*	*	*	*
uda_text	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemUDADateDesc

Tag Name	Table Name	Column Name	API Req	Description
item	*	*	*	*
uda_id	*	*	*	*
uda_date	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemImageDesc

Tag Name	Table Name	Column Name	API Req	Description
item	*	*	*	*
image_name	*	*	*	*
image_addr	*	*	*	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemUPCDesc

Tag Name	Table Name	Column Name	API Req	Description
item_id	item_upc	upc	Yes	*
item_parent	item_upc	item_id	No	*
primary_ref_item_ind	item_upc	primary_upc_ind	No	*
format_id	n/a	n/a	No	Not used in RWMS.
prefix	n/a	n/a	No	Not used in RWMS.
item_number_type	n/a	n/a	No	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemBOMDesc

Tag Name	Table Name	Column Name	API Req	Description
pack_no	bill_of_materials	master_item_id	Yes	*
item	bill_of_materials	component_item_id	Yes	*
pack_qty	bill_of_materials	unit_qty	Yes	*

Application Name: Retail Warehouse Management System

Version 13.0.1

XML-Schema or Node Name:ItemTcktDesc

Tag Name	Table Name	Column Name	API Req	Description
item	*	*	*	*
ticket_type_id	*	*	*	*