This article is also available in:

Importing subscriptions

For the import of the subscriptions, the tabs subscription and subscriptionlines are used. Give your tabs exactly these names: Robaws does not read in a tab with a different name. The connection is made on the basis of the 'NR' column. It 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 in Robaws.

Subscriptions

Column titles

Column title	Field in Robaws
USE_TEMPLATE_ID	(optional) Id of a subscription template. The subscription then starts from that template.
NR	Number of the subscription
DATE	First 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
CLIENTID	Id of the customer in Robaws
REF	Customer reference
STATUS	Status
REMARK	Remarks
NEXT	Next execution
PERIODICITY	Recurrence rule (see below)
TYPE	Type (see below)
DEADLINE	Last execution
COMPANY	Abbreviation of the company
DIARY	Name of the sales journal. If you leave this empty, Robaws takes the first sales journal of the company.
ACTIVE	Active: 'Yes' or 'No'. An empty cell counts as 'Yes'.
ENDCLIENTNR, ENDCLIENTNAME, ENDCLIENTID	Number, name or id of the end customer

PERIODICITY

Fill in the name of a recurring period you created via Settings > Subscriptions > Master data, for example 'Monthly' or 'Yearly'. Write the name exactly as in your settings. If Robaws does not find the name, the subscription gets no recurrence.

TYPE

Possible values for type:

Order
Invoice

Any other value becomes Invoice.

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 subscription 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	Serial number of the equipment
INSTALLATIONNR	Serial number of the installation
ACCOUNTANCY_CODE	Code of the GL account

Line type

Line: P
Title: H
Total: T
Quantity: A
Check: C
Variant: V
Option (unit price): O
Option (total): OT
Text: Tx
Chapters: H1, H2, H3, H4, ... H8

Updated on: 06/11/2026

Was this article helpful?

Thank you!