Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:RcvUnitAdjDesc.xsd
Tag Name Table Name Column Name API Req Description
loc rua_mfqueue location Yes The location where a receiver unit adjustment was performed.
loc_type rua_mfqueue loc_type Yes The type of location where the receiver unit adjustment was performed. Valid values are 'W' warehouse or 'S' store.
RcvUnitAdjDtl * * * *

Application Name: Retail Merchandising System
XML-Schema or Node Name:RcvUnitAdjDtl
Tag Name Table Name Column Name API Req Description
po_nbr rua_mfqueue order_no Yes The order number against which a receiver unit adjustment was performed.
asn_nbr rua_mfqueue asn No The ASn number associated with the shipment for which a receiver unit adjustment was performed.
item rua_mfqueue item Yes The item number that the receiver unit adjustment was performed against.
container_id rua_mfqueue carton No The supplier carton that contained the item against which the receiver unit adjustment was performed.
unit_qty rua_mfqueue adj_qty Yes The quantity of the receiver unit adjustment.
from_disposition inv_status_codes inv_status_code No This value, along with the to_disposition value, is used to determine if the inventory is available or unavailable.
to_disposition inv_status_codes inv_status_code No 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.