Retail Integration Bus Mappings Report Release:13.2.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.

XML-Schema Name:InvAdjustDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For InvAdjustDesc
Table Name Column Name API Type Column Length API Required API Description
dc_dest_id varchar210 1 1 Description is not available. RK_INV_ADJUSTMENT STORE_ID NUMBER 10 No Contains the location where the inventory adjustment occurred.
InvAdjustDtl * 1 unbounded Description is not available.
ExtOfInvAdjustDesc:ExtOfInvAdjustDesc * 0 1 Provide an extension hook to customize InvAdjustDesc. NA NA NA NA NA NA
LocOfInvAdjustDesc:LocOfInvAdjustDesc * 0 1 Provide an extension hook to localize InvAdjustDesc. NA NA NA NA NA NA

XML-Schema Name:InvAdjustDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For InvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Description is not available. RK_INV_ADJUSTMENT ITEM_ID VARCHAR2 25 No 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. RK_INV_ADJUSTMENT RK_INV_ADJ_REASON_ID NUMBER 12 No Contains the reason for the inventory adjustment. This field will have a value only for saleable inventory types.
unit_qty number12_4 1 1 Description is not available. RK_INV_ADJUSTMENT QUANTITY NUMBER 20 No Contains the quantity by which the inventory was adjusted.
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 Used to determine if the adjustment quantity is negative or positive.
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 Used to determine if the adjustment quantity is negative or positive.
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. RK_INV_ADJUSTMENT CREATED_BY VARCHAR2 128 No Contains the user ID of the user making the inventory adjustment.
create_date xs:dateTime 1 1 Description is not available. RK_INV_ADJUSTMENT CREATE_DATE DATE No Contains the date on which the inventory adjustment occurred.
po_nbr varchar210 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 NA NA NA NA NA NA
ExtOfInvAdjustDesc:ExtOfInvAdjustDtl * 0 1 Provide an extension hook to customize InvAdjustDtl. NA NA NA NA NA NA
LocOfInvAdjustDesc:LocOfInvAdjustDtl * 0 1 Provide an extension hook to localize InvAdjustDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfInvAdjustDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfInvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfInvAdjustDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfInvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description
InInvAdjustDesc:InInvAdjustDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrInvAdjustDesc:BrInvAdjustDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfInvAdjustDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfInvAdjustDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfInvAdjustDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfInvAdjustDesc
Table Name Column Name API Type Column Length API Required API Description
InInvAdjustDesc:InInvAdjustDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrInvAdjustDesc:BrInvAdjustDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA