Retail Integration Bus Mappings Report Release:13.2.0 (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.2.0 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 of the store 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
LocOfInvReqDesc:LocOfInvReqDesc * 0 1 Provide an extension hook to localize InvReqDesc. NA NA NA NA NA NA

XML-Schema Name:InvReqItem Version:13.2.0 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. string store_orders xs item 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. string store_orders xs need_qty 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. string uom_class xs uom Unit of Purchase. Used for conversion, because NEED_QTY is 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
LocOfInvReqDesc:LocOfInvReqItem * 0 1 Provide an extension hook to localize InvReqItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfInvReqItem Version:13.2.0 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:LocOfInvReqItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfInvReqItem
Table Name Column Name API Type Column Length API Required API Description
InInvReqDesc:InInvReqItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrInvReqDesc:BrInvReqItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfInvReqDesc Version:13.2.0 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

XML-Schema Name:LocOfInvReqDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfInvReqDesc
Table Name Column Name API Type Column Length API Required API Description
InInvReqDesc:InInvReqDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrInvReqDesc:BrInvReqDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA