RIB Mappings Report Release: 13.0.0

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AllocDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	alloc_header	alloc_no	Yes	Contains the number that uniquely identifies the allocation within the system.
doc_type	n/a	n/a	Yes	Specifies the type of document. This value will always be 'A' to signify an allocation.
physical_wh	wh	physical_wh	Yes	The physical wh location where the allocation will originate.
wh	alloc_header	wh	Yes	Contains the number of the warehouse loaction where the allocation will originate.
item	alloc_header	item	Yes	Unique alphanumeric value that identifies the item.
pick_not_before_date	alloc_header	release_date	No	Contains the date on which the allocation should be released from the warehouse for delivery to the store locations.
pick_not_after_date	n/a	n/a	No	This value is calculated by adding code_detail.code desc for code 'DATE' and code_type 'DEFT' to alloc_header.release_date. If the allocation is closed, pick_not_after_date will be a day before pick_not_before_date.
order_type	alloc_header	order_type	No	This field identifies the order associated with the PO. Allocations created before PO approval will be marked as 'PREDIST' ordertypes. Allocations created after PO approval will be marked as 'PO' order types.
order_no	alloc_header	order_no	No	Contains the order number to which the allocation applies.
order_doc_type	n/a	n/a	Yes	This value will always be 'P'.
event	rpm_promo_event	prom_event_id	No	This field contains the event to which the promotion belongs to. This is an optional field that provides a method to group promotions together for tracking and reporting purposes.
event_description	rpm_promo_event	description	No	This field contains the description of the promotional event.
priority	n/a	n/a	Yes	A value which indicates the priority of an allocation. This value will always be 1.
ticket_type_id	item_ticket	ticket_type_id	No	This field contains a character string which uniquely identifies the ticket type which is associated with the item.
AllocDtl	*	*	*	*
context_type	alloc_header	context_type	No	This field holds the functional area code to which the transfer relates to for example Promotions. Valid value is: PROM - Promotion
context_value	alloc_header	context_value	No	The value for the context type

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AllocDtl

Tag Name	Table Name	Column Name	API Req	Description
physical_to_loc	alloc_detail	to_loc	Yes	This field contains the physical location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse.
to_loc	alloc_detail	to_loc	Yes	This field contains the location to which the allocation is being sent. The loc_type field determinds if the location is a store or a warehouse.
loc_type	item_loc	loc_type	Yes	This field contains the type of location in the loctaion field. Valid values are 'S'tore and 'W'arehouse.
qty_allocated	alloc_detail	qty_allocated	Yes	Contains the total number of items allocated.
price	item_loc	selling_unit_retail	No	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
selling_uom	item_loc	selling_uom	No	This field holds the selling unit of measure for an item's single-unit retail.
priority	n/a	n/a	Yes	A value which indicates the priority of an allocation. This value will always be 1.
store_ord_mult	item_loc	store_ord_mult	Yes	This column contains the multiple in which the item needs to be shipped from a warehouse to the location.
AllocDtlTckt	*	*	*	*
in_store_date	alloc_detail	in_store_date	No	Date to be included in the ORMS publication to the RIB for communication to the warehouse. It indicates the date on which the freight needs to reach the location.
rush_flag	alloc_detail	rush_flag	No	It indicates that the item needs to be rushed to the location. It is to be included in the ORMS publication to the RIB for communication to the warehouse.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AllocDtlTckt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
comp_item	packitem_breakout	item	Yes	Alphanumeric value that identifies the item within the pack.
comp_price	item_loc	selling_unit_retail	Yes	This field holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
comp_selling_uom	item_loc	selling_uom	Yes	This field holds the selling unit of measure for an item's single-unit retail.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AllocRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	alloc_header	alloc_no	Yes	Contains the number that uniquely identifies the allocation within the system.
doc_type	n/a	n/a	Yes	Specifies the type of document. This value will always be 'A' to signify an allocation.
physical_wh	wh	physical_wh	Yes	Contains the number of the physical warehouse location where the allocation will originate.
wh	alloc_header	wh	Yes	Contains the number of the warehouse location where the allocation will originate.
item	alloc_header	item	Yes	Unique alphanumeric value that identifies the item.
AllocDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AllocDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
to_loc	alloc_detail	to_loc	Yes	This field contains the location to which the allocation is being sent. The loc_type field determines if the location is a store or a warehouse.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AppointDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
from_location	appt_head	loc	Yes	The location to which the merchandise has been sent.
to_location	n/a	n/a	Yes	Not used by RMS.
appt_nbr	appt_head	appt	Yes	An RWMS-generated unique numerical identifier for an Appointment.
appt_start_ts	n/a	n/a	Yes	Not used by RMS.
appt_action_status	appt_head	status	Yes	The status of the Appointment. Valid values include: SC - Scheduled, MS - Modified Scheduled, AR - Arrived, CL - Closed.
AppointDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AppointDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	appt_detail	item	Yes	The item shipped to the location under the Appt ID.
unit_qty	appt_detail	qty_appointed	Yes	The quantity of the item slated to be sent to the location.
po_nbr	appt_detail	doc	Yes	The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise.
document_type	appt_detail	doc_type	Yes	The type of document corresponding to the shipped merchandise. Possible choices are 'P'urchase Order, 'T'ransfer and 'A'llocation.
asn_nbr	appt_detail	asn	No	This column will hold the Advance Shipping Notice number associated with the Appointment.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AppointRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
appt_nbr	appt_head	appt	Yes	An RWMS-generated unique numerical identifier for an Appointment. Appointment is created in a Warehouse system.
from_location	appt_head	loc	Yes	The location to which the merchandise has been sent.
AppointDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AppointDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	appt_detail	item	Yes	The item shipped to the location under the Appt ID.
po_nbr	appt_detail	doc	Yes	The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise.
asn_nbr	appt_detail	asn	No	This column will hold the Advance Shipping Notice number associated with the Appointment.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNInDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	shipment	to_loc	Yes	Contains the location that the shipment will be delivered to.
from_location	n/a	n/a	Yes	Not used by RMS.
asn_nbr	shipment	asn	Yes	Holds the advance shipping notice number associated with a shipment.
asn_type	n/a	n/a	Yes	This field is used to determine the ship origin. If asn_type is 'C', ship_origin will be set to '6' (ASN UCC-128) upon insert to the SHIPMENT table. Otherwise, SHIP_ORIGIN is defaulted to '0' (ASN Shipment).
container_qty	n/a	n/a	Yes	Not used by RMS.
bol_nbr	shipment	ext_ref_no_in	No	Holds the transaction sequence number on the input message from the receiving PO or transfer process.
shipment_date	shipment	ship_date	Yes	This field contains the date the transfer or PO was shipped.
est_arr_date	shipment	est_arr_date	No	This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis.
ship_address1	n/a	n/a	No	Not used by RMS.
ship_address2	n/a	n/a	No	Not used by RMS.
ship_address3	n/a	n/a	No	Not used by RMS.
ship_address4	n/a	n/a	No	Not used by RMS.
ship_address5	n/a	n/a	No	Not used by RMS.
ship_city	n/a	n/a	No	Not used by RMS.
ship_state	n/a	n/a	No	Not used by RMS.
ship_zip	n/a	n/a	No	Not used by RMS.
ship_country_id	n/a	n/a	No	Not used by RMS.
trailer_nbr	n/a	n/a	No	Not used by RMS.
seal_nbr	n/a	n/a	No	Not used by RMS.
carrier_code	shipment	courier	No	Contains the courier that will deliver the shipment.
vendor_nbr	ordhead	supplier	Yes	This element is used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The order number must be in the table ORDHEAD, in either the ORDER_NO column or VENDOR_ORDER_NO column.
ship_pay_method	ordhead	ship_pay_method	No	Used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The ship_pay_method in the message must match the value of the order's SHIP_PAY_METHOD in RMS (ORDHEAD table.) If the message field is blank, the ORDHEAD value must be NULL.
ASNInPO	*	*	*	*
comments	n/a	n/a	No	Not used by RMS.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNInPO

Tag Name	Table Name	Column Name	API Req	Description
po_nbr	shipment	order_no	Yes	Identifies the order number which relates to the goods delivered in the shipment. Validated against the ORDHEAD table, and also the SHIPMENT table if the message applies to an existing shipment.
doc_type	n/a	n/a	Yes	Not used by RMS.
not_after_date	ordhead	not_after_date	No	Contains the last date that delivery of the order will be accepted.
comments	n/a	n/a	No	Not used by RMS.
ASNInCtn	*	*	*	*
ASNInItem	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNInCtn

Tag Name	Table Name	Column Name	API Req	Description
final_location	carton	location	Yes	This will be the final destination of the carton. For a cross-dock order this will be the allocation location, otherwise it will be the direct to order location.
container_id	carton	carton	Yes	Holds the UCC-128 carton number.
container_weight	n/a	n/a	No	Not used by RMS.
container_length	n/a	n/a	No	Not used by RMS.
container_width	n/a	n/a	No	Not used by RMS.
container_height	n/a	n/a	No	Not used by RMS.
container_cube	n/a	n/a	No	Not used by RMS.
expedite_flag	n/a	n/a	No	Not used by RMS.
in_store_date	n/a	n/a	No	Not used by RMS.
rma_nbr	n/a	n/a	No	Not used by RMS.
tracking_nbr	n/a	n/a	No	Not used by RMS.
freight_charge	n/a	n/a	No	Not used by RMS.
master_container_id	n/a	n/a	No	Not used by RMS.
ASNInItem	*	*	*	*
comments	n/a	n/a	No	Not used by RMS.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNInItem

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
final_location	alloc_detail	to_loc	Yes	Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location.
item_id	shipsku	item	Yes	Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message.
unit_qty	shipsku	qty_expected	Yes	Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination.
priority_level	n/a	n/a	No	Not used by RMS.
vpn	item_supplier	vpn	No	Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message.
order_line_nbr	n/a	n/a	No	Not used by RMS.
lot_nbr	n/a	n/a	Yes	Not used by RMS.
ref_item	shipsku	ref_item	No	Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message.
distro_nbr	n/a	n/a	Yes	Not used by RMS.
distro_doc_type	n/a	n/a	No	Not used by RMS.
container_qty	n/a	n/a	No	Not used by RMS.
comments	n/a	n/a	No	Not used by RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNInRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
to_location	shipment	to_loc	Yes	Contains the location which the shipment was to be delivered to.
from_location	n/a	n/a	No	Not use by RMS.
asn_nbr	shipment	asn	Yes	Holds the advance shipping notice number associated with a shipment to be deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNOutDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
to_location	shipment	to_loc	Yes	Contains the location that the shipment will be delivered to.
from_location	shipment	from_loc	Yes	For transfer and allocation shipments, this field will hold the location from which the shipment was sourced.
asn_nbr	shipment	bol_no	No	Holds the bill of lading number associated with a shipment.
asn_type	n/a	n/a	No	Not used by RMS.
container_qty	shipment	no_boxes	No	Contains the number of boxes associated with the shipment.
bol_nbr	shipment	ext_ref_no_out	Yes	Holds the transaction sequence number on the message from the transfer shipment confirmation process.
shipment_date	shipment	ship_date	No	This field contains the date the transfer or PO was shipped.
est_arr_date	shipment	est_arr_date	No	This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis.
ship_address1	n/a	n/a	No	Not used by RMS.
ship_address2	n/a	n/a	No	Not used by RMS.
ship_address3	n/a	n/a	No	Not used by RMS.
ship_address4	n/a	n/a	No	Not used by RMS.
ship_address5	n/a	n/a	No	Not used by RMS.
ship_city	n/a	n/a	No	Not used by RMS.
ship_state	n/a	n/a	No	Not used by RMS.
ship_zip	n/a	n/a	No	Not used by RMS.
ship_country_id	n/a	n/a	No	Not used by RMS.
trailer_nbr	n/a	n/a	Yes	Not used by RMS.
seal_nbr	n/a	n/a	No	Not used by RMS.
carrier_code	shipment	courier	No	Contains the courier that will deliver the shipment.
transshipment_nbr	n/a	n/a	No	Not used by RMS.
ASNOutDistro	*	*	*	*
comments	shipment	comments	No	Contains any miscellaneous comments about the shipment.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNOutDistro

Tag Name	Table Name	Column Name	API Req	Description
distro_nbr	shipsku	distro_no	Yes	Specifies the transfer or allocation number associated with the shipment/item/carton.
distro_doc_type	n/a	n/a	Yes	Specifies what the distro_nbr field corresponds to in RMS: V, D, and T specify transfer, A specifies Allocation.
customer_order_nbr	n/a	n/a	No	Not used by RMS.
consumer_direct	n/a	n/a	No	Not used by RMS.
ASNOutCtn	*	*	*	*
comments	n/a	n/a	No	Not used by RMS.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNOutCtn

Tag Name	Table Name	Column Name	API Req	Description
final_location	n/a	n/a	No	Not used by RMS.
container_id	shipsku	carton	Yes	Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments. This field will be zero for all shipments that are not at a carton level.
container_weight	n/a	n/a	No	Not used by RMS.
container_length	n/a	n/a	No	Not used by RMS.
container_width	n/a	n/a	No	Not used by RMS.
container_height	n/a	n/a	No	Not used by RMS.
container_cube	n/a	n/a	No	Not used by RMS.
expedite_flag	n/a	n/a	No	Not used by RMS.
in_store_date	n/a	n/a	No	Not used by RMS.
rma_nbr	n/a	n/a	No	Not used by RMS.
tracking_nbr	n/a	n/a	No	Not used by RMS.
freight_charge	n/a	n/a	No	Not used by RMS.
master_container_id	n/a	n/a	No	Not used by RMS.
ASNOutItem	*	*	*	*
comments	n/a	n/a	No	Not used by RMS.
weight	shipsku	weight_expected	No	Actual weight shipped for the container.
weight_uom	shipsku	weight_expected_uom	No	Unit of measurement for weight (e.g. pounds, kilograms) that was shipped.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ASNOutItem

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	shipsku	item	Yes	Unique identifier for the item.
unit_qty	shipsku	qty_expected	Yes	Contains the number of items expected to be received based on the supplier's advance shipment notification for this item/shipment combination.
priority_level	n/a	n/a	No	Not used by RMS.
order_line_nbr	n/a	n/a	No	Not used by RMS.
lot_nbr	n/a	n/a	No	Not used by RMS.
final_location	n/a	n/a	No	Not used by RMS.
from_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
to_disposition	n/a	n/a	No	Not used by RMS.
voucher_number	n/a	n/a	No	Not used by RMS.
voucher_expiration_date	n/a	n/a	No	Not used by RMS.
container_qty	n/a	n/a	No	Not used by RMS.
comments	n/a	n/a	No	Not used by RMS.
unit_cost	n/a	n/a	No	Not used by RMS.
weight	shipsku	weight_expected	No	Actual weight shipped.
weight_uom	shipsku	weight_expected_uom	No	Unit of measurement for weight (e.g. pounds, kilograms) shipped.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ATPDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
item_parent	item_loc_soh	item_parent	Yes	Alphanumeric value that uniquely identifies the item/group at the level above the item.
item_grandparent	item_loc_soh	item_grandparent	Yes	Alphanumeric value that uniquely identifies the item/group two levels above the item.
loc	item_loc_soh	loc	Yes	Number of the loction in which the item is to be found. This field may contain a store or a warehouse.
loc_type	item_loc_soh	loc_type	Yes	Type of location in the loc field. Valid values are 'S' for store or 'W' for Warehouse.
av_cost	item_loc_soh	av_cost	Yes	Calculated using the PO's extimated landing cost during PO receiving process if elc_ind = 'Y'. this field is stored in the local currency. Pack items will not have an average cost stored on item_loc. Stock of a pack item is valued at the compnent lev
unit_cost	item_loc_soh	unit_cost	Yes	If system_options.std_av_ind = 'A' and elc_ind = 'Y' then this field holds the estimated landed cost when item is initially set up. It is then updated with PO's estimated landed cost each time this item is received at this location. Otherwise, this fie
stock_on_hand	item_loc_soh	stock_on_hand	Yes	Current stock on hand for the item.
soh_update_datetime	item_loc_soh	soh_update_datetime	Yes	Date and time of most recent update to stock_on_hand.
last_hist_export_date	item_loc_soh	last_hist_export_date	Yes	This field contains most recent date up to which sales/issues have been exported to an external system for the item/store or item/warehouse combination.
in_transit_qty	item_loc_soh	in_transit_qty	Yes	All quantities of an item shipped bu not received on all transfers and allocations for the "destination" location.
pack_comp_intran	*	*	*	*
pack_comp_soh	item_loc_soh	pack_comp_soh	Yes	Current stock on hand for pack component item.
tsf_reserved_qty	item_loc_soh	tsf_reserved_qty	Yes	The sum of all requested quantities of an item that have not been shipped on all transfers and stand alone allocations for the "source" location.
pack_comp_resv	item_loc_soh	pack_comp_resv	Yes	The sum of all requested quantities of a component item that have not been shipped on all transfers and stand alone allocations for the "source" location.
tsf_expected_qty	item_loc_soh	tsf_expected_qty	Yes	The sum of all expected quantities of an item that have not been shipped on all transfers and stand alone allocations for the "desitination" location.
pack_comp_exp	item_loc_soh	pack_comp_exp	Yes	The sum of all expected quantities of a component item that have not been shipped on all transfers and stand alone allocations for the "destination" location.
rtv_qty	item_loc_soh	rtv_qty	Yes	All quantities approved but not shipped on all RTV's from inventory for an item/location. Will reduce stock on hand when RTV is shipped.
non_sellable_qty	item_loc_soh	non_sellable_qty	Yes	Total non-sellable quantity for an item/location (i.e. sum of inv_status_qty.qty for an item/location across all inventory status).
customer_resv	item_loc_soh	customer_resv	Yes	This will hold the number of units being reserved for customer orders.
customer_backorder	item_loc_soh	customer_backorder	Yes	This will hold the number of units held for customer back orders.
pack_comp_cust_resv	item_loc_soh	pack_comp_cust_resv	Yes	This will hold the number of packs being reserved for customer orders.
pack_comp_cust_back	item_loc_soh	pack_comp_cust_back	Yes	This will hold the number of packs held for customer back orders.
create_datetime	item_loc_soh	create_datetime	Yes	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
last_update_datetime	item_loc_soh	last_update_datetime	Yes	Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database.
last_update_id	item_loc_soh	last_update_id	Yes	Hold the Oracle user-id of the user who most recently updated this record. This field is required by the database.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:BannerDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
banner_id	banner	banner_id	Yes	The number to uniquely identify a Banner.
banner_name	banner	banner_name	Yes	The name of the Banner for which channels are associated.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:BannerRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
banner_id	banner	banner_id	Yes	The number to uniquely identify a Banner

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ChannelDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
channel_id	channels	channel_id	Yes	This column will contain the number that uniquely identifies the channel.
channel_name	channels	channel_name	Yes	Contains the name of the channel.
channel_type	channels	channel_type	Yes	Specifies the type of channel.
banner_id	channels	banner_id	Yes	The number to uniquely identify a Banner.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ChannelRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
channel_id	channels	channel_id	Yes	This column will contain the number that uniquely identifies the channel.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CodeDtlDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
code_type	code_detail	code_type	Yes	This field will contain a valid code type for the row. the valid code types are defined on the CODE_HEAD table.
code	code_detail	code	Yes	This field contains the code used in Retek which must be decoded for display in the on-line forms.
code_desc	code_detail	code_desc	Yes	This field contains the description associated with the code and the code type.
required_ind	code_detail	required_ind	Yes	This field indicates whether or not the code is required. If the code is specified as required, then the user will not be able to delete the rows in the table for that code.
code_seq	code_detail	code_seq	Yes	This is a number used to order the elements so that they appear consistently when using them to populate a list.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CodeDtlRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
code_type	code_detail	code_type	Yes	This field will contain a valid code type for the row. The valid code types are defined on the CODE_HEAD table.
code	code_detail	code	Yes	This field contains the code used in Retek which must be decoded for display in the on-line forms.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CodeHdrDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
code_type	code_head	code_type	Yes	This field contains the code tpe which will serve as a grouping mechansim for the multiple codes stored on the CODE_DETAIL table.
code_type_desc	code_head	code_type_desc	Yes	This field will contain the description of the code type.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CodeHdrRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
code_type	code_head	code_type	Yes	This field contains the code tpe which will serve as a grouping mechansim for the multiple codes stored on the CODE_DETAIL table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CogsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
trans_date	tran_data	tran_date	Yes	Idenfies the date the transaction was created.
item	tran_data	item	Yes	Unique alphanumeric value that identifies the item. This value must be a valid item in RMS.
store	tran_data	location	Yes	Unique value representing the store where the cogs transaction occurred. This must be a valid store within RMS.
units	tran_data	units	Yes	Contains the number of units sold. This value is also used to update the stock on hand for the store.
header_media	tran_data	ref_no_1	Yes	Concatinated with line_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric.
line_media	tran_data	ref_no_1	Yes	Concatinated with header_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric.
reason_code	tran_code	ref_no_2	Yes	Valid values are 1 or 2.
supplier	n/a	n/a	No	Not used by RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:COResCanDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	The location ID in which the customer reserve needs to be cancelled for the item. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
cancelled_quantity	item_loc_soh	customer_resv	Yes	This will hold the number of units need to be cancelled for customer orders.
supplier	n/a	n/a	Yes	Not used by RMS.
direct_ship_ind	n/a	n/a	Yes	Not used by RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:COResDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	The location ID in which the customer reserve needs to recorded for the item. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
reserved_quantity	item_loc_soh	customer_resv	Yes	This will hold the number of units being reserved for customer orders.
supplier	n/a	n/a	Yes	Not used by RMS.
direct_ship_ind	n/a	n/a	Yes	Not used by RMS

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZnGrpDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	cost_zone_group	zone_group_id	Yes	Contains the unique identifier for the cost zone group.
cost_level	cost_zone_group	cost_level	Yes	Specifies the pricing level of the cost zone group. Valid values are: 'L'ocation, 'C'orporate, and 'Z'one. There will only be one record with Corporate level pricing and only record with a Location cost level, but there can be multiple records with a
costzngrp_desc	cost_zone_group	description	Yes	Contains the description of the cost zone group.
CostZn	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZn

Tag Name	Table Name	Column Name	API Req	Description
zone_id	cost_zone	zone_id	Yes	Contains the unique zone identification number. If the cost level of the zone group is store, then the zone will be the store number.
costzngrp_desc	cost_zone	description	Yes	Contains the name of the zone. If the cost level of the zone group is store, then this column contains the store name.
currency_code	cost_zone	currency_code	Yes	Contains the currency code for the zone. Each zone will have a currency code attached to ensure that each store location associated with the zone shares the same currency.
base_cost_ind	cost_zone	base_cost_ind	Yes	Indicates whether or not this zone will be used as the default for the base cost zone. Valid values are Y and N.
CostZnGrpLoc	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZnGrpLoc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location	cost_zone_group_loc	location	Yes	Contains the store or warehouse number in the zone. There must be exactly one record for every store and warehouse in every zone group.
loc_type	cost_zone_group_loc	loc_type	Yes	Specifies whether the location is a 'S'tore or 'W'arehouse.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZnGrpRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	cost_zone_group	zone_group_id	Yes	Contains the unique identifier for the cost zone group.
CostZnRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZnRef

