Retail Integration Mappings Report Release:14.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StrAdjModVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrAdjModVo Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrAdjModVo 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
adjustment_id number12 0 1 Unique Identifier. If left empty, indicates creating new adjustment, otherwise will attempt to modify adjustment based on identifier. INV_ADJUST ID NUMBER 12,0 Yes Adjustment identifier.
store_id number10 1 1 Store identifier. This value cannot be altered on update. INV_ADJUST STORE_ID NUMBER 10,0 Yes Store identifier.
reference_id number12 0 1 Identifier of a source adjustment used to create this adjustment. This value cannot be altered on update. INV_ADJUST REFERENCE_ID NUMBER 12,0 No This is the identifier of the inventory adjustment this was copied from.
template_id number12 0 1 Identifier of template used to create the inventory adjustment. This value cannot be altered on update. INV_ADJUST INV_ADJUST_TEMPLATE_ID NUMBER 12,0 No Template used to create the adjustment.
comments varchar22000 0 1 Comments about the adjustment. If included, this value will replace any current comments. INV_ADJUST COMMENTS VARCHAR2 2000 No Comments associated to the adjustment.
StrAdjItmMod * 0 1000 Collection of inventory adjustment line items containing modified information.
removed_line_id_col number12 0 5000 Collections of removed line items indicated by their identifiers. Yes Removed line items list

XML-Schema Name:StrAdjItmMod Version:14.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrAdjItmMod 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 0 1 Unique Identifier. If left null, indicates a new line item, otherwise indicates the line item to modify. INV_ADJUST_LINE_ITEM ID VARCHAR2 25 Yes The item identifier.
item_id varchar225 1 1 Sku number of the item. This value can not be altered on update. INV_ADJUST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The item identifier.
reason_id number12 1 1 Store adjustment reason identifier. This value can not be altered on update. INV_ADJUST_LINE_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. This value is in standard units. INV_ADJUST_LINE_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_LINE_ITEM CASE_SIZE NUMBER 10,2 Yes A case size of the item.
added_uin_col varchar2128 0 100 Universal Identifier Numbers to add to the line item. Yes Serial numbers to add to line item
removed_uin_col varchar2128 0 1000 Universal Identifier Numbers to remove from the line item. Yes Removed Serail numbers