The following table lists the format for exporting in VAT Data Export.
Field Name |
Apprise Table/Field |
Format |
DocumentType |
Sales Invoice = IN and DM Purchase Invoice = IN and CM Sales Credit = CM Purchase Credit = DM |
0 = Sales Invoices 1 = Purchase Invoices 2 = Sales Credit 3 = Purchase Credit |
TransactionDate |
vat-trans.trans-date AR Reference Date AP Voucher Date |
YYYY-MM-DD |
InvoiceNumber |
vat-trans.ref-num AR Reference Number AP Voucher Number |
Max 100 Characters |
SupplierInvoiceNumber |
apinvhdr.reference-number AP Reference Number |
Max 100 Characters |
OwnReference |
This field contains key information of a line; can be used for troubleshooting. <transaction ref #> + <sequence #> + <product code>/<charge code> |
- |
InvoiceDate |
arinvhdr.created-date apinvhdr.created-date Invoice or Voucher Created Date |
YYYY-MM-DD |
Currency |
vat-trans.reporting-currency (ISO Currency) VAT Currency defined in VAT ID Maintenance |
Max 3 Characters |
Currency2 |
vat-trans.vat-basis-currency (ISO Currency) Currency on the document or transaction |
Max 3 Characters |
ExchangeRateDate |
vat-trans.vat-date |
YYYY-MM-DD |
VATCode |
vat-trans.vat-class-key VAT Class Code If the transaction line is VAT exempt, the system exports Exempt as the VAT Code. |
Max 50 Characters |
SupplierID |
For purchase, output Supplier Code For sales, output your own Company ID which is entered on the export screen |
Long Integer |
SupplierName |
For purchase, output Supplier Name For sales, output your own Company Name which is entered on the export screen |
Max 200 Characters |
SupplierStreet |
Supplier Address - Address 1 |
Max 200 Characters |
SupplierZip |
Supplier Address - Postal Code |
Max 50 Characters |
SupplierCity |
Supplier Address - City |
Max 200 Characters |
SupplierCountry |
For purchase, Supplier Address - Country (ISO Code) For sales, country linked to the VAT ID |
Max 4 Characters |
SupplierTelephone |
Supplier Address - Phone # |
Max 50 Characters |
SupplierFax |
Supplier Address - Fax # |
Max 50 Characters |
SupplierVATNumberUsed |
For purchase, system looks for the VAT ID defined on the supplier's ship from first; if it does not exist, the system looks for the VAT ID defined on the supplier header. For sales, output the specified VAT ID (your company’s VAT ID) on the screen. |
Max 50 Characters |
SupplierCountryVATNumberUsed |
First two digits from SupplierVATNumber |
Max 2 Characters |
CustomerID |
For sales, output customer code For purchase, output your own Company ID which is entered on the export screen. |
Long Integer |
CustomerName |
For sales, output customer name For purchase, output your own Company Name which is entered on the export screen. |
Max 100 Characters |
CustomerStreet |
Customer Main Address - Address 1 |
Max 200 Characters |
CustomerZip |
Customer Main Address - Postal Code |
Max 50 Characters |
CustomerCity |
Customer Main Address - City |
Max 200 Characters |
CustomerCountry |
For sales, Customer Main Address - Country (ISO Code) For purchase, VAT ID's country |
Max 2 Characters |
CustomerTelephone |
Customer Main Address -Phone # |
Max 50 Characters |
CustomerFax |
Customer Main Address -Fax # |
Max 50 Characters |
CustomerVATNumberUsed |
For purchase, output the specified VAT ID (your own VAT ID) on the screen. For sales, system looks for the customer VAT ID defined on the ship to address first; if it does not exist, the system looks for the VAT ID defined on the customer header. |
Max 100 Characters |
CustomerCountryVATNumberUsed |
First two digits from CustomerVATNumber |
Max 2 Characters |
ExemptionReason |
vat-trans.vat-reason-key. Exempt reason code and description |
- |
TaxableBasis |
vat-trans.vat-basis-amount using Currency1 |
Amount |
ValueVAT |
vat-trans.vat-amount using Currency1 |
Amount |
TotalValueLine |
TaxableBasis + ValuesVAT using Currency1 |
Amount |
AmountVATDeducted |
Not used, hardcode 0 |
Amount |
AmountVATReverseCharged |
Not used, hardcode 0 |
Amount |
TaxableBasisCurrency2 |
vat-trans.vat-basis-amount using Currency2 |
Amount |
ValueVATCurrency2 |
vat-trans.vat-amount using Currency2 |
Amount |
TotalValueLineCurrency2 |
TaxableBasis + ValuesVAT using Currency2 |
Amount |
AmountVATDeductedCurrency2 |
Not used, hardcode 0 |
Amount |
AmountVATReverseChargedCurrency2 |
Not used, hardcode 0 |
Amount |