Oracle Portal
Retail Integration Bus Mappings Report   

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:RTVDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id transshipment_setup dc_dest_id Yes *
rtv_id inv_adjustment_to_upload rtv id Yes *
item_id inv_adjustment_to_upload item_id Yes *
rtn_auth_nbr * * * *
unit_qty inv_adjustment_to_upload unit_qty No *
container_qty rtv container_qty No *
vendor_nbr rtv vendor_nbr Yes *
ship_address1 rtv address1 No *
ship_address2 rtv address2 No *
ship_address3 rtv address3 No *
state rtv state No *
city rtv city No *
shipto_zip rtv shipto_zip No *
country rtv country No *
from_disposition inv_adjustment_to_upload from_disposition No *
to_disposition inv_adjustment_to_upload to_disposition No *
creation_ts rtv creation_ts No *
unit_cost * * No *
reason * * No *
comments * * * *
rtv_order_no * * * *
weight * * * *
weight_uom * * * *
RTVDtl * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:RTVDtl
Tag Name Table Name Column Name API Req Description
item_id * * * *
unit_qty * * * *
container_qty * * * *
from_disposition * * * *
to_disposition * * * *
unit_cost * * * *
reason * * * *
weight * * * *
weight_uom * * * *