RIB Mappings Report Release: 13.0.1

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AllocDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	stock_allocation	distro_nbr or cust_order_nbr	Yes	*
doc_type	*	*	*	*
physical_wh	transshipment_setup	dc_dest_id	Yes	*
wh	*	*	*	*
item	stock_allocation	item_id	Yes	*
pick_not_before_date	*	*	*	*
pick_not_after_date	*	*	*	*
order_type	*	*	*	*
order_no	*	*	*	*
order_doc_type	*	*	*	*
event	*	*	*	*
event_description	*	*	*	*
priority	*	*	*	*
ticket_type_id	stock_allocation	ticket_type_id	No	*
AllocDtl	*	*	*	*
context_type	*	*	*	*
context_value	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AllocDtl

Tag Name	Table Name	Column Name	API Req	Description
physical_to_loc	*	*	*	*
to_loc	stock_allocation	dest_id	Yes	*
loc_type	*	*	*	*
qty_allocated	stock_allocation	requested_unit_qty	Yes	*
price	stock_allocation	retail_price	No	*
selling_uom	stock_allocation	selling_uom	No	*
priority	stock_allocation	priority	Yes	*
store_ord_mult	stock_allocation	store_ord_mult	Yes	*
AllocDtlTckt	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AllocDtlTckt

Tag Name	Table Name	Column Name	API Req	Description
comp_item	component_ticketing	component_item_id	Yes	*
comp_price	component_ticketing	retail_price	Yes	*
comp_selling_uom	component_ticketing	selling_uom	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AllocRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	stock_allocation	distro_nbr or cust_order_no	Yes	*
doc_type	*	*	*	*
physical_wh	transshipment_setup	dc_dest_id	Yes	*
wh	*	*	*	*
item	stock_allocation	item_id	Yes	*
AllocDtlRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AllocDtlRef

Tag Name	Table Name	Column Name	API Req	Description
to_loc	stock_allocation	dest_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AppointDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	transshipment_setup	dc_dest_id	Yes	*
to_location	*	*	Yes	*
appt_nbr	appt_header_to_upload	appt_nbr	Yes	*
appt_start_ts	appt_header_to_upload	appt_start_ts	Yes	*
appt_action_status	appt_header_to_upload	appt_action_status	Yes	*
AppointDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AppointDtl

Tag Name	Table Name	Column Name	API Req	Description
item_id	appt_detail_to_upload	item_id	Yes	*
unit_qty	appt_detail_to_upload	unit_qty	Yes	*
po_nbr	appt_detail_to_upload	po_nbr	Yes	*
document_type	appt_detail_to_upload	document_type	Yes	*
asn_nbr	appt_detail_to_upload	asn_nbr	No	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AppointRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
appt_nbr	*	*	*	*
from_location	*	*	*	*
AppointDtlRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AppointDtlRef

Tag Name	Table Name	Column Name	API Req	Description
item_id	*	item_id	Yes	*
po_nbr	*	po_nbr	Yes	*
asn_nbr	*	asn_nbr	No	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNInDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	n/a	n/a	Yes	Not used in RWMS
from_location	n/a	n/a	Yes	Not used in RWMS
asn_nbr	asn	asn_nbr	Yes	*
asn_type	asn	asn_type	Yes	*
container_qty	asn	container_qty	Yes	*
bol_nbr	asn	bol_nbr	No	*
shipment_date	n/a	n/a	Yes	Not used in RWMS.
est_arr_date	n/a	n/a	No	Not used in RWMS.
ship_address1	n/a	n/a	No	Not used in RWMS.
ship_address2	n/a	n/a	No	Not used in RWMS.
ship_address3	n/a	n/a	No	Not used in RWMS.
ship_address4	n/a	n/a	No	Not used in RWMS.
ship_address5	n/a	n/a	No	Not used in RWMS.
ship_city	n/a	n/a	No	Not used in RWMS.
ship_state	n/a	n/a	No	Not used in RWMS.
ship_zip	n/a	n/a	No	Not used in RWMS.
ship_country_id	n/a	n/a	No	Not used in RWMS.
trailer_nbr	n/a	n/a	No	Not used in RWMS.
seal_nbr	n/a	n/a	No	Not used in RWMS.
carrier_code	asn	carrier_code	No	*
vendor_nbr	po	vendor_nbr	Yes	*
ship_pay_method	n/a	n/a	No	Not used in RWMS.
ASNInPO	*	*	*	*
comments	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNInPO

Tag Name	Table Name	Column Name	API Req	Description
po_nbr	po_detail	po_nbr	Yes	*
doc_type	po	doc_type	Yes	*
not_after_date	po	deliv_not_after_date	No	*
comments	*	*	*	*
ASNInCtn	*	*	*	*
ASNInItem	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNInCtn

Tag Name	Table Name	Column Name	API Req	Description
final_location	container	dest_id	Yes	*
container_id	container	container_id	Yes	*
container_weight	container	container_weight	No	*
container_length	container	container_length	No	*
container_width	container	container_width	No	*
container_height	container	container_height	No	*
container_cube	container	container_cube	No	*
expedite_flag	container	expedite_flag	No	*
in_store_date	container	in_store_date	No	*
rma_nbr	container	rma_nbr	No	*
tracking_nbr	n/a	n/a	No	Not used in RWMS
freight_charge	container	freight_charge	No	*
master_container_id	n/a	n/a	No	Not used in RWMS
ASNInItem	*	*	*	*
comments	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNInItem

Tag Name	Table Name	Column Name	API Req	Description
final_location	asn_item	dest_id	Yes	*
item_id	po_detail	item_id	Yes	*
unit_qty	asn_item	unit_qty	Yes	*
priority_level	container_item	priority_level	No	*
vpn	*	*	*	*
order_line_nbr	n/a	n/a	No	Not used in RWMS.
lot_nbr	n/a	n/a	Yes	Not used in RWMS.
ref_item	n/a	n/a	No	Not used in RWMS.
distro_nbr	container_item	distro_nbr	Yes	*
distro_doc_type	n/a	n/a	No	Not used in RWMS.
container_qty	container_item	container_qty	No	*
comments	*	*	*	*
final_location	asn_item	dest_id	Yes	*
item_id	po_detail	item_id	Yes	*
unit_qty	asn_item	unit_qty	Yes	*
priority_level	container_item	priority_level	No	*
vpn	*	*	*	*
order_line_nbr	n/a	n/a	No	Not used in RWMS.
lot_nbr	n/a	n/a	Yes	Not used in RWMS.
ref_item	n/a	n/a	No	Not used in RWMS.
distro_nbr	container_item	distro_nbr	Yes	*
distro_doc_type	n/a	n/a	No	Not used in RWMS.
container_qty	container_item	container_qty	No	*
comments	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNInRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	manifest	dest_id	Yes	*
from_location	transshipment_setup	dc_dest_id	Yes	*
asn_nbr	calculated	asn_nbr	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNOutDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	ship_dest	dest_id	Yes	*
from_location	transshipment_setup	dc_dest_id	Yes	*
asn_nbr	computed	*	No	*
asn_type	calculated	*	No	*
container_qty	computed	*	No	*
bol_nbr	bol_to_upload	bol_nbr	Yes	*
shipment_date	manifest	ship_ts	No	*
est_arr_date	ship_dest	lead_time	No	*
ship_address1	ship_dest	address1	No	*
ship_address2	ship_dest	address2	No	*
ship_address3	n/a	n/a	No	Not used in RWMS.
ship_address4	n/a	n/a	No	Not used in RWMS.
ship_address5	n/a	n/a	No	Not used in RWMS.
ship_city	ship_dest	city	No	*
ship_state	ship_dest	state	No	*
ship_zip	ship_dest	zip	No	*
ship_country_id	ship_dest	country_code	No	*
trailer_nbr	manifest	trailer_id	Yes	*
seal_nbr	manifest	seal_nbr	No	*
carrier_code	trailer	carrier_code	Yes	*
transshipment_nbr	manifest	transshipment_nbr	No	*
ASNOutDistro	*	*	*	*
comments	n/a	n/a	No	Not used in RWMS.

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNOutDistro

