Application
|
Store Inventory Management
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
wo_id |
number15 |
1 |
1 |
The work order number for this finishing activity. |
|
|
|
|
null |
Not used in SIM. |
dc_dest_id |
varchar210 |
1 |
1 |
The 'from' location for tis transfer. |
|
|
|
|
null |
Not used in SIM. |
distro_nbr |
varchar212 |
1 |
1 |
The transfer that this work order is part of. |
|
|
|
|
null |
Not used in SIM. |
WOOutDtl
|
*
|
1
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
distro_parent_nbr |
varchar212 |
0 |
1 |
The higher level transfer that this transfer belongs to. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM. |
|
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
dest_id |
varchar210 |
1 |
1 |
The 'to' location for this transfer. |
|
|
|
|
null |
Not used in SIM. |
item_id |
varchar225 |
1 |
1 |
The item for this portion of the work order. |
|
|
|
|
null |
Not used in SIM. |
wip_seq_nbr |
number7 |
0 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
wip_code |
varchar29 |
0 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
personalization |
varchar2300 |
0 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
instructions |
varchar2300 |
0 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
order_line_nbr |
number3 |
0 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
auto_complete |
varchar21 |
1 |
1 |
Not used. |
|
|
|
|
null |
Not used in SIM. |
WOOutActivity
|
*
|
0
|
unbounded
|
Child node - see below.
|
|
|
|
|
|
|
inv_status |
number2 |
0 |
1 |
The inventory status of the transfer detail. |
|
|
|
|
null |
Not used in SIM. |
|
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
activity_id |
number10 |
1 |
1 |
A code number indicating the activity that will be performed on the item. |
|
|
|
|
null |
Not used in SIM. |
activity_cost |
number20_4 |
0 |
1 |
The per-unit cost of the finishing activity. |
|
|
|
|
null |
Not used in SIM. |
comments |
varchar22000 |
0 |
1 |
Any comments regarding this activity. |
|
|
|
|
null |
Not used in SIM. |
|
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
from_item |
varchar225 |
1 |
1 |
The original item on the transfer. |
|
|
|
|
null |
Not used in SIM. |
to_item |
varchar225 |
1 |
1 |
The item which will result from the finishing activity. |
|
|
|
|
null |
Not used in SIM. |
|
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM'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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
to_item |
varchar225 |
1 |
1 |
The item resulting from the packing process. |
|
|
|
|
null |
Not used in SIM. |
|
|
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 SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
from_item |
varchar225 |
1 |
1 |
The item used in the packing process. |
|
|
|
|
null |
Not used in SIM. |
|
|