Export definition orderfiles

This definition describes the order file format of inONE. This format can be used for orders from inONE (for suppliers) AND orders sent to inONE (being done by buyers) for processing by inONE.

 

XML Order files (order_date_time.xml)

•    filename of xml order file are ALWAYS unique (Ordername_date_time.xml).
•    All orders files can / will be put on an ftp site supplied by inONE.
•    One file can only contain 1 order.
•    XML orderfile always contains header data (Orderid, deliverydate etc).

Characteristics of the order export file:

=== Orderhead ===
•    Order id: @ optional the unique order id supplied by inONE
•    Order reference: @ optional: an order reference no (supplied by external system)
•    Delivery date: dd-mm-yyyy deliverydate of the order
•    Creation date: dd-mm-yyyy hh-mm-ss  optional creation date of the order
•    Supplier id: @ optiuonal the inONE id of the supplier
•    Supplier name: @ optional the inONE name of the supplier
•    Buyer id: @ optional the inONE id the buyer account
•    Buyer name: @ optional then name of the buyer account
•    Debtorid: @ the debtor-id of the buyer being used by supplier
•    Buyer id_Ext*:@ optional, the external customer no/reference nr which can be used by the backend system of the supplier / buyer
•    Supplier id_Ext*:@ optional, the external supplier id/ reference no which can be used by the backend system of the supplier.
•    Creator: @ optional, the creator of the order
•    Total order price:# 999999.99 optional the total price of the order
•    Remark: @ optional the total remark of the order.
•    emailErrorReport: @ optional email adress for sending error reports in case the order cannot be imported.

* the reference number for buyer and supplier need to be supplied in advance.

=== Orderrow ===
•    Product id: @ the suplier product number.
•    Product name: @ name of the product.
•    Product unit: @ product unit / orderunit**
•    Product portion: # product portion in grams.
•    Quantity: # 00.00 quantity orderred.
•    Product price: # optional 9999.99 price per 1 piece/kg.
•    Product rowprice: # optional 9999.99 total rowprice (price x quantity).
•    Row remark: @ optional row comment per product.

**Orderunit

• Kg
• Piece
• Gr/portion (a portion in grams need to be supplied with this unit)
• Other: piece units like Box, bag, sac, crate etc.

Example of an order file:

<?xml version="1.0" encoding="UTF-8"?>

<order>

    <orderid>QSUFG2-1</orderid>

    <deliverydate>08-04-2016</deliverydate>

    <creationdate>07-10-2016 10:23:22</creationdate>

    <supplierid>SMWTY3</supplierid>

    <suppliername>Smit and Dorlas</suppliername>

    <buyerid>QSUFG2</buyerid>

    <buyername>IND office Zwolle</buyername>

    <debtorid>1000099</debtorid>

    <totalorderprice>70.90</totalorderprice>

    <remark><![CDATA[please deliver on time]]></remark>
    
    <emailerrorreport>sales@smitendoorlas.nl</emailerrorreport>
    

    <orderrow>

        <productid>101000</productid>

        <productname><![CDATA[Smit and Dorlas Special]]></productname>

        <productunit>Piece</productunit>

        <productportion></productportion>

        <quantity>1.00</quantity>

        <productprice>12.95</productprice>

        <productrowprice>12.95</productrowprice>

        <rowremark></rowremark>

    </orderrow>

    <orderrow>

        <productid>201003</productid>

        <productname><![CDATA[Steak portioned]]></productname>

        <productunit>Gr/portion</productunit>

        <productportion>200</productportion>

        <quantity>10.00</quantity>

        <productprice>10.00</productprice>

        <productrowprice>20.00</productrowprice>

        <rowremark><![CDATA[ 3pc vac]]></rowremark>

    </orderrow>

    <orderrow>

        <productid>300253</productid>

        <productname><![CDATA[Kaldi Barista Blend 250]]></productname>

        <productunit>Piece</productunit>

        <productportion></productportion>

        <quantity>3.00</quantity>

        <productprice>12.65</productprice>

        <productrowprice>37.95</productrowprice>

        <rowremark></rowremark>

    </orderrow>

 </order>