> ## 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 work orders

For the import of the work orders you can use 3 tabs in the Excel. 'timetickets' contains the general information of the work order. With 'timetickethours' you can pass on the hours achieved. Finally there is 'timeticketlines', which lets you import the materials of the work order. 

| Make sure you also read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws.

## Work orders

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the work order |
| TITLE | Title |
| DATE | Date |
| PROJECTNR | Project number, has to be the same as the 'NR' column on the projects tab |
| CLIENTNR | Customer number, has to be the same as the 'NR' column on the clients tab |
| CLIENTNAME | Customer name, has to be the same as the 'NAME' column on the clients tab |
| STATUS | Status |
| CLIENTREF | Customer reference |
| REMARKS | Remarks |
| ENDCLIENTNR | Endcustomer number, has to be the same as the 'NR' column on the clients tab |
| ENDCLIENTNAME | Endcustomer name, has to be the same as the 'NAME' column on the clients tab |
| SALESORDERNR | Order number |

## Work order hours
You enter the work order hours on the 'timetickethours' tab. The 'NR' column is always mandatory because it is what makes the link with the work order. 

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the work order, has to be the same as the 'NR' column on the timetickets tab. |
| EMPLOYEENAME | Name of the employee, this has to be the unique **first name** of the employee. |
| HOUR_CODE | Item number of the hour code. This is the 'item nr.' field on the item of the hour code. |
| DESCRIPTION | Description |
| PAUSE | Pause |
| HOURS | total hours worked (enter as a decimal number) |
| COSTPRICE | Cost price |
| PRICE | Price |
| STARTHOUR | Start time |
| ENDHOUR | End time |
| EMPLOYEEID | ID of the employee |
| HOUR_TYPE | Hour type |
| ACTIVITY | Activity |
| BILLABLE_HOURS | Billable hours |

|| You enter the HOURS, PAUSE and BILLABLE_HOURS columns as a decimal number (e.g. 1.5). The HH:MM notation (e.g. 7:30) is only used for STARTHOUR and ENDHOUR.

## Work order materials
The 'NR' column is always mandatory because it is what makes the link with the work order. 

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the work order, has to be the same as the 'NR' column on the timetickets tab |
| AMOUNT | Quantity |
| UNITTYPE | Unit |
| LINE_TYPE | Line type - You have to enter a specific value for this. (see below) |
| PRICE | Price |
| COSTPRICE | Cost price |
| BTWTYPE | VAT tariff |
| DESCRIPTION | Description |
| EXTRADESCRIPTION | Extra description |
| CHAPTER | Post number |
| ACTIVITY | Activity |
| PROJECTNR | Project number, has to be the same as the 'NR' column on the projects tab |
| ARTICLENR | Item number, has to be the same as the 'NR' column on the articles tab |
| AGREEMENTTYPE | Type (SOG, FH, ... ) |
| MATERIALNR | Serialnumber of the equipment |
| INSTALLATIONNR | Serialnumber of the installation |

|| Enter the VAT tariff with the exact name of the tariff as it appears in Robaws, for example: 21%, 6%, ..
|| For the  activities, Robaws looks for a match in the database. If an exact match is found, it is linked to the item. If not, a new item is created that is linked to the item straight away.  Please note, the search is case sensitive!

### Line type

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