Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
Application Store Inventory Management
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 sim 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 RK_ALLOCATIONS ALLOCATION_ID varchar2 10 Yes mapped to DO_CTL_INV.ID_ICD as well.Not Yet Available
document_type varchar21 1 1 NA null null null null null
dc_dest_id varchar210 1 1 mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available RK_ALLOCATIONS WAREHOUSE_ID VARCHAR2 128 No mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available
order_type varchar29 0 1 NA null null null null null
pick_not_before_date xs:dateTime 0 1 Not Yet Available DO_CTL_INV NOT_AFTER_DATE RIBDate * No Not Yet Available
pick_not_after_date xs:dateTime 0 1 Not Yet Available RK_ALLOCATIONS DELIVERY_DATE RIBDate * No Not Yet Available
priority number4 1 1 NA null null null null null
event_code varchar26 0 1 NA null null null null null
event_description varchar21000 0 1 NA null null null null null
carrier_code varchar24 0 1 NA null null null null null
carrier_service_code varchar26 0 1 NA null null null null null
route varchar210 0 1 NA null null null null null
ship_address_desc varchar230 0 1 NA null null null null null
ship_address1 varchar2240 0 1 NA null null null null null
ship_address2 varchar2240 0 1 NA null null null null null
ship_address3 varchar2240 0 1 NA null null null null null
ship_address4 varchar2240 0 1 NA null null null null null
ship_address5 varchar2240 0 1 NA null null null null null
ship_city varchar2120 0 1 NA null null null null null
ship_state varchar23 0 1 NA null null null null null
ship_zip varchar230 0 1 NA null null null null null
ship_country_id varchar23 0 1 NA null null null null null
bill_address_desc varchar230 0 1 NA null null null null null
bill_address1 varchar2240 0 1 NA null null null null null
bill_address2 varchar2240 0 1 NA null null null null null
bill_address3 varchar2240 0 1 NA null null null null null
bill_address4 varchar2240 0 1 NA null null null null null
bill_address5 varchar2240 0 1 NA null null null null null
bill_city varchar2120 0 1 NA null null null null null
bill_state varchar23 0 1 NA null null null null null
bill_zip varchar230 0 1 NA null null null null null
bill_country_id varchar23 0 1 NA null null null null null
break_by_distro varchar21 0 1 NA null null null null null
rollback_allocation varchar21 0 1 NA null null null null null
cartonization varchar21 0 1 NA null null null null null
consumer_direct varchar21 0 1 NA null null null null null
message varchar22000 0 1 NA null null null null null
chute_type varchar26 0 1 NA null null null null null
po_nbr varchar210 0 1 NA null null null null null
parent_customer_order varchar220 0 1 NA null null null null null
pick_complete varchar21 0 1 NA null null null null null
order_line_costs varchar21 0 1 NA null null null null null
container_type varchar26 0 1 NA null null null null null
amount1 number16_2 0 1 NA null null null null null
amount2 number16_2 0 1 NA null null null null null
amount3 number16_2 0 1 NA null null null null null
amount4 number16_2 0 1 NA null null null null null
amount5 number16_2 0 1 NA null null null null null
amount6 number16_2 0 1 NA null null null null null
sub_total number12 0 1 NA null null null null null
gift_cost_total number12 0 1 NA null null null null null
promotion_total number12 0 1 NA null null null null null
total number12 0 1 NA null null null null null
tax_total number12 0 1 NA null null null null null
shipping_total number12 0 1 NA null null null null null
order_uda1 varchar210 0 1 NA null null null null null
order_uda2 varchar210 0 1 NA null null null null null
order_uda3 varchar210 0 1 NA null null null null null
order_uda4 varchar210 0 1 NA null null null null null
order_uda5 varchar210 0 1 NA null null null null null
order_uda6 varchar210 0 1 NA null null null null null
order_uda7 varchar210 0 1 NA null null null null null
order_uda8 varchar210 0 1 NA null null null null null
order_uda9 varchar210 0 1 NA null null null null null
order_uda10 varchar210 0 1 NA null null null null null
dl_comment varchar230 0 1 NA null null null null null
ship_date xs:dateTime 0 1 NA null null null null null
SODtlDesc * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 NA null null null null null
distro_parent_nbr varchar210 0 1 NA null null null null null
exp_dc_date xs:dateTime 0 1 NA null null null null null
approval_id varchar230 0 1 NA null null null null null
approval_date xs:dateTime 0 1 NA null null null null null
from_loc_tsf_entity number10 0 1 NA null null null null null
to_loc_tsf_entity number10 0 1 NA null null null null null
inv_type varchar26 0 1 NA null null null null null
so_status varchar21 0 1 NA null null null null null
delivery_date xs:dateTime 0 1 NA null null null null null
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 sim 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 RK_ALLOCATIONS STORE_ID VARCHAR2 128 No mapped to TR_LTM_ICD_MR.ID_STR_RT as well, Not Yet Available
item_id varchar225 1 1 mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available RK_ALLOCATIONS ITEM_ID VARCHAR2 128 No mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available
requested_unit_qty number12_4 1 1 mapped to TR_LTM_ICD_MR.QU_ITM as well.Not Yet Available RK_ALLOCATIONS QUANTITY NUMBER 20,4 No mapped to TR_LTM_ICD_MR.QU_ITM as well.Not Yet Available
retail_price number20_4 0 1 NA null null null null null
selling_uom varchar24 0 1 NA null null null null null
ticket_type varchar24 0 1 NA null null null null null
priority number4 0 1 NA null null null null null
store_ord_mult varchar21 0 1 NA null null null null null
expedite_flag varchar21 0 1 NA null null null null null
order_line_nbr number3 0 1 NA null null null null null
amount1 number16_2 0 1 NA null null null null null
amount2 number16_2 0 1 NA null null null null null
amount3 number16_2 0 1 NA null null null null null
amount4 number16_2 0 1 NA null null null null null
amount5 number16_2 0 1 NA null null null null null
amount6 number16_2 0 1 NA null null null null null
tax_percent number12_4 0 1 NA null null null null null
item_status varchar21 0 1 NA null null null null null
component_ticketing_distro_nbr varchar210 0 1 NA null null null null null
in_store_date xs:dateTime 0 1 NA null null null null null
total number12_4 0 1 NA null null null null null
gift_cost number12_4 0 1 NA null null null null null
shipping number12_4 0 1 NA null null null null null
promotion number10 0 1 NA null null null null null
sub_total number12_4 0 1 NA null null null null null
tax number12_4 0 1 NA null null null null null
order_detail_uda1 varchar210 0 1 NA null null null null null
order_detail_uda2 varchar210 0 1 NA null null null null null
order_detail_uda3 varchar210 0 1 NA null null null null null
order_detail_uda4 varchar210 0 1 NA null null null null null
order_detail_uda5 varchar210 0 1 NA null null null null null
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 sim Mapping For SODtlTcktDesc
Table Name Column Name API Type Column Length API Required API Description
distro_nbr varchar210 1 1 NA null null null null null
document_type varchar21 0 1 NA null null null null null
item_id varchar225 0 1 NA null null null null null
dest_id varchar210 0 1 NA null null null null null
component_item_id varchar225 1 1 NA null null null null null
retail_price number20_4 0 1 NA null null null null null
selling_uom varchar24 1 1 NA null null null null null
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 sim 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 sim 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 sim Mapping For ExtOfSODesc
Table Name Column Name API Type Column Length API Required API Description