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

XML-Schema Name:StrAdjDesc 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 StrAdjDesc 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 1 1 Unique identifier INV_ADJUST ID NUMBER 12,0 Yes Adjustment identifier.
store_id number10 1 1 Store identifier INV_ADJUST STORE_ID NUMBER 10,0 Yes Store identifier.
reference_id number12 0 1 Adjustment identifier of original adjustment used to create this adjustment 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 Template identifier of template used to create the inventory adjustment INV_ADJUST INV_ADJUST_TEMPLATE_ID NUMBER 12,0 No Template used to create the adjustment.
status str_adj_status 1 1 Status of the adjustment. Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. INV_ADJUST STATUS NUMBER 2,0 Yes Indicates the current status of the adjustment. Possible values 1- In Progress, 2- Completed, 3- Canceled
comments varchar22000 0 1 Comments about the adjustment INV_ADJUST COMMENTS VARCHAR2 2000 No Comments associated to the adjustment.
create_date xs:dateTime 1 1 Date the adjustment was created INV_ADJUST CREATE_DATE Date Fill column length. Yes The date the adjustment was created.
create_user_name varchar2128 1 1 User that created the adjustment INV_ADJUST CREATE_USER VARCHAR2 128 Yes The user that created the adjustment.
approve_date xs:dateTime 0 1 Date the adjustment was approved INV_ADJUST APPROVE_DATE Date Fill column length. No The date the adjustment was approved.
approve_user_name varchar2128 0 1 User that approved the adjustment INV_ADJUST APPROVE_USER VARCHAR2 128 No The user that approved the adjustment.
StrAdjItm * 0 unbounded Collection of store inventory adjustment line items

XML-Schema Name:StrAdjItm 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 StrAdjItm 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_LINE_ITEM ID NUMBER 12,0 Yes The unique id of the template line item.
item_id varchar225 1 1 Sku number INV_ADJUST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The item identifier.
reason_id number12 1 1 Adjustment reason identifier 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 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.
uin_col varchar2128 0 unbounded Collection of all the unique identifiers/serial numbers associated with the line item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Collection of Serial Numbers in the line item
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes for the line item. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc 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 StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.