Application
|
Retail Warehouse Management System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/WOOutDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:WOOutDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
wo_id |
number15 |
1 |
1 |
The work order number for this finishing activity. |
* |
* |
number |
10 |
Yes |
Used in interface only. |
dc_dest_id |
varchar210 |
1 |
1 |
The 'from' location for tis transfer. |
n/a |
n/a |
varchar2 |
10 |
Yes |
Used in interface only. |
distro_nbr |
varchar210 |
1 |
1 |
The transfer that this work order is part of. |
outbound_work_order |
distro_nbr |
varchar2 |
10 |
Yes |
* |
WOOutDtl
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
distro_parent_nbr |
varchar210 |
0 |
1 |
The higher level transfer that this transfer belongs to. |
* |
* |
varchar2 |
10 |
* |
* |
WOOutXForm
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
WOOutPacking
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
inv_type |
varchar26 |
0 |
1 |
A code to indicate whether the inventory on the transfer is available. A = available; U = unavailable. |
* |
* |
varchar2 |
6 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutDesc
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:WOOutDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
dest_id |
varchar210 |
1 |
1 |
The 'to' location for this transfer. |
outbound_work_order |
dest_id |
varchar2 |
10 |
Yes |
* |
item_id |
varchar225 |
1 |
1 |
The item for this portion of the work order. |
outbound_work_order |
item_id |
varchar2 |
25 |
Yes |
* |
wip_seq_nbr |
number7 |
0 |
1 |
Not used. |
outbound_work_order |
wip_seq_nbr |
number |
7 |
No |
* |
wip_code |
varchar29 |
0 |
1 |
Not used. |
outbound_work_order |
wip_code |
varchar2 |
6 |
No |
* |
personalization |
varchar2300 |
0 |
1 |
Not used. |
outbound_work_order |
personalization |
varchar2 |
300 |
No |
* |
instructions |
varchar2300 |
0 |
1 |
Not used. |
outbound_work_order |
instructions |
varchar2 |
300 |
No |
* |
order_line_nbr |
number3 |
0 |
1 |
Not used. |
outbound_work_order |
order_line_nbr |
number |
3 |
No |
* |
auto_complete |
varchar21 |
1 |
1 |
Not used. |
outbound_work_order |
auto_complete |
varchar2 |
1 |
Yes |
* |
WOOutActivity
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
inv_status |
number2 |
0 |
1 |
The inventory status of the transfer detail. |
* |
* |
number |
2 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutDtl
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:WOOutActivity
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutActivity |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
activity_id |
number10 |
1 |
1 |
A code number indicating the activity that will be performed on the item. |
* |
* |
number |
10 |
* |
* |
activity_cost |
number20_4 |
0 |
1 |
The per-unit cost of the finishing activity. |
* |
* |
number |
20 |
* |
* |
comments |
varchar22000 |
0 |
1 |
Any comments regarding this activity. |
* |
* |
varchar2 |
2000 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutActivity
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutActivity.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOOutActivity
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutActivity |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfWOOutDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:WOOutXForm
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutXForm |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
from_item |
varchar225 |
1 |
1 |
The original item on the transfer. |
* |
* |
varchar2 |
25 |
* |
* |
to_item |
varchar225 |
1 |
1 |
The item which will result from the finishing activity. |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutXForm
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutXForm.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOOutXForm
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutXForm |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:WOOutPacking
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutPacking |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
WOOutPackTo
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
WOOutPackFrom
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
ExtOfWOOutDesc:ExtOfWOOutPacking
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutPacking.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:WOOutPackTo
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutPackTo |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
to_item |
varchar225 |
1 |
1 |
The item resulting from the packing process. |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutPackTo
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutPackTo.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOOutPackTo
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutPackTo |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:WOOutPackFrom
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOOutPackFrom |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
from_item |
varchar225 |
1 |
1 |
The item used in the packing process. |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfWOOutDesc:ExtOfWOOutPackFrom
|
*
|
0
|
1
|
Provide an extension hook to customize WOOutPackFrom.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOOutPackFrom
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutPackFrom |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfWOOutPacking
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutPacking |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfWOOutDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOOutDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|