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.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.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.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.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.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.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 |
|
|