Creation of an import format for a fixed-length file.
For this type of file you need a file description.
| Start of field position | field description | field length |
|---|---|---|
| 5 | Identity (VAT number LU11223304 => 1122330400) | 10 |
| 25 | Flow (A/E) | 1 |
| 26 | Statistical period (MMYY) | 1 |
| 31 | Partner country | 2 |
| 33 | Nature of transaction | 2 |
| 35 | Mode of transport | 1 |
| 36 | Commodity code NC8 | 8 |
| 45 | Country of origin | 2 |
| 47 | Net mass | 9 |
| 56 | Supplementary unit | 2 |
| 65 | Invoice value | 11 |
| 76 | Statistical value | 11 |
| 100 | Partner VAT number | 20 |
To create an import format, use the "Import" option "Import format".
As the file contains information on the VAT number of the declarant (LU11223304 => 1122330400) , the statistical period (December 2023 => 1223) and the Flow (A/E)
the type of import to choose is"Declarations for more flows, periods or companies".
As file type you must choose "Text".
Choose the type of text "Fixed".
As the file contains no headers, the number of lines to ignore is "0".
In the order column, enter the start position of an element.
In the length column, enter the length of the variable. In our example the net mass has the length of 9 digits.
For example, for a date like 2024/01 => the format is YYYY/MM
For the flow, the first element is the letter for arrivals (X); the second letter for dispatches (Y).
Click on "Save" to save the import format.