Intrastat SPA file
In order to comply with the Spanish Government regulations (telematics way), it's necessary generate two different files: one of them to declare all the import operations and another for the export operations.
This function makes possible the generation of the Spanish Intrastat file in telematics form.
- Select on the screen the processing number, the rest of the fields are displayed.
- The company and the declaration date will be loaded from the processing number selected (DEBPAR table). Spanish legislation in the company is mandatory.
- If the processing number is not indicated, you can select the company and the date range to make the declaration. Spanish legislation in the company is mandatory. You can use this option to add several processing numbers in one declaration.
With the previous information, the declaration files will be generated in the following path: DEC\INTRASTAT\<leg>\<company>_<year>\<month>
The files will be named INTRASIN<n> (for import operations) and INTRASEX<n> (for export operations).
<n> depends on the number of operations. It´s necessary divide each 1000 lines in different files.
Example: if the number of lines is greater than 1000, the first file will be named INTRASIN, the second file will be named INTRASIN1 (same for export operations).
Format of the files:
FIELD | TYPE | LONG | FORMAT FIELD |
COUNTRY ORI/DES | A | 2 | format$("2X",[F:DEB]DESCRY) |
REGION | A | 2 | format$("2X",[F:DEB]REG) |
FREIGHT TERMS | A | 3 | format$("3X",[F:DEB]EECICT) |
TRANSACTION NATURE | C | 2 | format$("N0:2#",right$([F:DEB]EECNAT,3)) |
TRANSPORT MODE | C | 1 | format$("N0:1#",[F:DEB]EECTRN) |
PORT | C | 2 | format$("N0:1#",[F:DEB]PORT) |
REFERENCE | A | 8 | format$("N0:8#",[F:DEB]CUSREF) |
In case of import operation |
|
|
|
ORIGIN COUNTRY | A | 2 | format$("2X",[F:DEB]ORICRY) |
In case of export operation |
|
|
|
| A | 1 | " " |
EEC RULE | C | 1 | format$("N:1#",right$([F:DEB]EECSCH,3)) |
NET WEIGHT | DCB |
| ctrans(num$([F:DEB]NETMAS),".",",") |
EEC UNIT | DCB |
| ctrans(num$([F:DEB]EECUNT),".",",") |
FISCAL VALUE | DCB |
| ctrans(num$([F:DEB]FISAMT),".",",") |
STATISTIC VALUE | DCB |
| ctrans(num$([F:DEB]STAAMT),".",",") |
All fields separate by ";"
Example:
IT;28;CPT;11;3;;87149210;IT;11;2;30;300;300
FR;28;DDP;21;5;;87149390;FR;21;4;10;0;0
IT;28;FOB;21;7;;87149210;IT;21;2;30;300;300
Prerequisites
Refer to documentation Implementation
Screen management
Entry screen
Fields
The following fields are present on this tab :
Criteria entry
| You can select the number assigned automatically during the launching of a generation of the DEB table. |
| Company present in the processing number selected (Intrastat file). If the processing number is not indicated, you can select the company and the date range to make the declaration. In this way, several processing numbers will be added in the same file. |
|
|
| Date end must be in the same month that start date. |
Close
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Impossible to create a file directory
The directoy don't exist and its creation is not allowed.
The legislation of the company must be SPA.
The company legislation must be Spanish.
Start Date > End Date
End date is major than start date.
Must be in the same month
End date must be in the same month than start date.