Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
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 rms 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. inv_adj location varchar2 10 Yes 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 rms Mapping For InvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Description is not available. inv_adj item_id varchar2 25 Yes Unique identifier for the item.
adjustment_reason_code number4 0 1 Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. inv_adj reason number 4 No Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types.
unit_qty number12_4 1 1 Description is not available. inv_adj adj_qty number 12 Yes 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 Not used by RMS.
from_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. inv_status_codes inv_status_code null null No Used to fetch the inv_status. Also 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. inv_status_codes inv_status_code null null No Used to fetch the inv_status. Also 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 Not used by RMS.
to_trouble_code varchar29 0 1 Description is not available. n/a n/a null null No Not used by RMS.
from_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Not used by RMS.
to_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Not used by RMS.
transaction_code number4 0 1 Description is not available. n/a n/a null null No Not used by RMS.
user_id varchar230 1 1 Description is not available. inv_adj user_id varchar2 30 Yes Contains the user ID for the user making the inventory adjustment.
create_date xs:dateTime 1 1 Description is not available. inv_adj adj_date RIBDate * Yes 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. ordhead, tsfhead order_no, tsf_no null null No Either a PO or transfer associated to the inventory adjustment based on the doc_type.
doc_type varchar21 0 1 Description is not available. n/a n/a null null No Indicates whether the document is a Purchase Order (P) or a Transfer (T).
aux_reason_code varchar24 0 1 Description is not available. n/a n/a null null No Not used by RMS.
weight number12_4 0 1 Description is not available. n/a n/a null null No Actual weight of the inventory that was adjusted.
weight_uom varchar24 0 1 Description is not available. n/a n/a null null No Unit of measure for weight (such as pounds or kilograms).
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 rms 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 rms 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 rms 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 rms 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