Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:InvReqDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvReqDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
request_id number10 1 1 Used to build an error record when necessary. ITEM_REQUEST ID NUMBER 12,0 Yes the unique identifier of item request. this is generated by the system.
store number10 1 1 The store ID which is requesting the item. ITEM_REQUEST STORE_ID NUMBER 10,0 Yes the unique identifier of the store that is requesting the items.
request_type varchar22 1 1 Defines the request type. Valid values are - 'IR' (inventory request) and 'SO' (store order). n/a n/a null Fill column length. Yes Defines the request type. Valid values are IR (Inventory Request) and SO (Store Order).
InvReqItem * 1 unbounded Description is not available.

XML-Schema Name:InvReqItem Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvReqItem in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item varchar225 1 1 Unique alphanumeric value that identifies the item to be requested. ITEM_REQUEST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that is being requested.
qty_rqst number12_4 1 1 The quantity for the item being requested. This field is stored in the standard unit of measure. ITEM_REQUEST_LINE_ITEM QUANTITY NUMBER 20,4 No the quantity of this item that is being requested in units.
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. ITEM_REQUEST REQUESTED_DELIVERY_DATE DATE null No the date the user would like the item delivered to the store by.
delivery_slot_id varchar215 0 1 Specifies when the store requested quantity is needed at the store. DELIVERY_SLOT, ITEM_REQUEST ID VARCHAR2 15 Yes delivery slot id