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

XML-Schema Name:SODesc Version:13.2.0 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 12 Yes Contains the stock order number. this is inventory control document number for a transfer or return in SIM
document_type varchar21 1 1 NA null null null null Not used in SIM
dc_dest_id varchar210 1 1 mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available RK_ALLOCATIONS FROM_LOCATION_ID VARCHAR2 128 No Contains the location number of the stock order receiving location.
order_type varchar29 0 1 NA null null null null Not used in SIM
pick_not_before_date xs:dateTime 0 1 Not Yet Available RETURN NOT_AFTER_DATE RIBDate No Not After Date
pick_not_after_date xs:dateTime 0 1 Not Yet Available RK_ALLOCATIONS DELIVERY_DATE RIBDate No Delivery Date
priority number4 0 1 NA null null null null Not used in SIM
event_code varchar26 0 1 NA null null null null Not used in SIM
event_description varchar21000 0 1 NA null null null null Not used in SIM
carrier_code varchar24 0 1 NA null null null null Not used in SIM
carrier_service_code varchar26 0 1 NA null null null null Not used in SIM
route varchar210 0 1 NA null null null null Not used in SIM
ship_address_desc varchar230 0 1 NA null null null null Not used in SIM
ship_address1 varchar2240 0 1 NA null null null null Not used in SIM
ship_address2 varchar2240 0 1 NA null null null null Not used in SIM
ship_address3 varchar2240 0 1 NA null null null null Not used in SIM
ship_address4 varchar2240 0 1 NA null null null null Not used in SIM
ship_address5 varchar2240 0 1 NA null null null null Not used in SIM
ship_city varchar2120 0 1 NA null null null null Not used in SIM
ship_state varchar23 0 1 NA null null null null Not used in SIM
ship_zip varchar230 0 1 NA null null null null Not used in SIM
ship_country_id varchar23 0 1 NA null null null null Not used in SIM
bill_address_desc varchar230 0 1 NA null null null null Not used in SIM
bill_address1 varchar2240 0 1 NA null null null null Not used in SIM
bill_address2 varchar2240 0 1 NA null null null null Not used in SIM
bill_address3 varchar2240 0 1 NA null null null null Not used in SIM
bill_address4 varchar2240 0 1 NA null null null null Not used in SIM
bill_address5 varchar2240 0 1 NA null null null null Not used in SIM
bill_city varchar2120 0 1 NA null null null null Not used in SIM
bill_state varchar23 0 1 NA null null null null Not used in SIM
bill_zip varchar230 0 1 NA null null null null Not used in SIM
bill_country_id varchar23 0 1 NA null null null null Not used in SIM
break_by_distro varchar21 0 1 NA null null null null Not used in SIM
rollback_allocation varchar21 0 1 NA null null null null Not used in SIM
cartonization varchar21 0 1 NA null null null null Not used in SIM
consumer_direct varchar21 0 1 NA null null null null Not used in SIM
message varchar22000 0 1 NA null null null null Not used in SIM
chute_type varchar26 0 1 NA null null null null Not used in SIM
po_nbr varchar210 0 1 NA null null null null Not used in SIM
parent_customer_order varchar220 0 1 NA null null null null Not used in SIM
pick_complete varchar21 0 1 NA null null null null Not used in SIM
order_line_costs varchar21 0 1 NA null null null null Not used in SIM
container_type varchar26 0 1 NA null null null null Not used in SIM
amount1 number16_2 0 1 NA null null null null Not used in SIM
amount2 number16_2 0 1 NA null null null null Not used in SIM
amount3 number16_2 0 1 NA null null null null Not used in SIM
amount4 number16_2 0 1 NA null null null null Not used in SIM
amount5 number16_2 0 1 NA null null null null Not used in SIM
amount6 number16_2 0 1 NA null null null null Not used in SIM
sub_total number12 0 1 NA null null null null Not used in SIM
gift_cost_total number12 0 1 NA null null null null Not used in SIM
promotion_total number12 0 1 NA null null null null Not used in SIM
total number12 0 1 NA null null null null Not used in SIM
tax_total number12 0 1 NA null null null null Not used in SIM
shipping_total number12 0 1 NA null null null null Not used in SIM
order_uda1 varchar210 0 1 NA null null null null null
order_uda2 varchar210 0 1 NA null null null null Not used in SIM
order_uda3 varchar210 0 1 NA null null null null null
order_uda4 varchar210 0 1 NA null null null null Not used in SIM
order_uda5 varchar210 0 1 NA null null null null Not used in SIM
order_uda6 varchar210 0 1 NA null null null null Not used in SIM
order_uda7 varchar210 0 1 NA null null null null Not used in SIM
order_uda8 varchar210 0 1 NA null null null null Not used in SIM
order_uda9 varchar210 0 1 NA null null null null Not used in SIM
order_uda10 varchar210 0 1 NA null null null null Not used in SIM
dl_comment varchar230 0 1 NA null null null null Not used in SIM
ship_date xs:dateTime 0 1 NA null null null null Not used in SIM
SODtlDesc * 0 unbounded Description is not available.
not_after_date xs:dateTime 0 1 NA null null null null Not used in SIM
distro_parent_nbr varchar210 0 1 NA null null null null Not used in SIM
exp_dc_date xs:dateTime 0 1 NA null null null null Not used in SIM
approval_id varchar230 0 1 NA null null null null Not used in SIM
approval_date xs:dateTime 0 1 NA null null null null Not used in SIM
from_loc_tsf_entity number10 0 1 NA null null null null Not used in SIM
to_loc_tsf_entity number10 0 1 NA null null null null Not used in SIM
inv_type varchar26 0 1 NA null null null null Not used in SIM
so_status varchar21 0 1 NA null null null null Not used in SIM
delivery_date xs:dateTime 0 1 NA RK_ALLOCATIONS DELIVERY_DATE RIBDate No Delivery Date
context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. NA NA NA NA NA NA
context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. 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
LocOfSODesc:LocOfSODesc * 0 1 Provide an extension hook to localize SODesc. NA NA NA NA NA NA

