Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:InvReqDesc Version:13.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 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 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 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