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

XML-Schema Name:RcvUnitAdjDesc 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 RcvUnitAdjDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
loc number10 1 1 The location where a receiver unit adjustment was performed. rua_mfqueue location null null Yes The location at which a receiver unit adjustment was performed.
loc_type varchar21 1 1 The type of location where the receiver unit adjustment was performed. Valid values are 'W' warehouse or 'S' store. rua_mfqueue loc_type null null Yes The type for the location at which the receiver unit adjustment was performed. Valid values are W (warehouse) and S (store).
RcvUnitAdjDtl * 1 unbounded Description is not available.

XML-Schema Name:RcvUnitAdjDtl 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 RcvUnitAdjDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
po_nbr varchar212 1 1 The order number against which a receiver unit adjustment was performed. rua_mfqueue order_no number 12 Yes The order number against which a receiver unit adjustment was performed.
asn_nbr varchar230 0 1 The ASn number associated with the shipment for which a receiver unit adjustment was performed. rua_mfqueue asn null null No The ASn number associated with the shipment for which a receiver unit adjustment was performed.
item varchar225 1 1 The item number that the receiver unit adjustment was performed against. rua_mfqueue item null null Yes The item number that the receiver unit adjustment was performed against.
container_id varchar220 0 1 The supplier carton that contained the item against which the receiver unit adjustment was performed. rua_mfqueue carton null null No The supplier carton that contained the item against which the receiver unit adjustment was performed.
unit_qty number12_4 1 1 The quantity of the receiver unit adjustment. rua_mfqueue adj_qty null null Yes The quantity of the receiver unit adjustment.
from_disposition varchar24 0 1 This value, along with the to_disposition value, is used to determine if the inventory is available or unavailable. inv_status_codes inv_status_code null null No This value, along with the to_disposition value, is used to determine whether the inventory is available.
to_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. inv_status_codes inv_status_code null null No This value is used to determine whether the inventory is available, based on the code's INV_STATUS value in the INV_STATUS_CODES table.
RcvUnitAdjUin * 0 unbounded Collection of UIN(s) associated to the item.

XML-Schema Name:RcvUnitAdjUin 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 RcvUnitAdjUin in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS'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 Status associated with the UIN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.