Retail Integration Bus Mappings Report Release:13.1 (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.1 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 REQUEST_ID null null Yes An identifier which represents the inventory request
store number10 1 1 The store ID which is requesting the item. RK_ITEM_REQUEST STORE_ID 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 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 null null 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. RK_ITEM_REQUEST_LINE_ITEM QUANTITY null null Yes The quantity for 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 null null 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 sim 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 sim Mapping For ExtOfInvReqDesc
Table Name Column Name API Type Column Length API Required API Description