Tag Name	Table Name	Column Name	API Req	Description
zone_id	cost_zone_group	zone_id	Yes	Contains the unique zone identification number. If the cost level of the zone group is store, then the zone will be the store number.
CostZnGrpLocRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CostZnGrpLocRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location	cost_zone_group_loc	location	Yes	Contains the store or warehouse number in the zone. There must be exactly one record for every store and warehouse in every zone group.
loc_type	*	*	*	*

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CountryDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
country_id	country	country_id	Yes	The unique country identifier.
country_desc	country_desc	country_desc	Yes	The name of the country

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CountryRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
country_id	country	country_id	Yes	The unique country identifier.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CurrRateDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
from_currency	currency_rates	currency_code	Yes	Contains the currency code that the rate exchange is from.
to_currency	system_options	currency_code	Yes	Contains the currency code that the rate exchange is to. This must match the primary RMS currency system option.
conversion_date	currency_rates	effective_date	Yes	Date on which the currency rate became or will become active.
conversion_rate	currency_rates	exchange_rate	Yes	Contains the exchange rate for the specified currency/type/effective date combination.
user_conversion_type	currency_rates	exchange_type	Yes	Incoming conversion type (e.g. Consolidation, Operational, etc.) is translated to an exchange type code (C, O, etc) by reading the fif_currency_xref table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustBOCanDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	The location ID in which the customer back order needs to be cancelled for the item. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
cancelled_quantity	item_loc_soh	customer_backorder	Yes	This will hold the number of units need to be cancelled for customer back orders.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustBODesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	The location ID in which the customer back order needs to recorded for the item. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
backordered_quantity	item_loc_soh	customer_backorder	Yes	This will hold the number of units being reserved for customer back orders.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustBOToResDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	Number of the location in which the item is to be found. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
backordered_quantity	item_loc_soh	customer_resv	Yes	This will hold the number of units to be adjusted from back order to reserve.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustResToBODesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	Number of the location in which the item is to be found. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
backordered_quantity	item_loc_soh	customer_resv	Yes	This will hold the number of units to be adjusted from reserve to back order.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustRetSaleDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
store	item_loc_soh	loc	Yes	The contains the non-stockholding location ID in which the item is being returned. This field may contain a store or a warehouse.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
shipped_quantity	item_loc_soh	stock_on_hand	Yes	This holds the number of units that was returned.
wh	item_loc_soh	loc	Yes	This contains the stockholding location to which the item is to be returned.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:CustSaleDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	item_loc_soh	loc	Yes	This contains the stockholding location to which the item is sold. This field may contain a store or a warehouse. The item and wh combination must be valid on the item_loc table.
store	item_loc_soh	loc	Yes	The contains the non-stockholding location ID in which the item is sold. This field may contain a store or a warehouse. The item and store combination must be valid on the item_loc table.
item	item_loc_soh	item	Yes	Unique alphanumeric value that identifies the item.
shipped_quantity	item_loc_soh	stock_on_hand	Yes	This will hold the number of units being sold for customer orders.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_ids	diff_id	Yes	This field will hold a unique number (identifier) of the differentiator.
diff_type	diff_ids	diff_type	Yes	This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table.
diff_desc	diff_ids	diff_desc	Yes	Description of the differential ID.
industry_code	diff_ids	industry_code	No	A unique number that represents all possible combinations of sizes according to the National Retail Federation.
industry_subcode	diff_ids	industry_subgroup	No	A unique number that represents all different color range groups.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffGrpDtlDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_detail	diff_group_id	Yes	Contains the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table.
diff_id	diff_group_detail	diff_id	Yes	Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table.
display_seq	diff_group_detail	display_seq	No	This field contains the display sequence for the differential.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffGrpDtlRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_detail	diff_group_id	Yes	Contains the value of the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table.
diff_id	diff_group_detail	diff_id	Yes	Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffGrpHdrDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_head	diff_group_id	Yes	This field holds a unique number (identifier) of the differential group.
diff_group_type	diff_group_head	diff_type	Yes	This field holds a value for differential types.
diff_group_desc	diff_group_head	diff_group_desc	Yes	This is the description of the differential group.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffGrpRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_head	diff_group_id	Yes	This field holds a unique number (identifier) of the differential group.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_ids	diff_id	Yes	This field will hold a unique number (identifier) of the differentiator.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffTypeDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_type	diff_type	diff_type	Yes	Contains the value used to uniquely identify the diff type.
diff_type_desc	diff_type	diff_type_desc	Yes	Contains the diff type description.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DiffTypeRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_type	diff_type	diff_type	Yes	Contains the value used to uniquely identify the diff type.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDDealsDesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDDeals

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
order_no	ordhead	order_no	Yes	The order number that the deal should be applied.
supplier	invc_head	supplier	Yes	Invoice Supplier's Number.
store	shipment	to_loc	Yes	This field contains the location that the shipment will be delivered to.
dept	n/a	n/a	No	Not used by RMS.
currency_code	n/a	n/a	Yes	Not used by RMS.
paid_ind	invc_head	paid_ind	Yes	Indicates if the invoice has already been paid. Valid values are 'Y' (invoice has already been paid) or 'N' (invoice should be paid in AP system)
ext_ref_no	invc_head	ext_ref_no	No	Any given Supplier-generated invoice number.
proof_of_delivery_no	invc_head	proof_of_delivery_no	No	Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA.
payment_ref_no	invc_head	payment_ref_no	No	Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA.
payment_date	invc_head	payment_date	No	Date that the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA.
deals_ind	n/a	n/a	Yes	Specifies whether deals will be applied to the generated order. If set to 'Y', the procedure APPLY_DEALS_TO_ORDER will be called.
shipment	shipment	shipment	No	The corresponding shipment for the order that was applied by the deal.
invc_id	invc_head	invc_id	No	Contains the invoice number for the purchase order of this deal.
invc_ind	n/a	n/a	Yes	Inidcates whether an invoice was created for this receipt by the supplier.
vdate	period	vdate	Yes	Contains the current date of the RMS application.
qty_sum	invc_head	total_qty	No	Total quantity of items on the order to be invoiced.
cost_sum	invc_head	total_merch_cost	No	Total merchandise cost for the invoice. This field will be held in the invoice currency.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDReceiptDesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDReceipt

Tag Name	Table Name	Column Name	API Req	Description
supplier	ordhead	supplier	Yes	Unique identifying number for a supplier for the receipt.
origin_country_id	ordsku	origin_country_id	Yes	The identifier of the country from which the item is being sourced.
store	store	store	Yes	Contains the number which uniquely identifies the store.
dept	deps	dept	No	The department in which are all the items on the order. This field is required if the system enforces single department ordering.
currency_code	sups	currency_code	Yes	Contains a code identifying the currency the supplier uses for business transactions.
paid_ind	invc_head	paid_ind	Yes	Indicates if the invoice has already been paid. Valid values are 'Y' (invoice has already been paid) or 'N' (invoice should be paid in AP system).
ext_ref_no	invc_head	ext_ref_no	No	Any given supplier-generated invoice number.
proof_of_delivery_no	invc_head	proof_of_delivery_no	No	Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA.
payment_ref_no	invc_head	payment_ref_no	No	Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA
payment_date	invc_head	payment_date	No	Date when the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA.
invc_ind	n/a	n/a	Yes	Inidcates whether an invoice was created for this receipt by the supplier.
deals_ind	n/a	n/a	Yes	Valid values are 'Y' and NULL. This field decides whether deals need to be applied to the order or not.
DSDDtl	*	*	*	*
DSDNonMerch	*	*	*	*
ext_receipt_no	shipment	ext_ref_no_in	No	This field holds the external transaction sequence number for the receipt.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDDtl

Tag Name	Table Name	Column Name	API Req	Description
item	shipsku	item	Yes	Item that was received for the DSD.
qty_received	shipsku	qty_received	Yes	Contains the number of items already received for the SKU / Shipment combination.
unit_cost	ordloc	unit_cost	No	This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency.
weight	shipsku	weight_received	No	Contains the actual weight of the item on received.
weight_uom	shipsku	weight_received_uom	No	Contains the unit of measure of the received weight (e.g. pounds, kilograms).

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSDNonMerch

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
non_merch_code	invc_non_merch_temp	non_merch_code	Yes	Code identifying a non-merchandise cost that can be added to an invoice.
non_merch_amt	invc_non_merch_temp	non_merch_amt	Yes	Amount of the non-merchandise cost, specified by the non-merchandise code, that has been invoiced for. This field will be held in the invoice currency.
vat_code	invc_non_merch_temp	vat_code	No	Code identifying the VAT rate that should be applied to the non_merch_amt entered.
service_perf_ind	invc_non_merch_temp	service_perf_ind	Yes	Indicates if a service non-merchandise cost has actually been performed. Valid values are 'Y' (service has been performed) or 'N' (service has not been performed or non-merchandise cost is not a service cost).

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:DSRcptDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
trans_date	*	*	*	*
item	*	*	*	*
store	*	*	*	The store number which is requesting the inventory.
units	*	*	*	*
unit_cost	*	*	*	Unit cost associated with an item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:FrtTermDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
term_desc	freight_terms	term_desc	Yes	Contains a description of the freight terms used in the system.
enabled_flag	freight_terms	enabled_flag	No	Indicates whether the freight terms are valid or invalid within the respective application. Valid values are 'Y'es or 'N'o. NOTE: if interface is from Oracle Financials, the Check_Enabled logic will be bypassed which means field would not be required.
start_date_active	freight_terms	start_date_active	No	Indicates the date for assigning an active date to the Freight Terms.
end_date_active	freight_terms	end_date_active	No	Indicates the date for assigning an inactive date to the Freight Terms.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:GLCOADesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
primary_account	fif_gl_acct	primary_account	Yes	This denotes the primary account for a chart of accounts.
attribute1	fif_gl_acct	attribute1	No	Secondary Account information. A value is required if description1 is supplied.
attribute2	fif_gl_acct	attribute2	No	Secondary Account information. A value is required if description2 is supplied.
attribute3	fif_gl_acct	attribute3	No	Secondary Account information. A value is required if description3 is supplied.
attribute4	fif_gl_acct	attribute4	No	Secondary Account information. A value is required if description4 is supplied.
attribute5	fif_gl_acct	attribute5	No	Secondary Account information. A value is required if description5 is supplied.
attribute6	fif_gl_acct	attribute6	No	Secondary Account information. A value is required if description6 is supplied.
attribute7	fif_gl_acct	attribute7	No	Secondary Account information. A value is required if description7 is supplied.
attribute8	fif_gl_acct	attribute8	No	Secondary Account information. A value is required if description8 is supplied.
attribute9	fif_gl_acct	attribute9	No	Secondary Account information. A value is required if description9 is supplied.
attribute10	fif_gl_acct	attribute10	No	Secondary Account information. A value is required if description10 is supplied.
attribute11	fif_gl_acct	attribute11	No	Secondary Account information. A value is required if description11 is supplied.
attribute12	fif_gl_acct	attribute12	No	Secondary Account information. A value is required if description12 is supplied.
attribute13	fif_gl_acct	attribute13	No	Secondary Account information. A value is required if description13 is supplied.
attribute14	fif_gl_acct	attribute14	No	Secondary Account information. A value is required if description14 is supplied.
attribute15	fif_gl_acct	attribute15	No	Secondary Account information. A value is required if description15 is supplied.
description1	fif_gl_acct	description1	No	Description of the attribute1 field. Required if attribute1 supplied and you are not using Oracle Financials 11.5.10 or greater.
description2	fif_gl_acct	description2	No	Description of the attribute2 field. Required if attribute2 supplied and you are not using Oracle Financials 11.5.10 or greater.
description3	fif_gl_acct	description3	No	Description of the attribute3 field. Required if attribute3 supplied and you are not using Oracle Financials 11.5.10 or greater.
description4	fif_gl_acct	description4	No	Description of the attribute4 field. Required if attribute4 supplied and you are not using Oracle Financials 11.5.10 or greater.
description5	fif_gl_acct	description5	No	Description of the attribute5 field. Required if attribute5 supplied and you are not using Oracle Financials 11.5.10 or greater.
description6	fif_gl_acct	description6	No	Description of the attribute6 field. Required if attribute6 supplied and you are not using Oracle Financials 11.5.10 or greater.
description7	fif_gl_acct	description7	No	Description of the attribute7 field. Required if attribute7 supplied and you are not using Oracle Financials 11.5.10 or greater.
description8	fif_gl_acct	description8	No	Description of the attribute8 field. Required if attribute8 supplied and you are not using Oracle Financials 11.5.10 or greater.
description9	fif_gl_acct	description9	No	Description of the attribute9 field. Required if attribute9 supplied and you are not using Oracle Financials 11.5.10 or greater.
description10	fif_gl_acct	description10	No	Description of the attribute10 field. Required if attribute10 supplied and you are not using Oracle Financials 11.5.10 or greater.
description11	fif_gl_acct	description11	No	Description of the attribute11 field. Required if attribute11 supplied and you are not using Oracle Financials 11.5.10 or greater.
description12	fif_gl_acct	description12	No	Description of the attribute12 field. Required if attribute12 supplied and you are not using Oracle Financials 11.5.10 or greater.
description13	fif_gl_acct	description13	No	Description of the attribute13 field. Required if attribute13 supplied and you are not using Oracle Financials 11.5.10 or greater.
description14	fif_gl_acct	description14	No	Description of the attribute14 field. Required if attribute14 supplied and you are not using Oracle Financials 11.5.10 or greater
description15	fif_gl_acct	description15	No	Description of the attribute15 field. Required if attribute15 supplied and you are not using Oracle Financials 11.5.10 or greater.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:InvAdjustDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	inv_adj	location	Yes	Contains the location where the inventory adjustment occurred.
InvAdjustDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:InvAdjustDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	inv_adj	item_id	Yes	Unique identifier for the item.
adjustment_reason_code	inv_adj	reason	No	Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types.
unit_qty	inv_adj	adj_qty	Yes	Contains the quantity the inventory was adjusted by.
transshipment_nbr	n/a	n/a	No	Not used by RMS.
from_disposition	inv_status_codes	inv_status_code	No	Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive.
to_disposition	inv_status_codes	inv_status_code	No	Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive.
from_trouble_code	n/a	n/a	No	Not used by RMS.
to_trouble_code	n/a	n/a	No	Not used by RMS.
from_wip_code	n/a	n/a	No	Not used by RMS.
to_wip_code	n/a	n/a	No	Not used by RMS.
transaction_code	n/a	n/a	No	Not used by RMS.
user_id	inv_adj	user_id	Yes	Contains the user id for the user making the inventory adjustment.
create_date	inv_adj	adj_date	Yes	Contains the date on which the inventory adjustment occurred.
po_nbr	ordhead, tsfhead	order_no, tsf_no	No	Either a PO or transfer associated to the inventory adjustment based on the doc_type.
doc_type	n/a	n/a	No	Indicates if the document is a Purchase Order (P) or a Transfer (T).
aux_reason_code	n/a	n/a	No	Not used by RMS.
weight	n/a	n/a	No	Actual weight of the inventory that was adjusted.
weight_uom	n/a	n/a	No	Unit of measure for weight (e.g. pounds, kilograms)

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:InvReqDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
request_id	n/a	n/a	Yes	Not used by RMS.
store	store_orders	store	Yes	The store ID which is requesting the item.
request_type	n/a	n/a	Yes	Defines the request type. Valid values are - 'IR' (inventory request) and 'SO' (store order).
InvReqItem	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:InvReqItem

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	store_orders	item	Yes	Unique alphanumeric value that identifies the item to be requested.
qty_rqst	store_orders	need_qty	Yes	The quantity for the item being requested. This field is stored in the standard unit of measure.
uop	uom_class	uom	Yes	Unit of Purchase - used for conversion, since NEED_QTY is being stored in the standard unit of measure.
need_date	store_orders	need_date	Yes	The date that the store needs the item by.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ISCDimRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country_dim	item	Yes	Unique identifier for the item.
supplier	item_supp_country_dim	supplier	Yes	Unique identifier for the supplier.
origin_country	item_supp_country_dim	origin_country	Yes	The country where the item was manufactured or significantly altered
dim_object	item_supp_country_dim	dim_object	Yes	Specific object whose dimensions are specified in this record.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ISCDimWHRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
itemid	*	*	*	*
from_location	*	*	*	*
to_location	*	*	*	*
vendornbr	*	*	*	*
origincountryid	*	*	*	*
dimobject	*	*	*	*

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemBOMRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
pack_no	packitem_breakout	pack_no	Yes	Unique identifier for the pack item.
item	packitem_breakout	item	Yes	Unique identifier for the component item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

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 Management System

Version 13.0.0

