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

XML-Schema Name:StrAdjDesc 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 StrAdjDesc 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 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.
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.
adjustment_date xs:dateTime 1 1 Timestamp when the inventory movement is considered to have taken place. NA NA NA NA NA NA
create_date xs:dateTime 1 1 Date the adjustment was created INV_ADJUST CREATE_DATE DATE 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 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 5000 Collection of store inventory adjustment line items
StrInvAdjNote * 0 1000 Notes associated to the inventory adjustment. NA NA NA NA NA NA
StrCustAttDesc:StrCustAttDesc * 0 50 Custom attributes associated to the inventory adjustment. NA NA NA NA NA NA

XML-Schema Name:StrAdjItm 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 StrAdjItm 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 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 5000 Collection of all the unique identifiers/serial numbers associated with the line item ITEM_UIN UIN VARCHAR2 128 Yes Collection of Serial Numbers in the line item
StrInvExtAttDesc:StrInvExtAttDesc * 0 5000 Collection of extended attributes for the line item. NA NA NA NA NA NA

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:StrInvAdjNote 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 StrInvAdjNote 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:StrCustAttDesc 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 StrCustAttDesc 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
label varchar230 1 1 Holds the attribute label. NA NA NA NA NA NA
value_text varchar2250 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
admin_id number12 0 1 The unique identifier for the attribute admin record. If not present, indicates a display only non-editable value. NA NA NA NA NA NA