Application
|
Retail Merchandising 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:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
wo_id |
number15 |
1 |
1 |
The work order number for this finishing activity. |
tsf-wo-head |
tsf_wo_id |
null |
null |
Yes |
The work order number for this finishing activity. |
dc_dest_id |
varchar210 |
1 |
1 |
The 'from' location for tis transfer. |
tsfhead |
from_loc |
null |
null |
Yes |
The From location for this transfer. |
distro_nbr |
varchar212 |
1 |
1 |
The transfer that this work order is part of. |
tsfhead |
tsf-no |
null |
null |
Yes |
The transfer of which this work order is a part. |
WOOutDtl
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
distro_parent_nbr |
varchar212 |
0 |
1 |
The higher level transfer that this transfer belongs to. |
tsfhead |
tsf-parent-no |
null |
null |
No |
The higher level transfer to which this transfer belongs. |
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. |
tsfhead |
inventory_type |
null |
null |
Yes |
A code to indicate whether the inventory on the transfer is available. Valid values are A (available) and U (unavailable). |
|
|
XML-Schema Name:WOOutDtl
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutDtl in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
dest_id |
varchar210 |
1 |
1 |
The 'to' location for this transfer. |
tsfhead |
to-loc |
null |
null |
Yes |
The To location for this transfer. |
item_id |
varchar225 |
1 |
1 |
The item for this portion of the work order. |
tsf_wo_detail |
item |
null |
null |
Yes |
The item for this portion of the work order. |
wip_seq_nbr |
number7 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
wip_code |
varchar29 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
personalization |
varchar2300 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
instructions |
varchar2300 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
order_line_nbr |
number3 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
auto_complete |
varchar21 |
1 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
WOOutActivity
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
inv_status |
number2 |
0 |
1 |
The inventory status of the transfer detail. |
tsfdetail |
inv_status |
null |
null |
No |
The inventory status of the transfer detail. |
|
|
XML-Schema Name:WOOutActivity
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutActivity in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
activity_id |
number10 |
1 |
1 |
A code number indicating the activity that will be performed on the item. |
tsf_wo_detail |
activity_id |
null |
null |
No |
A code (number) indicating the activity that will be performed on the item. |
activity_cost |
number20_4 |
0 |
1 |
The per-unit cost of the finishing activity. |
tsf_wo_detail |
unit_cost |
null |
null |
No |
The per-unit cost of the finishing activity. |
comments |
varchar22000 |
0 |
1 |
Any comments regarding this activity. |
tsf_wo_detail |
comments |
null |
null |
No |
Comments regarding this activity. |
|
|
XML-Schema Name:WOOutXForm
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutXForm in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
from_item |
varchar225 |
1 |
1 |
The original item on the transfer. |
tsf_xform_detail |
from_item |
null |
null |
No |
The original item on the transfer. |
to_item |
varchar225 |
1 |
1 |
The item which will result from the finishing activity. |
tsf_xform_detail |
to_item |
null |
null |
No |
The item resulting from the finishing activity. |
|
|
XML-Schema Name:WOOutPacking
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPacking in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
WOOutPackTo
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
WOOutPackFrom
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
|
|
XML-Schema Name:WOOutPackTo
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPackTo in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
to_item |
varchar225 |
1 |
1 |
The item resulting from the packing process. |
tsf_packing_detail |
item |
null |
null |
Yes |
The item resulting from the packing process. |
|
|
XML-Schema Name:WOOutPackFrom
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOOutPackFrom in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
from_item |
varchar225 |
1 |
1 |
The item used in the packing process. |
tsf_packing_detail |
item |
null |
null |
Yes |
The item used in the packing process. |
|
|