Tag Name	Table Name	Column Name	API Req	Description
distro_nbr	container_item	distro_nbr	Yes	*
distro_doc_type	stock_order	document_type	Yes	*
customer_order_nbr	stock_order	cust_order_nbr	Yes	*
consumer_direct	stock_order	consumer_direct	No	*
ASNOutCtn	*	*	*	*
comments	n/a	n/a	No	Not used in RWMS.

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNOutCtn

Tag Name	Table Name	Column Name	API Req	Description
final_location	container	dest_id	No	*
container_id	container	container_id	Yes	*
container_weight	container	container_weight	No	*
container_length	container	container_length	No	*
container_width	container	container_width	No	*
container_height	container	container_height	No	*
container_cube	container	container_cube	No	*
expedite_flag	container	expedite_flag	No	*
in_store_date	container	in_store_date	No	*
rma_nbr	container	rma_nbr	No	*
tracking_nbr	*	tracking_nbr	No	*
freight_charge	*	freight_charge	No	*
master_container_id	container	master_container_id	No	*
ASNOutItem	*	*	*	*
comments	n/a	n/a	No	Not used in RWMS.
weight	*	*	*	*
weight_uom	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ASNOutItem

Tag Name	Table Name	Column Name	API Req	Description
item_id	container_item	item_id	Yes	*
unit_qty	container_item	unit_qty	Yes	*
priority_level	container_item	priority_level	No	*
order_line_nbr	*	*	No	*
lot_nbr	container	lot_nbr	No	*
final_location	*	*	No	*
from_disposition	*	*	No	*
to_disposition	*	*	No	*
voucher_number	*	*	No	*
voucher_expiration_date	*	*	No	*
container_qty	computed	*	No	*
comments	n/a	n/a	No	Not used in RWMS.
unit_cost	n/a	n/a	No	*
weight	*	*	*	*
weight_uom	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:CustRetDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	transshipment_setup	dc_dest_id	Yes	*
rma_nbr	returns_upload	rma_nbr	Yes	*
pro_nbr	returns_upload	pro_nbr	Yes	*
comments	returns_upload	comments	Yes	*
CustRetItem	*	*	*	*
return_date	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:CustRetItem

Tag Name	Table Name	Column Name	API Req	Description
item_id	returns_upload	item_id	Yes	*
CustRetItemQty	*	custretitemqty	Yes	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:CustRetItemQty

Tag Name	Table Name	Column Name	API Req	Description
unit_qty	returns_upload	unit_qty	Yes	*
from_wip	returns_upload	from_wip_code	Yes	*
to_wip	returns_upload	to_wip_code	Yes	*
from_disposition	returns_upload	from_disposition	Yes	*
to_disposition	returns_upload	to_disposition	Yes	*
saleable	returns_upload	saleable	Yes	*
CustRetItemQtyDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:CustRetItemQtyDtl

Tag Name	Table Name	Column Name	API Req	Description
unit_qty	returns_upload	unit_qty	Yes	*
reason_code	returns_upload	reason_code	Yes	*
action_code	returns_upload	action_code	Yes	*
replacement_item	returns_upload	replacement_item	Yes	*
replace_unit_qty	returns_upload	replace_unit_qty	Yes	*
cust_ret_postage_amt	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_id	differentiator	diff_id	Yes	*
diff_type	differentiator	diff_type	Yes	*
diff_desc	differentiator	diff_desc	Yes	*
industry_code	n/a	n/a	No	Not used in RWMS.
industry_subcode	n/a	n/a	No	Not used in RWMS.

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffGrpDtlDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_details	diff_group_id	Yes	*
diff_id	diff_group_details	diff_id	Yes	*
display_seq	*	*	No	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffGrpDtlRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_details	diff_group_id	Yes	*
diff_id	diff_group_details	diff_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffGrpHdrDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	differentiator_group	diff_group_id	Yes	*
diff_group_type	differentiator_group	diff_group_type	Yes	*
diff_group_desc	differentiator_group	diff_group_desc	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffGrpRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	differentiator_group	diff_group_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:DiffRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_id	differentiator	diff_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:InvAdjustDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
InvAdjustDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:InvAdjustDtl

Tag Name	Table Name	Column Name	API Req	Description
item_id	inv_adjustment_to_upload	item_id	Yes	*
adjustment_reason_code	inv_adjustment_to_upload	adjustment_reason_code	Yes	*
unit_qty	inv_adjustment_to_upload	unit_qty	Yes	*
transshipment_nbr	inv_adjustment_to_upload	transshipment_nbr	Yes	*
from_disposition	inv_adjustment_to_upload	from_disposition	Yes	*
to_disposition	inv_adjustment_to_upload	to_disposition	Yes	*
from_trouble_code	inv_adjustment_to_upload	from_trouble_code	Yes	*
to_trouble_code	inv_adjustment_to_upload	to_trouble_code	Yes	*
from_wip_code	inv_adjustment_to_upload	from_wip_code	Yes	*
to_wip_code	inv_adjustment_to_upload	to_wip_code	Yes	*
transaction_code	inv_adjustment_to_upload	transaction_code	Yes	*
user_id	inv_adjustment_to_upload	user_id	Yes	*
create_date	inv_adjustment_to_upload	create_date	Yes	*
po_nbr	inv_adjustment_to_upload	po_nbr	Yes	*
doc_type	po	doc_type	Yes	*
aux_reason_code	inv_adjustment_to_upload	aux_reason_code	Yes	*
weight	*	*	*	*
weight_uom	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ISCDimRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_supplier_country_dim	item_id	Yes	*
supplier	*	*	Yes	*
origin_country	*	*	*	*
dim_object	item_supplier_country_dim	dim_object	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ISCDimWHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dimobjectdesc	item_supp_country_dim	dim_object_desc	*	*
itemid	item_supp_country_dim	item_id	*	*
height	item_supp_country_dim	height	*	*
weight	item_supp_country_dim	weight	*	*
velocity	item_supp_country_dim	velocity	*	*
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
length	item_supp_country_dim	length	*	*
width	item_supp_country_dim	width	*	*
dimobject	item_supp_country_dim	dim_object	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ISCDimWHRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
itemid	item_supp_country_dim	item_id	*	*
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
vendornbr	item_supp_country_dim	vendor_nbr	*	*
origincountryid	item_supp_country_dim	origin_country_id	*	*
dimobject	item_supp_country_dim	dim_object	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemBOMRef.xsd

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	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

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

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

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

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

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

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

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

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

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

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

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

XML-Schema or Node Name:ItemTcktDesc

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

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemHdrWHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
itemid	item_master	item_id	*	*
description	item_master	description	*	*
vendornbr	item_master	vendor_nbr	*	*
containertype	item_master	container_type	*	*
conveyableflag	item_master	conveyable_flag	*	*
stdunitqty	item_master	std_unit_qty	*	*
hazardmatlcode	item_master	hazard_matl_code	*	*
highvalueind	item_master	high_value_ind	*	*
department	item_master	department	*	*
class	item_master	class	*	*
singlecontainerbulk	item_master	single_contain_bulk	*	*
subclass	item_master	subclass	*	*
expirationdays	item_master	expiration_days	*	*
perishableind	item_master	perishable_ind	*	*
division	item_master	division	*	*
putawaybyvolume	item_master	putaway_by_volume	*	*
stdunitfactor	item_master	std_unit_factor	*	*
itemmasteruda1	item_master	item_master_uda1	*	*
itemmasteruda2	item_master	item_master_uda2	*	*
itemmasteruda3	item_master	item_master_uda3	*	*
itemmasteruda4	item_master	item_master_uda4	*	*
itemmasteruda5	item_master	item_master_uda5	*	*
itemmasteruda6	item_master	item_master_uda6	*	*
itemmasteruda7	item_master	item_master_uda7	*	*
itemmasteruda8	item_master	item_master_uda8	*	*
itemmasteruda9	item_master	item_master_uda9	*	*
itemmasteruda10	item_master	item_master_uda10	*	*
itemmasteruda11	item_master	item_master_uda11	*	*
itemmasteruda12	item_master	item_master_uda12	*	*
itemmasteruda13	item_master	item_master_uda13	*	*
itemmasteruda14	item_master	item_master_uda14	*	*
itemmasteruda15	item_master	item_master_uda15	*	*
nonsaleable	item_master	non_saleable	*	*
brand	item_master	brand	*	*
fragile	item_master	fragile	*	*
rigid	item_master	rigid	*	*
standarduom	item_master	standard_uom	*	*
uomconvfactor	item_master	uom_conv_factor	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemSupCtyRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country	item_id	Yes	*
supplier	item_supp_country	vendor_nbr	Yes	*
origin_country_id	item_supp_country	origin_country_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemSupRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_supplier	item_id	Yes	*
supplier	item_supplier	vendor_nbr	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemSupWHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
vendornbr	item_supplier	vendor_nbr	*	*
vpn	item_supplier	vpn	*	*
itemid	item_supplier	item_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemSupWHRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
vendornbr	item_supplier	vendor_nbr	*	*
itemid	item_supplier	item_id	*	*
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemTcktRef.xsd

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

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemUDADateRef.xsd

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

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemUDAFFRef.xsd

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

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemUDALOVRef.xsd

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	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemUPCRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_upc	upc	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemWHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
itemhdrwhdesc	*	*	*	*
itemsupwhdesc	*	*	*	*
itemsupctywhdesc	*	*	*	*
iscdimwhdesc	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemWHRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
itemid	item_master	item_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZonePrcDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
ItemZoneGrp	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZoneGrp

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	*	*	*	*
item	*	*	*	*
ItemZone	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZone

Tag Name	Table Name	Column Name	API Req	Description
zone_id	*	*	*	*
unit_retail	*	*	*	*
selling_unit_retail	*	*	*	*
selling_uom	*	*	*	*
multi_units	*	*	*	*
multi_unit_retail	*	*	*	*
multi_selling_uom	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZonePrcRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
ItemZoneGrpRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZoneGrpRef

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	*	*	*	*
item	*	*	*	*
ItemZoneRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ItemZoneRef

Tag Name	Table Name	Column Name	API Req	Description
zone_id	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:LocationDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dest_id	ship_dest	dest_id	*	*
dest_type	ship_dest	dest_type	*	*
description	ship_dest	description	*	*
address1	ship_dest	address1	*	*
address2	ship_dest	address2	*	*
city	shiip_dest	city	*	*
state	ship_dest	state	*	*
country_code	ship_dest	country_code	*	*
zip	ship_dest	zip	*	*
contact_person	ship_dest	contact_person	*	*
dest_fax	ship_dest	dest_fax	*	*
phone_nbr	ship_dest	phone_nbr	*	*
currency_code	ship_dest	currency_code	*	*
default_route	ship_dest	default_route	*	*
default_carrier_code	ship_dest	default_carrier_code	*	*
default_service_code	ship_dest	default_service_code	*	*
expedite_route	ship_dest	expedite_route	*	*
expedite_carrier_code	ship_dest	expedite_carrier_code	*	*
expedite_service_code	ship_dest	expedite_service_code	*	*
bol_upload_type	ship_dest	bol_upload_type	*	*
bol_print_type	ship_dest	bol_print_type	*	*
lead_time	ship_dest	lead_time	*	*
distance_to_dest	ship_dest	distance_to_dest	*	*
drop_trailers_accepted_flag	ship_dest	drop_trailers_accepted_flag	*	*
rcv_dock_available_flag	ship_dest	rcv_dock_available_flag	*	*
container_type	ship_dest	container_type	*	*
mld_default_route	ship_dest	mld_default_route	*	*
unit_pick_container_type	ship_dest	unit_pick_container_type	*	*
dest_seq_nbr	ship_dest	dest_seq_nbr	*	*
owning_dc	ship_dest	owning_dc	*	*
email_to	ship_dest	email_to	*	*
email_cc	ship_dest	email_cc	*	*
email_bcc	ship_dest	email_bcc	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:LocationRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
dest_id	ship_dest	dest_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PendRtrnDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
physical_wh	transshipment_setup	dc_dest_id	Yes	*
return_order_number	pending_returns	pro_nbr	Yes	*
rma_nbr	pending_returns	rma_nbr	Yes	*
creation_date	pending_returns	expected_receipt	Yes	*
PendRtrnDtlDesc	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PendRtrnDtlDesc

