VAT Validation: CSV Import Interface
By using a simple CSV file, the VAT Validation module offers you a possibility to check your entire database.
We take care to maintain compatibility when extending the CSV import interface of the VAT Validation module. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.
In order to ensure that the individual VAT registration number records belong to your master data, you have the option of specifying up to two unique keys in the import file. These will be returned in the export file and can be used for re-import into your ERP system. You can also leave these two fields (Key_1 and Key_2) blank.
The default separator of the individual elements for the VAT Validation is the ‘|’ character (pipe). This can be changed in the settings. Bold field names are mandatory fields (the separator can be changed via settings).
Please note that all fields must be specified in the import file of the VAT Validation, even if you only want to perform a simple check. The qualified check is currently only available for the BZSt interface.
Structure — VAT CSV Import File
Example in the form of a CSV file:
4711|2|EN123456789|AT12345678|||… (other VAT validations)
When creating the VAT registration number import file, please pay attention to the correct number of columns (8 columns). This note is important for possible errors during import when using CSV. In the future we will support other import formats that do not have this restriction.
Structure — VAT CSV Export File
The CSV export file of the VAT Validation contains the returned values of the individual checks.
|errorcode_description||String||The requested VAT number is valid.|
Example in the form of a CSV file (with standard delimiter):
4711|2|EN123456789|AT12345678|200|The requested VAT number is valid.|2019-11-05 14:35:43
The naming of the fields of the VAT Validation within the CSV import or export file is in German. In the course of the extension of the import formats, these will be internationalized, i.e. we will keep the field names in English in the future. However, we have considered a configuration of the field names in order to increase flexibility.
The output of the export file in CSV format of the VAT Validation always includes an additional column containing the headings. Please keep this in mind for a possible automatic re-import of the check results.