One moment please...
 

Sales & Purchase order import IDF

 

Order;HeaderIndicator;
Order;HeaderIndicatorColumn;
Order;Startline;
Order;Options;
Order;Decimalseparator;notimplementedyet
-------Order type should be "V" for SALES and "B" for PURCHASE order
Order;Ordertype;
Order;Ordernumber;
Order;Prepayment;
Order;Confirm;
Order;Partdelivery;
Order;Description;
Order;Reference1;
Order;Reference2;
Order;Reference3;
Order;YourRef;
Order;OurRef;
Order;Orderdate;
Order;Orderdateformat;"yyyy-mm-dd"
Order;Currency;
Order;Resource;
-------ORDERED BY: only used in SALES order
Order;OrderedBy;
Order;OrderedByCompanyName;
Order;OrderedByAddresseeName;
Order;OrderedByAddresseeInitials;
Order;OrderedByAddresseeTitle;
Order;OrderedByAddresseeJobDescription;
Order;OrderedByAddresseeEmail;
Order;OrderedByAddressLine1;
Order;OrderedByAddressLine2;
Order;OrderedByAddressLine3;
Order;OrderedByAddressNo
Order;OrderedByAddressSuffix;
Order;OrderedByPostalCode;
Order;OrderedByCity;
Order;OrderedByCounty;
Order;OrderedByState;
Order;OrderedByCountry;
Order;OrderedByPhone;
Order;OrderedByFax;
-------ORDERED AT: only used in PURCHASE order
Order;OrderedAt;
Order;OrderedAtCompanyName;
Order;OrderedAtAddresseeName;
Order;OrderedAtAddresseeInitials;
Order;OrderedAtAddresseeTitle;
Order;OrderedAtAddresseeJobDescription;
Order;OrderedAtAddresseeEmail;
Order;OrderedAtAddressLine1;
Order;OrderedAtAddressLine2;
Order;OrderedAtAddressLine3;
Order;OrderedAtAddressNo;
Order;OrderedAtAddressSuffix;
Order;OrderedAtPostalCode;
Order;OrderedAtCity;
Order;OrderedAtCounty
Order;OrderedAtState
Order;OrderedAtCountry;
Order;OrderedAtPhone;
Order;OrderedAtFax;
-------DELIVER TO: used in SALES and PURCHASE order
Order;DeliverTo;
Order;DeliverToCompanyName;
Order;Deliverdate;
Order;Deliverdateformat;"yyyy-mm-dd"
Order;DeliverToAddresseeName;
Order;DeliverToAddresseeInitials;
Order;DeliverToAddresseeTitle;
Order;DeliverToAddresseeJobDescription;
Order;DeliverToAddresseeEmail;
Order;DeliverToAddressLine1;
Order;DeliverToAddressLine2;
Order;DeliverToAddressLine3;
Order;DeliverToAddressNo;
Order;DeliverToAddressSuffix;
Order;DeliverToPostalCode;
Order;DeliverToCity;
Order;DeliverToCounty
Order;DeliverToState
Order;DeliverToCountry;
Order;DeliverToPhone
Order;DeliverToFax

 

-------INVOICE TO used in SALES and PURCHASE order
Order;InvoiceTo;
Order;InvoiceToCompanyName;
Order;InvoiceToAddresseeName
Order;InvoiceToAddresseeInitials;
Order;InvoiceToAddresseeTitle;
Order;InvoiceToAddresseeJobDescription;
Order;InvoiceToAddresseeEmail;
Order;InvoiceToAddressLine1;
Order;InvoiceToAddressLine2;
Order;InvoiceToAddressLine3;
Order;InvoiceToAddressNo;
Order;InvoiceToAddressSuffix;
Order;InvoiceToPostalCode;
Order;InvoiceToCity;
Order;InvoiceToCounty
Order;InvoiceToState
Order;InvoiceToCountry;
Order;InvoiceToPhone;
Order;InvoiceToFax;

 

Order;Warehouse;
Order;Paymentmethod;
Order;Paymentcondition;
Order;Deliverymethod;
Order;Costcenter;
Order;Invoicecode;
Order;Selectioncode;
Order;Extratext;
Order;Purchaseordermethod;
Order;Freightpackages;
Order;FreightNetweight;
Order;FreightGrossweight;
Order;Route;
Order;Freetext1
Order;Freetext2
Order;Freetext3
Order;Freenumber4
Order;Freenumber5

 

Orderline;Description;
Orderline;Text
Orderline;Item;
Orderline;SerialNumber;
---Fields needed for salescontract import-----
Orderline;SerialNumberDescription;
Orderline;ProlongationDate;
Orderline;ProlongationDateFormat;"dd-mm-yyyy"
Orderline;Quantity;
Orderline;Pricelist;
Orderline;Unit;
Orderline;Currency;
Orderline;GrossPrice
Orderline;NettPrice;
Orderline;GrossAmount;
Orderline;NettAmount
Orderline;Discount%;
Orderline;Vatcode;
Orderline;Deliverydate;
Orderline;Deliverydateformat;"mm-dd-yyyy"
Orderline;Warehouse;
Orderline;Costcenter;
Orderline;Costunit;
Orderline;Project;
Orderline;Resource;
Orderline;Instruction;


Doc id: 00.000.848