Retail Integration Mappings Report Release:15.0.0

(Retail Merchandising System)

Application Retail Merchandising 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. XSD Structure WOOutDesc WOOutDtl WOOutActivity WOOutXForm WOOutPacking WOOutPackTo WOOutPackFrom

XML-Schema Name:WOOutDesc Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutDesc in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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 varchar212 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 varchar212 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).

XML-Schema Name:WOOutDtl Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutDtl in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.

XML-Schema Name:WOOutActivity Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutActivity in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.

XML-Schema Name:WOOutXForm Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutXForm in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.

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

XML-Schema Name:WOOutPackTo Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutPackTo in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.

XML-Schema Name:WOOutPackFrom Version:15.0.0 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutPackFrom in RMS application. RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.