Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising 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.
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
request_id number10 1 1 Used to build an error record when necessary. n/a n/a n/a n/a Yes Used to build an error record when necessary.
store number10 1 1 The store ID which is requesting the item. store_orders store number 10 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 n/a n/a 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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 Unique alphanumeric value that identifies the item to be requested. store_orders item varchar2 25 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 number 12 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. n/a n/a n/a n/a Yes 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 Fill column length. Yes The date that the store needs the item by.
delivery_slot_id varchar215 0 1 Specifies when the store requested quantity is needed at the store. store_orders delivery_slot_id varchar2 15 No Specifies when the store requested quantity is needed at the store.