XML Format 2

From WMS Wiki
Jump to: navigation, search

Contents

Overview

The XML Format 2 is used to import transactions into the WMS. If you are not sure if this is the correct file please check the XML File Import page.

XML Structure

The XML contains the following structure:

  • Master AWB
    • AWB: The master AWB #
    • Ship Date: The farm ship date. (mm/dd/yyyy)
    • Origin: The farm port of origin.
    • Destination: The port of destination.
    • Cargo Agent: The cargo agent code (optional)
    • House
      • House AWB: The house AWB. This value must be unique within the AWB.
      • Customer Code: The customer group code (this is required when customers are going to be managing inventory). The customer group allows the system to keep track of the owner of the product once it has been scheduled to ship to a different consignee.
      • Customer Name: The customer group (this is required when customers are going to be managing inventory). The customer group allows the system to keep track of the owner of the product once it has been scheduled to ship to a different consignee.
      • Exporter Code: The farm code.
      • Exporter Name: The farm name.
      • Truck Date: The truck date (optional) (mm/dd/yyyy)
      • Carrier: (optional) The carrier code (optional)
      • Kilos: (optional) The amount of kilos for the house (optional)
      • Packing: Indicates if the XML will include the box numbers that are generated by an external system (value of 1 - Default) or if the unique barcode numbers are to be automatically generated by the WMS (value of 0).
      • Box
        • Consignee: (optional) The customer code.
        • Box Id: The barcode value. This information is required if the Packing field is is to 1. Barcode values must be unique in the system. It's up to the farm to ensure that each barcode is unique.
        • Product Code: The product code.
        • Product Description: (optional) The product description.
        • Box Type: The box type. Valid box types are defined here.
        • Units Box: (optional) The bunches per box.
        • Units Bunch: (optional) The stems per bunch.
        • Unit Price: (optional) The unit price per stem.
        • Length: (optional) The box length.
        • Width: (optional) The box width.
        • Height: (optional) The box height.
        • Lot Number: (optional) The lot number.
        • Kilos: (optional) The amount of kilos for the box. This value is valid only if the number of kilos at the house level are not sent.


Sample XML - WMS Generated Barcodes

This shipment is created by a farm that does not create the unique barcode values. The highlighted lines indicate the Packing field with a value of 0 (barcode values will be generated by the WMS) and the Piezas (quantity) indicates the number of boxes that are to be generated by the WMS. Please note that the Packing value affects each house AWB. A house AWB can either have the boxes created by the WMS or sent by the farm.

The system will create each box using the same properties in the house AWB (e.g.: each box will have the same product code, description, dimensions, etc.).

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <root>
  3. <master_awb>
  4.     <awb>045-5676 2064</awb>
  5.     <ship_date>11/20/2010</ship_date>
  6.     <origin_code>UIO</origin_code>
  7.     <origin_name>QUITO</origin_name>
  8.     <destination_code>MIA</destination_code>
  9.     <destination_name>MIAMI</destination_name>
  10.     <cargo_agent>LIB</cargo_agent>
  11.     <house_awb>
  12.         <hawb>01108494</hawb>
  13.         <customer_code>CODE</customer_code>
  14.         <customer_name>CUSTOMER-GROUP NAME</customer_name>
  15.         <exporter_code>FL-785</exporter_code>
  16.         <exporter_name>FLOR ETERNA S.A.</exporter_name>
  17.         <truck_date>13/20/2010</truck_date>
  18.         <carrier>ARM</carrier>
  19.         <kilos>3.5</kilos>
  20.         <packing>0</packing>
  21.         <box>
  22.             <quantity>10</quantity>
  23.             <consignee>CODE</consignee>
  24.             <box_type>QB</box_type>
  25.             <units_box>12</units_box>
  26.         </box>
  27.     </house_awb>
  28. </master_awb>
  29. </root>
 Bulb.png The values in the XML are for sample purposes only.  Please make sure to replace each tag with your real values.

Sample XML - Farm Generated Barcodes

