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/RcvUnitAdjDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RcvUnitAdjDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For RcvUnitAdjDesc
Table Name Column Name API Type Column Length API Required 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.
ExtOfRcvUnitAdjDesc:ExtOfRcvUnitAdjDesc * 0 1 Provide an extension hook to customize RcvUnitAdjDesc. NA NA NA NA NA NA
LocOfRcvUnitAdjDesc:LocOfRcvUnitAdjDesc * 0 1 Provide an extension hook to localize RcvUnitAdjDesc. NA NA NA NA NA NA

XML-Schema Name:RcvUnitAdjDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For RcvUnitAdjDtl
Table Name Column Name API Type Column Length API Required API Description
po_nbr varchar210 1 1 The order number against which a receiver unit adjustment was performed. rua_mfqueue order_no null null 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.
ExtOfRcvUnitAdjDesc:ExtOfRcvUnitAdjDtl * 0 1 Provide an extension hook to customize RcvUnitAdjDtl. NA NA NA NA NA NA
LocOfRcvUnitAdjDesc:LocOfRcvUnitAdjDtl * 0 1 Provide an extension hook to localize RcvUnitAdjDtl. NA NA NA NA NA NA

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

XML-Schema Name:LocOfRcvUnitAdjDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfRcvUnitAdjDtl
Table Name Column Name API Type Column Length API Required API Description
InRcvUnitAdjDesc:InRcvUnitAdjDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrRcvUnitAdjDesc:BrRcvUnitAdjDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfRcvUnitAdjDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfRcvUnitAdjDesc
Table Name Column Name API Type Column Length API Required API Description
InRcvUnitAdjDesc:InRcvUnitAdjDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRcvUnitAdjDesc:BrRcvUnitAdjDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA