CBS-IRIS - Netherlands

The Dutch version of CBS-IRIS requires no fixed record layout for the import file. However, you must map the data coming from an import file in CBS-IRIS.

Note: The data to be imported must be in flat file format. Also, you must indicate the first position and the number of positions of each field to be imported from the flat file. The number of positions to import should not exceed the number of positions that is defined in CBS-IRIS for the field. The fields cannot overlap. You should end each field with a carriage return and a line feed.

In CBS-IRIS, the file containing the data to be imported should be a blank-separated txt-file (this type of file can be compared with a Microsoft Excel file that is saved as a text file with blanks as separation characters).

In CBS-IRIS, you can leave the fields blank, as long as the positions defined are correct (that is, each blank stands for one position in the record).

This table illustrates the structure that you must set up for a CBS-IRIS - Holland file:

Field	Position [Length]
Declarant Reference Number	1-10[10]
Del VAT Number	12-23[12]
Partner VAT Number	25-42[18]
Original Country of Origin	44-46[3]
Country of Origin	48-50[3]
Nature of Transaction A	52-52[1]
Statistical Procedure/Nature of VAT Regime	554-55[2]
Mode of Transport	57-57[1]
Port of Entry	59-60[2]
Commodity Code	62-69[8]
Tariff Code	71-72[2]
Currency Code	74-74[1]
Supplementary Unit	76-85[10]
Net Mass	87-96[10]
Invoice Value	98-107[10]
Statistical Value	109-118[10]
Commodity Flow	120-120[1]
Reporting Period	122-127[6]