Retail Integration Mappings Report Release:19.0.000 (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:19.0.000 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.
adjustment_date xs:dateTime 1 1 Timestamp when the inventory movement is considered to have taken place. NA NA NA NA NA NA
comments varchar22000 0 1 Deprecated. This attribute is no longer used and will be removed. 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 1000 Collections of removed line items indicated by their identifiers. INV_ADJUST_LINE_ITEM ID NUMBER 12 Yes Removed line items list
StrInvModAdjNote * 0 100 Collection of notes that will be added to the inventory adjustment. NA NA NA NA NA NA
StrCustAttModVo:StrCustAttModVo * 0 50 Collection of custom attribute to be updated for the inventory adjustment. NA NA NA NA NA NA

XML-Schema Name:StrAdjItmMod Version:19.0.000 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:19.0.000 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.

XML-Schema Name:StrInvModAdjNote Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrInvModAdjNote 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
note varchar22000 0 1 Note associated to the item basket. NA NA NA NA NA NA

XML-Schema Name:StrCustAttModVo Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrCustAttModVo 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
admin_id number12 0 1 The unique identifier for the admin record defining this attribute. NA NA NA NA NA NA
attribute_name varchar2128 0 1 Contains an identifying name of the attribute. Required if admin_id is not included. NA NA NA NA NA NA
value_text varchar2128 0 1 Holds the string value of the attribute. NA NA NA NA NA NA
value_date xs:dateTime 0 1 Holds the date value of the attribute. NA NA NA NA NA NA
value_decimal number18_4 0 1 Holds the decimal value of the attribute. NA NA NA NA NA NA
value_long number18 0 1 Holds the long value of the attribute. NA NA NA NA NA NA