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.
|
XSD Structure
|
|
|
XML-Schema Name:WOOutDesc
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
wo_id |
number15 |
1 |
1 |
The work order number for this finishing activity. |
* |
* |
number |
15 |
No |
Used in interface only. |
dc_dest_id |
varchar210 |
1 |
1 |
The 'from' location for tis transfer. |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
Used in interface only. |
distro_nbr |
varchar212 |
1 |
1 |
The transfer that this work order is part of. |
outbound_work_order |
distro_nbr |
varchar2 |
12 |
Yes |
A number which uniquely identifies a distribution order. |
WOOutDtl
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
distro_parent_nbr |
varchar212 |
0 |
1 |
The higher level transfer that this transfer belongs to. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
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. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutDtl
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutDtl in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
dest_id |
varchar210 |
1 |
1 |
The 'to' location for this transfer. |
outbound_work_order |
dest_id |
varchar2 |
10 |
Yes |
A number which uniquely identifies a destination to which the DC delivers goods |
item_id |
varchar225 |
1 |
1 |
The item for this portion of the work order. |
outbound_work_order |
item_id |
varchar2 |
25 |
Yes |
Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc. |
wip_seq_nbr |
number7 |
0 |
1 |
Not used. |
outbound_work_order |
wip_seq_nbr |
number |
7 |
Yes |
Order in which WIP Codes are processed |
wip_code |
varchar29 |
0 |
1 |
Not used. |
outbound_work_order |
wip_code |
varchar2 |
9 |
Yes |
Work in process code setup in wip_code table |
personalization |
varchar2300 |
0 |
1 |
Not used. |
outbound_work_order |
personalization |
varchar2 |
300 |
No |
Indicates whether the work order has personalization. |
instructions |
varchar2300 |
0 |
1 |
Not used. |
outbound_work_order |
instructions |
varchar2 |
300 |
No |
Specific instructions needed on an outbound work order. |
order_line_nbr |
number3 |
0 |
1 |
Not used. |
outbound_work_order |
order_line_nbr |
number |
3 |
No |
Order detail information |
auto_complete |
varchar21 |
1 |
1 |
Not used. |
outbound_work_order |
auto_complete |
varchar2 |
1 |
No |
If NULL default to 'Y' |
WOOutActivity
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
inv_status |
number2 |
0 |
1 |
The inventory status of the transfer detail. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutActivity
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutActivity in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
activity_id |
number10 |
1 |
1 |
A code number indicating the activity that will be performed on the item. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
activity_cost |
number20_4 |
0 |
1 |
The per-unit cost of the finishing activity. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
comments |
varchar22000 |
0 |
1 |
Any comments regarding this activity. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutXForm
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutXForm in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
from_item |
varchar225 |
1 |
1 |
The original item on the transfer. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
to_item |
varchar225 |
1 |
1 |
The item which will result from the finishing activity. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutPacking
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPacking in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
WOOutPackTo
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
WOOutPackFrom
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
|
|
XML-Schema Name:WOOutPackTo
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPackTo in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
to_item |
varchar225 |
1 |
1 |
The item resulting from the packing process. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutPackFrom
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPackFrom in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
from_item |
varchar225 |
1 |
1 |
The item used in the packing process. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|