Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.1

Application Name: Retail Warehouse Management System
Version 13.0.1
XML-Schema or Node Name:AllocDesc.xsd
Tag Name Table Name Column Name API Req Description
alloc_no stock_allocation distro_nbr or cust_order_nbr Yes *
doc_type * * * *
physical_wh transshipment_setup dc_dest_id Yes *
wh * * * *
item stock_allocation item_id Yes *
pick_not_before_date * * * *
pick_not_after_date * * * *
order_type * * * *
order_no * * * *
order_doc_type * * * *
event * * * *
event_description * * * *
priority * * * *
ticket_type_id stock_allocation ticket_type_id No *
AllocDtl * * * *
context_type * * * *
context_value * * * *

Application Name: Retail Warehouse Management System
Version 13.0.1
XML-Schema or Node Name:AllocDtl
Tag Name Table Name Column Name API Req Description
physical_to_loc * * * *
to_loc stock_allocation dest_id Yes *
loc_type * * * *
qty_allocated stock_allocation requested_unit_qty Yes *
price stock_allocation retail_price No *
selling_uom stock_allocation selling_uom No *
priority stock_allocation priority Yes *
store_ord_mult stock_allocation store_ord_mult Yes *
AllocDtlTckt * * * *

Application Name: Retail Warehouse Management System
Version 13.0.1
XML-Schema or Node Name:AllocDtlTckt
Tag Name Table Name Column Name API Req Description
comp_item component_ticketing component_item_id Yes *
comp_price component_ticketing retail_price Yes *
comp_selling_uom component_ticketing selling_uom Yes *