Retail Integration Mappings Report Release:14.1.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. XSD Structure WOOutDesc WOOutDtl WOOutActivity WOOutXForm WOOutPacking WOOutPackTo WOOutPackFrom

XML-Schema Name:WOOutDesc Version:14.1.0 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. null Not used in SIM. dc_dest_id varchar210 1 1 The 'from' location for tis transfer. null Not used in SIM. distro_nbr varchar212 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 varchar212 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.

XML-Schema Name:WOOutDtl Version:14.1.0 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. 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.

XML-Schema Name:WOOutActivity Version:14.1.0 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. 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.

XML-Schema Name:WOOutXForm Version:14.1.0 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. null Not used in SIM. to_item varchar225 1 1 The item which will result from the finishing activity. null Not used in SIM.

XML-Schema Name:WOOutPacking Version:14.1.0 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:14.1.0 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. null Not used in SIM.

XML-Schema Name:WOOutPackFrom Version:14.1.0 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. null Not used in SIM.