XML-Schema Name:SODtlDesc Version:13.2.0 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 Number 10 Yes Store id. This is also referred in TRANSFER.CREATE_STORE_ID and TRANSFER.RECEIVING_STORE_ID
item_id varchar225 1 1 mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available RK_ALLOCATIONS ITEM_ID VARCHAR2 25 Yes Item id. This is also referred in RETURN_LINE_ITEM and TRANSFER_LINE_ITEM
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 Requested quantity. This is also referred in RETURN_LINE_ITEM and TRANSFER_LINE_ITEM tables.
retail_price number20_4 0 1 NA null null null null Not used in SIM
selling_uom varchar24 0 1 NA null null null null Not used in SIM
ticket_type varchar24 0 1 NA null null null null Not used in SIM
priority number4 0 1 NA null null null null Not used in SIM
store_ord_mult varchar21 0 1 NA null null null null Not used in SIM
expedite_flag varchar21 0 1 NA null null null null Not used in SIM
order_line_nbr number3 0 1 NA null null null null Not used in SIM
amount1 number16_2 0 1 NA null null null null Not used in SIM
amount2 number16_2 0 1 NA null null null null Not used in SIM
amount3 number16_2 0 1 NA null null null null Not used in SIM
amount4 number16_2 0 1 NA null null null null Not used in SIM
amount5 number16_2 0 1 NA null null null null Not used in SIM
amount6 number16_2 0 1 NA null null null null Not used in SIM
tax_percent number12_4 0 1 NA null null null null Not used in SIM
item_status varchar21 0 1 NA null null null null Not used in SIM
component_ticketing_distro_nbr varchar210 0 1 NA null null null null Not used in SIM
in_store_date xs:dateTime 0 1 NA null null null null Not used in SIM
total number12_4 0 1 NA null null null null null
gift_cost number12_4 0 1 NA null null null null Not used in SIM
shipping number12_4 0 1 NA null null null null Not used in SIM
promotion number10 0 1 NA null null null null Not used in SIM
sub_total number12_4 0 1 NA null null null null Not used in SIM
tax number12_4 0 1 NA null null null null Not used in SIM
order_detail_uda1 varchar210 0 1 NA null null null null Not used in SIM
order_detail_uda2 varchar210 0 1 NA null null null null Not used in SIM
order_detail_uda3 varchar210 0 1 NA null null null null Not used in SIM
order_detail_uda4 varchar210 0 1 NA null null null null Not used in SIM
order_detail_uda5 varchar210 0 1 NA null null null null Not used in SIM
SODtlTcktDesc * 0 unbounded Description is not available.
ExtOfSODesc:ExtOfSODtlDesc * 0 1 Provide an extension hook to customize SODtlDesc. NA NA NA NA NA NA
LocOfSODesc:LocOfSODtlDesc * 0 1 Provide an extension hook to localize SODtlDesc. NA NA NA NA NA NA

XML-Schema Name:SODtlTcktDesc Version:13.2.0 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 No Not used in SIM
document_type varchar21 0 1 NA null null null null Not used in SIM
item_id varchar225 0 1 NA null null null No Not used in SIM
dest_id varchar210 0 1 NA null null null No Not used in SIM
component_item_id varchar225 1 1 NA null null null null Not used in SIM
retail_price number20_4 0 1 NA null null null null Not used in SIM
selling_uom varchar24 0 1 NA null null null null Not used in SIM
ExtOfSODesc:ExtOfSODtlTcktDesc * 0 1 Provide an extension hook to customize SODtlTcktDesc. NA NA NA NA NA NA
LocOfSODesc:LocOfSODtlTcktDesc * 0 1 Provide an extension hook to localize SODtlTcktDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfSODtlTcktDesc Version:13.2.0 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:LocOfSODtlTcktDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfSODtlTcktDesc
Table Name Column Name API Type Column Length API Required API Description
InSODesc:InSODtlTcktDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSODesc:BrSODtlTcktDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSODtlDesc Version:13.2.0 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:LocOfSODtlDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfSODtlDesc
Table Name Column Name API Type Column Length API Required API Description
InSODesc:InSODtlDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSODesc:BrSODtlDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSODesc Version:13.2.0 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

XML-Schema Name:LocOfSODesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfSODesc
Table Name Column Name API Type Column Length API Required API Description
InSODesc:InSODesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSODesc:BrSODesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA