Oracle Portal
Retail Integration Bus Mappings Report   

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutDesc.xsd
Tag Name Table Name Column Name API Req Description
wo_id * * Yes Used in interface only.
dc_dest_id n/a n/a Yes Used in interface only.
distro_nbr outbound_work_order distro_nbr Yes *
WOOutDtl * * * *
distro_parent_nbr * * * *
WOOutXForm * * * *
WOOutPacking * * * *
inv_type * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutDtl
Tag Name Table Name Column Name API Req Description
dest_id outbound_work_order dest_id Yes *
item_id outbound_work_order item_id Yes *
wip_seq_nbr outbound_work_order wip_seq_nbr No *
wip_code outbound_work_order wip_code No *
personalization outbound_work_order personalization No *
instructions outbound_work_order instructions No *
order_line_nbr outbound_work_order order_line_nbr No *
auto_complete outbound_work_order auto_complete Yes *
WOOutActivity * * * *
inv_status * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutActivity
Tag Name Table Name Column Name API Req Description
activity_id * * * *
activity_cost * * * *
comments * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutXForm
Tag Name Table Name Column Name API Req Description
from_item * * * *
to_item * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutPacking
Tag Name Table Name Column Name API Req Description
WOOutPackTo * * * *
WOOutPackFrom * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutPackTo
Tag Name Table Name Column Name API Req Description
to_item * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:WOOutPackFrom
Tag Name Table Name Column Name API Req Description
from_item * * * *