Oracle Portal
Retail Integration Bus Mappings Report   

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:CustRetDesc.xsd
Tag Name Table Name Column Name API Req Description
from_location transshipment_setup dc_dest_id Yes *
rma_nbr returns_upload rma_nbr Yes *
pro_nbr returns_upload pro_nbr Yes *
comments returns_upload comments Yes *
CustRetItem * * * *
return_date * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:CustRetItem
Tag Name Table Name Column Name API Req Description
item_id returns_upload item_id Yes *
CustRetItemQty * custretitemqty Yes *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:CustRetItemQty
Tag Name Table Name Column Name API Req Description
unit_qty returns_upload unit_qty Yes *
from_wip returns_upload from_wip_code Yes *
to_wip returns_upload to_wip_code Yes *
from_disposition returns_upload from_disposition Yes *
to_disposition returns_upload to_disposition Yes *
saleable returns_upload saleable Yes *
CustRetItemQtyDtl * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:CustRetItemQtyDtl
Tag Name Table Name Column Name API Req Description
unit_qty returns_upload unit_qty Yes *
reason_code returns_upload reason_code Yes *
action_code returns_upload action_code Yes *
replacement_item returns_upload replacement_item Yes *
replace_unit_qty returns_upload replace_unit_qty Yes *
cust_ret_postage_amt * * * *