Retail Integration Mappings Report Release:16.0.030 (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:16.0.030 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 BDI) 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.
publish xs:boolean 0 1 If true, stock movements triggered by confirming the adjustment will be published to external systems. If false, no publish will take place. No Not used by SIM.
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. INV_ADJUST_LINE_ITEM ID NUMBER 12 Yes Removed line items list

XML-Schema Name:StrAdjItmMod Version:16.0.030 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 BDI) 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 Unique Identifier Numbers to add to the line item. ITEM_UIN UIN VARCHAR2 128 Yes Serial numbers to add to line item
removed_uin_col varchar2128 0 1000 Unique Identifier Numbers to remove from the line item. ITEM_UIN UIN VARCHAR2 128 Yes Removed Serial numbers
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated to the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. INV_ADJUST_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.

XML-Schema Name:StrInvExtAttDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrInvExtAttDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT QUANTITY NUMBER 12 Yes Extended attribute quantity.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.