Retail Integration Bus Mappings Report Release:13.2.0 (Store Inventory Management)
Application Store Inventory Management
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 sim Mapping For InvReqDesc
Table Name Column Name API Type Column Length API Required API Description
request_id number10 1 1 Not used by RMS. RK_ITEM_REQUEST ITEM_REQUEST_ID VARCHAR2 128 Yes An identifier for the inventory request.
store number10 1 1 The store ID which is requesting the item. RK_ITEM_REQUEST STORE_ID NUMBER 10 Yes The 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 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 sim 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. RK_ITEM_REQUEST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Unique alphanumeric value that identifies the item requested.
qty_rqst number12_4 1 1 The quantity for the item being requested. This field is stored in the standard unit of measure. RK_ITEM_REQUEST_LINE_ITEM QUANTITY NUMBER 20 No The quantity of the item being requested.
uop varchar26 1 1 Unit of Purchase - used for conversion, since NEED_QTY is being stored in the standard unit of measure. n/a n/a null null Yes Unit of Purchase. Used for conversion.
need_date xs:dateTime 1 1 The date that the store needs the item by. RK_ITEM_REQUEST REQ_DELIVERY_DATE DATE null No The date by which the store needs the item.
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 sim 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 sim 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 sim 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 sim 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