This shipment is created by a farm that creates the unique barcode values from their system.

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <root>
  3. <master_awb>
  4.     <awb>045-5676 2064</awb>
  5.     <ship_date>11/20/2010</ship_date>
  6.     <origin_code>UIO</origin_code>
  7.     <origin_name>QUITO</origin_name>
  8.     <destination_code>MIA</destination_code>
  9.     <destination_name>MIAMI</destination_name>
  10.     <cargo_agent>LIB</cargo_agent>
  11.     <house_awb>
  12.         <hawb>01108494</hawb>
  13.         <customer_code>CODE</customer_code>
  14.         <customer_name>CUSTOMER-GROUP NAME</customer_name>
  15.         <exporter_code>FL-785</exporter_code>
  16.         <exporter_name>FLOR ETERNA S.A.</exporter_name>
  17.         <truck_date>13/20/2010</truck_date>
  18.         <carrier>ARM</carrier>
  19.         <kilos>2</kilos>
  20.         <box>
  21.             <boxId>K457466</boxId>
  22.             <consignee>CODE</consignee>
  23.             <product_code>118897</product_code>
  24. 	    <product_description>Delphinium Blue River 90 Cm</product_description>
  25.             <box_type>QB</box_type>
  26.             <units_box>12</units_box>
  27.             <units_bunch>5</units_bunch>
  28.             <unit_price>0.245</unit_price>
  29.             <length>41</length>
  30.             <width></width>
  31.             <height></height>
  32.             <po></po>
  33.             <sp_pack></sp_pack>
  34. 	    <lotNumber>10052</lotNumber>
  35.         </box>
  36.         <box>
  37.             <boxId>K457555</boxId>
  38.             <consignee>CODE</consignee>
  39.             <product_code>118897</product_code>
  40. 	    <product_description>Delphinium Blue River 90 Cm</product_description>
  41.             <box_type>QB</box_type>
  42.             <units_box>12</units_box>
  43.             <units_bunch>5</units_bunch>
  44.             <unit_price>0.223</unit_price>
  45.             <length>41</length>
  46.             <width></width>
  47.             <height></height>
  48.             <po></po>
  49. 	    <sp_pack></sp_pack>
  50. 	    <lotNumber>10052</lotNumber>
  51.         </box>
  52.     </house_awb>
  53.     <house_awb>
  54.         <hawb>01109856</hawb>
  55.         <customer_code>CODE</customer_code>
  56.         <customer_name>CUSTOMER-GROUP NAME</customer_name>
  57.         <exporter_code>FL-785</exporter_code>
  58.         <exporter_name>FLOR ETERNA S.A.</exporter_name>
  59.         <truck_date>13/20/2010</truck_date>
  60.         <carrier>ARM</carrier>
  61.         <box>
  62.             <boxId>K450000</boxId>
  63.             <consignee>CODE</consignee>
  64.             <product_code>118897</product_code>
  65. 	    <product_description>Delphinium Blue River 90 Cm</product_description>
  66.             <box_type>QB</box_type>
  67.             <units_box>12</units_box>
  68.             <units_bunch>5</units_bunch>
  69.             <unit_price>0</unit_price>
  70.             <length>41</length>
  71.             <width></width>
  72.             <height></height>
  73.             <po></po>
  74. 	    <sp_pack></sp_pack>
  75. 	    <lotNumber>10052</lotNumber>
  76.         </box>
  77.         <box>
  78.             <boxId>K457333</boxId>
  79.             <consignee>CODE</consignee>
  80.             <product_code>118897</product_code>
  81. 	    <product_description>Delphinium Blue River 90 Cm</product_description>
  82.             <box_type>QB</box_type>
  83.             <units_box>12</units_box>
  84.             <units_bunch>5</units_bunch>
  85.             <unit_price>0</unit_price>
  86.             <length>41</length>
  87.             <width></width>
  88.             <height></height>
  89.             <po></po>
  90. 	    <sp_pack></sp_pack>
  91. 	    <lotNumber>10052</lotNumber>
  92.         </box>
  93.     </house_awb>
  94. </master_awb>
  95. </root>


 Bulb.png The values in the XML are for sample purposes only.  Please make sure to replace each tag with your real values.

Box Types

  • FB: Full box.
  • HB: Half box.
  • QB: Quarter box.
  • EB: Eigth box.
  • PR: Procona / Hamper.
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox