Retail Integration Mappings Report Release:16.0.21 (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.
XSD Structure

XML-Schema Name:WOOutDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
wo_id number15 1 1 The work order number for this finishing activity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
dc_dest_id varchar210 1 1 The 'from' location for tis transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
distro_nbr varchar212 1 1 The transfer that this work order is part of. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
WOOutDtl * 1 unbounded Child node - see below.
distro_parent_nbr varchar212 0 1 The higher level transfer that this transfer belongs to. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.

XML-Schema Name:WOOutDtl Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutDtl in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
dest_id varchar210 1 1 The 'to' location for this transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
item_id varchar225 1 1 The item for this portion of the work order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
wip_seq_nbr number7 0 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
wip_code varchar29 0 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
personalization varchar2300 0 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
instructions varchar2300 0 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
order_line_nbr number3 0 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
auto_complete varchar21 1 1 Not used. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
WOOutActivity * 0 unbounded Child node - see below.
inv_status number2 0 1 The inventory status of the transfer detail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.

XML-Schema Name:WOOutActivity Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutActivity in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
activity_id number10 1 1 A code number indicating the activity that will be performed on the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
activity_cost number20_4 0 1 The per-unit cost of the finishing activity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
comments varchar22000 0 1 Any comments regarding this activity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.

XML-Schema Name:WOOutXForm Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutXForm in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
from_item varchar225 1 1 The original item on the transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.
to_item varchar225 1 1 The item which will result from the finishing activity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.

XML-Schema Name:WOOutPacking Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutPacking in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
WOOutPackTo * 1 unbounded Child node - see below.
WOOutPackFrom * 1 unbounded Child node - see below.

XML-Schema Name:WOOutPackTo Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutPackTo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
to_item varchar225 1 1 The item resulting from the packing process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.

XML-Schema Name:WOOutPackFrom Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutPackFrom in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
from_item varchar225 1 1 The item used in the packing process. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null Not used in SIM.