Master data import
This interface describes the structure of the template which is used to import companies into the VAT@GTC. This is usually only done at the beginning of the project. In the upper area you can define general settings for the interface.
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| File type | When importing master data, CSV must usually be selected. |
| Interface type | The interface master data import is selected here. |
| Default interface | This setting is irrelevant for the master data import. |
| Skip empty rows | If this box is checked, empty lines in the template are skipped. If the box is unchecked, these are reported as errors. |
| Do you want to archieve units, which are not included in the import file? | If this function is activated, the existing companies are archived in the period to which the master data is transferred. |
| Sheet name | If several worksheets are available, the name of the worksheet to be used can be entered here. |
| Seperator | The separator separates individual entries in the CSV file. Usually this is a semicolon or a comma. |
| First data row | The first row that contains data for the import. Title rows are not data rows. |
In der darauffolgenden Tabelle wird die Struktur des Templates konfiguriert.
| Column | Meaning |
|---|---|
| Name | The name of the field in the VAT@GTC. |
| Pattern | A pattern can be stored here, which every entry in this field must correspond to. |
| Order | The column in which the entry is to be found in the template is determined. If an entry does not exist in the template, a 0 must be entered. |
| Header name | The name of the column in the template. |
| Mandatory field | This box indicates whether this field is mandatory. If a mandatory field in the template is not completely filled, importing is not possible. |
| Skip row if the column is empty | The rows in which this column is not filled in the template are not imported. |
VAT-ID Import
The format of the upload file can be configured for the VAT@GTC VAT ID import. Only one configuration of the VAT ID check is possible. If no configuration is available, the import file is expected to be UTF-8 encoded by default.
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| File type | The file type can be defined (CSV or text file) |
| Encoding | The coding can be configured here. If the encoding does not match, special characters such as umlauts are not imported correctly. |
| Interface type | The VAT-ID Import interface is selected here. |
| Separator | Here you can select a separator to separate the individual entries of the CSV file. |
| First Data Row | Here you configure in which line of the CSV file the data to be imported starts (header lines are not to be imported). |
VAT Import
This interface configuration can be used to configure the import of the SAP-Reports RFUMSV00, RFUMSV10 and RFBILA00 for the VAT Return. It is possible to configure several different variants of the VAT-import. These can be assigned to the companies in [Master Data → Companies].
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| Encoding | The coding can be configured here. If the encoding does not match, special characters such as umlauts are not imported correctly. |
| Interface type | The VAT-Import interface is selected here. |
| Default interface | If "Yes (exclusive)" is selected here, this configuration is automatically configured for all companies. Only a single VAT-import configuration can be exclusive. A configuration of the VAT-import that is defined with "No (optional)" must be assigned to the companies in the Master Data area. |
ESL Import
This interface configuration can be used to configure the import of the declaration values for the ESL. It is possible to configure several different variants of the ESL import. These can be assigned to the companies in [Master Data → Companies].
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| File type | The file type can be defined (CSV or text file) |
| Encoding | The coding can be configured here. If the encoding does not match, special characters such as umlauts are not imported correctly. |
| Interface type | The ESL Import interface is selected here. |
| Default interface | If "Yes (exclusive)" is selected here, this configuration is automatically configured for all companies. Only a single ESL import configuration can be exclusive. A configuration of the ESL import that is defined with "No (optional)" must be assigned to the companies in the Master Data area. |
| Filename pattern | A separate file name pattern can be stored for each ZM Import configuration, which differs from the standard pattern of the network drive interface. If you create an individual file name pattern here, this file name pattern is used for this ZM import configuration instead of the file name pattern stored in the network drive import configuration. |
Automatic import
If the SAP reports are to be imported automatically it must be configured in the VAT@GTC.
Network drive import
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| File type | The file format of the SAP reports. These are usually text files. |
| Interface type | The interface network drive import is selected here. |
| Default interface | If the network drive is the default interface, "Yes (exclusive)" must be selected. If the web service Import is also active, it can also be configured, but as "No (optional)". In this case, the companies that import via the web service must be configured accordingly in the company master data. |
| Path to netdrive | The path to the folder where the SAP reports for import are stored. |
| Path to archive directory | The path of the folder in which the SAP reports are archived after the import. |
| Filename pattern | The pattern of SAP report names. Good to know You can configure your own pattern in the ESL Import. If this is the case, the general pattern configured here is not used in the companies with the corresponding ESL Import configuration. |
Webservice import
| Setting | Meaning |
|---|---|
| ID | The ID of the interface configuration. |
| Name | The name of the interface configuration. |
| Interface type | The interface webservice import is selected here. |
| Default interface | If the web service is the default interface, "Yes (exclusive)" must be selected. If network drive import is also active, it can also be configured, but as "No (optional)". In this case, the companies that import via the network drive must be configured accordingly in the company master data. |