Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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 rms 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. 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 varchar210 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 varchar210 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).
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 rms 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. 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.
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 rms 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. 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.
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 rms 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 rms 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 rms 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 rms 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 rms 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. 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.
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 rms 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 rms 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 rms 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 rms 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. tsf_packing_detail item null null Yes The item resulting from the packing process.
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 rms 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 rms 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 rms 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. tsf_packing_detail item null null Yes The item used in the packing process.
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 rms 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 rms 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 rms 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 rms 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 rms 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 rms 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