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

XML-Schema Name:StrAdjTplDesc 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 StrAdjTplDesc 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
template_id number12 1 1 Template identifier INV_ADJUST_TEMPLATE ID NUMBER 12,0 Yes Template identifier.
store_id number10 1 1 SIM store identifier INV_ADJUST_TEMPLATE STORE_ID NUMBER 10,0 Yes Store Identifier
description varchar2250 1 1 Description of the template. INV_ADJUST_TEMPLATE DESCRIPTION VARCHAR2 250 Yes Description of the template.
status str_adj_status 1 1 Status of the template. 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.
comments varchar22000 0 1 Comments about the template INV_ADJUST_TEMPLATE COMMENTS VARCHAR2 2000 No Comments associated with the template.
create_date xs:dateTime 1 1 The date the template was created INV_ADJUST_TEMPLATE CREATE_DATE DATE Fill column length. Yes The date the template was created.
create_user_name varchar2128 1 1 The user that created the template INV_ADJUST_TEMPLATE CREATE_USER VARCHAR2 128 Yes The user that created the template.
approve_date xs:dateTime 0 1 The date the template was approved INV_ADJUST_TEMPLATE APPROVE_DATE DATE Fill column length. Yes The date the template was approved.
approve_user_name varchar2128 0 1 The user that approved the template INV_ADJUST_TEMPLATE APPROVE_USER VARCHAR2 128 No The user that approved the template.
StrAdjTplItm * 0 1000 Collection of inventory adjustment template line items.

XML-Schema Name:StrAdjTplItm 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 StrAdjTplItm 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 Unique identifier INV_ADJUST_TEMPLATE_ITEM ID NUMBER 12,0 Yes The unique id of the template line item.
item_id varchar225 1 1 Sku number INV_ADJUST_TEMPLATE_ITEM ITEM_ID VARCHAR2 25 Yes The item identifier.
reason_id number12 1 1 Adjustment reason identifier INV_ADJUST_TEMPLATE_ITEM INV_ADJUST_REASON_ID NUMBER 12,0 Yes The identifier of the associated inventory adjustment reason code.
quantity number20_4 1 1 Quantity of the adjustment in standard units. INV_ADJUST_TEMPLATE_ITEM QUANTITY NUMBER 20,4 Yes The quantity of the item.
case_size number10_2 1 1 Case size associated with the item on this line item. INV_ADJUST_TEMPLATE_ITEM CASE_SIZE NUMBER 10,2 Yes A case size of the item.