Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising System
Target Name Space	http://www.oracle.com/retail/integration/base/bo/InvReqDesc/v1
Version	1.0
Description	This is root element of this document which contains name space definitions for the document elements.
	InvReqDesc InvReqItem ExtOfInvReqItem ExtOfInvReqDesc

XML-Schema Name:InvReqDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For InvReqDesc
					Table Name	Column Name	API Type	Column Length	API Required	API Description
request_id	number10	1	1	Not used by RMS.	n/a	n/a	null	null	Yes	Not used by RMS.
store	number10	1	1	The store ID which is requesting the item.	store_orders	store	null	null	Yes	The store ID which is requesting the item.
request_type	varchar22	1	1	Defines the request type. Valid values are - 'IR' (inventory request) and 'SO' (store order).	n/a	n/a	null	null	Yes	Defines the request type. Valid values are - 'IR' (inventory request) and 'SO' (store order).
InvReqItem	*	1	unbounded	Description is not available.
ExtOfInvReqDesc:ExtOfInvReqDesc	*	0	1	Provide an extension hook to customize InvReqDesc.	NA	NA	NA	NA	NA	NA

XML-Schema Name:InvReqItem

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For InvReqItem
					Table Name	Column Name	API Type	Column Length	API Required	API Description
item	varchar225	1	1	Unique alphanumeric value that identifies the item to be requested.	store_orders	item	xs:string	*	Yes	Unique alphanumeric value that identifies the item to be requested.
qty_rqst	number12_4	1	1	The quantity for the item being requested. This field is stored in the standard unit of measure.	store_orders	need_qty	xs:string	*	Yes	The quantity for the item being requested. This field is stored in the standard unit of measure.
uop	varchar26	1	1	Unit of Purchase - used for conversion, since NEED_QTY is being stored in the standard unit of measure.	uom_class	uom	xs:string	*	Yes	Unit of Purchase - used for conversion, since NEED_QTY is being stored in the standard unit of measure.
need_date	xs:dateTime	1	1	The date that the store needs the item by.	store_orders	need_date	RIBDate	*	Yes	The date that the store needs the item by.
delivery_slot_id	varchar215	0	1	Delivery Slot Id.	NA	NA	NA	NA	NA	NA
ExtOfInvReqDesc:ExtOfInvReqItem	*	0	1	Provide an extension hook to customize InvReqItem.	NA	NA	NA	NA	NA	NA

XML-Schema Name:ExtOfInvReqItem

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfInvReqItem
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:ExtOfInvReqDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfInvReqDesc
					Table Name	Column Name	API Type	Column Length	API Required	API Description