XML-Schema or Node Name:ItemHdrDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item	Yes	Unique alphanumeric value that identifies the item.
item_number_type	item_master	item_number_type	Yes	Code specifying what type the item is. Valid values for this field are in the code type 'UPCT' on the code_head and code_detail tables.
format_id	item_master	format_id	No	This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs.
prefix	item_master	prefix	No	This column holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their
item_parent	item_master	item_parent	No	Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.
item_grandparent	item_master	item_grandparent	No	Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table.
pack_ind	item_master	pack_ind	Yes	Indicates if the item is a pack. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database.
item_level	item_master	item_level	Yes	Number indicating which of the three levels the item resides. The item level determines if the item stands alone or if it is part of a family of related items. The item level also determines how the item may be used throughout the system.
tran_level	item_master	tran_level	Yes	Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item will be counted, transferred, shipped, etc. The transaction level may be at the current item or up to 2 levels above or below the current item. Only one level of the hierarchy of an item family may contain transaction level items.
diff_1	item_master	diff_1	No	Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Men's pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables.
diff_1_type	diff_ids	diff_type	No	This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table.
diff_2	item_master	diff_2	No	Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables.
diff_2_type	diff_ids	diff_type	No	This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table.
diff_3	item_master	diff_3	No	Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables.
diff_3_type	diff_ids	diff_type	No	This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table.
diff_4	item_master	diff_4	No	Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.). Valid values are found on the diff_group and diff_id tables.
diff_4_type	diff_ids	diff_type	No	This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table.
dept	item_master	dept	No	Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table.
dept_name	deps	dept_name	Yes	Contains the name of the department.
class	item_master	class	Yes	Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table.
class_name	class	class_name	Yes	Contains the name of the class.
subclass	item_master	subclass	Yes	Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table.
sub_name	subclass	sub_name	Yes	Contains the name of the subclass.
status	item_master	status	Yes	Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system.
item_desc	item_master	item_desc	Yes	Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null.
short_desc	item_master	short_desc	Yes	Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null.
desc_up	item_master	desc_up	Yes	All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system.
primary_ref_item_ind	item_master	primary_ref_item_ind	No	Indicates if the sub-transation level item is designated as the primary sub-transaction level item. For transaction level items and above the value in this field will be 'N'o.
retail_zone_group_id	item_master	retail_zone_group_id	No	Retail pricing strategy associated with the item.
cost_zone_group_id	item_master	cost_zone_group_id	No	Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table.
standard_uom	item_master	standard_uom	Yes	Unit of measure in which stock of the item is tracked at a corporate level.
uom_conv_factor	item_master	uom_conv_factor	No	Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure.
package_size	item_master	package_size	No	Holds the size of the product printed on any packaging (i.e. 24 ounces). This field is used for reporting purposes, as well as by Retek Price Mangement to determine same sized and different sized items.
package_uom	item_master	package_uom	No	Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Retek Price Management to determine same sized and different sized items.
merchandise_ind	item_master	merchandise_ind	Yes	Indicates if the item is a merchandise item (Y, N).
store_ord_mult	item_master	store_ord_mult	Yes	Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches.
forecast_ind	item_master	forecast_ind	Yes	Indicates if this item will be interfaced to an external forecasting system (Y, N).
mfg_rec_retail	item_master	mfg_rec_retail	No	Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency.
retail_label_type	item_master	retail_label_type	No	This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail.
retail_label_type_desc	code_detail	code_desc	No	Contains the retail label type description corresponding to the retail_label_type value in item_master.
retail_label_value	item_master	retail_label_value	No	This field represents the value associated with the retail label type.
handling_temp	item_master	handling_temp	No	Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables.
handling_temp_desc	code_detail	code_desc	No	Contains the Handling temperature description corresponding to the handling_temp value in item_master.
handling_sensitivity	item_master	handling_sensitivity	No	Holds the sensitivity information associated with the item. Valid values for this field are in the code type 'HSEN' on the code_head and code_detail tables.
handling_sensitivity_desc	code_detail	code_desc	No	Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master.
catch_weight_ind	item_master	catch_weight_ind	Yes	Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'.
waste_type	item_master	waste_type	No	Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales.
waste_type_desc	code_detail	code_desc	No	Contains the Waste Type description corresponding to the Waste_Type value in item_master.
waste_pct	item_master	waste_pct	No	Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items.
default_waste_pct	item_master	default_waste_pct	No	Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis.
const_dimen_ind	item_master	const_dimen_ind	Yes	Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country.
simple_pack_ind	item_master	simple_pack_ind	Yes	Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack.
contains_inner_ind	item_master	contains_inner_ind	Yes	Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs.
sellable_ind	item_master	sellable_ind	Yes	Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit.
orderable_ind	item_master	orderable_ind	Yes	Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered.
pack_type	item_master	pack_type	No	Indicates if pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack communication with the supplier will explode the pack out to its component items. This field will only be available if the item is a pack item. If the pack item is not orderable this field must be null. Valid values are: V = Vendor; B = Buyer.
order_as_type	item_master	order_as_type	No	Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid Values are: E = Eaches (component level) P = Pack (buyer pack only).
comments	item_master	comments	No	Holds any comments associated with the item.
unit_retail	item_zone_price	unit_retail	No	This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency.
item_service_level	item_master	item_service_level	No	Holds a value that restricts the type of shipment methods that RCOM can select for an item.
gift_wrap_ind	item_master	gift_wrap_ind	Yes	This field will contain a value of 'Y' if the item is eligible to be gift wrapped.
ship_alone_ind	item_master	ship_alone_ind	Yes	This field will contain a value of 'Y' if the item should be shipped to the customer is a seperate package versus being grouped together in a box.
vendor_style	n/a	n/a	No	Not used by RMS.
std_unit_weight	n/a	n/a	No	Not used by RMS.
single_price_flag	n/a	n/a	No	Not used by RMS.
preticket_flag	n/a	n/a	No	Not used by RMS.
planned_residual	n/a	n/a	No	Not used by RMS.
autopackable	n/a	n/a	No	Not used by RMS.
sortable	n/a	n/a	No	Not used by RMS.
item_master_uda1	n/a	n/a	No	Not used by RMS.
item_master_uda2	n/a	n/a	No	Not used by RMS.
item_master_uda3	n/a	n/a	No	Not used by RMS.
item_master_uda4	n/a	n/a	No	Not used by RMS.
item_master_uda5	n/a	n/a	No	Not used by RMS.
item_master_uda6	n/a	n/a	No	Not used by RMS.
item_master_uda7	n/a	n/a	No	Not used by RMS.
item_master_uda8	n/a	n/a	No	Not used by RMS.
item_master_uda9	n/a	n/a	No	Not used by RMS.
item_master_uda10	n/a	n/a	No	Not used by RMS.
item_master_uda11	n/a	n/a	No	Not used by RMS.
item_master_uda12	n/a	n/a	No	Not used by RMS.
item_master_uda13	n/a	n/a	No	Not used by RMS.
item_master_uda14	n/a	n/a	No	Not used by RMS.
item_master_uda15	n/a	n/a	No	Not used by RMS.
ship_alone	n/a	n/a	No	Not used by RMS.
slottable	n/a	n/a	No	Not used by RMS.
freight_class	n/a	n/a	No	Not used by RMS.
new_item	n/a	n/a	No	Not used by RMS.
brand	n/a	n/a	No	Not used by RMS.
break_case_ups	n/a	n/a	No	Not used by RMS.
rigid	n/a	n/a	No	Not used by RMS.
fragile	n/a	n/a	No	Not used by RMS.
container_type	n/a	n/a	No	Not used by RMS.
conveyable_flag	n/a	n/a	No	Not used by RMS.
hazard_matl_code	n/a	n/a	No	Not used by RMS.
velocity	n/a	n/a	No	Not used by RMS.
high_value_ind	n/a	n/a	No	Not used by RMS.
ticket_type	n/a	n/a	No	Not used by RMS.
color	n/a	n/a	No	Not used by RMS.
size1	n/a	n/a	No	Not used by RMS.
fit	n/a	n/a	No	Not used by RMS.
shade	n/a	n/a	No	Not used by RMS.
single_contain_bulk	n/a	n/a	No	Not used by RMS.
unit_pick_system_code	n/a	n/a	No	Not used by RMS.
roundable_flag	n/a	n/a	No	Not used by RMS.
perishable_ind	n/a	n/a	No	Not used by RMS.
division	n/a	n/a	No	Not used by RMS.
vendor_nbr	n/a	n/a	No	Not used by RMS.
kitting_wip_code	n/a	n/a	No	Wip code used to designate the Kitting process used in item_master
unit_ticket_qty	n/a	n/a	No	Item Master User Defined Attribute
item_length	n/a	n/a	No	Length of an individual item
item_width	n/a	n/a	No	Width of an individual item
item_height	n/a	n/a	No	Height of an individual Item
item_weight	n/a	n/a	No	Weight of an individual item
item_cube	n/a	n/a	No	Cubic dimension of an individual item
std_unit_factor	n/a	n/a	No	Used for putaway by volume. The percentage of the standard number of units that will fit into a location type.
std_unit_qty	n/a	n/a	No	The number of items that normally fit on/in the container type
expiration_days	n/a	n/a	No	The number of days before inventory is deemed to be no longer distributable
putaway_by_volume	n/a	n/a	No	If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity.
putaway_plan	n/a	n/a	No	Plan used for putaway
item_type	n/a	n/a	No	This column contains a character indicator to determine if the item being ordered is a pack or not.
sorter_group	n/a	n/a	No	Sorter Group identifier
sku_optimization	n/a	n/a	No	Indicator for inclusion in SKU optimization
ext_source_system	n/a	n/a	No	Specifies what external system the data originated from.
item_xform_ind	n/a	n/a	No	Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process.
inventory_ind	n/a	n/a	No	Inventory Indicator
order_type	n/a	n/a	No	Indicates the type of order and which Open To Buy bucket will be updated.
sale_type	n/a	n/a	No	n/a
deposit_item_type	n/a	n/a	No	n/a
container_item	n/a	n/a	No	n/a
deposit_in_price_per_uom	n/a	n/a	No	n/a
transport_ind	n/a	n/a	No	n/a

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemSupDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_supplier	item	Yes	Unique identifier for the item.
supplier	item_supplier	supplier	Yes	Unique identifier for the supplier.
primary_supp_ind	item_supplier	primary_supp_ind	Yes	This field indicates whether this supplier is the primary supplier for the item. An item can have one and only one primary supplier.
vpn	item_supplier	vpn	No	This field contains the Vendor Product Number for the Item.
supp_label	item_supplier	supp_label	No	This field contains the supplier label. It will only be popluated if item is a style.
consignment_rate	item_supplier	consignment_rate	No	This field contains the consignment rate for this item for the supplier.
supp_diff_1	item_supplier	supp_diff_1	No	This field contains the first supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
supp_diff_2	item_supplier	supp_diff_2	No	This field contains the second supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
supp_diff_3	item_supplier	supp_diff_3	No	This field contains the third supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
supp_diff_4	item_supplier	supp_diff_4	No	This field contains the fourth supplier differentiator and/or description. This field may only contain a value for items with an item_parent.
pallet_name	item_supplier	pallet_name	Yes	Code referencing the name used to refer to the pallet.
case_name	item_supplier	case_name	Yes	Code referencing the name used to refer to the case.
inner_name	item_supplier	inner_name	Yes	Code referencing the name used to refer to the inner.
supp_discontinue_date	item_supplier	supp_discontinue_date	No	Date when the supplier discontinues an item.
direct_ship_ind	item_supplier	direct_ship_ind	Yes	A value of 'Y'es in this field indicates that any item associated with this supplier is eligible for a direct shipment from the supplier to the customer.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemSupCtyDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country	item	Yes	Unique identifier for the item.
supplier	item_supp_country	supplier	Yes	Unique identifier for the supplier.
origin_country_id	item_supp_country	origin_country_id	Yes	The country where the item was manufactured or significantly altered.
primary_supp_ind	item_supp_country	primary_supp_ind	Yes	This field indicates whether this supplier is the primary supplier for the item. Each item can have one and only one primary supplier.
primary_country_ind	item_supp_country	primary_country_ind	Yes	This field indicates whether this country is the primary country for the item/supplier. Each item/supplier combination can have one and only one primary country.
unit_cost	item_supp_country	unit_cost	Yes	This field contains the current corporate unit cost for the item from the supplier /origin country. This field is stored in the Supplier's currency.
lead_time	item_supp_country	lead_time	No	This field contains the number of days that will elapse between the date an order is written and the delivery to the store or warehouse from the supplier.
pickup_lead_time	item_supp_country	pickup_lead_time	No	Contains the time that will be taken to get the item from the supplier to the initial receiving location.
supp_pack_size	item_supp_country	supp_pack_size	Yes	This field contains the quantity that orders must be placed in multiples of for the supplier for the item.
inner_pack_size	item_supp_country	inner_pack_size	Yes	This field contains the break pack size for this item from the supplier.
round_lvl	item_supp_country	round_lvl	Yes	This column is used to determine how order quantities will be rounded to case, layer and pallet.
min_order_qty	item_supp_country	min_order_qty	No	This field contains the minimum quantity that can be ordered at one from the supplier for the item.
max_order_qty	item_supp_country	max_order_qty	No	This field contains the maximum quantity that can be ordered at one from the supplier for the item.
packing_method	item_supp_country	packing_method	No	This field indicates whether the packing method for the item in the container is flat or hanging.
default_uop	item_supp_country	default_uop	No	Contains the default unit of purchase for the item/supplier/country. Valid values include 'C'ase and 'P'allet.
ti	item_supp_country	ti	Yes	Number of shipping units (cases) that make up one tier of the pallet. Multiply TI x HI to get total number of units (cases) in a Pallet.
hi	item_supp_country	hi	Yes	Number of tiers that make up a complete pallet. Multiply TI x HI to get total number of units (cases) in a Pallet.
cost_uom	item_supp_country	cost_uom	Yes	A cost UOM is held to allow costs to be managed in a separate UOM to the standard UOM.
tolerance_type	item_supp_country	tolerance_type	No	The unit of tolerance for catch weight simple packs. Valid values are: 'A'-actual 'P' - percent.
max_tolerance	item_supp_country	max_tolerance	No	The maximum tolerance value for the catch weight simple pack.
min_tolerance	item_supp_country	min_tolerance	No	The minimum tolerance value for a catch weight simple pack

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ISCDimDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country_dim	item	Yes	Unique identifier for the item.
supplier	item_supp_country_dim	supplier	Yes	Unique identifier for the supplier.
origin_country	item_supp_country_dim	origin_country	Yes	The country where the item was manufactured or significantly altered.
dim_object	item_supp_country_dim	dim_object	Yes	Specific object whose dimensions are specified in this record.
object_desc	code_detail	code_desc/object_desc	No	Dim_object description fetched from the code_detail table.
presentation_method	item_supp_country_dim	presentation_method	No	Describes the packaging (if any) being taken into consideration in the specified dimensions.
method_desc	code_detail	code_desc/method_desc	No	Presentation method description fetched from the code_detail table.
length	item_supp_country_dim	length	No	Length of dim_object measured in units specified in lwh_uom.
width	item_supp_country_dim	width	No	Width of dim_object measured in units specified in lwh_uom.
height	item_supp_country_dim	height	No	Height of dim_object measured in units specified in lwh_uom.
lwh_uom	item_supp_country_dim	lwh_uom	No	Unit of measurement for length, width and height.
weight	item_supp_country_dim	weight	No	Weight of dim_object measured in units specified in weight_uom.
net_weight	item_supp_country_dim	net_weight	No	Net weight of the dim_object (weight without packaging) measured in units specified in weight_uom.
weight_uom	item_supp_country_dim	weight_uom	No	Unit of measurement for weight.
liquid_volume	item_supp_country_dim	liquid_volume	No	Liquid volume, or capacity, of dim_object measured in units specified in colume_uom. Liquid volumes are only convertible to other liquid volumes.
liquid_volume_uom	item_supp_country_dim	liquid_volume_uom	No	Unit of measurement for liquid volume. Liquid volumes are only convertible to other liquid volumes.
stat_cube	item_supp_country_dim	stat_cube	No	Statistical value of the dim_object's dimensions to be used for loading purposes.
tare_weight	item_supp_country_dim	tare_weight	No	Amount of weight to be subtracted for packaging materials. Used to calculate the true net weight of the dim_object.
tare_type	item_supp_country_dim	tare_type	No	Indicates whether the tare weight for the dim_object is wet or dry.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDALOVDesc

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_lov	item	Yes	Item ID
uda_id	uda_item_lov	uda_id	Yes	This field contains the unique identified of the Attribute Group being added or delete to the item list.
uda_value	uda_item_lov	uda_value	Yes	Contains the value of the Attribute Group.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDAFFDesc

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_ff	item	Yes	Unique identifier for the item.
uda_id	uda_item_ff	uda_id	Yes	This field contains a number identifying the user-defined attribute.
uda_text	uda_item_ff	uda_text	No	This field contains the text value of the user-defined attribute for the item.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDADateDesc

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_date	item	Yes	Unique identifier for the item.
uda_id	uda_item_date	uda_id	Yes	This field contains a number identifying the user-defined attribute.
uda_date	uda_item_date	uda_date	Yes	This field contains the effective date for the Uda id.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemImageDesc

Tag Name	Table Name	Column Name	API Req	Description
item	item_image	item	Yes	Unique identifier for the item.
image_name	item_image	image_name	Yes	Name of the image.
image_addr	item_image	image_addr	Yes	Path where the image file is stored.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUPCDesc

Tag Name	Table Name	Column Name	API Req	Description
item_id	item_master	item_id	Yes	Unique identifier for the item.
item_parent	item_master	item_parent	No	Unique identifier for the item/group at the level above the item.
primary_ref_item_ind	item_master	primary_ref_item_ind	No	Indicates if the sub-transaction level item is designated as the primary sub-transaction level item. For transaction level items and above, the value in this field will be 'N'o.
format_id	item_master	format_id	No	This field will hold the format id that corresponds to the item's variable UPC. This value is only used for items with variable UPCs.
prefix	item_master	prefix	No	This field holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS.
item_number_type	item_master	item_number_type	No	Code specifying what type the item is.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemBOMDesc

Tag Name	Table Name	Column Name	API Req	Description
pack_no	packitem_breakout	pack_no	Yes	Unique identifier for the pack item.
item	packitem_breakout	item	Yes	Unique identifier for the component item.
pack_qty	packitem_breakout	pack_item_qty	Yes	Contains the quantity of each item in the pack item.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemTcktDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_ticket	item	Yes	Unique identifier for the item.
ticket_type_id	item_ticket	ticket_type_id	Yes	This field uniquely identifies the ticket type which is associated with the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemImageRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_image	item	Yes	Unique identifier for the item.
image_name	item_image	image_name	Yes	Name of the image.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemListDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
skulist	skulist_head	skulist	Yes	Contains the number which uniquely identifies the SKU list.
skulist_desc	skulist_head	skulist_desc	Yes	Contains the description which corresponds to the SKU list number.
create_date	skulist_head	create_date	No	This field contains the date that the item list was created.
create_id	skulist_head	create_id	No	This field contains the Oracle user ID of the user that created the item list.
static_ind	skulist_head	static_ind	No	This field indicates whether the item is to be kept static, i.e. whether or not the item list can ever be changed. Valid values are Y and N.
last_rebuild_date	skulist_head	last_rebuild_date	No	This field contains the date that the item list was last rebuilt. An item list can only be rebuild if it is a dynamic item list (i.e. STATIC_IND = 'N').
tax_prod_group_ind	skulist_head	tax_prod_group_ind	No	This field will identify if the item list is of type 'Tax Product Group' ('Y') or 'Basic' ('N').
comment_desc	skulist_head	comment_desc	No	Contains comments about the SKU list.
ItemListDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemListDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	skulist_detail	item	Yes	Identifier of item included in item list.
item_level	skulist_detail	item_level	Yes	Indicates on which of the three levels the item resides.
tran_level	skulist_detail	tran_level	Yes	Indicates the level on which transactions are done.
pack_ind	skulist_detail	pack_ind	Yes	Indicates if the item is a pack item.
system_ind	n/a	*	Yes	Indicates what type of item this message is for. Used by RMS 9.
insert_id	skulist_detail	insert_id	No	This field will hold the username of the individual who added the item to the itemlist. This field is updated when the item is initially added to the itemlist or when the itemlist is rebuilt.
insert_date	skulist_detail	insert_date	No	This field will hold the date the item was added to the item list. This field is updated when the item is initially added to the itemlist or when the itemlist is rebuilt.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemListRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
skulist	skulist_head	skulist	Yes	Contains the number which uniquely identifies the SKU list.
ItemListDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemListDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	skulist_detail	item	Yes	Identifier of item included in item list.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemLocDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_loc	item	Yes	Unique identifier for the item.
ItemLocPhys	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemLocPhys

Tag Name	Table Name	Column Name	API Req	Description
physical_loc	wh, item_loc	physical_wh, loc	Yes	If the loc_type is 'W', this is the physical warehouse that is assigned to the virtual wh where the item is located. If the loc_type is an 'S' then this is the store where the item is located.
ItemLocVirt	*	*	*	*
ItemLocVirtRepl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemLocVirt

Tag Name	Table Name	Column Name	API Req	Description
loc	item_loc	loc	Yes	Location where the item is to be found. This field may contain a store or a warehouse.
loc_type	item_loc	loc_type	Yes	Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse).
local_item_desc	item_loc	local_item_desc	Yes	Contains the local description of the item.
local_short_desc	item_loc	local_short_desc	No	Contains the local short description of the item.
status	item_loc	status	Yes	Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted).
primary_supp	item_loc	primary_supp	No	Primary supplier for the item/location.
primary_cntry	item_loc	primary_cntry	No	Contains the origin country which will be considered the primary country for the item/location.
receive_as_type	item_loc	receive_as_type	No	Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack.
taxable_ind	item_loc	taxable_ind	Yes	Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No).
source_method	item_loc	source_method	No	Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'.
source_wh	item_loc	source_wh	No	If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store.
unit_retail	item_loc	unit_retail	No	Unit retail of the item in the selling Unit of Measure. Only published for create not modify.
selling_unit_retail	item_loc	selling_unit_retail	No	Selling unit retail in selling unit of measure. Only published for create, not update
selling_uom	item_loc	selling_uom	No	Selling Unit of measure. Only published for Create not update.
store_price_ind	item_loc	store_price_ind	Yes	Indicates if the location can modify the item's price

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemLocVirtRepl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
loc	repl_item_loc	location	Yes	Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment.
loc_type	repl_item_loc	loc_type	Yes	Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse.
primary_repl_supplier	repl_item_loc	primary_repl_supplier	No	Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment.
repl_method	repl_item_loc	repl_method	Yes	Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders.
reject_store_order_ind	repl_item_loc	reject_store_ord_ind	No	Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid."
next_delivery_date	repl_item_loc	next_delivery_date	No	Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemLocRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_loc	item	Yes	Unique identifier for the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item	Yes	Unique identifier for the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemSupCtyRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country	item	Yes	Unique identifier for the item.
supplier	item_supp_country	supplier	Yes	Unique identifier for the supplier.
origin_country_id	item_supp_country	origin_country_id	Yes	The country where the item was manufactured or significantly altered.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemSupRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_supplier	item	Yes	Unique identifier for the item.
supplier	item_supplier	supplier	Yes	Unique identifier for the supplier.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemTcktRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	item_ticket	item	Yes	Unique identifier for the item.
ticket_type_id	item_ticket	ticket_type_id	Yes	This field uniquely identifies the ticket type which is associated with the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDADateRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_date	item	Yes	Unique identifier for the item.
uda_id	uda_item_date	uda_id	Yes	This field contains a unique number identifying the user-defined attribute.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDAFFRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_ff	item	Yes	Unique identifier for the item.
uda_id	uda_item_ff	uda_id	Yes	This field contains a number identifying the user-defined attribute.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUDALOVRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	uda_item_lov	item	Yes	Unique identifier for the item.
uda_id	uda_item_lov	uda_id	Yes	This field contains a number identifying the user-defined attribute.
uda_value	uda_item_lov	uda_value	Yes	This field contains value of the user-defined attribute for the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemUPCRef.xsd

RIB Mappings Report Release: 13.0.0

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

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZonePrcDesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZoneGrp

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	item_zone_price	zone_group_id	Yes	Contains the zone group in which the item is contained.
item	item_zone_price	item	Yes	Alphanumeric value that identifies the item.
ItemZone	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZone

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
zone_id	item_zone_price	zone_id	Yes	The zone in which the item is contained.
unit_retail	item_zone_price	unit_retail	Yes	Holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency.
selling_unit_retail	item_zone_price	selling_unit_retail	Yes	Holds the unit retail in the selling unit of measure for the item/zone combination. This field is stored in the local currency.
selling_uom	item_zone_price	selling_uom	Yes	Holds the selling unit of measure for an item's single-unit retail.
multi_units	item_zone_price	multi_units	Yes	Contains the multi-units for the item/zone combination.
multi_unit_retail	item_zone_price	multi_unit_retail	Yes	Holds the multi-unit retail in the multi selling unit of measure for the item/zone combination. This field is stored in the local currency.
multi_selling_uom	item_zone_price	multi_selling_uom	Yes	Holds the selling unit of measure for an item's multi-unit retail.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZonePrcRef.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZoneGrpRef

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id	item_zone_price	zone_group_id	Yes	Contains the zone group in which the item is contained.
item	item_zone_price	item	Yes	Alphanumeric value that identifies the item.
ItemZoneRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ItemZoneRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
zone_id	item_zone_price	zone_id	Yes	The zone in which the item is contained.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocationDesc.xsd

RIB Mappings Report Release: 13.0.0

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

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocationRef.xsd

