Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management 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.
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 RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's 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.

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 RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
item_id varchar225 1 1 Description is not available. inv_adjustment_to_upload item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
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 2 Yes Identifies the type of inventory adjustments that was performed
unit_qty number12_4 1 1 Description is not available. inv_adjustment_to_upload unit_qty number 12,4 Yes Number of individual units.
transshipment_nbr varchar230 0 1 Description is not available. inv_adjustment_to_upload transshipment_nbr varchar2 30 Yes Transshipment number on the inventory.
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 From Disposition Inventory Code
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 To Disposition Inventory Code
from_trouble_code varchar29 0 1 Description is not available. inv_adjustment_to_upload from_trouble_code varchar2 9 Yes *
to_trouble_code varchar29 0 1 Description is not available. inv_adjustment_to_upload to_trouble_code varchar2 9 Yes *
from_wip_code varchar29 0 1 Description is not available. inv_adjustment_to_upload from_wip_code varchar2 9 Yes *
to_wip_code varchar29 0 1 Description is not available. inv_adjustment_to_upload to_wip_code varchar2 9 Yes *
transaction_code number4 0 1 Description is not available. inv_adjustment_to_upload transaction_code number 4 Yes Indicates the positive/negative orientation of the upload
user_id varchar230 1 1 Description is not available. inv_adjustment_to_upload user_id varchar2 30 Yes A unique identifier for a user of the WMS.
create_date xs:dateTime 1 1 Description is not available. inv_adjustment_to_upload create_date RIBDate Date Yes Date and Time record created
po_nbr varchar212 0 1 Either a PO or transfer associated to the inventory adjustment based on the doc_type. inv_adjustment_to_upload po_nbr varchar2 12 Yes PO number associated with adjustment
doc_type varchar21 0 1 Description is not available. po doc_type varchar2 1 Yes Document Type
aux_reason_code varchar24 0 1 Description is not available. inv_adjustment_to_upload aux_reason_code varchar2 4 Yes Auxilliary Reason Code
weight number12_4 0 1 Description is not available. inv_adjustment_to_upload weight_adjustment number 12,4 No The weight adjustment of an item
weight_uom varchar24 0 1 Description is not available. * * varchar2 4 No If weight_adjustment is NOT NULL uses SCP sys_weight_uom value.
unit_cost number20_4 0 1 Contains the current unit cost of the item * * * * Yes *
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 RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS'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.