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

XML-Schema Name:ItmRqstHdrColDesc 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 ItmRqstHdrColDesc 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
ItmRqstHdrDesc:ItmRqstHdrDesc * 0 unbounded Collection of item request headers NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ItmRqstHdrDesc 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 ItmRqstHdrDesc 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.
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.
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
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.
department_id number12 1 1 SIM internal department identifier ITEM_REQUEST DEPARTMENT_ID VARCHAR2 128 Yes 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_count number9 1 1 Number of line items on request Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.