RIB Mappings Report Release: 13.0.0

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

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocListDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
loc_list	loc_list_head	loc_list	Yes	Contains a number to uniquely identify a location list.
loc_list_desc	loc_list_head	loc_list_desc	Yes	Contains the description of the location list.
create_date	loc_list_head	create_date	Yes	Contains the date that the location list was created.
create_id	loc_list_head	create_id	Yes	Contains the Oracle user ID of the user that created the location list.
static_ind	loc_list_head	static_ind	Yes	Indicates whether the location list is static or dynamic. A dynamic list can be rebuilt. Valid values are Y and N.
batch_rebuild_ind	loc_list_head	batch_rebuild_ind	Yes	Indicates whether the location list is to be rebuilt in the nightly batch process. Valid values are Y and N.
last_rebuild_date	loc_list_head	last_rebuild_date	Yes	Contains the date that the location list was last rebuilt. A location list can only be rebuilt if the static_ind is N.
source	loc_list_head	source	Yes	Indicates how the location list was generated. Valid values for this field are: RMS, RDF, RDW.
external_ref_no	loc_list_head	external_ref_no	No	Contains the external reference number for the location list populated by sources like RDF and RDW.
comment_desc	loc_list_head	comment_desc	No	Contains comments about the location list.
LocListDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocListDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location	loc_list_detail	location	Yes	Identifies the location that is on the location list. The location can be either a store or warehouse.
loc_type	loc_list_detail	loc_type	Yes	Contains the location type of the location included in the location list. Valid values are: 'S'tore, 'W'arehouse.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocListRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
loc_list	loc_list_head	loc_list	Yes	Contains a number to uniquely identify a location list.
LocListDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:LocListDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location	loc_list_detail	location	Yes	Identifies the location that is on the location list. The location can be either a store or warehouse.
loc_type	loc_list_detail	loc_type	Yes	Contains the location type of the location included in the location list. Valid values are: 'S'tore, 'W'arehouse.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrClsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
class	class	class	Yes	Contains the number which uniquely identifies the class within the system.
class_name	class	class_name	Yes	Contains the name of the class which, along with the class number, identifies the class.
class_vat_ind	class	class_vat_ind	No	This field determines if retail is displayed and held with or with out vat. This field is only editable when vat is turned on in the system and defined at the class level, when that is the case the field can vary between 'Y' and 'N' by class. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'.
dept	class	dept	Yes	Contains the number of the department of which the class is a member.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrClsRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
class	class	class	Yes	Contains the number which uniquely identifies the class within the system.
dept	class	dept	Yes	Contains the number of the department of which the class is a member.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrDeptDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
dept	deps	dept	Yes	Contains the number which uniquely identifies the department.
dept_name	deps	dept_name	Yes	Contains the name of the department.
buyer	deps	buyer	No	Contains the number which uniquely identifies the buyer for that department.
purchase_type	deps	purchase_type	Yes	Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment Stock.
total_market_amt	deps	total_market_amt	No	Contains the total market amount that is expected for the department. The field can be used for analytics or reporting.
merch	deps	merch	No	Contains the number which uniquely describes the merchandiser for that department.
group_no	deps	group_no	Yes	Contains the number of the group in which the department exists.
bud_mkup	deps	bud_mkup	Yes	Contains the Budgeted Markup percentage. This term is synonymous with the term Markup Percent of Cost.
profit_calc_type	deps	profit_calc_type	Yes	Contains a number which indicates whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are:1 = Direct Cost, 2 = Retail Inventory
markup_calc_type	deps	markup_calc_type	Yes	Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, R = Retail
otb_calc_type	deps	otb_calc_type	Yes	Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, R = Retail
max_avg_counter	deps	max_avg_counter	No	A maximum average counter will hold the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is 'Y' (yes) on the system_options table, then this field will be required when maintaining departments online.
avg_tolerance_pct	deps	avg_tolerance_pct	No	A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column
bud_int	deps	bud_int	Yes	Contains the Budgeted Intake percentage. Budgeted Intake is the percent of total take that is income and is synonymous with the term Markup Percent of Retail.
dept_vat_incl_ind	deps	dept_vat_incl_ind	Yes	This indicator will be be used only to default to the class level indicator when classes are initially set up for the department and will only be available when the system level class vat option is on. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrDeptRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
dept	deps	dept	Yes	Contains the number which uniquely identifies the department.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrDivDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
division	division	division	Yes	Contains the number which uniquely identifies the division of the company.
div_name	division	div_name	Yes	Contains the name which, along with the division number, identifies the division of the company.
buyer	division	buyer	No	Contains the number of the buyer associated with the division.
merch	division	merch	No	Contains the number of the merchandiser associated with the division.
total_market_amt	division	total_market_amt	No	Contains the total market amount that is expected for the division. The field can be used for analytics or reporting.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrDivRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
division	division	division	Yes	Contains the number which uniquely identifies the division of the company.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrGrpDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
group_no	groups	group_no	Yes	Contains the number which uniquely identifies the group.
group_name	groups	group_name	Yes	Contains the description which, along with the group number, identifies the group.
buyer	groups	buyer	No	Contains the number of the buyer associated with the group.
merch	groups	merch	No	Contains the number of the merchandiser associated with the group.
division	groups	division	Yes	Contains the number of the division of which the group is a member.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrGrpRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
group_no	groups	group_no	Yes	Contains the number which uniquely identifies the group.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrSclsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
subclass	subclass	subclass	Yes	Contains the number which uniquely identifies the subclass.
subclass_name	subclass	sub_name	Yes	Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass.
class	subclass	class	Yes	Contains the class number of which the subclass is a member.
dept	subclass	dept	Yes	Contains the department number of which the subclass is a member.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:MrchHrSclsRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
subclass	subclass	subclass	Yes	Contains the number which uniquely identifies the subclass.
class	subclass	class	Yes	Contains the class number of which the subclass is a member.
dept	subclass	dept	Yes	Contains the department number of which the subclass is a member.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OrgHierDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_level	n/a	n/a	Yes	The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District
hier_value	chain, area, region, district	chain, area, region, district	Yes	Hierarchy value.
hier_desc	chain, area, region, district	chain_name, area_name, region_name	No	Hierarchy description.
mgr_name	chain, area, region, district	mgr_name	No	Manager name of the hierarchy.
currency_code	chain, area, region, district	currency_code	No	The currency code for the Hierarchy entity.
parent_id	chain, area, region	chain, area, region	No	Contains the number that identifies the Hierarchy level.
parent_level	n/a	n/a	No	Contains the parent level of the current Organizational Hierarchy level. Valid values are; for Area parent - Chain, for Region parent - Area, for District parent - Region.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OrgHierRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_level	n/a	n/a	Yes	The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District
hier_value	chain, area, region, district	chain, area, region, district	Yes	Contains the number which uniquely identifies the hierarchy within the system.
parent_id	chain, area, region	chain, area, region	No	Contains the number that identifies the Hierarchy level above.
parent_level	n/a	n/a	Yes	Contains the parent level of the current Organizational Hierarchy level. Valid values are; for Area parent - Chain, for Region parent - Area, for District parent - Region.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OTBDesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OTB

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
po_nbr	shipment	order_no	Yes	Identifies the unique umber which relates to the goods delivered in the shipment.
dept	otb	dept	Yes	Contains the department number for the Open To Buy budget.
class	otb	class	Yes	Contains the class number for the Open To Buy budget.
subclass	otb	subclass	Yes	Contains the sublass number for the Open To Buy budget.
unit_retail	ordloc	unit_retail	Yes	Contains the current retail price for the SKU at this location. This field is stored int he local currency. This field is only stored on this table for the purpose of calculating Open-To-Buy.
unit_cost	ordloc	unit_cost	Yes	This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.
receipt_qty	ordloc	qty_received	Yes	Contains the number of items already received for the purchase order.
approved_qty	ordloc	qty_ordered	Yes	Contains the number of items ordered for the purchase order.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PartnerDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
partner_type	partner	partner_type	Yes	Specifies the type of the partner.
partner_id	partner	partner_id	Yes	Unique identifying number for a partner within the system.
partner_desc	partner	partner_desc	Yes	Contain the partner's description or name.
currency_code	partner	currency_code	Yes	Contains a code identifying the currency the partner uses for business transactions.
lang	partner	lang	No	The partner's preferred language. This field is provided for custom purchase orders in a specified language
status	partner	status	Yes	Determines if the partner is currently active. Valid values are 'A' = Active or 'I' = Inactive.
contact_name	partner	contact_name	Yes	Contains the name of the partner's representative contract.
contact_phone	partner	contact_phone	Yes	Contains the phone number of the partner's representative contact.
contact_fax	partner	contact_fax	No	Contains the fax number of the partner's representative contact.
contact_telex	partner	contact_telex	No	Contains the telex number of the partner's representative contact.
contact_email	partner	contact_email	No	Contains the e-mail address of the partner's representative contact.
mfg_id	partner	mfg_id	No	Contains the manufacturer's tax identification number. This field is NULL when the Partner Type is Bank ('BK').
principal_country_id	partner	principal_country_id	No	Contains the country id to which the partner is assigned. This field is NULL when the Partner Type is Bank ('BK').
line_of_credit	partner	line_of_credit	No	Contains the line of credit the company has at the Bank in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK').
outstanding_credit	partner	outstanding_credit	No	Contains the total amount of credit that the company has used or has charged against in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK').
open_credit	partner	open_credit	No	Contains the total amount that the company can still charge against in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK').
ytd_credit	partner	ytd_credit	No	Contains the total amount of credit the company has used this year to date in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK').
ytd_drawdowns	partner	ytd_drawdowns	No	Contains the year to date payments the bank has made on behalf of the company in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK').
tax_id	partner	tax_id	No	Contains the unique tax identification number of the partner. This will be used for reporting during the Customs Entry process.
terms	partner	terms	Yes	Payment terms for the partner. These terms specify when payment is due and if any discounts exist for early payment. If populated, they will default on any invoice entered for this partner.
service_perf_req_ind	partner	service_perf_req_ind	Yes	Indicates if the partner's services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that partner. Valid values are 'Y' and 'N'.
invc_pay_loc	partner	invc_pay_loc	No	Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are 'S' (paid at the store) and 'C' (paid centrally).
invc_receive_loc	partner	invc_receive_loc	No	Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are 'S' (received at the store) and 'C' (received centrally).
import_country_id	partner	import_country_id	No	Import country of the Import Authority. This field is not populated for other partner types.
primary_ia_ind	partner	primary_ia_ind	Yes	Indicates if an Import Authority is the primary Import Authority for an import country. This field will always be 'N' for other partner types. There must be one and only one primary Import Authority for each country associated with an Import Authority on the partner table.
AddrDesc	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	Address unique identifier.
addr_type	addr	addr_type	Yes	Indicates the type for the address. Valid values are: 01-business, 02-postal, 03-returns, 04-order, 05-invoice, 06-external finisher
primary_addr_type_ind	addr	primary_addr_type_ind	Yes	The primary address of a particular address type
primary_addr_ind	addr	primary_addr_ind	Yes	Indicates whether the address is the primary address for the address type
add_1	addr	add_1	Yes	Contains the first line of the address
add_2	addr	add_2	No	Contains the second line of the address
add_3	addr	add_3	No	Contains the third line of the address
city	addr	city	Yes	Contains the city address
state	addr	state	Yes	Contains the postal abbreviation for the state of the address.
country_id	addr	country_id	Yes	Contains the country code of the country for the address.
post	addr	post	Yes	Contains the zip code for the address
contact_name	addr	contact_name	No	Contains the name of the contact for the partner at this address
contact_phone	addr	contact_phone	No	Contains the phone number of the contact for the partner at this address.
contact_telex	addr	contact_telex	No	Contains the telex number of the partner or suppliers representative contact.
contact_fax	addr	contact_fax	No	Contains the fax number of the contact for the partner at this address.
contact_email	addr	contact_email	No	Contains the email address of the partner or suppliers representative contact.
oracle_vendor_site_id	addr	oracle_vendor_site_id	No	The unique identifier of the address on the oracle side
county	addr	county	No	Holds the county of the location

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PartnerRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
partner_type	partner	partner_type	Yes	Specifies the type of partner. Valid values are Bank 'BK', Agent 'AG', Freight Forwarder 'FF', Importer 'IM', Broker 'BR', Factory 'FA', Applicant 'AP', Consolidator 'CO', and Consignee 'CN', Supplier hierarchy level 1 'S1', Supplier hierarchy level 2 '
partner_id	partner	partner_id	Yes	Unique identifying number for a partner within the system. The user determines this number when a new partner is first added to the system.
AddrRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	Address Unique Identifier

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PayTermDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
terms	terms_head	terms	Yes	Unique id for this payment term.
terms_code	terms_head	terms_code	Yes	The alpha value which acts as the Term code in Oracle Financials.
terms_desc	terms_head	terms_desc	Yes	Description of the payment terms.
due_days	*	*	No	Not used.
enabled_flag	*	*	No	Not used.
start_date_active	*	*	No	Not used.
end_date_active	*	*	No	Not used.
discdays	*	*	No	Not used.
percent	*	*	No	Not used.
PayTermDtl	*	*	No	Child node.
rank	terms_head	rank	Yes	Unique rank to rate invoice payment terms against PO terms

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PayTermDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
due_days	terms_detail	duedays	Yes	The number of days until payment is due.
due_max_amount	terms_detail	due_max_amount	Yes	Maximum payment amount due by a certain date.
due_dom	terms_detail	due_dom	Yes	Day of month used to calculate due date.
discdays	terms_detail	discdays	Yes	Number of days in which payment must be made to get the discount.
percent	terms_detail	percent	Yes	Percentage used to calculate discount available.
disc_dom	terms_detail	disc_dom	Yes	Day of month used to calculate discount date.
disc_mm_fwd	terms_detail	disc_mm_fwd	Yes	Number of months ahead to calculate discount date.
fixed_date	terms_detail	fixed_date	No	Fixed due date.
enabled_flag	terms_detail	enabled_flag	Yes	Indicates whether the Payment terms are valid or invalid within the respective application. The values would be either (Y)es or (N)o.
start_date_active	terms_detail	start_date_active	No	Start date terms are in effect.
end_date_active	terms_detail	end_date_active	No	End date terms are in effect.
terms_seq	terms_detail	terms_seq	No	Sequence for the discount percent and part of unique identifier for the detail line.
due_mm_fwd	terms_detail	due_mm_fwd	Yes	Number of months ahead to calculate due date.
cutoff_day	terms_detail	cutoff_day	No	Day of month after which the following month will be used for calculations.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PODesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
doc_type	n/a	n/a	Yes	Indicates the type of document this message is for. Valid value is 'P' for purchase order.
order_no	ordhead	order_no	Yes	Contains the number that uniquely identifies an order within the system.
order_type	ordhead	order_type	Yes	Indicates the type of order and which Open To Buy bucket will be updated. Valid values include: 'N/B' - Non Basic 'ARB' - Automatic Reorder of Basic 'BRB' - Buyer Reorder of Basic.
order_type_desc	order_types	order_types_desc	Yes	The description for the given order type.
dept	ordhead	dept	No	Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department.
dept_name	deps	dept_name	No	Contains the name of the department.
buyer	ordhead	buyer	No	Contains the number associated with the buyer for the order.
buyer_name	buyer	buyer_name	No	Contains the name of the authorized buyer.
supplier	ordhead	supplier	Yes	Contains the vendor number who will provide the merchandise specified in the order.
promotion	ordhead	promotion	No	Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog.
prom_desc	rpm_promo	description	Yes	Contains a description of the promotion. This value comes from RPM.
qc_ind	ordhead	qc_ind	Yes	Determines whether or not quality control will be required when items for this order are received. Valid values are 'Y' and 'N'.
not_before_date	ordhead	not_before_date	No	Contains the first date that delivery of the order will be accepted.
not_after_date	ordhead	not_after_date	No	Contains the last date that delivery of the order will be accepted.
otb_eow_date	ordhead	otb_eow_date	No	This field contains the OTB budget bucket the order amount should be placed into.
earliest_ship_date	ordhead	earliest_ship_date	No	The date before which the items on the purchase order can not be shipped by the supplier. Represents the earliest earliest ship date of all the items on the order.
latest_ship_date	ordhead	latest_ship_date	No	The date after which the items on the purchase order can not be shipped by the supplier. Represents the greatest latest ship date of all the items on the order.
close_date	ordhead	close_date	No	Contains the date when the order is closed.
terms	ordhead	terms	Yes	Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment.
terms_code	terms	terms_code	Yes	Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials.
freight_terms	ordhead	freight_terms	No	Indicator that references what freight terms are related to the order.
cust_order	ordhead	cust_order	Yes	This field indicates whether or not the order is generated for a customer.
payment_method	ordhead	payment_method	No	Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).
payment_method_desc	ordhead	payment_method_desc	No	Indicates how the purchase order will be paid. Valid options are 'LC' - Letter of Credit, 'WT' - Wire Transfer, 'OA' - Open Account.
backhaul_type	ordhead	backhaul_type	No	This field contains the type of backhaul allowance that will be applied to the order. Some examples are 'C'alculated or 'F'lat rate
backhaul_type_desc	code_detail	code_desc	No	The description for the given backhaul type.
backhaul_allowance	ordhead	backhaul_allowance	No	This field will contain the backhaul allowance value.
ship_method	ordhead	ship_method	No	The method used to ship the items on the purchase order from the country of origin to the country of import.
ship_method_desc	code_detail	code_desc	No	Contains the description of the given shipping method.
purchase_type	ordhead	purchase_type	No	Indicates what's included in the supplier's cost of the item. Valid values include C (Cost), CI (Cost and Insurance), CIF (Cost, Insurance and Freight), FOB (Free on Board).
purchase_type_desc	code_detail	code_desc	No	Contains the description of the given purchase type.
status	ordhead	status	Yes	Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed
ship_pay_method	ordhead	ship_pay_method	No	Code indicating the payment terms for freight charges associated with the order. Valid values inlude: 'CC' - Collect, 'CF' - Collect Freight Credited Back to Customer, 'DF' - Defined by Buyer and Seller, 'MX' - Mixed, 'PC' - Prepaid but Charged to Customer, 'PO' - Prepaid Only, 'PP' - Prepaid by Seller.
ship_pay_method_desc	code_detail	code_desc	No	Contains the description of the given shipment payment method.
fob_trans_res	ordhead	fob_trans_desc	No	Contains the code indicating the type of the location that is responsible for the transportation of the order.
fob_trans_res_code_desc	code_detail	code_desc	No	Contains the description of the given fob_trans_res_code
fob_trans_res_desc	ordhead	fob_trans_res_desc	No	User entered field describing the code for the location responsible for the transportation of the order.
fob_title_pass	ordhead	fob_title_pass	No	Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples include city, factory, or origin.
fob_title_pass_code_desc	code_detail	code_desc	No	Contains the description of the given fob_title_pass_code.
fob_title_pass_desc	ordhead	fob_title_pass_desc	No	User entered field describing the code where the title of the merchandise is to be passed. Could be a city name, factory name, or place of origin.
vendor_order_no	ordhead	vendor_order_no	No	Contains the vendor's unique identifying number for an order. These orders may have originated by the vendor through the EDI process or this number can be associated to a Retek order when the order is created on-line.
exchange_rate	ordhead	exchange_rate	No	The rate of exchange used for the purchase order between the order and primary currencies.
factory	ordhead	factory	No	The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality.
factory_desc	partner	partner_desc	No	Contains the description of the given factory.
agent	ordhead	agent	No	The agent that is used in the purchase of the items on the purchase order. This field is only available when the system is running Import functionality.
agent_desc	partner	partner_desc	No	Contains the description of the given partner
discharge_port	ordhead	discharge_port	No	The port at which the items on the purchase order will enter the country of import. This field is only available when the system is running Import functionality.
discharge_port_desc	outloc	outloc_desc	No	Contains the description of the given discharge port.
lading_port	ordhead	lading_port	No	The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality.
lading_port_desc	outloc	outloc_desc	No	Contains the description of the given lading port.
bill_to_id	ordhead	bill_to_id	No	Indicates the ID of the bill-to-address, which will be stored on the OUTLOC table under the outloc_type 'BT'.
freight_contract_no	ordhead	freight_contract_no	No	The number of the contract with a shipper that will give specific freight rates. This field is only available when the system is running Import functionality.
po_type	ordhead	po_type	No	Contains the value associated with the PO_TYPE for the order.
po_type_desc	po_type	po_type_desc	No	Contains a description for the specific PO_TYPE
pre_mark_ind	ordhead	pre_mark_ind	Yes	This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores.
currency_code	ordhead	currency_code	Yes	Contains the currency code for the order. When creating an order within Retek, this field will always default to the currency of the supplier, but it can be overwritten.
contract_no	ordhead	contract_no	No	Contains the contract number associated with this order.
pickup_loc	ordhead	pickup_loc	No	Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
pickup_no	ordhead	pickup_no	No	Contains the reference number of the 'Pickup' order.
pickup_date	ordhead	pickup_date	No	Contains the date when the order can be picked up from the Supplier. This field is only required if the Purchase Type of the order is 'Pickup'.
app_datetime	ordhead	app_datetime	No	This column will hold the date and time of the receiving appointment at the warehouse.
comment_desc	ordhead	comment_desc	No	Any miscellaneous comments attached to the purchase order.
PODtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PODtl

Tag Name	Table Name	Column Name	API Req	Description
item	ordloc	item	Yes	Unique alphanumeric value that identifies the item.
ref_item	ordsku	ref_item	No	Unique alphanumeric value that identifies the reference item.
physical_location_type	ordloc	loc_type	Yes	This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse
physical_location	ordloc	location	Yes	This field contains the actual physical location that item will be ordered to. This field may contain a store or a physical warehouse.
physical_qty_ordered	ordloc	qty_ordered	No	Contains the total number of items ordered for the SKU to this location.
unit_cost	ordloc	unit_cost	No	This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.
origin_country_id	ordsku	country_code	No	The identifier of the country into which the items on the order are being imported.
supp_pack_size	ordsku	order_casepack	No	Supplier pack size for this order/item.
earliest_ship_date	ordsku	earliest_ship_date	No	The date before which the item can not be shipped by the supplier.
latest_ship_date	ordsku	latest_ship_date	No	The date after which the item can not be shipped by the supplier.
pickup_loc	ordsku	pickup_loc	No	Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
pickup_no	ordsku	pickup_no	No	Contains the reference number of the 'Pickup' order.
packing_method	item_supp_country	packing_method	No	This field indicates whether the packing method of the item in the container is flat or hanging. Valid values for this field are stored in the 'PKMT' code.
round_lvl	item_supp_country	round_lvl	No	This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
door_ind	n/a	n/a	No	Not used by RMS.
priority_level	n/a	n/a	No	Not used by RMS.
new_item	n/a	n/a	No	Not used by RMS.
quarantine	n/a	n/a	No	Not used by RMS.
rcvd_unit_qty	n/a	n/a	No	Not used by RMS.
tsf_po_link_id	ordloc	tsf_po_link_no	No	A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (ie warehouse) on the transfer to fulfill the transfer quantity to the to location (ie store) on the transfer.
POVirtualDtl	*	*	*	*
cost_source	ordloc	cost_source	No	Indicates the basis for the cost of the Item/Location on the order. Valid values include 'NORM' - Normal Supplier Cost, 'DEAL' - Cost Based on a Deal, 'BRKT' - Cost Based on a Bracket, 'MANL' - User Specified or Manual Override Cost, 'CONT' - Costs retrieved from the Contract, 'ALLW' - Cost Based on an Allowance
est_in_stock_date	ordloc	est_in_stock_date	No	Date that the item on the PO is expected to be available to ship from the PO location to another location.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:POVirtualDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location_type	ordloc	loc_type	Yes	This field contains the type of location in the location field. Valid values are S - Store, W - Warehouse
location	ordloc	location	Yes	This field contains the location all items on the order will be delivered to if populated. (i.e. it will mean a single location order)
qty_ordered	ordloc	qty_ordered	No	Contains the total number of items ordered for the SKU to this location.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PORef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
doc_type	n/a	n/a	Yes	Indicates the type of document this message is for. This field will always have a value of 'P'.
order_no	ordhead	order_no	Yes	Contains the number that uniquely identifies an order within the system.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PrcZoneGrpDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id
PriceZone	*	*	*	*
pricing_level

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PriceZone

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PriceZoneGrpSt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
store

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PrcZoneGrpRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
zone_group_id
PriceZoneRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PriceZoneRef

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:PrcZoneGrpStRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
store

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RcptAdjustDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
bol_nbr	shipment	bol_nbr	Yes	This column will hold the bill of lading number associated with a shipment.
carton	shipsku	carton	No	Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments. This field will be zero for all shipments that are not at a carton level.
from_location	shipment	from_loc	Yes	For transfer and allocation shipments, this field will hold the location from which the shipment was sourced.
to_location	shipment	to_loc	Yes	This field contains the location that the shipment will be delivered to.
receipt_date	shipment	receive_date	No	This field contains the date the stock order is received.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RcvUnitAdjDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
loc	rua_mfqueue	location	Yes	The location where a receiver unit adjustment was performed.
loc_type	rua_mfqueue	loc_type	Yes	The type of location where the receiver unit adjustment was performed. Valid values are 'W' warehouse or 'S' store.
RcvUnitAdjDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RcvUnitAdjDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
po_nbr	rua_mfqueue	order_no	Yes	The order number against which a receiver unit adjustment was performed.
asn_nbr	rua_mfqueue	asn	No	The ASn number associated with the shipment for which a receiver unit adjustment was performed.
item	rua_mfqueue	item	Yes	The item number that the receiver unit adjustment was performed against.
container_id	rua_mfqueue	carton	No	The supplier carton that contained the item against which the receiver unit adjustment was performed.
unit_qty	rua_mfqueue	adj_qty	Yes	The quantity of the receiver unit adjustment.
from_disposition	inv_status_codes	inv_status_code	No	This value, along with the to_disposition value, is used to determine if the inventory is available or unavailable.
to_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ReceiptDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
appt_nbr	appt_head	appt	No	Unique identifier for receiving a group of items. This is usually an RDM-generated unique numerical identifier for an Appointment.
Receipt	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:Receipt

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	alloc_detail, ordloc, tsf	to_loc, location, to_loc	Yes	This element corresponds to different RMS tables, depending on the document_type. 'A' - ALLOC_DETAIL.TO_LOC, 'P' - ORDLOC.LOCATION, 'T' - TSFHEAD.TO_LOC
po_nbr	alloc_header, ordhead, tsf	alloc_no, ordloc, tsf_no	No	Specifies the unique identifier of the allocation, purchase order, or transfer.
document_type	doc_close_queue	doc_type	Yes	Specifies whether the receipt is for an allocation 'A', purchase order 'P', or transfer 'T'. Types 'D' and 'V' are also valid document types that are treated the same as transfers.
asn_nbr	shipment	asn	No	Used to relate the receipt message to the previous ASN message, be it ASNIn or ASNOut. This field is required for doc types 'A' and 'T', not required for doc_type 'P'.
ReceiptDtl	*	*	*	*
ReceiptCartonDtl	*	*	*	*
receipt_type	n/a	n/a	No	This field is required when receiving a transfer or allocation to determine if the receipt is at the 'BL' (BOL) level or 'SK' (SKU) level. It is not used for a PO receipt.
from_loc	shipment	from_loc	No	The originating location
from_loc_type	shipment	from_loc_type	No	From location type

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ReceiptDtl

