> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) 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, ...