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