Tag Name	Table Name	Column Name	API Req	Description
item_id	alloc_header, ordloc, tsf	item	Yes	Specifies the item on the allocation, purchase order, or transfer that has been received.
unit_qty	alloc_detail, ordloc, tsf	qty_received	Yes	Contains the quantity received for the allocation, purchase order, or transfer. The shipment record is also updated with the quantity received (SHIPSKU.QTY_RECEIVED)
receipt_xactn_type	n/a	n/a	Yes	Specifies whether the receipt detail line item is for a 'R'eceipt, 'T'ransshipment, or 'A'djustment. For purchase order receiving, Transshipments are not allowed. For stock order (ie. Allocation and Transfer) receiving, Transshipments are handled the same way as 'R'eceipt type.
receipt_date	shipment	receive_date	No	Identifies the date the transaction was written.
receipt_nbr	shipment	ext_ref_no_out	No	An externally generated numerical identifier corresponding to the successful reception of the item at the location.
dest_id	alloc_detail	to_loc	No	Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This element specifies the location to which the allocation is being sent.
container_id	shipsku	carton	Yes	Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments.
distro_nbr	alloc_header	alloc_no	No	Only used for doc_type of 'P', when the purchase order has an allocation attached to it. This element specifies the allocation id.
distro_doc_type	n/a	n/a	No	Only used for doc_type of 'P', when the purchase order has an allocation attached to it. When populated, this value should always be 'A' to specify an allocation.
to_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
from_disposition	inv_status_codes	inv_status_code	No	This value is used to determine inventory availability only if the to_disposition is not specified in the message.
to_wip	n/a	*	No	Not used by RMS.
from_wip	n/a	*	No	Not used by RMS.
to_trouble	n/a	*	No	Not used by RMS.
from_trouble	n/a	*	No	Not used by RMS.
user_id	n/a	*	No	Not used by RMS.
dummy_carton_ind	dummy_carton_stage	dummy_carton_ind	No	Indicates if this carton is a dummy carton. This field is only used for transfer receipts.
tampered_carton_ind	dummy_carton_stage	tampered_ind	No	Indicates if the carton was tampered. This field is only used for transfer receipts.
unit_cost	ordloc	unit_cost	No	Only used for doc_type of 'P'. Specifies the unit_cost for the item on the order. Cost is converted to the order's currency before insert/update.
shipped_qty	shipsku	qty_expected	No	Only used for doc_type of 'P'. Updates the number of items expected to be received, originally set by the ASN process.
weight	shipsku	weight_received	No	Contains the actual weight of the item on received for the shipment.
weight_uom	shipsku	weight_received_uom	No	Contains the unit of measure of the received weight (e.g. pounds, kilograms).

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:ReceiptCartonDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
carton_status_ind	n/a	n/a	Yes	Denotes the status of the carton received. It can be ?A?ctual, ?D?ummy or ?O?verage. This field is only used for stock order receiving.
container_id	shipsku	carton	Yes	Contains the carton ID for the shipment.
dest_id	shipsku	to_loc	No	Identifies the location to which the stock order is received.
receipt_xactn_type	n/a	n/a	Yes	Specifies whether the carton receipt is for a 'R'eceipt, 'T'ranshipment, or 'A'djustment.
receipt_date	shipment	receive_date	No	This field contains the date the carton is received.
receipt_nbr	shipment	ext_ref_no_out	No	This field holds the externally generated number when the shipment is received at the location.
user_id	n/a	n/a	No	Not used by RMS.
to_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
weight	shipsku	weight_received	No	Contains the actual weight of the item on received for the carton.
weight_uom	shipsku	weight_received_uom	No	Contains the unit of measure of the received weight (e.g. pounds, kilograms).

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RegPrcChgDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
location	ticket_request	location	Yes	This field contains the location number which has requested tickets.
loc_type	ticket_request	loc_type	Yes	Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store).
RegPrcChgDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RegPrcChgDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
price_change_id	ticket_request	price_change_id	Yes	Contains the ID of the price change that initiated the ticket request.
item	ticket_request	item	Yes	Alphanumeric value that identifies the item for which tickets have been requested.
effective_date	ticket_request	price_change_eff_date	Yes	Holds the effective date for the price change.
selling_retail_changed_ind	n/a	n/a	Yes	Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed.
selling_unit_retail	ticket_request	unit_retail	Yes	This field contains the unit retail for the item at the indicated location.
selling_uom	uom_class	uom	Yes	Holds the selling unit of measure for an item's single-unit retail.
selling_currency	currencies	currency_code	Yes	Contains the currency code that should match the store's or warehouse's currency code.
multi_unit_changed_ind	n/a	n/a	Yes	Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed.
multi_units	ticket_request	multi_units	No	This field contains the multi-unit parts of the multi-unit retail for the item at the indicated location.
multi_unit_retail	ticket_request	multi_unit_retail	No	This field contains the multi-unit retail for the item at the indicated location.
multi_unit_retail_currency	currencies	currency_code	No	Contains the currency code that should match the store's or warehouse's currency code.
multi_selling_uom	uom_class	uom	No	Holds the selling unit of measure for an item's multi-unit retail.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RegPrcChgRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
location	ticket_request	location	*	*
loc_type	ticket_request	loc_type	*	*
RegPrcChgDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RegPrcChgDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
price_change_id	ticket_request	price_change_id	*	*
item	ticket_request	item	*	*

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
rtv_id	rtv_head	ext_ref_no	Yes	Audit trail reference to external system when an external transaction initiates master record creation in the Retek system.
item_id	rtv_detail	item	Yes	Unique identifier for the item on the RTV.
rtn_auth_nbr	rtv_head	ret_auth_num	No	Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data.
unit_qty	rtv_detail	qty_returned	Yes	Contains the quantiy of items being returned to the supplier under this RTV number.
container_qty	n/a	n/a	No	Not used by RMS.
vendor_nbr	rtv_head	supplier	Yes	Contains the supplier ID to which the merchandise is being returned.
ship_address1	rtv_head	ship_to_add_1	No	Contains the first line of the supplier's address for returns.
ship_address2	rtv_head	ship_to_add_2	No	Contains the second line of the supplier's address for returns.
ship_address3	rtv_head	ship_to_add_3	No	Contains the third line of the supplier's address for returns.
state	rtv_head	state	No	Contains the state of the supplier's address for returns.
city	rtv_head	ship_to_city	No	Contains the city name of the supplier's address for returns.
shipto_zip	rtv_head	ship_to_pcode	No	Contains the zip code of the supplier's address for returns.
country	rtv_head	ship_to_country_id	No	Contains the country ID of the supplier's address for returns.
from_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
to_disposition	n/a	n/a	No	Not used by RMS.
creation_ts	rtv_head	created_date, completed_date	No	CREATED_DATE contains the date the vendor return was created, COMPLETED_DATE contains the date the vendor return was completed.
unit_cost	rtv_detail	unit_cost	No	Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
reason	rtv_detail	reason	No	Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock).
comments	rtv_head	comment_desc	No	Contains any comments associated with the return.
rtv_order_no	rtv_head	rtv_order_no	No	Contains the number that uniquely identifies the return to vendor within the system.
weight	n/a	n/a	No	Actual weight shipped for the item on the RTV.
weight_uom	n/a	n/a	No	Unit of Measure for the weight (e.g. pounds, kilograms).
RTVDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	rtv_detail	item	Yes	Unique identifier for the item on the RTV.
unit_qty	rtv_detail	qty_returned	Yes	Contains the quantiy of items being returned to the supplier under this RTV number.
container_qty	n/a	n/a	No	Not used by RMS.
from_disposition	inv_status_codes	inv_status_code	No	This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table.
to_disposition	n/a	n/a	No	Not used by RMS.
unit_cost	rtv_detail	unit_cost	No	Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
reason	rtv_detail	reason	No	Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory. Other values may also be entered via the codes table under code type 'RTVR', however, the two codes listed previously may never be deleted. Note that any value added can only be related to RTV from existing inventory (e.g. overstock).
weight	n/a	n/a	No	Actual weight shipped for the item on the RTV.
weight_uom	n/a	n/a	No	Unit of Measure for the weight (e.g. pounds, kilograms).

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVReqDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
rtv_order_no	rtv_head	rtv_order_no	Yes	Contains the number that uniquely identifies the return to vendor within the system.
supplier	rtv_head	supplier	Yes	Contains the supplier number to which the merchandise is being returned.
status_ind	rtv_head	status_ind	Yes	Contains the current status of the return. Valid values include: 05- Input, 10 - Approved, 15 - Shipped, 20 - Cancelled.
loc	rtv_head	store, wh	Yes	Contains either the store or warehouse number for the items being returned.
loc_type	n/a	n/a	Yes	Indicates the location type. Contains an 'S' if the location is a store or 'W' if the location is a warehouse.
physical_loc	rtv_head, wh	store, physical_wh	Yes	Contains the store number or the physical warehouse where the items are being returned.
total_order_amt	rtv_head	total_order_amt	No	Contains the total amount of the return. This field is stored in the supplier's currency.
ship_to_addr_line1	rtv_head	ship_to_add_1	Yes	Contains the first line of the supplier's address for returns.
ship_to_addr_line2	rtv_head	ship_to_add_2	No	Contains the second line of the supplier's address for returns.
ship_to_addr_line3	rtv_head	ship_to_add_3	No	Contains the third line of the supplier's address for returns.
ship_to_city	rtv_head	ship_to_city	Yes	Contains the city name of the supplier's address for returns.
state	rtv_head	state	Yes	Contains the state of the supplier's address for returns.
ship_to_country_code	rtv_head	ship_to_country_id	Yes	Contains the country ID of the supplier's address for returns.
ship_to_postal_code	rtv_head	ship_to_pcode	No	Contains the zip code of the supplier's address for returns.
ret_auth_nbr	rtv_head	ret_auth_num	No	Contains the number that the supplier provides when the decision is made that an order may be returned. This value is not always required and is determined by vendor level data.
ret_courier	rtv_head	courier	No	Contains the courier name if the supplier requires that returns be sent by a designated carrier.
freight_charge	rtv_head	freight	No	Contains the freight cost associated with the vendor return. This field is stored in the supplier's currency.
creation_date	rtv_head	created_date	Yes	Contains the date the vendor return was created.
completed_date	rtv_head	completed_date	No	Contains the date the vendor return was completed.
handling_pct	rtv_head	restock_pct	No	Contains the handling (restocking) percent if a percent is specified at a vendor level.
handling_cost	rtv_head	restock_cost	Yes	Contains the handling (restocking) cost for the vendor return if a handling (restocking) percent is specified at a supplier level. The cost is calculated by taking the total order amount multiplied by the handling (restocking) percent. This field is stored in the supplier's currency.
ext_ref_no	rtv_head	ext_ref_no	No	Audit trail reference to external system when an external transaction initiates master record creation in the Retek system.
comment_desc	rtv_head	comment_desc	No	Contains any comments associated with the return.
RTVReqDtl	*	*	*	*
not_after_date	rtv_head	not_after_date	No	Contains the last date that delivery of the order will be accepted.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVReqDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
seq_no	rtv_detail	seq_no	Yes	This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field.
item	rtv_detail	item	Yes	Unique identifier for the item.
shipment	rtv_detail	shipment	Yes	Contains the shipment number associated with all vendor returns originating from the Quality Control process. This field will contain a -1 for all returns originating from held inventory.
inv_status	rtv_detail	inv_status	No	This field contains the number representing the inventory status code. This field is only required if the reason field has a value of 'U' for unavailable inventory.
rtv_qty	rtv_detail	qty_requested	Yes	Contains the quantity of items requested to be returned to the supplier under this RTV number.
unit_cost	rtv_detail	unit_cost	Yes	Contains the cost per unit for the SKU being returned. This field is stored in the supplier's currency.
reason	rtv_detail	reason	Yes	Contains the value identifying the reason for the return. Valid values are: Q - QC Failed, U - Unavailable Inventory.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVReqRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
rtv_order_no	rtv_head	rtv_order_no	Yes	Contains the number that uniquely identifies the return to vendor within the system.
RTVReqDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:RTVReqDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
seq_no	rtv_detail	seq_no	Yes	This field will contain a sequence number which makes the record unique when combined with the RTV_ORDER_NO field.
item	rtv_detail	item	Yes	Unique identifier for the item on the RTV.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:SOStatusDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dc_dest_id	tsfhead, alloc_detail	to_loc, store	No	Contains the location number of the stock order receiving location.
distro_nbr	alloc_header, tsfhead	alloc_no, tsf_no	No	Contains the stock order number. This is either the transfer or allocation number in RMS.
distro_document_type	n/a	n/a	Yes	Specifies whether the stock order status pertains to an allocation 'A', or transfer 'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro are also valid document types but will be ignored by the RMS API.
SOStatusDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:SOStatusDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
cust_order_nbr	n/a	n/a	No	Not used by RMS.
dest_id	tsfhead, alloc_detail	to_loc, store	No	Contains the location number of the stock order receiving location.
item_id	tsfdetail, alloc_header	item	Yes	Unique identifier for the item.
order_line_nbr	n/a	n/a	No	Not used by RMS.
unit_qty	alloc_detail, tsfdetail	qty_allocated, tsf_qty	Yes	The quantity of the item pertaining to the stock order status message.
status	n/a	n/a	Yes	The status of the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation.
user_id	n/a	n/a	No	Not used by RMS.
updated_date	n/a	n/a	No	Not used by RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StkCountSchDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
cycle_count	stake_head	cycle_count	Yes	Contains the number which uniquely identifies the stock or cycle count.
cycle_count_desc	stake_head	cycle_count_desc	Yes	Contains a description of the cycle or stock count which, along with the cycle count number, identifies the cycle or stock count.
location_type	stake_head	loc_type	Yes	Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse.
stocktake_date	stake_head	stocktake_date	Yes	Contains the date on which the stock or cycle count even will take place.
stocktake_type	stake_head	stocktake_type	Yes	Contains a value which indicates the type of stock take. Valid values are 'B' -Both Unit and Dollar and 'U' - Unit only. However the RIB interface only allows 'B'.
StkCountSchProd	*	*	*	*
StkCountSchLoc	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StkCountSchProd

Tag Name	Table Name	Column Name	API Req	Description
dept	stake_product	dept	Yes	Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments.
class	stake_product	class	No	Contains the class number where the cycle count will occur.
subclass	stake_product	subclass	No	Contains the subclass number where the cycle count will occur.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StkCountSchLoc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
location	stake_location	location	Yes	Contains the store or wh number on the cycle count.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StkCountSchRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
cycle_count	stake_head	cycle_count	Yes	The unique identifier for the cycle count.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StoreDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
store	store	store	Yes	Contains the number which uniquely identifies the store.
store_name	store	store_name	Yes	Contains the name of the store.
store_name10	store	store_name10	Yes	Contains a ten character abbreviation of the store name.
store_name3	store	store_name3	Yes	Contains a three character abbreviation of the store name.
store_add1	*	*	No	Field not used.
store_add2	*	*	No	Field not used.
store_city	*	*	No	Field not used.
county	*	*	No	Field not used.
state	*	*	No	Field not used.
country_id	*	*	No	Field not used.
store_pcode	*	*	No	Field not used.
store_class	store	store_class	Yes	Contains the code letter indicating the class of which the store is a member. Valid values are A through E.
store_mgr_name	store	store_mgr_name	Yes	Contains the name of the store manager.
store_open_date	store	store_open_date	Yes	Contains the date on which the store opened.
store_close_date	store	store_close_date	No	Contains the date on which the store closed.
acquired_date	store	acquired_date	No	Contains the date on which the store was acquired.
remodel_date	store	remodel_date	No	Contains the date on which the store was last remodeled.
fax_number	store	fax_number	No	Contains the fax number for the store.
phone_number	store	phone_number	No	Contains the phone number for the store.
email	store	email	No	Holds the email address for the location
total_square_ft	store	total_square_ft	No	Contains the total square footage of the store.
selling_square_ft	store	selling_square_ft	No	Contains the total square footage of the store's selling area.
linear_distance	store	linear_distance	No	Holds the total merchandisable space of the location.
stockholding_ind	store	stockholding_ind	Yes	This column indicates whether the store can hold stock. In a non-multichannel environment this will always be
channel_id	store	channel_id	No	In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table.
store_format	store	store_format	No	Contains the number indicating the format of the store. Valid values are found on the store format table.
mall_name	store	mall_name	No	Contains the name of the mall in which the store is located.
district	store	district	Yes	Contains the number of the district in which the store is a member.
district_name	district	district_name	No	Contains the name of the district.
promo_zone	*	*	No	Field not used.
promo_desc	*	*	No	Field not used.
transfer_zone	store	transfer_zone	No	Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table.
description	tsfzone	description	No	Contains the name of the transfer zone.
default_wh	store	default_wh	No	Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment.
stop_order_days	store	stop_order_days	No	Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined.
start_order_days	store	start_order_days	Yes	Contains the number of days before the store_open_date that the store will begin accepting orders.
currency_code	store	currency_code	Yes	This field contains the currency code under which the store operates.
lang	store	lang	Yes	This column identifies the language to be used for the given store.
integrated_pos_ind	store	integrated_pos_ind	Yes	Indicates whether or not the POS system at the Store is integrated.
orig_currency_code	store	orig_currency_code	Yes	holds the original currency of a store after it's adopted the Euro as its main operating currency
duns_number	store	duns_number	No	This field holds the Dun and Bradstreet number to identify the store.
duns_loc	store	duns_loc	No	This field holds the Dun and Bradstreet number to identify the location
AddrDesc	*	*	*	See layout below.
pricing_loc	store-add	price-store	No	The store from which pricing info was copied for this store.
pricing_loc_curr	store	currency_code	No	This is the currency code of the pricing_loc store.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	Address Unigue Identifier
addr_type	addr	addr_type	Yes	Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table.
primary_addr_type_ind	add_type_module	primary_ind	Yes	Y or N - indicates whether this address type is the primary address type.
primary_addr_ind	addr	primary_addr_ind	Yes	Indicates whether this address is the primary address for this address type
add_1	addr	add_1	Yes	Contains the first line of the address
add_2	addr	add_2	No	Contains the second line of the address
add_3	addr	add_3	No	Contains the third line of the address
city	addr	city	Yes	Contains the city.
state	addr	state	No	Contains the postal abbreviation for the state.
country_id	addr	country_id	Yes	Contains the country code.
post	addr	post	No	Contains the zip code for the address
contact_name	addr	contact_name	No	Contains the name of the contact.
contact_phone	addr	contact_phone	No	Contains the phone number of the contact.
contact_telex	addr	contact_telex	No	Contains the telex number of the contact.
contact_fax	addr	contact_fax	No	Contains the fax number of the contact.
contact_email	addr	contact_email	No	Contains the email address of the contact.
oracle_vendor_site_id	addr	oracle_vendor_site_id	No	Generally not used.
county	addr	county	No	Holds the county of the location

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:StoreRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
store	store	store	Yes	The store number for the store or address being deleted.
AddrRef	*	*	No	See layout below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	The unique identifier of the address being deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:TsfDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
tsf_no	tsfhead	tsf_no	Yes	The number that uniquely identifies the transfer.
doc_type	*	*	Yes	Defaulted to 'T' for RMS transfers.
physical_from_loc	store, wh	store, physical_wh	Yes	Physical location that the from_loc belongs to.
from_loc_type	item_loc	loc_type	Yes	Type of location in the location field. Valid values are: S = Store W = Warehouse
from_loc	tsfhead	from_loc	Yes	The location number of the transfer from location. This field will contain either a store or warehouse number based on the from_loc_type field.
physical_to_loc	store, wh	store, physical_wh	Yes	Physical location that the to_loc belongs to.
to_loc_type	item_loc	loc_type	Yes	Type of location in the location field. Valid values are: S = Store W = Warehouse
to_loc	tsfhead	to_loc	Yes	The location number of the transfer to location. This field will contain either a store or warehouse number based on the to_loc_type field.
tsf_type	tsfhead	tsf_type	Yes	A code for the type of the transfer, such as SR - Store Requisition CO - Customer Order RV - RTV CF - Confirmation NS - Non-Salable AD - Administrative MR - Manual Requisitions PL - PO-Linked Transfer.
pick_not_before_date	tsfhead	approval_date	Yes	The date the transfer was approved.
pick_not_after_date	*	*	Yes	This is a calculated date.
default_order_type	system_options	default_order_type	Yes	This is the default order type associated with transfers.. RWMS uses this value to determine how to distribute stock orders. Valid values (e.g. Automatic, Manual, etc.) are on the order_types table.
priority	*	*	No	Reserved for future use; currently defaulted to 1.
break_by_distro	*	*	Yes	Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N.
delivery_date	tsfhead	delivery_date	No	The earliest date that the transfer can be delivered to the store. This will be populated if the transfer type is PO-Linked.
cust_name	customer	cust_name	No	The name of the customer.
deliver_add1	ordcust	deliver_add1	No	The delivery address for the customer/order relationship.
deliver_add2	ordcust	deliver_add2	No	Contains an optional second line of the delivery address for the customer/order relationship.
deliver_city	ordcust	deliver_city	No	Contains the city in which the customer order will be delivered.
deliver_state	ordcust	deliver_state	No	Contains the state in which the customer order will be delivered.
deliver_post	ordcust	deliver_post	No	Contains the postal code in which the customer order will be delivered.
deliver_country_id	ordcust	deliver_country_id	No	Contains the country in which the customer order will be delivered.
message	tsfhead	comment_desc	No	Any comments associated with the transfer.
TsfDtl	*	*	*	Child node - see layout below.
tsf_parent_no	tsfhead	tsf_parent_no	No	Transfer parent number
exp_dc_date	tsfhead	exp_dc_date	No	Date the inventory is expected to arrive at the DC.
approval_id	tsfhead	approval_id	No	The ID of the user who approved the transfer
approval_date	tsfhead	approval_date	No	Date the transfer was approved
from_loc_tsf_entity	store, wh	tsf_entity_id	No	Transfer entity of the from location
to_loc_tsf_entity	store, wh	tsf_entity_id	No	Transfer entity of the to location
inv_type	tsfhead	inventory_type	No	Type of inventory
tsf_status	tsfhead	status	No	Status of the transfer.
not_after_date	tsfhead	not_after_date	No	The last day delivery of the transfer will be accepted
context_type	tsfhead	context_type	No	Can be used to indicate the transfer reason or category, e.g. 'promotion'.
context_value	tsfhead	context_value	No	Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:TsfDtl

Tag Name	Table Name	Column Name	API Req	Description
item	tsfdetail	item	Yes	Unique alphanumeric value that identifies the item.
tsf_qty	tsfdetail	tsf_qty	Yes	The total quantity of the item reserved at the from location for this transfer. This field is set back to zero each time the stock is either merged into a 'Combined Transfer' or shipped.
price	*	*	No	This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
selling_uom	*	*	No	This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
priority	*	*	No	This field is currently defaulted to 1. It is reserved for future use.
expedite_flag	*	*	No	If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'.
store_ord_mult	item_loc	store_ord_mult	No	The multiple in which the item needs to be shipped from a warehouse to the location.
tsf_po_link_no	tsfdetail	tsf_po_link_no	No	A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer.
ticket_type_id	item_ticket	ticket_type_id	No	The ticket type associated with the item.
TsfDtlTckt	*	*	*	Child Node - see layout below.
inv_status	tsfdetail	inv_status	No	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:TsfDtlTckt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
comp_item	packitem_breakout	item	Yes	Alphanumeric value that identifies the item within the pack.
comp_price	*	*	No	This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.
comp_selling_uom	*	*	No	This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:TsfRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
tsf_no	tsfhead	tsf_no	Yes	The number that uniquely identifies the transfer within the system.
doc_type	*	*	Yes	Defaulted to 'T' for RMS transfers.
physical_from_loc	store, wh	store, physical_wh	Yes	Physical location that the from_loc belongs to.
from_loc	tsfhead	from_loc	Yes	The location number of the transfer from location. This will be either a store or warehouse number based on the from_loc_type field.
physical_to_loc	store, wh	store, physical_wh	Yes	Physical location that the to_loc belongs to.
to_loc	tsfhead	to_loc	Yes	The location number of the transfer to location. This will be either a store or warehouse number based on the to_loc_type field.
TsfDtlRef	*	*	*	Child Node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:TsfDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	tsfdetail	item	Yes	Unique alphanumeric value that identifies the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:UDADesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda	uda_id	Yes	The id number for the User Defined Attribute.
uda_desc	uda	uda_desc	Yes	Description of the UDA.
module	uda	module	Yes	Indicates which system module the UDA belongs to. This will always be 'ITEM'.
display_type	uda	display_type	Yes	A code to indicate how the UDA will be displayed to the user. Values are in the UDIS code table.
data_type	uda	data_type	No	Optional field indicating what value types are valid for this UDA. Valid types are NUM, ALPHA, DATE.
data_length	uda	data_length	No	Optional field indicating valid data length for this UDA.
single_value_ind	uda	single_value_ind	Yes	Y or N to indicate whether the UDA is limited to having at most one value.
host_ind	*	*	No	Field not used.
carton_group	*	*	No	Field not used.
combinability	*	*	No	Field not used.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:UDARef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda	uda_id	Yes	The id number of the UDA that was deleted in RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:UDAValDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda_values	uda_id	Yes	The id number of the UDA.
uda_value	uda_values	uda_value	Yes	The value for the UDA.
uda_value_desc	uda_values	uda_value_desc	Yes	Description of the UDA value.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:UDAValRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda_values	uda_id	Yes	The id number of the UDA.
uda_value	uda_values	uda_value	Yes	The value being deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorAddrRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
supplier	sups	supplier	Yes	The supplier number.
seq_no	addr	seq_no	Yes	Number indicating the sequence that addresses within the same type were entered.
addr_type	addr	addr_type	Yes	Indicates the address type (e.g. 01 - Business, 02 - Postal, etc.).

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
VendorHdrDesc	*	*	Yes	This is a child node.
VendorAddrDesc	*	*	Yes	This is a child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorHdrDesc

