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

XML-Schema Name:ItmRqstDesc 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 ItmRqstDesc 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 number12 1 1 SIM internal identifier ITEM_REQUEST ID NUMBER 12,0 Yes the unique identifier of item request. this is generated by the system.
store_id number10 1 1 Store identifier ITEM_REQUEST STORE_ID NUMBER 10,0 Yes the unique identifier of the store that is requesting the items.
user_name varchar2128 1 1 User that last modified the request ITEM_REQUEST CREATE_USER VARCHAR2 128 Yes The create user name.
comments varchar22000 0 1 Comments ITEM_REQUEST COMMENTS VARCHAR2 2000 No any comments as defined by the user.
delivery_date xs:dateTime 0 1 Delivery date in GMT ITEM_REQUEST REQUESTED_DELIVERY_DATE DATE Fill column length. No the date the user would like the item delivered to the store by.
expiration_date xs:dateTime 0 1 Expiration date in GMT 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.
process_date xs:dateTime 0 1 Process date in GMT ITEM_REQUEST PROCESS_DATE DATE Fill column length. No the date that the item request is requested or cancelled.
create_date xs:dateTime 1 1 Creation date in GMT ITEM_REQUEST CREATE_DATE_TIME DATE Fill column length. Yes the date and time stamp of when the item request was created.
status itm_rqst_status 1 1 Current 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
timeslot_id varchar215 0 1 Unique timeslot identifier ITEM_REQUEST DELIVERY_SLOT_ID VARCHAR2 15 No delivery slot id
schedule_description varchar2250 0 1 Schedule description ITEM_REQUEST SCHEDULE_DESCRIPTION VARCHAR2 250 No for item lists created via a product group, this will hold the description that was assigned to the product group when it was scheduled.
ItmRqstItm * 1 1000 Collection of item request line items

XML-Schema Name:ItmRqstItm 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 ItmRqstItm 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
line_id number12 1 1 SIM internal identifier ITEM_REQUEST_LINE_ITEM ID VARCHAR2 12,0 Yes unique id
item_id varchar225 1 1 Sku number ITEM_REQUEST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes the unique identifier of the item that is being requested.
timeslot_id varchar215 0 1 SIM internal timeslot identifier ITEM_REQUEST_LINE_ITEM DELIVERY_SLOT_ID VARCHAR2 15 No delivery slot id.
quantity number20_4 1 1 Quantity in units ITEM_REQUEST_LINE_ITEM QUANTITY NUMBER 20,4 Yes the quantity of this item that is being requested in units.
case_size number10_2 1 1 Case size of the item ITEM_REQUEST_LINE_ITEM CASE_SIZE NUMBER 10,2 Yes the pack size that was specified when the item request was created.