Retail Integration Bus Mappings Report Release:13.1 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/SODesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:SODesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For SODesc
Table Name Column Name API Type Column Length API Required API Description
distro_nbr varchar210 1 1 mapped to DO_CTL_INV.ID_ICD as well.Not Yet Available stock_order distro_nbr / cust_order_nbr varchar2 10 Yes *
document_type varchar21 1 1 NA stock_order document_type varchar2 1 * *
dc_dest_id varchar210 1 1 mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available transshipment_setup dc_dest_id varchar2 10 * *
order_type varchar29 0 1 NA stock_order order_type varchar2 9 * *
pick_not_before_date xs:dateTime 0 1 Not Yet Available stock_order pick_not_before_date RIBDate * * *
pick_not_after_date xs:dateTime 0 1 Not Yet Available stock_order pick_not_after_date RIBDate * * *
priority number4 1 1 NA stock_order priority number 4 * *
event_code varchar26 0 1 NA stock_order event_code varchar2 6 * *
event_description varchar21000 0 1 NA stock_order event_description varchar2 250 * *
carrier_code varchar24 0 1 NA stock_order carrier_code varchar2 4 * *
carrier_service_code varchar26 0 1 NA stock_order carrier_service_code varchar2 6 * *
route varchar210 0 1 NA stock_order route varchar2 10 * *
ship_address_desc varchar230 0 1 NA stock_order ship_address_desc varchar2 30 * *
ship_address1 varchar2240 0 1 NA stock_order ship_address1 varchar2 240 * *
ship_address2 varchar2240 0 1 NA stock_order ship_address2 varchar2 240 * *
ship_address3 varchar2240 0 1 NA stock_order ship_address3 varchar2 240 * *
ship_address4 varchar2240 0 1 NA stock_order ship_address4 varchar2 240 * *
ship_address5 varchar2240 0 1 NA stock_order ship_address5 varchar2 240 * *
ship_city varchar2120 0 1 NA stock_order ship_city varchar2 120 * *
ship_state varchar23 0 1 NA stock_order ship_state varchar2 3 * *
ship_zip varchar230 0 1 NA stock_order ship_zip varchar2 30 No *
ship_country_id varchar23 0 1 NA stock_order ship_country_code varchar2 3 No *
bill_address_desc varchar230 0 1 NA stock_order bill_address_description varchar2 30 No *
bill_address1 varchar2240 0 1 NA stock_order bill_address1 varchar2 240 No *
bill_address2 varchar2240 0 1 NA stock_order bill_address2 varchar2 240 * *
bill_address3 varchar2240 0 1 NA stock_order bill_address3 varchar2 240 * *
bill_address4 varchar2240 0 1 NA stock_order bill_address4 varchar2 240 * *
bill_address5 varchar2240 0 1 NA stock_order bill_address5 varchar2 240 * *
bill_city varchar2120 0 1 NA stock_order bill_city varchar2 120 * *
bill_state varchar23 0 1 NA stock_order bill_state varchar2 3 * *
bill_zip varchar230 0 1 NA stock_order bill_zip varchar2 30 * *
bill_country_id varchar23 0 1 NA stock_order bill_country_code varchar2 3 * *
break_by_distro varchar21 0 1 NA stock_order break_by_distro varchar2 1 * *
rollback_allocation varchar21 0 1 NA stock_order rollback_allocation varchar2 1 * *
cartonization varchar21 0 1 NA stock_order cartonization varchar2 1 * *
consumer_direct varchar21 0 1 NA stock_order consumer_direct varchar2 1 * *
message varchar22000 0 1 NA stock_order message varchar2 300 * *
chute_type varchar26 0 1 NA stock_order chute_type varchar2 6 * *
po_nbr varchar210 0 1 NA stock_order po_nbr varchar2 10 * *
parent_customer_order varchar220 0 1 NA stock_order parent_customer_order varchar2 20 * *
pick_complete varchar21 0 1 NA stock_order pick_complete varchar2 1 * *
order_line_costs varchar21 0 1 NA stock_order order_line_costs varchar2 1 * *
container_type varchar26 0 1 NA stock_order container_type varchar2 6 * *
amount1 number16_2 0 1 NA stock_order amount1 number 16 * *
amount2 number16_2 0 1 NA stock_order amount2 number 16 * *
amount3 number16_2 0 1 NA stock_order amount3 number 16 * *
amount4 number16_2 0 1 NA stock_order amount4 number 16 * *
amount5 number16_2 0 1 NA stock_order amount5 number 16 * *
amount6 number16_2 0 1 NA stock_order amount6 number 16 * *
sub_total number12 0 1 NA stock_order sub_total number 12 * *
gift_cost_total number12 0 1 NA stock_order gift_cost_total number 12 * *
promotion_total number12 0 1 NA stock_order promotion_total number 12 * *
total number12 0 1 NA stock_order total number 12 * *
tax_total number12 0 1 NA stock_order tax_total number 12 * *
shipping_total number12 0 1 NA stock_order shipping_total number 12 * *
order_uda1 varchar210 0 1 NA stock_order order_uda1 varchar2 10 * *
order_uda2 varchar210 0 1 NA stock_order order_uda2 varchar2 10 * *
order_uda3 varchar210 0 1 NA stock_order order_uda3 varchar2 10 * *
order_uda4 varchar210 0 1 NA stock_order order_uda4 varchar2 10 * *
order_uda5 varchar210 0 1 NA stock_order order_uda5 varchar2 10 * *
order_uda6 varchar210 0 1 NA stock_order order_uda6 varchar2 10 * *
order_uda7 varchar210 0 1 NA stock_order order_uda7 varchar2 10 * *
order_uda8 varchar210 0 1 NA stock_order order_uda8 varchar2 10 * *
order_uda9 varchar210 0 1 NA stock_order order_uda9 varchar2 10 * *
order_uda10 varchar210 0 1 NA stock_order order_uda10 varchar2 10 * *
dl_comment varchar230 0 1 NA stock_order dl_comment varchar2 30 * *
ship_date xs:dateTime 0 1 NA * * RIBDate * * *
SODtlDesc * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 NA * * RIBDate * * *
distro_parent_nbr varchar210 0 1 NA * * varchar2 10 * *
exp_dc_date xs:dateTime 0 1 NA * * RIBDate * * *
approval_id varchar230 0 1 NA * * varchar2 120 * *
approval_date xs:dateTime 0 1 NA * * RIBDate * * *
from_loc_tsf_entity number10 0 1 NA * * number 10 * *
to_loc_tsf_entity number10 0 1 NA * * number 10 * *
inv_type varchar26 0 1 NA * * varchar2 6 * *
so_status varchar21 0 1 NA * * varchar2 1 * *
delivery_date xs:dateTime 0 1 NA NA NA NA NA NA NA
delivery_slot_id varchar215 0 1 Delivery Slot Id. NA NA NA NA NA NA
delivery_slot_desc varchar2240 0 1 Delivery slot description. NA NA NA NA NA NA
ExtOfSODesc:ExtOfSODesc * 0 1 Provide an extension hook to customize SODesc. NA NA NA NA NA NA

XML-Schema Name:SODtlDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For SODtlDesc
Table Name Column Name API Type Column Length API Required API Description
dest_id varchar210 1 1 mapped to TR_LTM_ICD_MR.ID_STR_RT as well, Not Yet Available stock_allocation dest_id varchar2 10 * *
item_id varchar225 1 1 mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available stock_allocation item_id varchar2 25 * *
requested_unit_qty number12_4 1 1 mapped to TR_LTM_ICD_MR.QU_ITM as well.Not Yet Available stock_allocation requested_unit_qty number 12 * *
retail_price number20_4 0 1 NA component_ticketing retail_price number 20 * *
selling_uom varchar24 0 1 NA stock_allocation selling_uom varchar2 4 * *
ticket_type varchar24 0 1 NA stock_allocation ticket_type varchar2 4 * *
priority number4 0 1 NA stock_order priority number 4 * *
store_ord_mult varchar21 0 1 NA stock_allocation store_ord_mult varchar2 1 * *
expedite_flag varchar21 0 1 NA stock_allocation expedite_flag varchar2 1 * *
order_line_nbr number3 0 1 NA stock_allocation_cid order_line_nbr number 3 No Derived as ROWNUM.
amount1 number16_2 0 1 NA stock_allocation amount1 number 16 * *
amount2 number16_2 0 1 NA stock_allocation amount2 number 16 * *
amount3 number16_2 0 1 NA stock_allocation amount3 number 16 * *
amount4 number16_2 0 1 NA stock_allocation amount4 number 16 * *
amount5 number16_2 0 1 NA stock_allocation amount5 number 16 * *
amount6 number16_2 0 1 NA stock_allocation amount6 number 16 * *
tax_percent number12_4 0 1 NA stock_allocation tax_percent number 12 * *
item_status varchar21 0 1 NA stock_allocation item_status varchar2 1 * *
component_ticketing_distro_nbr varchar210 0 1 NA component_ticketing component_ticketing_distro_nbr varchar2 10 * *
in_store_date xs:dateTime 0 1 NA stock_allocation in_store_date RIBDate * * *
total number12_4 0 1 NA transshipment_setupe total number 12 * *
gift_cost number12_4 0 1 NA stock_allocation gift_cost number 12 * *
shipping number12_4 0 1 NA stock_allocation shipping number 12 * *
promotion number10 0 1 NA stock_allocation promotion number 10 * *
sub_total number12_4 0 1 NA stock_allocation sub_total number 12 * *
tax number12_4 0 1 NA stock_allocation tax number 12 * *
order_detail_uda1 varchar210 0 1 NA stock_allocation order_detail_uda1 varchar2 10 * *
order_detail_uda2 varchar210 0 1 NA stock_allocation order_detail_uda2 varchar2 10 * *
order_detail_uda3 varchar210 0 1 NA stock_allocation order_detail_uda3 varchar2 10 * *
order_detail_uda4 varchar210 0 1 NA stock_allocation order_detail_uda4 varchar2 10 * *
order_detail_uda5 varchar210 0 1 NA stock_allocation order_detail_uda5 varchar2 10 * *
SODtlTcktDesc * 0 unbounded Description is not available.
ExtOfSODesc:ExtOfSODtlDesc * 0 1 Provide an extension hook to customize SODtlDesc. NA NA NA NA NA NA

XML-Schema Name:SODtlTcktDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For SODtlTcktDesc
Table Name Column Name API Type Column Length API Required API Description
distro_nbr varchar210 1 1 NA stock_allocation distro_nbr varchar2 10 * *
document_type varchar21 0 1 NA stock_order document_type varchar2 1 * *
item_id varchar225 0 1 NA stock_allocation item_id varchar2 25 * *
dest_id varchar210 0 1 NA stock_allocation dest_id varchar2 10 * *
component_item_id varchar225 1 1 NA component_ticketing component_item_id varchar2 25 * *
retail_price number20_4 0 1 NA component_ticketing retail_price number 20 * *
selling_uom varchar24 1 1 NA component_ticketing selling_uom varchar2 4 * *
ExtOfSODesc:ExtOfSODtlTcktDesc * 0 1 Provide an extension hook to customize SODtlTcktDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfSODtlTcktDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfSODtlTcktDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfSODtlDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfSODtlDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfSODesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfSODesc
Table Name Column Name API Type Column Length API Required API Description