Tag Name	Table Name	Column Name	API Req	Description
supplier	sups	supplier	Yes	The unique number for the supplier in the RMS system.
sup_name	sups	sup_name	Yes	Contains the supplier's trading name.
contact_name	sups	contact_name	Yes	Contains the name of the supplier's representative contact.
contact_phone	sups	contact_phone	Yes	Contains a telephone number for the supplier's representative contact.
contact_fax	sups	contact_fax	No	Contains a fax number for the supplier's representative contact.
contact_pager	sups	contact_pager	No	Contains a pager number for the supplier's representative contact.
sup_status	sups	sup_status	Yes	Valid values include: 'A' for an active supplier or 'I' for an inactive supplier. The status of a supplier will be checked when an order is being created to make certain the supplier is active.
qc_ind	sups	qc_ind	Yes	Determines whether orders from this supplier will default as requiring quality control.
qc_pct	sups	qc_pct	No	Indicates the percentage of items per receipt that will be marked for quality checking.
qc_freq	sups	qc_freq	No	Indicates the frequency in which items per receipt that will be marked for quality checking.
vc_ind	sups	vc_ind	Yes	Determines whether orders from this supplier will default as requiring vendor control.
vc_pct	sups	vc_pct	No	Indicates the percentage of items per receipt that will be marked for vendor checking.
vc_freq	sups	vc_freq	No	Indicates the frequency in which items per receipt that will be marked for vendor checking.
currency_code	sups	currency_code	Yes	Contains a code identifying the currency the supplier uses for business transactions.
lang	sups	lang	No	Contains the supplier's preferred language.
terms	sups	terms	Yes	Indicator identifying the sales terms that will default when an order is created for the supplier. These terms specify when payment is due and if any discounts exist for early payment.
freight_terms	sups	freight_terms	Yes	Indicator that references what freight terms will default when an order is created for the supplier.
ret_allow_ind	sups	ret_allow_ind	Yes	Indicates whether or not the supplier will accept returns.
ret_auth_req	sups	ret_auth_req	Yes	Indicates if returns must be accompanied by an authorization number when sent back to the vendor.
ret_min_dol_amt	sups	ret_min_dol_amt	No	Contains a value if the supplier requires a minimum dollar amount to be returned in order to accept the return. Returns of less than this amount will not be processed by the system. This field is stored in the supplier's currency.
ret_courier	sups	ret_courier	No	Contains the name of the courier that should be used for all returns to the supplier.
handling_pct	sups	handling_pct	No	This percentage will be multiplied by an order's total cost to determine the handling cost for the return.
edi_po_ind	sups	edi_po_ind	Yes	Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange.
edi_po_chg	sups	edi_po_chg	Yes	Indicates whether purchase order changes will be sent to the supplier via Electronic Data Interchange.
edi_po_confirm	sups	edi_po_confirm	Yes	Indicates whether acknowledgements of purchase orders will be sent to the supplier via Electronic Data Interchange.
edi_asn	sups	edi_asn	Yes	Indicates whether the supplier will send Advance Shipment Notifications electronically.
edi_sales_rpt_freq	sups	edi_sales_rpt_freq	No	This field contains the EDI sales report frequency for the supplier. Valid values are 'D' or 'W', specifying that sales and stock information will be downloaded daily or weekly.
edi_supp_available_ind	sups	edi_supp_available_ind	Yes	Indicates whether the supplier will send availability via EDI.
edi_contract_ind	sups	edi_contract_ind	Yes	Indicates whether contracts will be sent to the supplier via EDI.
edi_invc_ind	sups	edi_invc_ind	Yes	Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via EDI.
cost_chg_pct_var	sups	cost_chg_pct_var	No	Contains the cost change variance by percent. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog.
cost_chg_amt_var	sups	cost_chg_amt_var	No	Contains the cost change variance by amount. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog.
replen_approval_ind	sups	replen_approval_ind	Yes	Indicates whether contract orders for the supplier should be createed in Approved status.
ship_method	sups	ship_method	No	The method used to ship the items on the purchase order from the country of origin to the country of import. Check the RMS data model for valid values.
payment_method	sups	payment_method	No	Indicates how the purchase order will be paid. Valid options are: LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).
contact_telex	sups	contact_telex	No	Contains a telex number for the supplier's representative contact.
contact_email	sups	contact_email	No	Contains an email address for the supplier's representative contact.
settlement_code	sups	settlement_code	Yes	Indicates which payment process method is used for the supplier. Check the RMS data model for valid values.
pre_mark_ind	sups	pre_mark_ind	Yes	Indicates whether or not the supplier has agreed to break an order into separate boxes (and mark them) that can be shipped directly to the stores.
auto_appr_invc_ind	sups	auto_appr_invc_ind	Yes	Indicates whether or not the supplier's invoice matches can be automatically approved for payment.
dbt_memo_code	sups	dbt_memo_code	No	Indicates when a debit memo will be sent to the supplier to resolve a discrepancy. Valid values are Y if debit memos are always to be sent, L if debit memos are used only if a credit note is not sent by the invoice due date, or N if debit memos are neve
freight_charge_ind	sups	freight_charge_ind	Yes	Indicates whether or not a supplier is allowed to charge freight costs to the client.
auto_appr_dbt_memo_ind	sups	auto_appr_dbt_memo_ind	Yes	Indicates whether or not debit memos sent to the supplier can be automatically approved on creation.
inv_mgmt_lvl	sups	inv_mgmt_lvl	No	Indicator that determines whether supplier inventory management information can be sent up at the supplier/deparment level or just at the supplier level.
backorder_ind	sups	backorder_ind	Yes	Indicates if backorders or partial shipments will be accepted.
vat_region	sups	vat_region	No	Contains the unique identifying number for the VAT region in the system.
prepay_invc_ind	sups	prepay_invc_ind	Yes	Indicates whether or not all invoices for the supplier can be pre-paid invoices.
service_perf_req_ind	sups	service_perf_req_ind	Yes	Indicates if the supplier's services must be confirmed as performed before paying an invoice from that supplier.
invc_pay_loc	sups	invc_pay_loc	No	Indicates where invoices from this supplier are paid - at the store ('S') or centrally through coroporate accounting ('C').
invc_receive_loc	sups	invc_receive_loc	No	Indicates where invoices from this supplier are received - at the store ('S') or centrally through coroporate accounting ('C').
addinvc_gross_net	sups	addinvc_gross_net	No	Indicates if the supplier invoice lists items at gross cost ('G') or net cost ('N').
delivery_policy	sups	delivery_policy	Yes	Contains the delivery policy of the supplier. Valid values come from the DLVY code on code_head/code_detail.
comment_desc	sups	comment_desc	No	Any miscellaneous comments associated with the supplier.
default_item_lead_time	sups	default_item_lead_time	No	Holds the default lead time for the supplier. The lead time is the time the supplier needs between receiving an order and having the order ready to ship. This value will be defaulted to item/supplier relationships.
duns_number	sups	duns_number	No	This field holds the Dun and Bradstreet number to identify the supplier.
duns_loc	sups	duns_loc	No	This field holds the Dun and Bradstreet number to identify the location of the supplier.
bracket_costing_ind	sups	bracket_costing_ind	Yes	This field will determine if the supplier uses bracket costing pricing structures.
vmi_order_status	sups	vmi_order_status	No	Determines the status in which any inbound PO's from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier.
end_date_active	*	*	No	Not used by RMS.
dsd_supplier_ind	sups	dsd_ind	Yes	Specifies whether or not DSD shipments can be created for the supplier.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorAddrDesc

Tag Name	Table Name	Column Name	API Req	Description
module	addr	module	Yes	The code for the entity type the address is for, which in this case will always be 'SUPP' for supplier.
key_value_1	addr	key_value_1	Yes	The supplier number the address is attached to.
key_value_2	*	*	No	Field not used.
seq_no	addr	seq_no	Yes	Number indicating the sequence that addresses within the same type were entered.
addr_type	addr	addr_type	Yes	Indicates the type for the address. Valid values (e.g. 01 - Business, 02 - Postal) are on the add_type table.
primary_addr_ind	addr	primary_addr_ind	Yes	Indicates whether the address is the primary address for the address type.
add_1	addr	add_1	Yes	Contains the first line of the address.
add_2	addr	add_2	No	Contains the second line of the address.
add_3	addr	add_3	No	Contains the third line of the address.
city	addr	city	Yes	Contains the name of the city associated with the address.
state	addr	state	Yes	Contains the state abbreviation for the address.
country_id	addr	country_id	Yes	Contains the country where the address exists.
post	addr	post	Yes	Contains the zip code for the address.
contact_name	addr	contact_name	No	Contains the name of the contact for the supplier at this address.
contact_phone	addr	contact_phone	No	Contains the phone number for the contact for the contact person at this address.
contact_telex	addr	contact_telex	No	Contains the telex number of the partner or supplier's representative contact.
contact_fax	addr	contact_fax	No	Contains the fax number for the contact for the contact person at this address.
contact_email	addr	contact_email	No	Contains the email address of the partner or supplier's representative contact.
oracle_vendor_site_id	addr	oracle_vendor_site_id	No	Used only if client is integrated with Oracle Financials using RMS10 or earlier version.
OracleOUDesc	*	*	No	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OracleOUDesc

Tag Name	Table Name	Column Name	API Req	Description
OUDtlDesc	*	*	No	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OUDtlDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
ou_id	*	*	No	Field not used in publish mode.
site_id	*	*	No	Field not used in publish mode.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
supplier	sups	supplier	Yes	The supplier number.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
VendorHdrDesc	*	*	Yes	Child node - see below.
VendorAddrDesc	*	*	Yes	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorHdrDesc

Tag Name	Table Name	Column Name	API Req	Description
supplier	sups	supplier	Yes	Unique identifying number for a supplier.
sup_name	sups	sup_name	Yes	The supplier's trading name.
contact_name	sups	contact_name	No	The contact name for the supplier.
contact_phone	sups	contact_phone	No	Contact phone number for the supplier.
contact_fax	sups	contact_fax	No	Fax number for supplier.
contact_pager	sups	contact_pager	No	Pager number for supplier.
sup_status	sups	sup_status	No	A code to indicate supplier status. A = Active, I = Inactive.
qc_ind	sups	qc_ind	No	Determines whether orders from this supplier will default as requiring quality control.
qc_pct	sups	qc_pct	No	The percentage of items per receipt that will be marked for quality checking.
qc_freq	sups	qc_freq	No	The frequency for which items per receipt will be marked for quality checking.
vc_ind	sups	vc_ind	No	Determines whether orders from this supplier will default as requiring vendor control.
vc_pct	sups	vc_pct	No	The percentage of items per receipt that will be marked for vendor checking.
vc_freq	sups	vc_freq	No	The frequency for which items per receipt that will be marked for vendor checking.
currency_code	sups	currency_code	No	A code identifying the currency the supplier uses for business transactions.
lang	sups	lang	No	A code for the supplier's preferred language.
terms	sups	terms	No	A code indicating the payment terms that will default when an order is created for the supplier.
freight_terms	sups	freight_terms	No	A code indicating what freight terms will default when an order is created for the supplier.
ret_allow_ind	sups	ret_allow_ind	No	Indicates whether or not the supplier will accept returns.
ret_auth_req	sups	ret_auth_req	No	Indicates if returns must be accompanied by an authorization number when sent back to the vendor.
ret_min_dol_amt	sups	ret_min_dol_amt	No	Contains a value if the supplier requires a minimum value to be returned in order to accept the return. Stored in the supplier's currency.
ret_courier	sups	ret_courier	No	Contains the name of the courier that should be used for returns to the supplier.
handling_pct	sups	handling_pct	No	The percent to be multiplied by an order's total cost to determine the handling cost for the return.
edi_po_ind	sups	edi_po_ind	No	Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange.
edi_po_chg	sups	edi_po_chg	No	Indicates whether purchase order changes will be sent to the supplier via EDI.
edi_po_confirm	sups	edi_po_confirm	No	Indicates whether acknowledgements of purchase orders will be sent to the supplier via EDI.
edi_asn	sups	edi_asn	No	Indicates whether the supplier will send Advance Shipment Notifications electronically.
edi_sales_rpt_freq	sups	edi_sales_rpt_freq	No	This field contains the EDI sales report frequency for the supplier. Valid values are D = Daily, W = Weekly.
edi_supp_available_ind	sups	edi_supp_available_ind	No	Indicates whether the supplier will send availability via EDI.
edi_contract_ind	sups	edi_contract_ind	No	Indicates whether contracts will be sent to the supplier via EDI.
edi_invc_ind	sups	edi_invc_ind	No	Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via EDI.
cost_chg_pct_var	sups	cost_chg_pct_var	No	Contains the cost change variance by percent. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog.
cost_chg_amt_var	sups	cost_chg_amt_var	No	Contains the cost change variance by amount. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog.
replen_approval_ind	sups	replen_approval_ind	No	Indicates whether contract orders for the supplier should be created in Approved status.
ship_method	sups	ship_method	No	The method used to ship the items on the purchase order from the country of origin to the country of import. Check the RMS data model for valid values.
payment_method	sups	payment_method	No	Indicates how the purchase order will be paid. Valid options are: LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).
contact_telex	sups	contact_telex	No	The telex number for the supplier's contact.
contact_email	sups	contact_email	No	Contains an email address for the supplier's representative contact.
settlement_code	sups	settlement_code	No	Indicates which payment process method is used for the supplier. Check the RMS data model for valid values.
pre_mark_ind	sups	pre_mark_ind	No	Indicates whether or not the supplier has agreed to break an order into separate boxes (and mark them) that can be shipped directly to the stores.
auto_appr_invc_ind	sups	auto_appr_invc_ind	No	Indicates whether or not the supplier's invoice matches can be automatically approved for payment.
dbt_memo_code	sups	dbt_memo_code	No	Indicates when a debit memo will be sent to the supplier to resolve a discrepancy. Y = Yes, N = No, L = only if a credit note is not sent by the invoice due date.
freight_charge_ind	sups	freight_charge_ind	No	Indicates whether a supplier is allowed to charge freight costs to the client.
auto_appr_dbt_memo_ind	sups	auto_appr_dbt_memo_ind	No	Indicates whether debit memos sent to the supplier can be automatically approved on creation.
inv_mgmt_lvl	sups	inv_mgmt_lvl	No	Indicates whether supplier inventory management information can be set up at the supplier/deparment level or just at the supplier level.
backorder_ind	sups	backorder_ind	No	Indicates if backorders or partial shipments will be accepted.
vat_region	sups	vat_region	No	The VAT region for the supplier.
prepay_invc_ind	sups	prepay_invc_ind	No	Indicates whether or not all invoices for the supplier can be pre-paid invoices.
service_perf_req_ind	sups	service_perf_req_ind	No	Indicates if the supplier's services must be confirmed as performed before paying an invoice from that supplier.
invc_pay_loc	sups	invc_pay_loc	No	Indicates where invoices from this supplier are paid - at the store ('S') or centrally through corporate accounting ('C').
invc_receive_loc	sups	invc_receive_loc	No	Indicates where invoices from this supplier are received - at the store ('S') or centrally through corporate accounting ('C').
addinvc_gross_net	sups	addinvc_gross_net	No	Indicates if the supplier invoice lists items at gross cost ('G') or net cost ('N').
delivery_policy	sups	delivery_policy	No	Contains the delivery policy of the supplier. Valid values come from the DLVY code on code_head/code_detail.
comment_desc	sups	comment_desc	No	Any miscellaneous comments associated with the supplier.
default_item_lead_time	sups	default_item_lead_time	No	Holds the default lead time for the supplier. The lead time is the time the supplier needs between receiving an order and having the order ready to ship. This value will be defaulted to item/supplier relationships.
duns_number	sups	duns_number	No	The Dun and Bradstreet number of the supplier.
duns_loc	sups	duns_loc	No	The Dun and Bradstreet number of the location of the supplier.
bracket_costing_ind	sups	bracket_costing_ind	No	This field will determine if the supplier uses bracket costing pricing structures.
vmi_order_status	sups	vmi_order_status	No	Determines the status in which any inbound PO's from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier.
end_date_active	*	*	No	Not used by RMS.
dsd_supplier_ind	sups	dsd_ind	No	Specifies whether or not DSD shipments can be created for the supplier.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:VendorAddrDesc

Tag Name	Table Name	Column Name	API Req	Description
module	addr	module	Yes	Indicates the data type that the address is attached to. In this case, it will always be 'SUPP'.
key_value_1	addr	key_value_1	Yes	Holds the id the address is attached to. In this case, it will be the supplier number.
key_value_2	*	*	No	Field not used.
seq_no	*	*	No	Field not used.
addr_type	addr	addr_type	Yes	The address type. Valid values (e.g. 01 - Business, 02 - Postal, etc.) are on the add_type table.
primary_addr_ind	*	*	No	Field not used.
add_1	addr	add_1	Yes	The first line of the address.
add_2	addr	add_2	No	Contains the second line of the address.
add_3	addr	add_3	No	Contains the third line of the address.
city	addr	city	Yes	Contains the name of the city associated with the address.
state	addr	state	No	Contains the state abbreviation for the address.
country_id	addr	country_id	Yes	Contains the country where the address exists.
post	addr	post	No	The zip code for the address.
contact_name	addr	contact_name	No	The name of the contact at this address.
contact_phone	addr	contact_phone	No	The phone number for this address.
contact_telex	addr	contact_telex	No	The telex number for this address.
contact_fax	addr	contact_fax	No	The fax number for this address.
contact_email	addr	contact_email	No	The email address for this address.
oracle_vendor_site_id	*	*	No	Field not used.
OracleOUDesc	*	*	No	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OracleOUDesc

Tag Name	Table Name	Column Name	API Req	Description
OUDtlDesc	*	*	No	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:OUDtlDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
ou_id	org_unit_add_site	org_unit_id	Yes	The Oracle Financials org unit associated with this address.
site_id	org_unit_addr_site	oracle_vendor_site_id	Yes	The Oracle Financials site id associated with this address.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WHDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wh	wh	wh	Yes	The number which uniquely identifies the warehouse. The wh table stores all warehouses in the system, both virtual and physical.
wh_name	wh	wh_name	Yes	The name of the warehouse.
wh_add1	*	*	No	Field not used.
wh_add2	*	*	No	Field not used.
wh_city	*	*	No	Field not used.
county	*	*	No	Field not used.
state	*	*	No	Field not used.
country_id	*	*	No	Field not used.
wh_pcode	*	*	No	Field not used.
email	wh	email	No	The email address for the warehouse.
stockholding_ind	wh	stockholding_ind	Yes	Indicates if the warehouse is a stock holding location. In a non-multichannel environment, this will always be 'Y'. In a multichannel environment it will be 'N' for a physical warehouse and 'Y' for a virtual warehouse.
channel_id	wh	channel_id	No	The channel for which the virtual warehouse will be assigned.
currency_code	wh	currency_code	Yes	The code for the currency which the warehouse uses.
duns_number	wh	duns_number	No	The Dun and Bradstreet number tp identify the warehouse.
duns_loc	wh	duns_loc	No	The Dun and Bradstreet number to identify the location.
physical_wh	wh	physical_wh	Yes	The number of the physical warehouse corresponding to this warehouse.
break_pack_ind	wh	break_pack_ind	Yes	Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or 'N'
redist_wh_ind	wh	redist_wh_ind	Yes	Indicates whether the warehouse is a 'Re-Distribution' warehouse. Used as a location on Purchase Orders in place of actual locations that are unknown at the time of purchase order creation. Used by Redistribution report.
delivery_policy	wh	delivery_policy	Yes	The delivery policy of the warehouse. Next day indicates that the if a location is closed, the warehouse will deliver on the next day. Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day.
contact_person	*	*	No	Field not used.
dest_fax	*	*	No	Field not used.
phone_nbr	*	*	No	Field not used.
default_route	*	*	No	Field not used.
default_carrier_code	*	*	No	Field not used.
default_service_code	*	*	No	Field not used.
expedite_route	*	*	No	Field not used.
expedite_carrier_code	*	*	No	Field not used.
expedite_service_code	*	*	No	Field not used.
bol_upload_type	*	*	No	Field not used.
bol_print_type	*	*	No	Field not used.
lead_time	*	*	No	Always set to zero.
distance_to_dest	*	*	No	Always set to zero.
drop_trailers_accepted_flag	*	*	No	Field not used.
rcv_dock_available_flag	*	*	No	Field not used.
container_type	*	*	No	Field not used.
mld_default_route	*	*	No	Field not used.
unit_pick_container_type	*	*	No	Field not used.
dest_seq_nbr	*	*	No	Always set to zero.
owning_dc	*	*	No	Field not used.
AddrDesc	*	*	*	This is a child node; see layout below.
pricing_loc	wh_add	pricing_location	No	The location for which pricing info was copied for this warehouse.
pricing_loc_curr	wh_add	pricing_loc_curr	No	This is the currency code of the pricing location.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrDesc

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	Address unique identifier
addr_type	addr	addr_type	Yes	Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table.
primary_addr_type_ind	add_type_module	primary_ind	Yes	Y or N - indicates whether this address type is the primary address type.
primary_addr_ind	addr	primary_addr_ind	Yes	Indicates whether this address is the primary address for this address type
add_1	addr	add_1	Yes	Contains the first line of the address
add_2	addr	add_2	No	Contains the second line of the address
add_3	addr	add_3	No	Contains the third line of the address
city	addr	city	Yes	Contains the city of this address
state	addr	state	No	Contains the postal abbreviation for the state in which the warehouse is located.
country_id	addr	country_id	Yes	Contains the country code for this address.
post	addr	post	No	Contains the zip code for the address
contact_name	addr	contact_name	No	Contains the name of the contact for this address
contact_phone	addr	contact_phone	No	Contains the phone number of the contact for this address.
contact_telex	addr	contact_telex	No	Contains the telex number of the contact at this address.
contact_fax	addr	contact_fax	No	Contains the fax number of the contact at this address.
contact_email	addr	contact_email	No	Contains the email address of the contact at this address.
oracle_vendor_site_id	addr	oracle_vendor_site_id	No	The unique identifier of this address in the Oracle Financials systems, if used.
county	addr	county	No	The county of this address.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WHRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wh	wh	wh	Yes	The number of the warehouse for which data is being deleted.
AddrRef	*	*	No	This is a child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:AddrRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
addr	addr	addr_key	Yes	The key of the address being deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WODesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOHdr

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WODtl

RIB Mappings Report Release: 13.0.0

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

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOInDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	wo_head	wo_id	Yes	The unique identifier for work in process associated with an order or transfer.
order_no	wo_head	order_no	Yes	The order number associated with the work order.
WOInDtl	*	*	Yes	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOInDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	wo_detail	wh	Yes	The warehouse where the work order will be done.
item	wo_detail	item	Yes	The item on which the work order will be done.
loc_type	wo_detail	loc_type	Yes	The location type of the final destination location. Valid values are:'S' - Store or 'W' - Warehouse
location	wo_detail	location	Yes	The final destination of the merchandise. If the item is predistributed this location will be the store/warehouse on the allocation. If not, it will be the same warehouse as in the wh column.
seq_no	wo_detail	seq_no	Yes	The sequence number (needed to ensure each record is unique, since the same wip code can be listed more than once on the same work order).
wip_code	wo_detail	wip_code	Yes	The wip code for the work to be done on the item.
instructions	*	*	No	Not used by RMS.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOInRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	wo_head	wo_id	Yes	The work order for which deletion activity is occurring.
order_no	wo_head	order_no	Yes	Th order number associated with the work order.
WOInDtlRef	*	*	No	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOInDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
wh	wo_detail	wh	Yes	The warehouse of the work order.
item	wo_detail	item	Yes	The item of the work order.
loc_type	wo_detail	loc_type	Yes	The location type of the final destination location. Valid values are:'S' - Store 'W' - Warehouse
location	wo_detail	location	Yes	The final destination of the merchandise. If the item is predistributed this location will be the store/warehouse on the allocation. If not, it will be the same warehouse as in the wh column.
seq_no	wo_detail	seq_no	Yes	The sequence number.
wip_code	wo_detail	wip_code	Yes	The wip code which indicates the work to be done on the item.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	tsf-wo-head	tsf_wo_id	Yes	The work order number for this finishing activity.
dc_dest_id	tsfhead	from_loc	Yes	The 'from' location for tis transfer.
distro_nbr	tsfhead	tsf-no	Yes	The transfer that this work order is part of.
WOOutDtl	*	*	*	Child node - see below.
distro_parent_nbr	tsfhead	tsf-parent-no	No	The higher level transfer that this transfer belongs to.
WOOutXForm	*	*	*	Child node - see below.
WOOutPacking	*	*	*	Child node - see below.
inv_type	tsfhead	inventory_type	Yes	A code to indicate whether the inventory on the transfer is available. A = available; U = unavailable.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutDtl

Tag Name	Table Name	Column Name	API Req	Description
dest_id	tsfhead	to-loc	Yes	The 'to' location for this transfer.
item_id	tsf_wo_detail	item	Yes	The item for this portion of the work order.
wip_seq_nbr	*	*	No	Not used.
wip_code	*	*	No	Not used.
personalization	*	*	No	Not used.
instructions	*	*	No	Not used.
order_line_nbr	*	*	No	Not used.
auto_complete	*	*	No	Not used.
WOOutActivity	*	*	*	Child node - see below.
inv_status	tsfdetail	inv_status	No	The inventory status of the transfer detail.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutActivity

Tag Name	Table Name	Column Name	API Req	Description
activity_id	tsf_wo_detail	activity_id	No	A code number indicating the activity that will be performed on the item.
activity_cost	tsf_wo_detail	unit_cost	No	The per-unit cost of the finishing activity.
comments	tsf_wo_detail	comments	No	Any comments regarding this activity.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutXForm

