Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
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:15.0.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:15.0.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:15.0.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:15.0.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:15.0.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:15.0.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:15.0.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