This article is also available in:

Importing supply orders

When you import supply orders, the tabs 'purchaseorders' and 'purchaseorderslines' are used. The connection is made on the basis of the column 'NR'. That column has to be the same in both tabs, so that the lines are linked to the right supply order.

Do read the general information about data import in Robaws as well.

Supply orders

Column titles

Column title	Field in Robaws
NR	Number of the supply order
DATE	Date
SUPPLIERNR	Supplier number, has to be the same as the column 'NR' in the tab suppliers
SUPPLIERNAME	Supplier name, has to be the same as the column 'NAME' in the tab suppliers
AMOUNT	Quantity
STATUS	Status
PRICE	Price
BTWTYPE	VAT tariff
CURRENCY	Currency
CONVERSION	Quantity received

The column 'NR' in 'supply orders' has to contain a unique value; if it does not, the import is stopped.

Supply order lines

The column 'NR' is always mandatory, because it is what links the line to the supply order.

Column titles

Column title	Field in Robaws
NR	Number of the supply order, has to be the same as the column 'NR' in the tab purchaseorders
AMOUNT	Quantity
UNITTYPE	Unit
LINE_TYPE	Line type - you have to enter a specific value here, depending on the line type. (see below)
PRICE	Price
COSTPRICE	Cost price
BTWTYPE	VAT tariff
DESCRIPTION	Description
EXTRADESCRIPTION	Extended description
CHAPTER	Post number
ACTIVITY	Activity
PROJECTNR	Project number, has to be the same as the column 'NR' in the tab projects
ARTICLENR	Item number, has to be the same as the column 'NR' in the tab articles
AGREEMENTTYPE	Type (SOG, FH, ... )

Line type

Line: P
Title: H
Total: T
Quantity: A
Check: C
Variant: V
Text: Tx
Chapters: H1, H2, H3, H4, ...

Updated on: 09/09/2026

Was this article helpful?

Thank you!