Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
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.

XML-Schema Name:WOOutDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
dc_dest_id varchar210 1 1 The 'from' location for tis transfer. null null null null null
distro_nbr varchar210 1 1 The transfer that this work order is part of. null null null null null
WOOutDtl * 1 unbounded Child node - see below.
distro_parent_nbr varchar210 0 1 The higher level transfer that this transfer belongs to. null null null null null
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 null null null null
ExtOfWOOutDesc:ExtOfWOOutDesc * 0 1 Provide an extension hook to customize WOOutDesc. NA NA NA NA NA NA

XML-Schema Name:WOOutDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
item_id varchar225 1 1 The item for this portion of the work order. null null null null null
wip_seq_nbr number7 0 1 Not used. null null null null null
wip_code varchar29 0 1 Not used. null null null null null
personalization varchar2300 0 1 Not used. null null null null null
instructions varchar2300 0 1 Not used. null null null null null
order_line_nbr number3 0 1 Not used. null null null null null
auto_complete varchar21 1 1 Not used. null null null null null
WOOutActivity * 0 unbounded Child node - see below.
inv_status number2 0 1 The inventory status of the transfer detail. null null null null null
ExtOfWOOutDesc:ExtOfWOOutDtl * 0 1 Provide an extension hook to customize WOOutDtl. NA NA NA NA NA NA

XML-Schema Name:WOOutActivity Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
activity_cost number20_4 0 1 The per-unit cost of the finishing activity. null null null null null
comments varchar22000 0 1 Any comments regarding this activity. null null null null null
ExtOfWOOutDesc:ExtOfWOOutActivity * 0 1 Provide an extension hook to customize WOOutActivity. NA NA NA NA NA NA

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

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

XML-Schema Name:WOOutXForm Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
to_item varchar225 1 1 The item which will result from the finishing activity. null null null null null
ExtOfWOOutDesc:ExtOfWOOutXForm * 0 1 Provide an extension hook to customize WOOutXForm. NA NA NA NA NA NA

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

XML-Schema Name:WOOutPacking Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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

XML-Schema Name:WOOutPackTo Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
ExtOfWOOutDesc:ExtOfWOOutPackTo * 0 1 Provide an extension hook to customize WOOutPackTo. NA NA NA NA NA NA

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

XML-Schema Name:WOOutPackFrom Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. null null null null null
ExtOfWOOutDesc:ExtOfWOOutPackFrom * 0 1 Provide an extension hook to customize WOOutPackFrom. NA NA NA NA NA NA

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

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

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