<< Klicke um Table of Contents anzuzeigen >> Navigation: Nexus Interfacebook EN > ExportInterfaces > VATReport - Specialexport |
A function of the nexus vat-report-module allows to create a special export of vat-reportdata.
The export provides a file with the vat-report-data and in addition a file, containing all detected errors.
All of the following informations refering to CSV-Format-Version 21.8.1.
The needed data is provided as csv-file:
Encoding = UTF-8
Delimiter = Semicolon
End of Line = CR LF (10)(13)
Fieldtypes
N = integer
AN = alphanumeric, (fielddelimiter = CHR(34))
D = date (yyyy-mm-dd)
d = decimal with two decimal places
Pattern of the filename of the vat-report-file
VAT_SpecialExport_m_YYYY_MM.CSV
Pattern of the filename of the failure-file
VAT_SpecialExport_m_YYYY_MM_Failures.CSV
m = Nexus Client-Number-Nr. (4 - 9 digits)
YYYY = Year
MM = Month
Structure of the CSV-file containing the VAT-Report-Data
Each row represents a lineitem of the Voucher or an ancillary Service Item.
Field-No. |
Fieldname |
Content |
Type |
---|---|---|---|
1 |
ID |
Inside the file an unique ID of the row |
N |
2 |
BracketID |
Inside the file unique ID, that groups all rows having created from the same voucher. |
N |
3 |
Period |
Reporting Period(YYYY-MM) |
AN |
4 |
TransactionType |
Type of the transaction, one of the following values: SALE / TRANSFER / REFUND / PURCHASE |
AN |
5 |
TypeServiceProvision |
Tax-classification of the Item. One of this values: Goods / Services / MOSS |
AN |
6 |
SentFromCountry |
ISO-2-Code of distributioncountry |
AN |
7 |
SentToCountry |
ISO-2-Code of departurecountry |
AN |
8 |
DocumentDate |
Voucherdate |
D |
9 |
DocumentNumber |
Voucher-Number (Invoice-Number) |
AN |
10 |
CorrectedDocumentNo |
Number of credit-note (Refunds) Empty when Invoice |
AN |
11 |
CorrectedDocumentDate |
Date of Credit-Note (refunds) Empty when invoice |
D |
12 |
TransactionOrderDate |
Orderdate, date the transaction was triggered |
D |
13 |
TransactionShipmentDate |
Date of shipping |
D |
14 |
TransactionDeliveryDate |
Date of delivery |
D |
15 |
ItemDescription |
Description of delivered goods / services. The prefix (AS) shows, that the Item is an ancillary service. |
AN |
16 |
TotalPriceOfItems |
Total gros amount of the invoice itemline (position) |
d |
17 |
TotalTransactionValue |
Total gros amount of voucher. Gesamtbetrag des Beleges (brutto), bei TRANSFER = Netto, bei REFUND Negativ |
d |
18 |
TransactionCurrency |
ISO-currency-code of the transaction (EUR = Euro) |
AN |
19 |
VATRate |
VAT-Rate (Percentage) of the itemline (position) |
d |
20 |
BuyerName |
Complete name of the buyer (firstname and familiy name) |
AN |
21 |
BuyerAdress1 |
Address of the buyer 1 |
AN |
22 |
BuyerAdress1 |
Additional infos to the address of buyer |
AN |
23 |
BuyerCounty |
County of the buyer. Only provided for romania (RO) |
AN |
24 |
BuyerCountry |
ISO-2-Code of the buyers residence |
AN |
25 |
BuyerVAT_ID_No |
EU-VAT-Registration-Number of the buyer. Only provided, wenn buyer is an enterprise |
AN |
28 |
CommodityCode |
Taric-No. / Comoditiy-Code refering to the article in the item line |
AN |
29 |
TaxCollectionResponsibility |
Only provided für invoices and creditnotes. Specifies the responsibility of VAT-Collection by one of this values: SELLER MARKETPLACE |
AN |
Structure of the CSV-file, containing the failure-informations to the VAT-Report-File:
Each row represents a failure.
Feld-Nr. |
Feldname |
Inhalt |
Typ |
---|---|---|---|
1 |
ItemID |
Foreign Key - ID from the VAT-Report-Data-File, specifies the row the failure refers. |
N |
2 |
Column |
Name of the column in the VAT-Report-Data-File, the failure Refers |
N |
3 |
ErrorLevel |
Specifies the level / type of the failure: 1 = formal failure (refers only to the column / field) 2 = logic failure (refers to the complete row / record) Currently, level 2 Failures are not provided |
N |
4 |
ErrorText |
Description of the failure. The description may contain more than one line of text. End of Line: #CR# |
AN |