Tag Name	Table Name	Column Name	API Req	Description
from_item	tsf_xform_detail	from_item	No	The original item on the transfer.
to_item	tsf_xform_detail	to_item	No	The item which will result from the finishing activity.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutPacking

Tag Name	Table Name	Column Name	API Req	Description
WOOutPackTo	*	*	*	Child node - see below.
WOOutPackFrom	*	*	*	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutPackTo

Tag Name	Table Name	Column Name	API Req	Description
to_item	tsf_packing_detail	item	Yes	The item resulting from the packing process.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutPackFrom

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
from_item	tsf_packing_detail	item	Yes	The item used in the packing process.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	tsf_wo_head	tsf_wo_id	Yes	The work order number.
dc_dest_id	tsfhead	from_loc	Yes	The 'from' location of the transfer.
distro_nbr	tsfhead	tsf_no	Yes	The transfer that this work order is part of.
WOOutDtlRef	*	*	*	Child node - see below.
distro_parent_nbr	tsfhead	tsf_parent_no	No	The higher level transfer that this transfer belongs to.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOOutDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
dest_id	tsfhead	to_loc	Yes	The 'to' location of the transfer.
item_id	tsf_wo_detail	item	Yes	The item for this portion of the work order.
wip_seq_nbr	*	*	No	Not used.
order_line_nbr	*	*	No	Not used.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WORef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item_id	*	*	*	*
wip_seq_nbr	*	*	*	*
order_line_nbr	*	*	*	*
dest_id	*	*	*	*
wo_id	wo_detail	wo_id	*	This column will hold the work order ID.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOStatusDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
wo_id	*	*	No	Not used.
distro_nbr	tsfhead	tsf_no	Yes	The transfer that this work order is part of.
distro_doc_type	*	*	Yes	The should be 'T' for transfer.
distro_parent_nbr	tsfhead	tsf_parent_no	No	The higher level transfer that this transfer is part of.
distro_parent_type	*	*	No	Not used.
item	tsfdetail	item	Yes	The item on which the work order has been completed. If an item transformation occurred, this should be the resultant item.
wh	*	*	No	Not used.
loc_type	*	*	No	Not used.
location	wh	wh	Yes	The warehouse that is the finisher location.
seq_no	*	*	No	Not used.
wip_code	*	*	No	Not used.
instructions	*	*	No	Not used.
complete_date	*	*	No	The date the work on the item was completed.
completed_qty	*	*	No	The quantity of the item on which work has been completed.
completed_ind	*	*	No	Not used.
WOStatusInvAdj	*	*	No	Child node that is not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:WOStatusInvAdj

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
from_disposition	*	*	No	This entire node is not used.
to_disposition	*	*	No	*
unit_qty	*	*	No	*

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XAllocDesc.xsd

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

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XAlloc

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	alloc_header	alloc_no	Yes	Contains the unique identifier of the Allocation. This field is not editable once the allocation is created in RMS. This should fall within the range of RMS ids already designated for allocations.
alloc_desc	alloc_header	alloc_desc	Yes	Contains the user defined description of the Allocation. This field is always editable.
order_no	alloc_header	order_no	No	Contains the purchase order with which the allocation is associated in order to perform a cross-dock allocation. This field is not editable once the allocation has been created in RMS.
item	alloc_header	item	Yes	Contains the transaction level item that is being allocated. This field is not editable once the allocation has been created in RMS.
from_loc	alloc_header	wh	Yes	Contains the location that is the source of the allocation. This must be a valid stockholding store or warehouse predefined in RMS. This field is not editable once the allocation has been created in RMS.
release_date	alloc_header	release_date	No	Contains the earliest date on which the warehouse should ship the allocation. This field is editable assuming that the warehouse has not yet started processing on the Allocation. This date cannot be in the past.
XAllocDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XAllocDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
to_loc	alloc_detail	to_loc	Yes	Contains the to location of the allocation. This must be an active store previously defined in RMS.
to_loc_type	alloc_detail	to_loc_type	Yes	Contains the location type of the to location. Since only stores can be allocated to, this value should always be 'S'.
qty_allocated	alloc_detail	qty_allocated	Yes	Contains the allocated quantity of the item to the to location. When the allocation is being created this value must be a positive integer. If this value is being modified, it will contain the quantity adjusted (positive or negative), rather than an override value.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XAllocRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
alloc_no	alloc_header	alloc_no	Yes	Contains the unique identifier of the Allocation. This should fall within the range of RMS ids already designated for allocations.
XAllocDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XAllocDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
to_loc	alloc_detail	to_loc	Yes	Contains the to location of the allocation. This must be an active store previously defined in RMS.
to_loc_type	alloc_detail	to_loc_type	Yes	Contains the location type of the to location. Since only stores can be allocated to, this value should always be 'S'.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XClearanceDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_loc	item	Yes	The item to which the markdown will apply. A valid item will have an item level at or above the transaction level if no diff is specified, or above the transaction level if a diff is specified. The item must be predefined in RMS.
diff_id	item_master	diff_1, diff_2, diff_3, diff_4	No	The diff id used with an item above transaction level item to group multiple items for the markdown. The diff must be valid for the item specified. This value must be a diff id, not a diff group.
selling_unit_retail	item_loc	selling_unit_retail	Yes	The unit retail of the markdown in the currency specified on the message.
selling_uom	item_loc	selling_uom	Yes	A unit of measure which is predefined in RMS.
currency_code	currencies	currency_code	No	The code of the currency in which the retail is represented. This currency must be predefined in the CURRENCIES table.
country	country	country_id	Yes	The code of the country used to limit the locations to which the markdown applies. This code must be predefined on the COUNTRY table.
hier_level	n/a	n/a	Yes	The level of the organizational hierarchy in which are the stores to which the markdown applies. Valid values are 'CH' chain, 'AR' area, 'RE' region, 'DI' district, 'S' store, and 'W' warehouse.
XClearanceHrDtl	*	*	*	*
XClearanceExcSt	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XClearanceHrDtl

Tag Name	Table Name	Column Name	API Req	Description
hier_value	chain, area, region, district, store, wh	chain, area, region, district, store, wh	Yes	The value at the specified level of the hierarchy which encompasses the locations affected by the markdown.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XClearanceExcSt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
exception_stores	store	store	Yes	The id of a store which will be excluded from the markdown. This field should be used only if the hier_level field indicates a level of the organizational hierarchy.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XCostChgDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_supp_country	item	Yes	The item to which the cost change applies. It can be a parent item, but its item level cannot be greater than its transaction level. This cannot be a buyer pack.
supplier	item_supp_country	supplier	Yes	The number of the supplier that sources the items the cost change affects. This value must be predefined on the SUPS table. This can be a primary or non-primary supplier.
origin_country_id	item_supp_country	origin_country_id	Yes	The identifier of the origin country of the item\supplier to which the cost change will apply. This value must be predefined on the COUNTRIES table. This can be the primary or a non-primary country.
diff_id	item_master	diff_1, diff_2, diff_3, diff_4	No	The identifier for a differentiator. This can be used with a parent or grandparent item. The cost change will "explode" to all the parent's transaction level items with the differentiator. This value must be predefined on the DIFF_IDS table.
unit_cost	item_supp_country	unit_cost	Yes	The new unit cost of the item in the currency specified on the message. Tables item_supp_country_loc, item_loc_soh, and ordloc can also be updated, depending on the values in tags hier_level and hier_value.
recalc_ord_ind	n/a	n/a	Yes	This field will indicate if orders in approved status for items on the cost change will be recalculated with the new cost. Valid values will be Y (yes) and N (no).
currency_code	currency	currency_code	Yes	The currency code of the unit cost. This value must be predefined on the CURRENCIES table and must be the currency of the supplier.
hier_level	n/a	n/a	No	The hierarchy level of the hierarchy value. This field will indicate the level of the organizational hierarchy to which the cost change applies. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse).
XCostChgHrDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XCostChgHrDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_value	chain, area, region, district, store, wh	chain, area, region, district, store, wh	Yes	The hierarchy value at the specified level of the hierarchy which encompasses the locations affected by the cost change.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffGrpDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_head	diff_group_id	Yes	A unique differentiator group identifier. This field cannot be modified once the differentiator is created.
diff_group_type	diff_group_head	diff_type	Yes	A differentiator type which is predefined on the DIFF_TYPE table. Each diff group is composed of one diff type. This field cannot be modified once the diff group is created.
diff_group_desc	diff_group_head	diff_group_desc	Yes	The description of the differentiator group.
create_datetime	diff_group_head	create_datetime	No	The date/time the differentiator group was created. If it is not populated on the message it will be defaulted to the time of creation in RMS. This value cannot be modified once the diff group is created.
XDiffGrpDtl	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffGrpDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_group_detail	diff_id	Yes	The identifier of the differentiator contained within the differentiator group. This id must be unique within the diff group. This must be populated when a diff group is being created since a diff group needs at least one diff id. Value must be predefined in the DIFF_IDS table.
display_seq	diff_group_detail	display_seq	No	The order in which the differentiators within the differentiator group are displayed on-line.
create_datetime	diff_group_detail	create_datetime	No	The date\time the differentiator was added to the differentiator group. This field will default to the time of creation in RMS if it is not populated on the message. This field will not be editable once the detail has been created.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffGrpRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
diff_group_id	diff_group_head	diff_group_id	Yes	A unique differentiator group identifier.
XDiffGrpDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffGrpDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_group_detail	diff_id	Yes	The identifier of the differentiator contained within the differentiator group. This id must be unique within the diff group. Value must be predefined in the DIFF_IDS table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffIDDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_ids	diff_id	Yes	The unique identifier of the differentiator. This field cannot be modified.
diff_type	diff_ids	diff_type	Yes	The identifier of the differentiator type. This value must be predefined on the DIFF_TYPE table. This field cannot be modified.
diff_desc	diff_ids	diff_desc	Yes	The description of the differentiator.
industry_code	diff_ids	industry_code	No	The unique reference number which represents all possible combinations of sizes according to the National Retail Federation.
industry_subcode	diff_ids	industry_subgroup	No	The unique reference number that represents color ranges.
create_datetime	diff_ids	create_datetime	No	The date/time the differentiator was created. If this field is not populated on the message it will default to the time of creation in RMS. This field cannot be modified.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XDiffIDRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
diff_id	diff_ids	diff_id	Yes	The unique identifier of the differentiator.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

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 Management System

Version 13.0.0

XML-Schema or Node Name:XItemImage

RIB Mappings Report Release: 13.0.0

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	*	*	*	*

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemLocDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_loc	item	Yes	The identifier for the item.
hier_level	*	*	Yes	The level of the organizational hierarchy to which the hier_value field pertains. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse).
XItemLocDtl	*	*	Yes	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemLocDtl

Tag Name	Table Name	Column Name	API Req	Description
hier_value	*	*	Yes	The same value as in the hier_level field.
primary_supp	item_loc	primary_supp	No	The primary supplier for the item at the location. If not populated on a create message this will default from the primary supplier on the ITEM_SUPPLIER table.
primary_cntry	item_loc	primary_cntry	No	The primary country for the item at the location. If not populated on a create message this will default from the primary country on the ITEM_SUPP_COUNTRY table.
local_item_desc	item_loc	local_item_desc	No	Local description for the item at the location. If not populated on the message this will default from the ITEM_MASTER table.
status	item_loc	status	Yes	The status of the item at the location. This value must be 'A' (active) on a create message. On a modify messge it can be 'I' (inactive), 'C' (discontinued), or 'D' (deleted).
store_ord_mult	item_loc	store_ord_mult	No	The unit type of the item shipped from the warehouse to the location. Valid values are C (cases), I (inners), and E (eaches). Eaches will default if left null on a create message.
receive_as_type	item_loc	receive_as_type	No	The unit in which the warehouse will receive goods. Valid values are E (eaches) and P (pack). This field only applies to buyer packs. If the item is not a buyer pack this field should be null.
taxable_ind	item_loc	taxable_ind	No	Indicates if the item is taxable at the location. Valid values are 'Y' and 'N'. If not populated on the message it will default to 'Y'.
ti	item_loc	ti	No	Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of cases for a pallet.
hi	item_loc	hi	No	Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of cases for a pallet.
daily_waste_pct	item_loc	daily_waste_pct	No	Average percentage lost from inventory on a daily basis due to natural wastage.
local_short_desc	item_loc	local_short_desc	No	The local short description of the item. Will default to the item's short description. Will be downloaded to the POS.
XItemLocTrt	*	*	*	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemLocTrt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
launch_date	item_loc_traits	launch_date	No	The date the item should first be sold at the location. Value will be downloaded to the POS. No internal processing occurs from this field.
qty_key_options	item_loc_traits	qty_key_options	No	Determines whether the qty key on a POS should be used for this item at the location. Valid values are in the code_type 'RPO'. Current values include 'R - required', 'P - Prohibited', and 'O - Optional'. Additional values can be added to the code type
manual_price_entry	item_loc_traits	manual_price_entry	No	Determines whether the price can/should be entered manually on a POS for this item at the location. Valid values are in the code_type 'RPO'. Current values include 'R - required', 'P - Prohibited', and 'O - Optional'. Additional values can be added.
deposit_code	item_loc_traits	deposit_code	No	Indicates whether a deposit is associated with this item at the location. Values are in the code_type 'DEPO'. The only processing in RMS is downloading it to the POS
food_stamp_ind	item_loc_traits	food_stamp_ind	No	Indicates whether the item is approved for food stamps at the location. This value will be downloaded to the POS.
wic_ind	item_loc_traits	wic_ind	No	Indicates whether the item is approved for WIC at the location. This value will be downloaded to the POS.
proportional_tare_pct	item_loc_traits	proportional_tare_pct	No	For items sold by weight, this is the proportion of the total weight of a unit of an item that is packaging.
fixed_tare_value	item_loc_traits	fixed_tare_value	No	Holds the weight of the packaging in items sold by weight at the location; i.e. if the tare item is bulk candy, this is weight of the bag and twist tie). The only processing RMS does is to download it to POS.
fixed_tare_uom	item_loc_traits	fixed_tare_uom	No	Holds the unit of measure value associated with the tare value. The only processing RMS does involving the fixed tare value and UOM is downloading it to the POS. Fixed tare is not subtracted from items sold by weight when sales are uploaded to RMS, etc
reward_eligible_ind	item_loc_traits	reward_eligible_ind	No	Holds whether the item is legally valid for various types of bonus point/award programs at the location. This value will be downloaded to the POS.
natl_brand_comp_item	item_loc_traits	natl_brand_comp_item	No	Holds the nationally branded item to which you would like to compare the current item. This nationally branded item must exist as an item in RMS (i.e. on the item_master table).
return_policy	item_loc_traits	return_policy	No	The return policy for the item at the location. Valid values are in the code_type 'RETP'. This value will be downloaded to the POS.
stop_sale_ind	item_loc_traits	stop_sale_ind	No	Indicates that sale of the item should be stopped immediately at the location (i.e. in case of recall etc). This value will be downloaded to the POS.
elect_mkt_clubs	item_loc_traits	elect_mtk_clubs	No	Code for the marketing clubs to which the item belongs at the location. Valid values are in the code_type 'MTKC'.
report_code	item_loc_traits	report_code	No	Code to determine which reports the location should run. Values are in the code type 'REPC'.
req_shelf_life_on_selection	item_loc_traits	req_shelf_life_on_selection	No	Holds the required shelf life for an item on selection in days. This field is not required. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it.
req_shelf_life_on_receipt	item_loc_traits	req_shelf_life_on_receipt	No	Holds the required shelf life for an item on receipt in days. This field is not required. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing
ib_shelf_life	item_loc_traits	ib_shelf_life	No	The Investment Buy-specific shelf life for the item/location
store_reorderable_ind	item_loc_traits	store_reorderable_ind	No	A code (Y or N) to indicate whether the store may re-order the item. Will default to N. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems.
rack_size	item_loc_traits	rack_size	No	Indicates the rack size that should be used for the item. Valid values for the field are in the code_type 'RACK'. No RMS processing is based on the value in this field. It is clients responsibility to communicate to external systems.
full_pallet_item	item_loc_traits	full_pallet_item	No	A code (Y or N) to indicate whether a store must reorder an item in full pallets only. Will default to N. No RMS processing is based on the value in this field. It is clients responsibility to communicate to external systems.
in_store_market_basket	item_loc_traits	in_store_market_basket	No	The in store market basket code for this item/location. Valid values for the field are in the code_type 'STMB'. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems.
storage_location	item_loc_traits	storage_location	No	Holds the current storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing.
alt_storage_location	item_loc_traits	alt_storage_location	No	Holds the preferred alternate storage location or bin number for the item at the location. No RMS processing is based on the value in this field. It is clients responsibility to communicate this value to external systems that may need it for processing
returnable_ind	item_loc_traits	returnable_ind	No	This field will contain a value of 'Y'es when the item can be returned to the location
refundable_ind	item_loc_traits	refundable_ind	No	This field will contain a value of 'Y'es when the item is refundable at the location.
back_order_ind	item_loc_traits	back_order_ind	No	This field will contain a value of 'Y'es when the item can be back ordered to the location
create_datetime	item_loc_traits	create_datetime	No	The the time and date of record creation.
last_update_id	item_loc_traits	last_update_id	No	The user id of the last user to update the record.
last_update_datetime	item_loc_traits	last_update_datetime	No	The time and date of the last update of the record.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemRclsDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
reclass_no	reclass_head	reclass_no	Yes	The unique number which identifies the reclass event.
reclass_desc	reclass_head	reclass_desc	Yes	The description of the reclass event.
reclass_date	reclass_head	reclass_date	Yes	The date on which the reclass event is scheduled to take place.
to_dept	reclass_head	to_dept	Yes	The department to which the item will belong after the reclass event.
to_class	reclass_head	to_class	Yes	The class to which the item will belong after the reclass event.
to_subclass	reclass_head	to_subclass	Yes	The subclass to which the item will belong after the reclass event.
XItemRclsDtl	*	*	Yes	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemRclsDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	reclass_item	item	Yes	The item in the reclass event.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemRclsRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
reclass_no	reclass_head	reclass_no	Yes	The reclass event for which deletion activity is occurring.
reclass_date	recass_head	reclass_date	No	The date of the reclass event.
purge_all_ind	*	*	No	If this field is 'Y', then all item reclass events for this reclass_no should be deleted.
XItemRclsDtl	*	*	No	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemRclsDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	reclass_item	item	Yes	The item of the reclass-item event which should be deleted

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_master	item	Yes	The unique identifier for the item.
hier_level	n/a	n/a	No	The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District
XItemSupRef	*	*	No	Child node.
XItemVATRef	*	*	No	Child node.
XItemImageRef	*	*	No	Child node that is not used.
XItemSeasonRef	*	*	No	Child node that is not used.
XItemUDARef	*	*	No	Child node that is not used.
XItemBOMRef	*	*	No	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemSupRef

Tag Name	Table Name	Column Name	API Req	Description
supplier	item_supplier	supplier	Yes	Item Supplier affected by the deletion activity.
delete_children_ind	*	*	Yes	Indicates whether the deletion should be applied to all associated item/supplier records below the item level of the item specified on the deletion message.
XItemSupCtyRef	*	*	No	Child node.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemSupCtyRef

Tag Name	Table Name	Column Name	API Req	Description
origin_country_id	item_supp_country	origin_country_id	Yes	The supplier country affected by the deletion activity.
XISCLocRef	*	*	No	Child node
XISCDimRef	*	*	No	Child node that is not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XISCLocRef

Tag Name	Table Name	Column Name	API Req	Description
hier_id	*	*	Yes	The id of the location hierarchy level affected by the message.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XISCDimRef

Tag Name	Table Name	Column Name	API Req	Description
dim_object	*	*	No	This node is not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemVATRef

Tag Name	Table Name	Column Name	API Req	Description
vat_type	vat_item	vat_type	Yes	The vat type of the vat item info to be deleted.
vat_region	vat_item	vat_region	Yes	The vat region of the vat item info to be deleted.
vat_code	vat_item	vat_code	Yes	The vat code of the vat item info to be deleted.
active_date	vat_item	active_date	Yes	The active date of the vat item info to be deleted.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemImageRef

Tag Name	Table Name	Column Name	API Req	Description
image_name	*	*	No	This node is not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemSeasonRef

Tag Name	Table Name	Column Name	API Req	Description
season_id	*	*	No	This node is not used.
phase_id	*	*	No	Not used.
diff_id	*	*	No	Not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemUDARef

