Retail Integration Bus Mappings Report Release:13.2.0 (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.2.0 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 Not used in SIM.
dc_dest_id varchar210 1 1 The 'from' location for tis transfer. null Not used in SIM.
distro_nbr varchar210 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 varchar210 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.
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 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 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.
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 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 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.
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 sim 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 sim 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 sim 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 sim 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 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 Not used in SIM.
to_item varchar225 1 1 The item which will result from the finishing activity. null Not used in SIM.
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 sim 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 sim 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 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
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 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 Not used in SIM.
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 sim 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 sim 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 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 Not used in SIM.
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 sim 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 sim 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 sim 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 sim 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 sim 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 sim 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