Preface
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>
Comments
0 comments
Please sign in to leave a comment.