Application
|
Retail Warehouse Management System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/WOOutRef/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:WOOutRef
|
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 WOOutRef 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 |
NA |
* |
* |
number |
10 |
No |
Exists in code but not used |
dc_dest_id |
varchar210 |
1 |
1 |
NA |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
* |
distro_nbr |
varchar212 |
1 |
1 |
NA |
outbound_work_order |
distro_nbr |
varchar2 |
12 |
Yes |
A number which uniquely identifies a distribution order. |
WOOutDtlRef
|
*
|
0
|
unbounded
|
NA
|
|
|
|
|
|
|
distro_parent_nbr |
varchar212 |
0 |
1 |
The higher level transfer that this transfer belongs to. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
|
|
XML-Schema Name:WOOutDtlRef
|
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 WOOutDtlRef 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 |
NA |
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 |
NA |
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 |
NA |
outbound_work_order |
wip_seq_nbr |
number |
7 |
Yes |
Order in which WIP Codes are processed |
order_line_nbr |
number20 |
0 |
1 |
NA |
outbound_work_order |
order_line_nbr |
number |
4 |
Yes |
Order detail information |
|
|