Oracle Portal
Retail Integration Bus Mappings Report   

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:SODesc.xsd
Tag Name Table Name Column Name API Req Description
distro_nbr stock_order distro_nbr / cust_order_nbr Yes *
document_type stock_order document_type * *
dc_dest_id transshipment_setup dc_dest_id * *
order_type stock_order order_type * *
pick_not_before_date stock_order pick_not_before_date * *
pick_not_after_date stock_order pick_not_after_date * *
priority stock_order priority * *
event_code stock_order event_code * *
event_description stock_order event_description * *
carrier_code stock_order carrier_code * *
carrier_service_code stock_order carrier_service_code * *
route stock_order route * *
ship_address_desc stock_order ship_address_desc * *
ship_address1 stock_order ship_address1 * *
ship_address2 stock_order ship_address2 * *
ship_address3 stock_order ship_address3 * *
ship_address4 stock_order ship_address4 * *
ship_address5 stock_order ship_address5 * *
ship_city stock_order ship_city * *
ship_state stock_order ship_state * *
ship_zip stock_order ship_zip No *
ship_country_id stock_order ship_country_code No *
bill_address_desc stock_order bill_address_description No *
bill_address1 stock_order bill_address1 No *
bill_address2 stock_order bill_address2 * *
bill_address3 stock_order bill_address3 * *
bill_address4 stock_order bill_address4 * *
bill_address5 stock_order bill_address5 * *
bill_city stock_order bill_city * *
bill_state stock_order bill_state * *
bill_zip stock_order bill_zip * *
bill_country_id stock_order bill_country_code * *
break_by_distro stock_order break_by_distro * *
rollback_allocation stock_order rollback_allocation * *
cartonization stock_order cartonization * *
consumer_direct stock_order consumer_direct * *
message stock_order message * *
chute_type stock_order chute_type * *
po_nbr stock_order po_nbr * *
parent_customer_order stock_order parent_customer_order * *
pick_complete stock_order pick_complete * *
order_line_costs stock_order order_line_costs * *
container_type stock_order container_type * *
amount1 stock_order amount1 * *
amount2 stock_order amount2 * *
amount3 stock_order amount3 * *
amount4 stock_order amount4 * *
amount5 stock_order amount5 * *
amount6 stock_order amount6 * *
sub_total stock_order sub_total * *
gift_cost_total stock_order gift_cost_total * *
promotion_total stock_order promotion_total * *
total stock_order total * *
tax_total stock_order tax_total * *
shipping_total stock_order shipping_total * *
order_uda1 stock_order order_uda1 * *
order_uda2 stock_order order_uda2 * *
order_uda3 stock_order order_uda3 * *
order_uda4 stock_order order_uda4 * *
order_uda5 stock_order order_uda5 * *
order_uda6 stock_order order_uda6 * *
order_uda7 stock_order order_uda7 * *
order_uda8 stock_order order_uda8 * *
order_uda9 stock_order order_uda9 * *
order_uda10 stock_order order_uda10 * *
dl_comment stock_order dl_comment * *
ship_date * * * *
SODtlDesc * * * *
not_after_date * * * *
distro_parent_nbr * * * *
exp_dc_date * * * *
approval_id * * * *
approval_date * * * *
from_loc_tsf_entity * * * *
to_loc_tsf_entity * * * *
inv_type * * * *
so_status * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:SODtlDesc
Tag Name Table Name Column Name API Req Description
dest_id stock_allocation dest_id * *
item_id stock_allocation item_id * *
requested_unit_qty stock_allocation requested_unit_qty * *
retail_price component_ticketing retail_price * *
selling_uom stock_allocation selling_uom * *
ticket_type stock_allocation ticket_type * *
priority stock_order priority * *
store_ord_mult stock_allocation store_ord_mult * *
expedite_flag stock_allocation expedite_flag * *
order_line_nbr stock_allocation_cid order_line_nbr No Derived as ROWNUM.
amount1 stock_allocation amount1 * *
amount2 stock_allocation amount2 * *
amount3 stock_allocation amount3 * *
amount4 stock_allocation amount4 * *
amount5 stock_allocation amount5 * *
amount6 stock_allocation amount6 * *
tax_percent stock_allocation tax_percent * *
item_status stock_allocation item_status * *
component_ticketing_distro_nbr component_ticketing component_ticketing_distro_nbr * *
in_store_date stock_allocation in_store_date * *
total transshipment_setupe total * *
gift_cost stock_allocation gift_cost * *
shipping stock_allocation shipping * *
promotion stock_allocation promotion * *
sub_total stock_allocation sub_total * *
tax stock_allocation tax * *
order_detail_uda1 stock_allocation order_detail_uda1 * *
order_detail_uda2 stock_allocation order_detail_uda2 * *
order_detail_uda3 stock_allocation order_detail_uda3 * *
order_detail_uda4 stock_allocation order_detail_uda4 * *
order_detail_uda5 stock_allocation order_detail_uda5 * *
SODtlTcktDesc * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:SODtlTcktDesc
Tag Name Table Name Column Name API Req Description
distro_nbr stock_allocation distro_nbr * *
document_type stock_order document_type * *
item_id stock_allocation item_id * *
dest_id stock_allocation dest_id * *
component_item_id component_ticketing component_item_id * *
retail_price component_ticketing retail_price * *
selling_uom component_ticketing selling_uom * *