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/InvAdjustDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:InvAdjustDesc 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 InvAdjustDesc 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
dc_dest_id varchar210 1 1 Description is not available. INV_ADJUST STORE_ID NUMBER 10 Yes Store identifier where the inventory adjustment occurred.
InvAdjustDtl * 1 unbounded Description is not available.

XML-Schema Name:InvAdjustDtl 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 InvAdjustDtl 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
item_id varchar225 1 1 Description is not available. INV_ADJUST_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Identifies the item on the inventory adjustment.
adjustment_reason_code number4 0 1 Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. INV_ADJUST_REASON CODE NUMBER 4 Yes contains a code to uniquely identify the reason for an inventory adjustment.
unit_qty number12_4 1 1 Description is not available. INV_ADJUST_LINE_ITEM QUANTITY NUMBER 20,4 Yes The quantity of the item.
transshipment_nbr varchar230 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
from_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. n/a n/a null null No Populated by SIM with an empty value
to_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. n/a n/a null null No Populated by SIM with an empty value.
from_trouble_code varchar29 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
to_trouble_code varchar29 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
from_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
to_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
transaction_code number4 0 1 Description is not available. n/a n/a null null Yes Populated by SIM with 0.
user_id varchar230 1 1 Description is not available. INV_ADJUST APPROVE_USER VARCHAR2 128 No The user that approved the adjustment.
create_date xs:dateTime 1 1 Description is not available. Fill application table name. null DATE Fill column length. No Current date when Inventory adjustment was created
po_nbr varchar212 0 1 Either a PO or transfer associated to the inventory adjustment based on the doc_type. n/a n/a null null No Populated by SIM with an empty value.
doc_type varchar21 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
aux_reason_code varchar24 0 1 Description is not available. n/a n/a null null No Populated by SIM with an empty value.
weight number12_4 0 1 Description is not available. n/a n/a null null No Not used by SIM.
weight_uom varchar24 0 1 Description is not available. n/a n/a null null No Not used by SIM.
unit_cost number20_4 0 1 Contains the current unit cost of the item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
InvAdjustUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:InvAdjustUin 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 InvAdjustUin 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
uin varchar2128 1 1 Universal Identification Number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status number4 1 1 Contains the status code of the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.