> ## 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 subscriptions

For the import of the subscriptions, the tabs 'subscriptions' and 'subscriptionslines' are used. The connection is made on the basis of the 'NR' column. This has to be the same on both tabs so the lines are linked to the right subscription. 

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

## Subscriptions

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the subscription |
| DATE | Date |
| 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 |
| REF | Customer reference |
| STATUS | Status |
| REMARK | Remarks |
| NEXT | Next execution |
| PERIODICITY | Periodicity (see overview below) |
| TYPE | Type (see overview below) |
| DEADLINE | Deadline |
| ACTIVE | Active ( "Yes" or "No") |

#### PERIODICITY
Possible values for periodicity:
* Weekly
* Monthly
* 4 Weekly
* Yearly
* 3 months
* 6 months
* 2 Yearly
* 5 Yearly

#### TYPE
Possible values for type:
* Order
* Invoice

|| The 'NR' column on 'subscriptions' has to contain a unique value, otherwise the import is stopped.

## Subscription lines
The 'NR' column is always mandatory because it is what makes the link with the subscription. 

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the subscription, has to be the same as the 'NR' column on the subscriptions 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 |

### Line type

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