Tag Name	Table Name	Column Name	API Req	Description
return_order_number	pending_returns_detail	pro_nbr	Yes	*
physical_wh	*	*	*	*
rma_nbr	pending_returns_detail	rma_nbr	Yes	*
item	pending_returns_detail	item_id	Yes	*
ordered_quantity	pending_returns_detail	unit_qty	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PendRtrnDtlRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
return_order_number	pending_returns	pro_nbr	Yes	*
physical_wh	*	*	*	*
rma_nbr	pending_returns	rma_nbr	Yes	*
item	pending_returns_detail	item_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PendRtrnRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
physical_wh	*	*	*	*
return_order_number	pending_returns	pro_nbr	Yes	*
rma_nbr	pending_returns	rma_nbr	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PODesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
doc_type	po	doc_type	Yes	*
order_no	po	po_nbr	Yes	*
order_type	n/a	n/a	Yes	Not used in RWMS.
order_type_desc	n/a	n/a	Yes	Not used in RWMS.
dept	n/a	n/a	No	Not used in RWMS.
dept_name	n/a	n/a	No	Not used in RWMS.
buyer	*	buyer	No	*
buyer_name	po	buyer_code	No	*
supplier	po	vendor_nbr	Yes	*
promotion	n/a	n/a	No	Not used in RWMS.
prom_desc	n/a	n/a	No	Not used in RWMS.
qc_ind	n/a	n/a	Yes	Not used in RWMS.
not_before_date	po	deliv_not_before_date	No	*
not_after_date	po	deliv_not_after_date	No	*
otb_eow_date	n/a	n/a	No	Not used in RWMS.
earliest_ship_date	n/a	n/a	No	Not used in RWMS.
latest_ship_date	n/a	n/a	No	Not used in RWMS.
close_date	n/a	n/a	No	Not used in RWMS.
terms	n/a	n/a	Yes	Not used in RWMS.
terms_code	n/a	n/a	Yes	Not used in RWMS.
freight_terms	*	*	*	*
cust_order	n/a	n/a	Yes	Not used in RWMS.
payment_method	n/a	n/a	No	Not used in RWMS.
payment_method_desc	n/a	n/a	No	Not used in RWMS.
backhaul_type	n/a	n/a	No	Not used in RWMS.
backhaul_type_desc	n/a	n/a	No	Not used in RWMS.
backhaul_allowance	n/a	n/a	No	Not used in RWMS.
ship_method	po	transportation_mode	No	*
ship_method_desc	n/a	n/a	No	*
purchase_type	n/a	n/a	No	*
purchase_type_desc	n/a	n/a	No	*
status	po	status	Yes	*
ship_pay_method	n/a	n/a	No	Not used in RWMS.
ship_pay_method_desc	n/a	n/a	No	Not used in RWMS.
fob_trans_res	n/a	n/a	No	Not used in RWMS.
fob_trans_res_code_desc	n/a	n/a	No	Not used in RWMS.
fob_trans_res_desc	n/a	n/a	No	Not used in RWMS.
fob_title_pass	n/a	n/a	No	Not used in RWMS.
fob_title_pass_code_desc	n/a	n/a	No	Not used in RWMS.
fob_title_pass_desc	n/a	n/a	No	Not used in RWMS.
vendor_order_no	n/a	n/a	No	Not used in RWMS.
exchange_rate	n/a	n/a	No	Not used in RWMS.
factory	n/a	n/a	No	Not used in RWMS.
factory_desc	n/a	n/a	No	Not used in RWMS.
agent	n/a	n/a	No	Not used in RWMS.
agent_desc	n/a	n/a	No	Not used in RWMS.
discharge_port	n/a	n/a	No	Not used in RWMS.
discharge_port_desc	n/a	n/a	No	Not used in RWMS.
lading_port	n/a	n/a	No	Not used in RWMS.
lading_port_desc	n/a	n/a	No	Not used in RWMS.
bill_to_id	n/a	n/a	No	Not used in RWMS.
freight_contract_no	n/a	n/a	No	Not used in RWMS.
po_type	n/a	n/a	No	Not used in RWMS.
po_type_desc	po	po_type	No	*
pre_mark_ind	n/a	n/a	Yes	*
currency_code	n/a	n/a	Yes	Not used in RWMS.
contract_no	n/a	n/a	No	Not used in RWMS.
pickup_loc	n/a	n/a	No	Not used in RWMS.
pickup_no	n/a	n/a	No	Not used in RWMS.
pickup_date	n/a	n/a	No	Not used in RWMS.
app_datetime	n/a	n/a	No	Not used in RWMS.
comment_desc	po	po_comments	No	*
PODtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PODtl

Tag Name	Table Name	Column Name	API Req	Description
item	po_detail	item_id	Yes	*
ref_item	n/a	n/a	No	Not used in RWMS.
physical_location_type	n/a	n/a	Yes	Not used in RWMS.
physical_location	n/a	n/a	Yes	Not used in RWMS.
physical_qty_ordered	po_detail	requested_unit_qty	No	*
unit_cost	n/a	n/a	No	Not used in RWMS.
origin_country_id	po_detail	country_code	No	*
supp_pack_size	po_detail	order_casepack	No	*
earliest_ship_date	n/a	n/a	No	Not used in RWMS.
latest_ship_date	n/a	n/a	No	Not used in RWMS.
pickup_loc	n/a	n/a	No	Not used in RWMS.
pickup_no	n/a	n/a	No	Not used in RWMS.
packing_method	n/a	n/a	No	Not used in RWMS.
round_lvl	po_detail	round_lvl	No	*
door_ind	po_detail	door_ind	No	*
priority_level	po_detail	priority_level	No	*
new_item	po_detail	new_item	No	*
quarantine	po_detail	quarantine	No	*
rcvd_unit_qty	po_detail	rcvd_unit_qty	No	*
tsf_po_link_id	n/a	n/a	No	Not used in RWMS.
POVirtualDtl	*	*	*	*
cost_source	*	*	*	*
est_in_stock_date	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:POVirtualDtl

Tag Name	Table Name	Column Name	API Req	Description
location_type	n/a	n/a	Yes	Not used in RWMS.
location	n/a	n/a	Yes	Not used in RWMS.
qty_ordered	n/a	n/a	No	Not used in RWMS.

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:PORef.xsd

Tag Name	Table Name	Column Name	API Req	Description
doc_type	po	doc_type	Yes	*
order_no	po	order_no	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ReceiptDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
appt_nbr	receipt_to_upload	appt_nbr	Yes	*
Receipt	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:Receipt

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
po_nbr	receipt_to_upload	po_nbr	Yes	*
document_type	po	doc_type	Yes	*
asn_nbr	receipt_to_upload	asn_nbr	No	*
ReceiptDtl	*	*	*	*
ReceiptCartonDtl	*	*	*	*
receipt_type	*	*	*	*
from_loc	*	*	*	*
from_loc_type	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ReceiptDtl

Tag Name	Table Name	Column Name	API Req	Description
item_id	receipt_to_upload	item_id	Yes	*
unit_qty	receipt_to_upload	unit_qty	Yes	*
receipt_xactn_type	receipt_to_upload	receipt_xactn_type	Yes	*
receipt_date	receipt_to_upload	receipt_date	No	*
receipt_nbr	receipt_to_upload	receipt_nbr	Yes	*
dest_id	receipt_to_upload	dest_id	No	*
container_id	receipt_to_upload	container_id	Yes	*
distro_nbr	receipt_to_upload	distro_nbr	No	*
distro_doc_type	receipt_to_upload	distro_doc_type	No	*
to_disposition	receipt_to_upload	to_disposition	No	*
from_disposition	receipt_to_upload	from_disposition	No	*
to_wip	receipt_to_upload	to_wip_code	No	*
from_wip	receipt_to_upload	from_wip_code	No	*
to_trouble	receipt_to_upload	to_trouble_code	No	*
from_trouble	receipt_to_upload	from_trouble_code	No	*
user_id	receipt_to_upload	user_id	No	*
dummy_carton_ind	*	*	*	*
tampered_carton_ind	*	*	*	*
unit_cost	*	*	*	*
shipped_qty	*	*	*	*
weight	*	*	*	*
weight_uom	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:ReceiptCartonDtl

