Retail Integration Bus Mappings Report Release:13.2.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.

XML-Schema Name:WOOutDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutDesc
Table Name Column Name API Type Column Length API Required API Description
wo_id number15 1 1 The work order number for this finishing activity. * * number 10 Yes Used in interface only.
dc_dest_id varchar210 1 1 The 'from' location for tis transfer. n/a n/a varchar2 10 Yes Used in interface only.
distro_nbr varchar210 1 1 The transfer that this work order is part of. outbound_work_order distro_nbr varchar2 10 Yes *
WOOutDtl * 1 unbounded Child node - see below.
distro_parent_nbr varchar210 0 1 The higher level transfer that this transfer belongs to. * * varchar2 10 * *
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. * * varchar2 6 * *
ExtOfWOOutDesc:ExtOfWOOutDesc * 0 1 Provide an extension hook to customize WOOutDesc. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutDesc * 0 1 Provide an extension hook to localize WOOutDesc. NA NA NA NA NA NA

XML-Schema Name:WOOutDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutDtl
Table Name Column Name API Type Column Length API Required API Description
dest_id varchar210 1 1 The 'to' location for this transfer. outbound_work_order dest_id varchar2 10 Yes *
item_id varchar225 1 1 The item for this portion of the work order. outbound_work_order item_id varchar2 25 Yes *
wip_seq_nbr number7 0 1 Not used. outbound_work_order wip_seq_nbr number 7 No *
wip_code varchar29 0 1 Not used. outbound_work_order wip_code varchar2 6 No *
personalization varchar2300 0 1 Not used. outbound_work_order personalization varchar2 300 No *
instructions varchar2300 0 1 Not used. outbound_work_order instructions varchar2 300 No *
order_line_nbr number3 0 1 Not used. outbound_work_order order_line_nbr number 3 No *
auto_complete varchar21 1 1 Not used. outbound_work_order auto_complete varchar2 1 Yes *
WOOutActivity * 0 unbounded Child node - see below.
inv_status number2 0 1 The inventory status of the transfer detail. * * number 2 * *
ExtOfWOOutDesc:ExtOfWOOutDtl * 0 1 Provide an extension hook to customize WOOutDtl. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutDtl * 0 1 Provide an extension hook to localize WOOutDtl. NA NA NA NA NA NA

XML-Schema Name:WOOutActivity Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutActivity
Table Name Column Name API Type Column Length API Required API Description
activity_id number10 1 1 A code number indicating the activity that will be performed on the item. * * number 10 * *
activity_cost number20_4 0 1 The per-unit cost of the finishing activity. * * number 20 * *
comments varchar22000 0 1 Any comments regarding this activity. * * varchar2 2000 * *
ExtOfWOOutDesc:ExtOfWOOutActivity * 0 1 Provide an extension hook to customize WOOutActivity. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutActivity * 0 1 Provide an extension hook to localize WOOutActivity. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutActivity Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutActivity
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutActivity Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutActivity
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutActivity * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutActivity * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutDtl
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:WOOutXForm Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutXForm
Table Name Column Name API Type Column Length API Required API Description
from_item varchar225 1 1 The original item on the transfer. * * varchar2 25 * *
to_item varchar225 1 1 The item which will result from the finishing activity. * * varchar2 25 * *
ExtOfWOOutDesc:ExtOfWOOutXForm * 0 1 Provide an extension hook to customize WOOutXForm. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutXForm * 0 1 Provide an extension hook to localize WOOutXForm. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutXForm Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutXForm
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutXForm Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutXForm
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutXForm * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutXForm * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:WOOutPacking Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutPacking
Table Name Column Name API Type Column Length API Required API Description
WOOutPackTo * 1 unbounded Child node - see below.
WOOutPackFrom * 1 unbounded Child node - see below.
ExtOfWOOutDesc:ExtOfWOOutPacking * 0 1 Provide an extension hook to customize WOOutPacking. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutPacking * 0 1 Provide an extension hook to localize WOOutPacking. NA NA NA NA NA NA

XML-Schema Name:WOOutPackTo Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutPackTo
Table Name Column Name API Type Column Length API Required API Description
to_item varchar225 1 1 The item resulting from the packing process. * * varchar2 25 * *
ExtOfWOOutDesc:ExtOfWOOutPackTo * 0 1 Provide an extension hook to customize WOOutPackTo. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutPackTo * 0 1 Provide an extension hook to localize WOOutPackTo. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutPackTo Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutPackTo
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutPackTo Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutPackTo
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutPackTo * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutPackTo * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:WOOutPackFrom Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOOutPackFrom
Table Name Column Name API Type Column Length API Required API Description
from_item varchar225 1 1 The item used in the packing process. * * varchar2 25 * *
ExtOfWOOutDesc:ExtOfWOOutPackFrom * 0 1 Provide an extension hook to customize WOOutPackFrom. NA NA NA NA NA NA
LocOfWOOutDesc:LocOfWOOutPackFrom * 0 1 Provide an extension hook to localize WOOutPackFrom. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutPackFrom Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutPackFrom
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutPackFrom Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutPackFrom
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutPackFrom * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutPackFrom * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutPacking Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutPacking
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutPacking Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutPacking
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutPacking * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutPacking * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOOutDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOOutDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOOutDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOOutDesc
Table Name Column Name API Type Column Length API Required API Description
InWOOutDesc:InWOOutDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOOutDesc:BrWOOutDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA