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

XML-Schema Name:StrAdjTpHdCriVo 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 StrAdjTpHdCriVo 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 Include only templates created at this store INV_ADJUST_TEMPLATE STORE_ID NUMBER 10,0 Yes Store identifier.
from_date xs:dateTime 0 1 Include only templates created at or after this date INV_ADJUST_TEMPLATE APPROVE_DATE, CREATE_DATE Date Fill column length. Yes The date template was created/approved
to_date xs:dateTime 0 1 Include only templates created at or before this date INV_ADJUST_TEMPLATE APPROVE_DATE, CREATE_DATE Date Fill column length. Yes The date the template was created/approved
item_id varchar225 0 1 Include only templates containing this sku number INV_ADJUST_TEMPLATE_ITEM ITEM_ID 25 VARCHAR2 Yes The item identifier.
template_id number12 0 1 Include only templates with this template identifier INV_ADJUST_TEMPLATE ID NUMBER 12,0 Yes Template identifier.
description varchar2250 0 1 Include only templates with descriptions containing this text INV_ADJUST_TEMPLATE DESCRIPTION VARCHAR2 250 Yes Description of the template.
reason_id number12 0 1 Include only templates with at least one line item containing this reason identifier INV_ADJUST_TEMPLATE_ITEM INV_ADJUST_REASON_ID NUMBER 12,0 Yes The identifier of the associated inventory adjustment reason code.
status str_adj_status 1 1 Include only templates with this status. Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. INV_ADJUST_TEMPLATE STATUS NUMBER 2,0 Yes Current status of the template 1=In Progress, 2=Complete, 3=Cancelled.
user_name varchar2128 0 1 Include only templates created by this user INV_ADJUST_TEMPLATE CREATE_USER VARCHAR2 128 Yes The user that created the template.