Tag Name	Table Name	Column Name	API Req	Description
carton_status_ind	*	*	*	*
container_id	*	*	*	*
dest_id	*	*	*	*
receipt_xactn_type	*	*	*	*
receipt_date	*	*	*	*
receipt_nbr	*	*	*	*
user_id	*	*	*	*
to_disposition	*	*	*	*
weight	*	*	*	*
weight_uom	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
rtv_id	inv_adjustment_to_upload	rtv id	Yes	*
item_id	inv_adjustment_to_upload	item_id	Yes	*
rtn_auth_nbr	*	*	*	*
unit_qty	inv_adjustment_to_upload	unit_qty	No	*
container_qty	rtv	container_qty	No	*
vendor_nbr	rtv	vendor_nbr	Yes	*
ship_address1	rtv	address1	No	*
ship_address2	rtv	address2	No	*
ship_address3	rtv	address3	No	*
state	rtv	state	No	*
city	rtv	city	No	*
shipto_zip	rtv	shipto_zip	No	*
country	rtv	country	No	*
from_disposition	inv_adjustment_to_upload	from_disposition	No	*
to_disposition	inv_adjustment_to_upload	to_disposition	No	*
creation_ts	rtv	creation_ts	No	*
unit_cost	*	*	No	*
reason	*	*	No	*
comments	*	*	*	*
rtv_order_no	*	*	*	*
weight	*	*	*	*
weight_uom	*	*	*	*
RTVDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVDtl

Tag Name	Table Name	Column Name	API Req	Description
item_id	*	*	*	*
unit_qty	*	*	*	*
container_qty	*	*	*	*
from_disposition	*	*	*	*
to_disposition	*	*	*	*
unit_cost	*	*	*	*
reason	*	*	*	*
weight	*	*	*	*
weight_uom	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVReqDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
rtv_order_no	*	*	*	*
supplier	*	*	*	*
status_ind	*	*	*	*
loc	*	*	*	*
loc_type	*	*	*	*
physical_loc	*	*	*	*
total_order_amt	*	*	*	*
ship_to_addr_line1	*	*	*	*
ship_to_addr_line2	*	*	*	*
ship_to_addr_line3	*	*	*	*
ship_to_city	*	*	*	*
state	*	*	*	*
ship_to_country_code	*	*	*	*
ship_to_postal_code	*	*	*	*
ret_auth_nbr	*	*	*	*
ret_courier	*	*	*	*
freight_charge	*	*	*	*
creation_date	*	*	*	*
completed_date	*	*	*	*
handling_pct	*	*	*	*
handling_cost	*	*	*	*
ext_ref_no	*	*	*	*
comment_desc	*	*	*	*
RTVReqDtl	*	*	*	*
not_after_date	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVReqDtl

Tag Name	Table Name	Column Name	API Req	Description
seq_no	*	*	*	*
item	*	*	*	*
shipment	*	*	*	*
inv_status	*	*	*	*
rtv_qty	*	*	*	*
unit_cost	*	*	*	*
reason	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVReqRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
rtv_order_no	*	*	*	*
RTVReqDtlRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:RTVReqDtlRef

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

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SKUOptmDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	*	*	Yes	*
to_location	*	*	Yes	*
groupnbr	task_queue	group_nbr	Yes	*
movenbr	task_queue	move_nbr	Yes	*
seqnbr	task_queue	seq_nbr	Yes	*
itemid	task_queue	item_id	Yes	*
fromlocationid	transshipment_setup	dc_dest_id	Yes	*
tolocationid	*	*	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SODesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
distro_nbr	stock_order	distro_nbr / cust_order_nbr	Yes	*
document_type	stock_order	document_type	*	*
dc_dest_id	transshipment_setup	dc_dest_id	*	*
order_type	stock_order	order_type	*	*
pick_not_before_date	stock_order	pick_not_before_date	*	*
pick_not_after_date	stock_order	pick_not_after_date	*	*
priority	stock_order	priority	*	*
event_code	stock_order	event_code	*	*
event_description	stock_order	event_description	*	*
carrier_code	stock_order	carrier_code	*	*
carrier_service_code	stock_order	carrier_service_code	*	*
route	stock_order	route	*	*
ship_address_desc	stock_order	ship_address_desc	*	*
ship_address1	stock_order	ship_address1	*	*
ship_address2	stock_order	ship_address2	*	*
ship_address3	stock_order	ship_address3	*	*
ship_address4	stock_order	ship_address4	*	*
ship_address5	stock_order	ship_address5	*	*
ship_city	stock_order	ship_city	*	*
ship_state	stock_order	ship_state	*	*
ship_zip	stock_order	ship_zip	No	*
ship_country_id	stock_order	ship_country_code	No	*
bill_address_desc	stock_order	bill_address_description	No	*
bill_address1	stock_order	bill_address1	No	*
bill_address2	stock_order	bill_address2	*	*
bill_address3	stock_order	bill_address3	*	*
bill_address4	stock_order	bill_address4	*	*
bill_address5	stock_order	bill_address5	*	*
bill_city	stock_order	bill_city	*	*
bill_state	stock_order	bill_state	*	*
bill_zip	stock_order	bill_zip	*	*
bill_country_id	stock_order	bill_country_code	*	*
break_by_distro	stock_order	break_by_distro	*	*
rollback_allocation	stock_order	rollback_allocation	*	*
cartonization	stock_order	cartonization	*	*
consumer_direct	stock_order	consumer_direct	*	*
message	stock_order	message	*	*
chute_type	stock_order	chute_type	*	*
po_nbr	stock_order	po_nbr	*	*
parent_customer_order	stock_order	parent_customer_order	*	*
pick_complete	stock_order	pick_complete	*	*
order_line_costs	stock_order	order_line_costs	*	*
container_type	stock_order	container_type	*	*
amount1	stock_order	amount1	*	*
amount2	stock_order	amount2	*	*
amount3	stock_order	amount3	*	*
amount4	stock_order	amount4	*	*
amount5	stock_order	amount5	*	*
amount6	stock_order	amount6	*	*
sub_total	stock_order	sub_total	*	*
gift_cost_total	stock_order	gift_cost_total	*	*
promotion_total	stock_order	promotion_total	*	*
total	stock_order	total	*	*
tax_total	stock_order	tax_total	*	*
shipping_total	stock_order	shipping_total	*	*
order_uda1	stock_order	order_uda1	*	*
order_uda2	stock_order	order_uda2	*	*
order_uda3	stock_order	order_uda3	*	*
order_uda4	stock_order	order_uda4	*	*
order_uda5	stock_order	order_uda5	*	*
order_uda6	stock_order	order_uda6	*	*
order_uda7	stock_order	order_uda7	*	*
order_uda8	stock_order	order_uda8	*	*
order_uda9	stock_order	order_uda9	*	*
order_uda10	stock_order	order_uda10	*	*
dl_comment	stock_order	dl_comment	*	*
ship_date	*	*	*	*
SODtlDesc	*	*	*	*
not_after_date	*	*	*	*
distro_parent_nbr	*	*	*	*
exp_dc_date	*	*	*	*
approval_id	*	*	*	*
approval_date	*	*	*	*
from_loc_tsf_entity	*	*	*	*
to_loc_tsf_entity	*	*	*	*
inv_type	*	*	*	*
so_status	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SODtlDesc