Tag Name	Table Name	Column Name	API Req	Description
uda_id	*	*	No	This node is not used.
display_type	*	*	No	Not used.
uda_value	*	*	No	Not used.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XItemBOMRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
component_item	packitem	item	Yes	The pack item to be deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XLocTrtDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_trait_id	loc_traits	loc_trait	Yes	The unique id number of the location trait.
trait_desc	loc_traits	description	Yes	The description of the location trait.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XLocTrtRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_trait_id	loc_traits	loc_trait	Yes	The id number of the location trait being deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrClsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
class	class	class	Yes	The unique number of the class. This field cannot be modified.
class_name	class	class_name	Yes	The name of the class.
class_vat_ind	class	class_vat_ind	No	Indicates whether retail is displayed and held with or without VAT for items within the class. This field is available when VAT is on in the system and defined at the class level. Valid values are Y and N.
dept	class	dept	Yes	The number of the department which contains the class. This value must be predefined on the DEPS table. This value cannot be modified.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrClsRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
class	class	class	Yes	The unique number of the class.
dept	class	dept	Yes	The ID of the department which which contains the class.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrCompDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
company	comphead	company	Yes	The unique number which identifies the company for which the system is running. This value cannot be modified.
company_name	comphead	co_name	Yes	The name of the company for which the system is running.
add_1	comphead	co_add1	Yes	The first line of the company headquarters address.
add_2	comphead	co_add2	No	The second line of the company headquarters address.
add_3	comphead	co_add3	No	The third line of the company headquarters address.
city	comphead	co_city	Yes	The city the company headquarters.
state	comphead	co_state	No	The abbreviation of the state of the company headquarters. This value must be predefined on the STATE table.
country_code	comphead	co_country	Yes	The abbreviation of the country of the company headquarters. This value must be predefined on the COUNTRY table.
postal_code	comphead	co_post	No	The postal zip code of the company headquarters.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrDeptDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
dept	deps	dept	Yes	The number which uniquely identifies the department. This value cannot be modified.
dept_name	deps	dept_name	Yes	The name of the department.
buyer	deps	buyer	No	The number of the buyer associated to the department. This value must be predefined on the BUYER table.
purchase_type	deps	purchase_type	Yes	The code which indicates whether items in this department are normal merchandise (0) or consignment stock (1). This field cannot be modified.
total_market_amt	deps	total_market_amt	No	The total market amount that is expected for the department. This value cannot be less than 1000.
merch	deps	merch	No	The number of the merchandiser that is associated to the department. This value must be predefined on the MERCHANT table.
group_no	deps	group_no	Yes	The number of the group to which the department belongs. This value must be predefined on the GROUPS table.
bud_mkup	deps	bud_mkup	No	The budgeted markup percentage. The markup percent of cost. If this value is not populated on the message it will be calculated to be the inverse of the budgeted intake percentage. This column will hold 70% as 70, not .70.
profit_calc_type	deps	profit_calc_type	Yes	The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This value cannot be modified.
markup_calc_type	deps	markup_calc_type	Yes	The code letter that indicates how markup is calculated in this department. Valid values are cost (C) and retail (R).
otb_calc_type	deps	otb_calc_type	Yes	The code letter which indicates how OTB is calculated for this department. Valid values are cost (C) and retail (R). This value cannot be modified.
max_avg_counter	deps	max_avg_counter	No	The maximum count of days with acceptable data to include in an average for items within the department. This value is required if RPM is installed.
avg_tolerance_pct	deps	avg_tolerance_pct	No	The tolerance percentage value used in averaging for items within this value. This column will hold 70% as 70, not .70. This value is required if RPM is installed.
bud_int	deps	bud_int	No	The budgeted intake percentage. The percent of the total take that is income. If this field is not populated on the message it will be calculated as the inverse of the budgeted markup percentage. This column will hold 70% as 70, not .70.
XMrchHrDeptVAT	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrDeptVAT

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
vat_region	vat_deps	vat_region	Yes	The number of the VAT region to which this department is associated. This value must be predefined on the VAT_REGION table.
vat_code	vat_deps	vat_code	Yes	The alphanumeric identifier of the VAT code. This value must be predefined on the VAT_CODES table.
vat_type	vat_deps	vat_type	Yes	Indicates if the VAT rate is used for purchasing (C), selling (R), or both (B).

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrDeptRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
dept	deps	dept	Yes	The number which uniquely identifies the department.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrDivDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
division	division	division	Yes	The unique identifier of the division. This field cannot be modified.
div_name	division	div_name	Yes	The name of the division.
merch	division	merch	No	The number of the merchant associated with the division. This value must be predefined on the MERCHANT table.
buyer	division	buyer	No	The number of the buyer associated with the division. This value must be predefined on the BUYER table.
total_market_amt	division	total_market_amt	No	The total market amount that is expected for the division. If this field is not null it must be at least 1000.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrDivRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
division	division	division	Yes	The unique identifier of the division.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrGrpDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
group_no	groups	group_no	Yes	The number which uniquely identifies the group. This field cannot be modified.
group_name	groups	group_name	Yes	The name of the group.
division	groups	division	Yes	The identifier of the division of which the group is a member. This value must be predefined on the DIVISION table.
merch	groups	merch	No	The number of the merchandiser associated to the group. This value must be predefined on the MERCHANT table.
buyer	groups	buyer	No	The number of the buyer associated to the group. This value must be predefined on the BUYER table.
group_no	groups	group_no	Yes	The number which uniquely identifies the group. This field cannot be modified.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrRclsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
merch_hier_level	pend_merch_hier	hier_type	Yes	Indicates the level of the merchandise hierarchy. Valid values are V (division), G (group), D (department), C (class), and S (subclass).
merch_hier_id	pend_merch_hier	merch_hier_id	Yes	Contains the merchandise hierarchy ID.
merch_hier_parent_id	pend_merch_hier	merch_hier_parent_id	No	The parent of the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id	pend_merch_hier	merch_hier_grandparent_id	No	The grandparent of the hierarchy identified in the merch_hier_id field. This field will only be used when the hierarchy level indicates subclass. It will contain the number of the department the subclass belongs to.
merch_hier_name	pend_merch_hier	merch_hier_name	Yes	The name of the hierarchy value.
effective_date	pend_merch_hier	effective_date	Yes	The date the hierarchy change will become effective.
action_type	pend_merch_hier	action_type	No	Indicates if this field is an addition or modification. Valid values are A and M. It is required on a create message and should not be populated on a modify message.
buyer	pend_merch_hier	buyer	No	The number of the buyer associated with the entity. This value must be predefined on the BUYER table. This field should only hold a value if the hierarchy level indicates division, group, or department.
purchase_type	pend_merch_hier	purchase_type	No	The code which indicates whether items in the department are normal merchandise (0) or consignment stock (1). This field will only be used if the hierarchy level indicates department.
total_market_amt	pend_merch_hier	total_market_amt	No	The total market amount that is expected for the entity. This field will only be used if the hierarchy value indicates division or department.
merch	pend_merch_hier	merch	No	The number of the merchandiser associated with the entity. This value must be predefined on the MERCHANT table. This field should hold a value only if the hierarchy level indicates division, group, or department.
bud_mkup	pend_merch_hier	bud_mkup	No	The budgeted markup percentage. The markup percent of cost. This field will only be used if the hierarchy level indicates department.
profit_calc_type	pend_merch_hier	profit_calc_type	No	The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This field will only be used if the hierarchy level indicates department.
markup_calc_type	pend_merch_hier	markup_calc_type	No	The code letter which indicates how markup is calculated in the department. This field will only be used if the hierarchy level indicates department. Valid values are C (cost) and R (retail).
otb_calc_type	pend_merch_hier	otb_calc_type	No	The code letter which indicates how OTB is calculated in the department. Valid values are cost (C) and retail (R). This field will only be used if the hierarchy value indicates department.
max_avg_counter	pend_merch_hier	max_avg_counter	No	The maximum count of days with acceptable data to include in an average for items with the department. This field will only be used if the hierarchy level indicates department. It is required if RPM is installed.
avg_tolerance_pct	pend_merch_hier	avg_tolerance_pct	No	The tolerance percentage value used in averaging for items within this value. This column will hold 70% as 70, not .70. This field will only be used if the hierarchy value indicates department. It is required if RPM is installed.
bud_int	pend_merch_hier	bud_int	No	The budgeted intake percentage. The percent of the total take that is income. This field will only be used if the hierarchy value indicates department.
dept_vat_incl_ind	pend_merch_hier	dept_vat_incl_ind	No	Indicates the default value for the class VAT indicator. When classes are initially set up they will inherit this value. This field will only be populated when the hierarchy level indicates department.
class_vat_ind	pend_merch_hier	class_vat_ind	No	Indicates if retail is displayed and held with or without VAT for items within a class. Valid values are Y (yes) and N (no). This field will only be used if the hierarchy level indicates class.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrRclsRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
merch_hier_level	pend_merch_hier	hier_type	Yes	Indicates the level of the merchandise hierarchy. Valid values are V (division), G (group), D (department), C (class), and S (subclass).
merch_hier_id	pend_merch_hier	merch_hier_id	Yes	Contains the merchandise hierarchy ID.
merch_hier_parent_id	pend_merch_hier	hier_parent_id	No	The parent of the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id	pend_merch_hier	merch_hier_grandparent_id	No	The grandparent of the hierarchy identified in the merch_hier_id field. This column will only be populated if the merch_hier_level = subclass. In this case, the column will contain the dept number.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrSclsDesc.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
subclass	subclass	subclass	Yes	The unique number which identifies the subclass. This value cannot be modified.
subclass_name	subclass	subclass_name	Yes	The name of the subclass.
class	subclass	class	Yes	The number of the class which contains the subclass. This value must be predefined on the CLASS table. This value cannot be modified.
dept	subclass	dept	Yes	The number of the department which contains the subclass. This value must be predefined on the DEPS table. This value cannot be modified.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XMrchHrSclsRef.xsd

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
subclass	subclass	subclass	Yes	The unique number which identifies the subclass.
class	subclass	class	Yes	The number of the class which contains the subclass. This value must be predefined on the CLASS table.
dept	subclass	dept	Yes	The number of the department which contains the subclass. This value must be predefined on the DEPS table.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrderDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
order_no	ordhead	order_no	Yes	The unique identifier for the order.
supplier	ordhead	supplier	Yes	The identifier of the supplier from which the order will be sourced. This cannot be modified if details exist for the PO.
currency_code	ordhead	currency_code	No	The code of the order's currency. If not populated, the supplier's currency will be used. This field can be modified if the order status is worksheet or approved and the order has not been shipped.
terms	ordhead	terms	No	The sales terms of the order. If not populated on the create message, will default to the supplier's terms. This can be modified in worksheet or approved status.
not_before_date	ordhead	not_before_date	No	The first date that delivery will be accepted. This can be modified in worksheet or approved status.
not_after_date	ordhead	not_after_date	No	The last date that delivery will be accepted. This can be modified in worksheet or approved status.
otb_eow_date	ordhead	otb_eow_date	No	The end of week date of the OTB bucket used. This can be modified in worksheet or approved status.
dept	ordhead	dept	No	The department in which are all the items on the order. This field is required if the system enforces single department ordering. This cannot be modified if details exist for the PO.
status	ordhead	status	No	The code for the status of the order. Valid values are 'W' worksheet and 'A' approved for PO creation. It is also possible to modify the status to 'C' closed.
exchange_rate	ordhead	exchange_rate	No	The rate of exchange for the PO used between the order and primary currencies. This field can be modified if the order status is worksheet or approved and the order has not been shipped..
include_on_ord_ind	ordhead	include_on_ord_ind	No	Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status.
written_date	ordhead	written_date	No	The date the order was created. If this field is not populated on the message it will default to the time of creation in RMS. It cannot be modified.
XOrderDtl	*	*	*	*
orig_ind	ordhead	orig_ind	Yes	Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8.
edi_po_ind	ordhead	edi_po_ind	No	Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are: Y = Submit via EDI, N = Do not use EDI.
pre_mark_ind	ordhead	pre_marked_ind	No	This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores.
user_id	ordhead	orig_approval_id	No	Indicates where the order was approved. It will be the user ID of the person approving the order.
comment_desc	ordhead	comment_desc	No	Any comments pertaining to the order.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrderDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	ordsku	item	No	An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). This is required if the ref_item field is not populated.An item/location may be added to the order in worksheet or approved status.
location	ordloc	location	Yes	An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. An item/location may be added to the order in worksheet or approved status.
unit_cost	ordloc	unit_cost	No	The cost of the item from the supplier in the order's currency. This can be modified if the status is worksheet or approved, but not if any portion of the item's order quantity is in transit or has been received. If it is not specified on the message, it will default from the item supplier cost for this location.
ref_item	ordsku	ref_item	No	The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required. A ref item/location may be added to the order in worksheet or approved status.
origin_country_id	ordsku	origin_country_id	No	The identifier of the country from which the item is being sourced. This field cannot be modified.
supp_pack_size	ordsku	supp_pack_size	No	The supplier pack size for the item on the order. This may be updated in worksheet or approved status.
qty_ordered	ordloc	qty_ordered	Yes	The quantity ordered of item. This can be updated in worksheet or approved status to adjust the quantity of an item/location or cancel an item/location from the order.
location_type	ordloc	location_type	Yes	The location type of the location. Valid values are 'S' store and 'W' warehouse. This field cannot be modified.
cancel_ind	n/a	n/a	No	Indicates if the detail record's quantity should be cancelled. Valid values are 'Y'es and 'N'o.
reinstate_ind	n/a	n/a	No	Indicates if a detail record which was previously cancelled should be reinstated. This will reinstate in the order quantity the amount in the cancelled bucket. Valid values are 'Y'es and 'N'o.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrderRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
order_no	ordhead	order_no	Yes	The unique identifier for the order.
XOrderDtlRef	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrderDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	ordsku	item	No	An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P').
location	ordloc	location	Yes	An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected.
ref_item	ordsku	ref_item	No	The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrgHrDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
hier_value	chain, area, region, district	chain, area, region, district	Yes	The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level. It cannot be modified.
hier_desc	chain, area, region, district	chain_name, area_name, region_name, district_name	Yes	The description of the hierarchy value.
hier_level	n/a	n/a	Yes	Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district).
parent_id	chain, area, region	chain, area, region	No	The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on either the CHAIN, AREA or REGION table.
mgr_name	chain, area, region, district	mgr_name	No	The manager name of the hierarchy value.
currency_code	chain, area, region, district	currency_code	No	The code which identifies the currency under which the hierarchy value operates. This value must be predefined on the CURRENCIES table.
XOrgHrLocTrt	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrgHrLocTrt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_trait_id	loc_area_traits, loc_region_traits, loc_district_traits	loc_trait	Yes	The location trait associated to the hierarchy value. This value must be predefined on LOC_TRAITS table. A location trait cannot be associated with (or deleted from) a chain.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrgHrRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
hier_value	chain, area, region, district	chain, area, region, district	Yes	The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level.
hier_level	n/a	n/a	Yes	Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district).
XOrgHrLocTrt	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XOrgHrLocTrt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
hier_trait_id	loc_area_traits, loc_region_traits, loc_district_traits	loc_trait	Yes	The location trait associated to the hierarchy value. This value must be predefined on LOC_TRAITS table. A location trait cannot be associated with (or deleted from) a chain.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XPriceChgDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
item	item_zone_price	item	Yes	The item to which the price change will apply. The item level of the item should be at or above the transaction level if no diff is specified, or above the transaction level if a diff is specified.
diff_id	item_master	diff_1, diff_2, diff_3, diff_4	No	The diff id used with an above transaction level item to group multiple items for the price change. The diff must be valid for the item specified. This value must be a diff id, not a diff group.
selling_unit_retail	item_zone_price	selling_unit_retail	No	The unit retail of the price change in the currency specified on the message. If multi unit retail is not populated, this is required.
selling_uom	item_zone_price	selling_uom	No	A unit of measure which is predefined in RMS.
multi_units	item_zone_price	multi_units	No	The number of units for the multi unit price change. This field is required for a multi unit price change.
multi_unit_retail	item_zone_price	multi_unit_retail	No	The multi unit retail in the currency specified on the message. This field is required for a multi unit price change. If single unit retail is not populated, this is required.
multi_selling_uom	item_zone_price	multi_selling_uom	No	The unit of measure for the item's multi-unit retail. This value must be predefined in RMS. This field is required for a multi unit price change.
currency_code	currencies	currency_code	Yes	The code of the currency in which the retail is represented. This currency must be predefined in the CURRENCIES table.
country	country	country_id	No	The code of the country used to limit the locations to which the price change applies. This code must be predefined on the COUNTRY table.
hier_level	n/a	n/a	Yes	The level of the organizational hierarchy in which are the stores to which the price change applies. Valid values are 'CH' chain, 'AR' area, 'RE' region, 'DI' district, 'S' store, and 'W' warehouse.
XPriceChgHrDtl	*	*	*	*
XPriceChgExcSt	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XPriceChgHrDtl

Tag Name	Table Name	Column Name	API Req	Description
hier_value	chain, area, region, district, store, wh	chain, area, region, district, store, wh	Yes	The ID of the specified level of the hierarchy which encompasses the locations affected by the price change.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XPriceChgExcSt

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
exception_stores	store	store	Yes	The id of a store which will be EXCLUDED from the price change. This field should be used only if the hier_level field indicates a level of the organizational hierarchy.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
store	store	store	Yes	The unique identifier of the store.
store_name	store	store_name	Yes	The name of the store.
store_name10	store	store_name10	No	The ten character abbreviation of the store name.
store_name3	store	store_name3	No	The three character abbreviation of the store name.
store_add1	addr	add1	Yes	The first line of the store's address.
store_add2	addr	add2	No	The second line of the store's address.
store_city	addr	city	Yes	The city in which the store is located.
state	addr	state	No	The postal abbreviation of the state in which the store is located. This value must be predefined on the STATE table.
country_id	addr	country_id	Yes	The identifier of the country in which the store is located. This value must be predefined in the COUNTRY table.
store_pcode	addr	post	No	The postal zip code for the store.
store_class	store	store_class	Yes	The code of the class of which the store is a member.
store_mgr_name	store	store_mgr_name	Yes	The name of the store manager.
store_open_date	store	store_open_date	Yes	The date on which the store opened.
store_close_date	store	store_close_date	No	The date on which the store closed.
acquired_date	store	acquired_date	No	The date on which the store was acquired.
remodel_date	store	remodel_date	No	The date on which the store was remodeled.
fax_number	store	fax_number	No	The fax number of the store.
phone_number	store	phone_number	No	The store's phone number.
email	store	email	No	The email address of the store.
total_square_ft	store	total_square_ft	No	The total square footage of the store.
selling_square_ft	store	selling_square_ft	No	The total square footage of the store's selling area.
linear_distance	store	linear_distance	No	The total merchandise space of the store.
stockholding_ind	store	stockholding_ind	Yes	Indicates if the store can hold stock. This field cannot be modified.
channel_id	store	channel_id	No	The identifier of the channel. This value must be predefined on the CHANNELS table. In a multichannel environment this field is required.
store_format	store	store_format	No	The code of the store format of the store. This value must be predefined on the STORE_FORMAT table.
mall_name	store	mall_name	No	The name of the mall in which the store is located.
district	store	district	Yes	The number of the district of which the store is a member. This value must be predefined on the DISTRICT table.
promo_zone	*	*	No	Field not used.
transfer_zone	store	transfer_zone	No	The transfer zone in which the store is located. This value must be predefined on the TSFZONE table.
default_wh	store	default_wh	No	The default warehouse for the store. This value must be predefined on the WH table.
stop_order_days	store	stop_order_days	No	The number of days before the store close date that the store will stop accepting orders.
start_order_days	store	start_order_days	Yes	The number of days before the store open date that the store will begin accepting orders.
currency_code	store	currency_code	Yes	The code of the currency under which the store operates. This value must be predefined on the CURRENCIES table. It cannot be modified.
lang	store	lang	No	The code of the language used at the store. This value must be predefined on the LANG table.
iso_code	store	iso_code	No	The character code corresponding to the Language used at the store
integrated_pos_ind	store	integrated_pos_ind	Yes	Indicates whether the store's POS is integrated.
duns_number	store	duns_number	No	The Dun and Bradstreet number to identify the store.
duns_loc	store	duns_loc	No	The Dun and Bradstreet number to identify the location.
copy_dlvry_ind	store	copy_dlvry_ind	No	Indicates if the like store's delivery schedule information should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
copy_activity_ind	store	copy_activity_ind	No	Indicates if the like store's closing date schedule should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
price_store	store	price_store	No	The store from which pricing information will be copied to the new store. The pricing store does not need the same currency as the new store. This value is not required on a create message and should not be populated on a modify message.
cost_location	store	cost_location	No	The location from which to copy cost information to the new store. This field should only be populated on store create messages. This value must be predefined on the WH or STORE table. This value cannot be modified.
vat_include_ind	store	vat_include_ind	No	Indicates whether retail prices for the store will contain VAT.
vat_region	store	vat_region	No	The vat region of which the store is a part. This value must be predefined on the VAT_REGION table. It is required if VAT is on in the system.
like_store	store	like_store	No	The store from which the new store will have item\locations copied. This value must be predefined on the STORE table. It cannot be modified and will only be populated on a create message.
copy_repl_ind	store	copy_repl_ind	No	Indicates whether replenishment information should be copied from the like store to the new store. This field cannot be modified. It will only be populated on a store create message.
transfer_entity	store	tsf_entity_id	No	The transfer entity of which the store is a part. This value must be predefined on the TSF_ENTITY table. If the system allows intercompany transfers this field is required.
sister_store	store	sister_store	No	The store which will be used to relate historical data to the new store. This value must be predefined on the STORE table.
tran_no_generated	store	tran_no_generated	Yes	The level at which unique POS transaction numbers are generated.
addr_change	*	*	No	Field not used.
county	addr	county	No	The county in which the store is located.
XStoreLocTrt	*	*	No	This is a child node - see below.
XStoreWT	*	*	No	This is a child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreLocTrt

Tag Name	Table Name	Column Name	API Req	Description
loc_trait	loc_traits	loc_trait	Yes	The identifier of the location trait. Though the node is optional, this field is required if the node is included. The node can not be populated on the store create message.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreWT

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
walk_through_store	walk_through_store	walk_through_store	Yes	A walk through store of the store being modified. Though the node is optional, if it is included this field is required. This node can not be populated on a store create message.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
store	store	store	Yes	The store number being deleted, or for which a location trait or walk through store is being disassociated.
XStoreLocTrt	*	*	No	See layout below.
XStoreWT	*	*	No	See layout below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreLocTrt

Tag Name	Table Name	Column Name	API Req	Description
loc_trait	loc_traits_matrix	loc_trait	Yes	The location trait to be disassociated from this store.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XStoreWT

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
walk_through_store	walk_through_store	walk_through_store	Yes	The store to be removed as a walk through store for this store.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XTsfDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
tsf_no	tsfhead	tsf_no	Yes	Number that uniquely identifies the transfer.
from_loc_type	tsfhead	from_loc_type	Yes	The location type of the from location.
from_loc	tsfhead	from_loc	Yes	The location number of the from location.
to_loc_type	tsfhead	to_loc_type	Yes	The location type of the to location.
to_loc	tsfhead	to_loc	Yes	The location number of the to location.
delivery_date	tsfhead	delivery_date	No	The earliest date the transfer can be delivered.
dept	tsfhead	dept	No	The department number associated with the transfer.
routing_code	tsfhead	routing_code	No	If the freight status is expedite, this is a code indicating more detailed freight info.
freight_code	tsfhead	freight_code	No	A code indicating the freight status of the transfer (e.g. normal, expedite, etc.).
tsf_type	tsfhead	tsf_type	No	A code indicating the type of transfer (e.g. store requisition, book transfer, etc.).
XTsfDtl	*	*	*	Child node - see layout below.
status	tsfhead	status	No	A code indicating the status of the transfer (e.g. approved, closed, etc.).
user_id	tsfhead	create_id	No	The userid of the user who created the transfer.
comment_desc	tsfhead	comment_desc	No	Comments associated with the transfer.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XTsfDtl

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	tsfdetail	item	Yes	The unique identifier of the item being transferred.
tsf_qty	tsfdetail	tsf_qty	Yes	The total quantity of the item reserved for this transfer at the from location.
supp_pack_size	tsfdetail	supp_pack_size	No	The supplier pack size for this item/transfer.
inv_status	tsfdetail	inv_status	No	A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table.
unit_cost	*	*	No	Not mapped to a database field. Sometimes used to calculate retail price.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XTsfRef.xsd

Tag Name	Table Name	Column Name	API Req	Description
tsf_no	tsfhead	tsf_no	Yes	The transfer number where info is being deleted.
XTsfDtlRef	*	*	No	Child node - see below.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XTsfDtlRef

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
item	tsfdetail	item	Yes	The item for which transfer info is being deleted.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDADesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda	uda_id	Yes	This field contains a unique number identifying the User Defined Attribute.
uda_desc	uda	uda_desc	Yes	This field contains a description of the User-Defined Attribute.
module	uda	module	Yes	This field identifies which module the UDA belongs to. Valid values are:ITEM
display_type	uda	display_type	Yes	This field is used to store the display type (how the UDA values will be displayed to the user) for the given UDA.
data_type	uda	data_type	Yes	This field contains the data type of any valid values for the UDA. This is an optional field used only if specific processing is needed to validate the data type of the UDA values. Valid values are:NUMBERALPHANUMERICDATE
data_length	uda	data_length	Yes	This field contains the data length of any valid values for the UDA. This is an optional field used only if specific processing is needed to validate the data length of the UDA values.
single_value_ind	uda	single_value_ind	Yes	This field indicates whether or not the UDA should be constrained to having at most one value when assigned to a specific module.
XUDAValue	*	*	*	*
XUDADefault	*	*	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDAValue

Tag Name	Table Name	Column Name	API Req	Description
uda_value	uda_values	uda_values	Yes	Specifies the unique UDA value.
uda_value_desc	uda_values	uda_value_desc	Yes	The description of the UDA.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDADefault

RIB Mappings Report Release: 13.0.0

Tag Name	Table Name	Column Name	API Req	Description
seq_no	uda_item_defaults	seq_no	No	Indicates the order in which the criteria should be applied.
dept	uda_item_defaults	dept	No	Contains the department for which the default is set up.
class	uda_item_defaults	class	No	Contains the class for which the default is set up.
subclass	uda_item_defaults	subclass	No	Contains the subclass for which the default is set up.
uda_value	uda_item_defaults	uda_value	No	Specifiies the default uda value.
required_ind	uda_item_defaults	required_ind	No	Specifies whether the attribute is required.
hierarchy_value	uda_item_defaults	hierarchy_value	No	Specifies which hierarchy is being defaulted. 1 - Department, 2 - Class, 3 - Subclass.

Retail Integration Bus Mappings Report Release: 13.0.0

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDARef.xsd

Tag Name	Table Name	Column Name	API Req	Description
uda_id	uda	uda_id	Yes	This field contains a unique number identifying the User Defined Attribute.
XUDAValueRef	*	*
XUDADefaultRef	*	*

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDAValueRef

Tag Name	Table Name	Column Name	API Req	Description
uda_value	uda_values	uda_values	Yes	Specifies the unique UDA value.

Application Name: Retail Management System

Version 13.0.0

XML-Schema or Node Name:XUDADefaultRef

Tag Name	Table Name	Column Name	API Req	Description
seq_no	uda_item_defaults	seq_no	No	Indicates the order in which the criteria should be applied.
dept	uda_item_defaults	dept	No	Contains the department for which the default is set up.
class	uda_item_defaults	class	No	Contains the class for which the default is set up.
subclass	uda_item_defaults	subclass	No	Contains the subclass for which the default is set up.