Retail Integration Bus Mappings Report

Application Name: Retail Merchandising System

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

XML-Schema or Node Name:InvReqItem

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.