Tag Name	Table Name	Column Name	API Req	Description
dest_id	stock_allocation	dest_id	*	*
item_id	stock_allocation	item_id	*	*
requested_unit_qty	stock_allocation	requested_unit_qty	*	*
retail_price	component_ticketing	retail_price	*	*
selling_uom	stock_allocation	selling_uom	*	*
ticket_type	stock_allocation	ticket_type	*	*
priority	stock_order	priority	*	*
store_ord_mult	stock_allocation	store_ord_mult	*	*
expedite_flag	stock_allocation	expedite_flag	*	*
order_line_nbr	stock_allocation_cid	order_line_nbr	No	Derived as ROWNUM.
amount1	stock_allocation	amount1	*	*
amount2	stock_allocation	amount2	*	*
amount3	stock_allocation	amount3	*	*
amount4	stock_allocation	amount4	*	*
amount5	stock_allocation	amount5	*	*
amount6	stock_allocation	amount6	*	*
tax_percent	stock_allocation	tax_percent	*	*
item_status	stock_allocation	item_status	*	*
component_ticketing_distro_nbr	component_ticketing	component_ticketing_distro_nbr	*	*
in_store_date	stock_allocation	in_store_date	*	*
total	transshipment_setupe	total	*	*
gift_cost	stock_allocation	gift_cost	*	*
shipping	stock_allocation	shipping	*	*
promotion	stock_allocation	promotion	*	*
sub_total	stock_allocation	sub_total	*	*
tax	stock_allocation	tax	*	*
order_detail_uda1	stock_allocation	order_detail_uda1	*	*
order_detail_uda2	stock_allocation	order_detail_uda2	*	*
order_detail_uda3	stock_allocation	order_detail_uda3	*	*
order_detail_uda4	stock_allocation	order_detail_uda4	*	*
order_detail_uda5	stock_allocation	order_detail_uda5	*	*
SODtlTcktDesc	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SODtlTcktDesc

Tag Name	Table Name	Column Name	API Req	Description
distro_nbr	stock_allocation	distro_nbr	*	*
document_type	stock_order	document_type	*	*
item_id	stock_allocation	item_id	*	*
dest_id	stock_allocation	dest_id	*	*
component_item_id	component_ticketing	component_item_id	*	*
retail_price	component_ticketing	retail_price	*	*
selling_uom	component_ticketing	selling_uom	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SORef.xsd

Tag Name	Table Name	Column Name	API Req	Description
distro_nbr	stock_allocation	distro_nbr	Yes	*
document_type	stock_allocation	document_type	Yes	*
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
SODtlRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SODtlRef

Tag Name	Table Name	Column Name	API Req	Description
dest_id	stock_allocation	dest_id	Yes	*
item_id	stock_allocation	item_id	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SOStatusDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
distro_nbr	stock_order_info_upload	distro_nbr	No	*
distro_document_type	stock_order	distro_document_type	Yes	*
SOStatusDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:SOStatusDtl

Tag Name	Table Name	Column Name	API Req	Description
cust_order_nbr	*	*	*	*
dest_id	stock_allocation	dest_id	*	*
item_id	stock_allocation	item_id	*	*
order_line_nbr	stock_allocation_cid	order_line_nbr	No	Derived as ROWNUM.
unit_qty	stock_allocation	requested_unit_qty	*	*
status	stock_allocation	item_status	*	*
user_id	*	*	*	*
updated_date	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:StoreDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
store	ship_dest	dest_id	Yes	*
store_type	*	*	Yes	*
org_unit_type	*	*	No	*
store	ship_dest	dest_id	Yes	*
store_name	ship_dest	description	Yes	*
store_name10	*	*	Yes	*
store_name3	*	*	Yes	*
store_add1	ship_dest	address1	Yes	*
store_add2	ship_dest	address2	Yes	*
store_city	ship_dest	city	Yes	*
county	*	*	Yes	*
state	ship_dest	state	Yes	*
country_id	ship_dest	country_code	Yes	*
store_pcode	ship_dest	zip	Yes	*
store_class	*	*	Yes	*
store_mgr_name	ship_dest	contact_person	Yes	*
store_open_date	*	*	Yes	*
store_close_date	*	*	Yes	*
acquired_date	*	*	Yes	*
remodel_date	*	*	Yes	*
fax_number	ship_dest	dest_fax	Yes	*
phone_number	ship_dest	phone_nbr	Yes	*
email	*	*	Yes	*
total_square_ft	*	*	Yes	*
selling_square_ft	*	*	Yes	*
linear_distance	*	*	Yes	*
stockholding_ind	*	*	Yes	*
channel_id	*	*	Yes	*
store_format	*	*	Yes	*
mall_name	*	*	Yes	*
district	*	*	Yes	*
district_name	*	*	Yes	*
promo_zone	*	*	Yes	*
promo_desc	*	*	Yes	*
transfer_zone	*	*	Yes	*
description	*	*	Yes	*
default_wh	ship_dest	owning_dc	Yes	*
stop_order_days	*	*	Yes	*
start_order_days	*	*	Yes	*
currency_code	ship_dest	currency_code	Yes	*
lang	*	*	Yes	*
integrated_pos_ind	*	*	Yes	*
orig_currency_code	*	*	Yes	*
duns_number	*	*	Yes	*
duns_loc	*	*	Yes	*
AddrDesc	*	*	*	*
pricing_loc	*	*	*	*
pricing_loc_curr	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AddrDesc

Tag Name	Table Name	Column Name	API Req	Description
addr	*	*	*	*
addr_type	*	*	*	*
primary_addr_type_ind	*	*	*	*
primary_addr_ind	*	*	*	*
add_1	*	*	*	*
add_2	*	*	*	*
add_3	*	*	*	*
city	*	*	*	*
state	*	*	*	*
country_id	*	*	*	*
post	*	*	*	*
contact_name	*	*	*	*
contact_phone	*	*	*	*
contact_telex	*	*	*	*
contact_fax	*	*	*	*
contact_email	*	*	*	*
oracle_vendor_site_id	*	*	*	*
county	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:UDADesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	attribute_type	attribute_type	Yes	*
uda_desc	attribute_type	description	Yes	*
module	n/a	n/a	Yes	Not used in RWMS.
display_type	n/a	n/a	Yes	Not used in RWMS.
data_type	n/a	n/a	No	Not used in RWMS.
data_length	n/a	n/a	No	Not used in RWMS.
single_value_ind	n/a	n/a	No	Not used in RWMS.
host_ind	attribute_type	host_type	No	*
carton_group	attribute_type	carton_group	No	*
combinability	attribute_type	combinability	No	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:UDARef.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	attribute_type	attribute_type.attribute_ty	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:UDAValDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	attributes	attribute_type	Yes	*
uda_value	attributes	attribute	Yes	*
uda_value_desc	attributes	description	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:UDAValRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	attributes	attribute_type	Yes	*
uda_value	attributes	attribute	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:VendorAddrRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
supplier	vendor_address	vendor_nbr	Yes	*
seq_no	vendor_address	seq_no	Yes	*
addr_type	vendor_address	addr_type	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:VendorDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
VendorHdrDesc	*	vendorhdrdesc	Yes	*
VendorAddrDesc	*	vendoraddrdesc	Yes	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:VendorHdrDesc

