Retail Integration Bus Mappings Report Release:13.1 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAdjustDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:InvAdjustDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms 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. transshipment_setup dc_dest_id varchar2 10 Yes *
InvAdjustDtl * 1 unbounded Description is not available.
ExtOfInvAdjustDesc:ExtOfInvAdjustDesc * 0 1 Provide an extension hook to customize InvAdjustDesc. NA NA NA NA NA NA

XML-Schema Name:InvAdjustDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms 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_adjustment_to_upload item_id varchar2 25 Yes *
adjustment_reason_code number4 0 1 Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. inv_adjustment_to_upload adjustment_reason_code number 4 Yes *
unit_qty number12_4 1 1 Description is not available. inv_adjustment_to_upload unit_qty number 12 Yes *
transshipment_nbr varchar230 0 1 Description is not available. inv_adjustment_to_upload transshipment_nbr varchar2 30 Yes *
from_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. inv_adjustment_to_upload from_disposition varchar2 4 Yes *
to_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. inv_adjustment_to_upload to_disposition varchar2 4 Yes *
from_trouble_code varchar29 0 1 Description is not available. inv_adjustment_to_upload from_trouble_code varchar2 2 Yes *
to_trouble_code varchar29 0 1 Description is not available. inv_adjustment_to_upload to_trouble_code varchar2 2 Yes *
from_wip_code varchar29 0 1 Description is not available. inv_adjustment_to_upload from_wip_code varchar2 6 Yes *
to_wip_code varchar29 0 1 Description is not available. inv_adjustment_to_upload to_wip_code varchar2 6 Yes *
transaction_code number4 0 1 Description is not available. inv_adjustment_to_upload transaction_code number 4 Yes *
user_id varchar230 1 1 Description is not available. inv_adjustment_to_upload user_id varchar2 30 Yes *
create_date xs:dateTime 1 1 Description is not available. inv_adjustment_to_upload create_date RIBDate * Yes *
po_nbr varchar210 0 1 Either a PO or transfer associated to the inventory adjustment based on the doc_type. inv_adjustment_to_upload po_nbr varchar2 10 Yes *
doc_type varchar21 0 1 Description is not available. po doc_type varchar2 1 Yes *
aux_reason_code varchar24 0 1 Description is not available. inv_adjustment_to_upload aux_reason_code varchar2 4 Yes *
weight number12_4 0 1 Description is not available. * * number 12 * *
weight_uom varchar24 0 1 Description is not available. * * varchar2 4 * *
ExtOfInvAdjustDesc:ExtOfInvAdjustDtl * 0 1 Provide an extension hook to customize InvAdjustDtl. NA NA NA NA NA NA

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

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