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/ItmRqstCriVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ItmRqstCriVo 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 ItmRqstCriVo 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
store_id number10 1 1 Return only item requests for this store. ITEM_REQUEST STORE_ID NUMBER 10,0 Yes the unique identifier of the store that is requesting the items.
user_name varchar2128 0 1 Return only item requests created by this user. ITEM_REQUEST CREATE_USER VARCHAR2 128 No The create user name.
status itm_rqst_status 1 1 Return only item requests in this status. Valid values are PENDING, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. ITEM_REQUEST STATUS NUMBER 2,0 Yes the status of the item request. 1 - pending 2 - completed 4 - cancelled
item_id varchar225 0 1 Return only item requests containing this item ITEM_REQUEST_LINE_ITEM ITEM_ID VARCHAR2 25 No the unique identifier of the item that is being requested.
department_id number12 0 1 Return only item requests for this department ITEM_REQUEST DEPARTMENT_ID VARCHAR2 128 No the unique identifier of the department that the items on the request belong to. if the items on the request belong to more than 1 department this will only hold 1 value. in the display the user will see this value followed by a +.
item_request_id number12 0 1 Return only item request with this identifier. This will limit responses to a single item request. ITEM_REQUEST ID NUMBER 12,0 No the unique identifier of item request. this is generated by the system.
timeslot_id varchar215 0 1 Return only item requests that deliveries scheduled in this timeslot. ITEM_REQUEST DELIVERY_SLOT_ID VARCHAR2 15 No delivery slot id
from_expiration_date xs:dateTime 0 1 Return only item requests that expire after this GMT date. ITEM_REQUEST EXPIRATION_DATE DATE Fill column length. No The date the item request expires. this cannot be specified in the item request and is only populated through the batch process when a days before expiration value is specified in the product group.
to_expiration_date xs:dateTime 0 1 Return only items requests that expire before this GMT date. ITEM_REQUEST EXPIRATION_DATE DATE Fill column length. No the date the item request expires. this cannot be specified in the item request and is only populated through the batch process when a days before expiration value is specified in the product group.
from_create_date xs:dateTime 0 1 Return only item requests that were created after this GMT date. ITEM_REQUEST REQUESTED_DELIVERY_DATE DATE Fill column length. No the date and time stamp of when the item request was created.
to_create_date xs:dateTime 0 1 Return only item requests that were created before this GMT date. ITEM_REQUEST REQUESTED_DELIVERY_DATE DATE Fill column length. No the date and time stamp of when the item request was created.