Tag Name	Table Name	Column Name	API Req	Description
supplier	vendor	vendor_nbr	Yes	*
sup_name	vendor	vendor_name	Yes	*
contact_name	n/a	n/a	Yes	Not used in RWMS.
contact_phone	n/a	n/a	Yes	Not used in RWMS.
contact_fax	n/a	n/a	No	Not used in RWMS.
contact_pager	n/a	n/a	No	Not used in RWMS.
sup_status	vendor	sup_status	Yes	*
qc_ind	n/a	n/a	No	Not used in RWMS.
qc_pct	vendor	percent_qa_sampling	No	*
qc_freq	vendor	freq_qa_audit	No	*
vc_ind	n/a	*	Yes	Not used in RWMS.
vc_pct	vendor	percent_va_sampling	No	*
vc_freq	vendor	freq_va_audit	No	*
currency_code	n/a	n/a	Yes	Not used in RWMS.
lang	n/a	n/a	No	Not used in RWMS.
terms	n/a	n/a	No	Not used in RWMS.
freight_terms	n/a	n/a	No	Not used in RWMS.
ret_allow_ind	n/a	n/a	No	Not used in RWMS.
ret_auth_req	n/a	n/a	No	Not used in RWMS.
ret_min_dol_amt	n/a	n/a	No	Not used in RWMS.
ret_courier	n/a	n/a	No	Not used in RWMS.
handling_pct	n/a	n/a	No	Not used in RWMS.
edi_po_ind	n/a	n/a	Yes	Not used in RWMS.
edi_po_chg	n/a	n/a	No	Not used in RWMS.
edi_po_confirm	n/a	n/a	No	Not used in RWMS.
edi_asn	n/a	n/a	No	Not used in RWMS.
edi_sales_rpt_freq	n/a	n/a	No	Not used in RWMS.
edi_supp_available_ind	n/a	n/a	Yes	Not used in RWMS.
edi_contract_ind	n/a	n/a	No	Not used in RWMS.
edi_invc_ind	n/a	n/a	No	Not used in RWMS.
cost_chg_pct_var	n/a	n/a	No	Not used in RWMS.
cost_chg_amt_var	n/a	n/a	No	Not used in RWMS.
replen_approval_ind	n/a	n/a	No	Not used in RWMS.
ship_method	n/a	n/a	No	Not used in RWMS.
payment_method	n/a	n/a	No	Not used in RWMS.
contact_telex	n/a	n/a	No	Not used in RWMS.
contact_email	n/a	n/a	No	Not used in RWMS.
settlement_code	n/a	n/a	No	Not used in RWMS.
pre_mark_ind	n/a	n/a	No	Not used in RWMS.
auto_appr_invc_ind	*	*	*	*
dbt_memo_code	*	*	*	*
freight_charge_ind	*	*	*	*
auto_appr_dbt_memo_ind	n/a	n/a	No	Not used in RWMS.
inv_mgmt_lvl	n/a	n/a	No	Not used in RWMS.
backorder_ind	n/a	n/a	No	Not used in RWMS.
vat_region	n/a	n/a	No	Not used in RWMS.
prepay_invc_ind	n/a	n/a	No	Not used in RWMS.
service_perf_req_ind	n/a	n/a	No	Not used in RWMS.
invc_pay_loc	n/a	n/a	No	Not used in RWMS.
invc_receive_loc	n/a	n/a	No	Not used in RWMS.
addinvc_gross_net	n/a	n/a	No	Not used in RWMS.
delivery_policy	n/a	n/a	No	Not used in RWMS.
comment_desc	n/a	n/a	No	Not used in RWMS.
default_item_lead_time	n/a	n/a	No	Not used in RWMS.
duns_number	n/a	n/a	No	Not used in RWMS.
duns_loc	n/a	n/a	No	Not used in RWMS.
bracket_costing_ind	n/a	n/a	No	Not used in RWMS.
vmi_order_status	n/a	n/a	No	Not used in RWMS.
end_date_active	n/a	end_date_active	No	Not used in RWMS.
dsd_supplier_ind	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:VendorAddrDesc

Tag Name	Table Name	Column Name	API Req	Description
module	*	*	Yes	Not used in RWMS.
key_value_1	n/a	n/a	Yes	Not used in RWMS.
key_value_2	n/a	n/a	No	Not used in RWMS.
seq_no	vendor_address	seq_no	Yes	*
addr_type	vendor_address	addr_type	Yes	*
primary_addr_ind	vendor_address	primary_addr_ind	Yes	*
add_1	vendor_address	address1	Yes	*
add_2	vendor_address	address2	No	*
add_3	vendor_address	address3	No	*
city	vendor_address	city	Yes	*
state	vendor_address	state	Yes	*
country_id	vendor_address	country	Yes	*
post	vendor_address	shipto_zip	Yes	*
contact_name	n/a	n/a	No	Not used in RWMS.
contact_phone	n/a	n/a	No	Not used in RWMS.
contact_telex	n/a	n/a	No	Not used in RWMS.
contact_fax	n/a	n/a	No	Not used in RWMS.
contact_email	n/a	n/a	No	Not used in RWMS.
oracle_vendor_site_id	n/a	n/a	No	Not used in RWMS.
OracleOUDesc	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:OracleOUDesc

Tag Name	Table Name	Column Name	API Req	Description
OUDtlDesc	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:OUDtlDesc

Tag Name	Table Name	Column Name	API Req	Description
ou_id	*	*	*	*
site_id	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:VendorRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
supplier	vendor	vendor_nbr	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wh	ship_dest	dest_id	Yes	*
wh_name	ship_dest	description	Yes	*
wh_add1	ship_dest	address1	Yes	*
wh_add2	ship_dest	address2	Yes	*
wh_city	ship_dest	city	Yes	*
county	*	*	Yes	*
state	ship_dest	state	Yes	*
country_id	ship_dest	country_code	Yes	*
wh_pcode	ship_dest	zip	Yes	*
email	*	*	Yes	*
stockholding_ind	*	*	Yes	*
channel_id	*	*	Yes	*
currency_code	ship_dest	currency_code	Yes	*
duns_number	*	*	Yes	*
duns_loc	*	*	Yes	*
physical_wh	*	*	Yes	*
break_pack_ind	*	*	Yes	*
redist_wh_ind	*	*	Yes	*
delivery_policy	*	*	Yes	*
contact_person	ship_dest	contact_person	No	*
dest_fax	ship_dest	dest_fax	No	*
phone_nbr	ship_dest	phone_nbr	No	*
default_route	ship_dest	default_route	No	*
default_carrier_code	ship_dest	default_carrier_code	No	*
default_service_code	ship_dest	default_service_code	No	*
expedite_route	ship_dest	expedite_route	No	*
expedite_carrier_code	ship_dest	expedite_carrier_code	No	*
expedite_service_code	ship_dest	expedite_service_code	No	*
bol_upload_type	ship_dest	bol_upload_type	No	*
bol_print_type	ship_dest	bol_print_type	No	*
lead_time	ship_dest	lead_time	No	*
distance_to_dest	ship_dest	distance_to_dest	No	*
drop_trailers_accepted_flag	ship_dest	drop_trailers_accepted_flag	No	*
rcv_dock_available_flag	ship_dest	rcv_dock_available_flag	No	*
container_type	ship_dest	container_type	No	*
mld_default_route	ship_dest	mld_default_route	No	*
unit_pick_container_type	ship_dest	unit_pick_container_type	No	*
dest_seq_nbr	ship_dest	dest_seq_nbr	No	*
owning_dc	ship_dest	owning_dc	No	*
AddrDesc	*	*	*	*
pricing_loc	*	*	*	*
pricing_loc_curr	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AddrDesc

