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.
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] |