Tag Name	Table Name	Column Name	API Req	Description
addr	*	*	*	*
addr_type	*	*	*	*
primary_addr_type_ind	*	*	*	*
primary_addr_ind	*	*	*	*
add_1	*	*	*	*
add_2	*	*	*	*
add_3	*	*	*	*
city	*	*	*	*
state	*	*	*	*
country_id	*	*	*	*
post	*	*	*	*
contact_name	*	*	*	*
contact_phone	*	*	*	*
contact_telex	*	*	*	*
contact_fax	*	*	*	*
contact_email	*	*	*	*
oracle_vendor_site_id	*	*	*	*
county	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHEquipClsDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
reduction_factor	*	*	*	*
from_location	transshipment_setup	dc_dest_id	*	*
description	equipment_class_upload	equipment_desc	*	*
equipment_class	equipment_class_upload	equip_class	*	*
to_location	*	*	*	*
horizontal_speed	equipment_class_upload	horizontal_speed	*	*
loaded_horizontal_speed	*	*	*	*
vertical_speed	equipment_class_upload	vertical_speed	*	*
loaded_vertical_speed	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHEquipClsRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	*	*	*	*
from_location	transshipment_setup	dc_dest_id	*	*
equipment_class	equipment_class_upload	equip_class	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHEquipDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
reduction_factor	*	*	*	*
equipment_id	equipment_upload	equipment_id	Yes	*
horizontal_speed	equipment_upload	horizontal_speed	*	*
loaded_vertical_speed	*	*	*	*
equipment_class	equipment_upload	equipment_class	*	*
from_location	transshipment_setup	dc_dest_id	*	*
to_location	*	*	*	*
vertical_speed	equipment_upload	vertical_speed	*	*
loaded_horizontal_speed	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHEquipRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
equipment_id	equipment_upload	equipment_id	Yes
to_location	*	*	*	*
from_location	transshipment_setup	dc_dest_id	*	*
equipment_class	equipment_upload	equipment_class	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHLocRefDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
facility_id	*	facility_id	*	*
distance	*	distance	*	*
aisle	*	aisle	*	*
reference_point	*	reference_point	*	*
location_id	*	location_id	*	*
reference_type	*	reference_type	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHLocRefRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
reference_point	*	reference_point	*	*
location_id	*	location_id	*	*
facility_id	*	facility_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wh	ship_dest	dest_id	Yes	*
AddrRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:AddrRef

Tag Name	Table Name	Column Name	API Req	Description
addr	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHReferenceDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	*	dc_dest_id	*	*
x_coordinate	*	x_coordinate	*	*
y_coordinate	*	y_coordinate	*	*
z_coordinate	*	z_coordinate	*	*
facility_id	*	facility_id	*	*
description	*	description	*	*
reference_point	*	reference_point	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHReferenceRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
reference_point	*	reference_point	*	*
facility_id	*	facility_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHRefMapDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	*	dc_dest_id	*	*
from_point	*	from_point	*	*
facility_id	*	facility_id	*	*
distance	*	distance	*	*
to_point	*	to_point	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHRefMapRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_point	*	from_point	*	*
to_point	*	to_point	*	*
facility_id	*	facility_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHSpaceLocsDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
x_coordinate	location	x_coordinate	*	*
z_coordinate	location	z_coordinate	*	*
to_location	*	*	*	*
from_location	transshipment_setup	dc_dest_id	*	*
reference_point	*	reference_point	*	*
y_coordinate	location	y_coordinate	*	*
location_id	location	location_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WHSpaceLocsRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	*	*	*	*
from_location	transshipment_setup	dc_dest_id	*	*
location_id	location	location_id	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WODesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
WOHdr	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOHdr

Tag Name	Table Name	Column Name	API Req	Description
wo_id	*	*	*	*
order_no	*	*	*	*
WODtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WODtl

Tag Name	Table Name	Column Name	API Req	Description
wh	*	*	*	*
item	*	*	*	*
loc_type	*	*	*	*
location	*	*	*	*
seq_no	*	*	*	*
wip_code	*	*	*	*
instructions	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOInDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	n/a	n/a	Yes	Used in interface only.
order_no	inbound_work_order	po_nbr	Yes	*
WOInDtl	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOInDtl

Tag Name	Table Name	Column Name	API Req	Description
wh	n/a	n/a	Yes	Not used in RWMS.
item	inbound_work_order	item_id	Yes	*
loc_type	n/a	n/a	Yes	Not used in RWMS.
location	inbound_work_order	dest_id	Yes	*
seq_no	inbound_work_order	wip_seq_no	Yes	*
wip_code	inbound_work_order	wip_code	Yes	*
instructions	inbound_work_order	instructions	No	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOInRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	*	*	Yes	*
order_no	inbound_work_order	po_nbr	Yes	*
WOInDtlRef	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOInDtlRef

Tag Name	Table Name	Column Name	API Req	Description
wh	*	*	Yes	*
item	inbound_work_order	item_id	Yes	*
loc_type	*	*	Yes	*
location	inbound_work_order	dest_id	Yes	*
seq_no	inbound_work_order	wip_seq_nbr	Yes	*
wip_code	inbound_work_order	wip_code	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	*	*	Yes	Used in interface only.
dc_dest_id	n/a	n/a	Yes	Used in interface only.
distro_nbr	outbound_work_order	distro_nbr	Yes	*
WOOutDtl	*	*	*	*
distro_parent_nbr	*	*	*	*
WOOutXForm	*	*	*	*
WOOutPacking	*	*	*	*
inv_type	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutDtl

Tag Name	Table Name	Column Name	API Req	Description
dest_id	outbound_work_order	dest_id	Yes	*
item_id	outbound_work_order	item_id	Yes	*
wip_seq_nbr	outbound_work_order	wip_seq_nbr	No	*
wip_code	outbound_work_order	wip_code	No	*
personalization	outbound_work_order	personalization	No	*
instructions	outbound_work_order	instructions	No	*
order_line_nbr	outbound_work_order	order_line_nbr	No	*
auto_complete	outbound_work_order	auto_complete	Yes	*
WOOutActivity	*	*	*	*
inv_status	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutActivity

Tag Name	Table Name	Column Name	API Req	Description
activity_id	*	*	*	*
activity_cost	*	*	*	*
comments	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutXForm

Tag Name	Table Name	Column Name	API Req	Description
from_item	*	*	*	*
to_item	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutPacking

Tag Name	Table Name	Column Name	API Req	Description
WOOutPackTo	*	*	*	*
WOOutPackFrom	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutPackTo

Tag Name	Table Name	Column Name	API Req	Description
to_item	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutPackFrom

Tag Name	Table Name	Column Name	API Req	Description
from_item	*	*	*	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	*	*	Yes	*
dc_dest_id	transshipment_setup	dc_dest_id	Yes	*
distro_nbr	outbound_work_order	distro_nbr	Yes	*
WOOutDtlRef	*	*	*	*
distro_parent_nbr	*	*	*	*

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WOOutDtlRef

Tag Name	Table Name	Column Name	API Req	Description
dest_id	outbound_work_order	dest_id	Yes	*
item_id	outbound_work_order	item_id	Yes	*
wip_seq_nbr	outbound_work_order	wip_seq_nbr	Yes	*
order_line_nbr	outbound_work_order	order_line_nbr	Yes	*

Retail Integration Bus Mappings Report

Application Name: Retail Warehouse Management System

XML-Schema or Node Name:WORef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item_id	inbound_work_order	item_id	*	*
wip_seq_nbr	inbound_work_order	wip_seq_nbr	*	*
order_line_nbr	*	*	*	*
dest_id	inbound_work_order	dest_id	*	*
wo_id	*	*	*	*