AvaTax: Transactions

For each invoice that is posted, these details are available through the Avalara admin console (admin.avalara.com):

Field Description Field Description
Origin Dealership Address Destination Ship To Address (if none, dealership address)
Document ID AvaTax system value Salesperson Code Salesperson ID from the IntelliDealer invoice
Document Code The TID number assigned in IntelliDealer. For work orders this number has a suffix of a dash (-) followed by a C (customer), W (warranty) or I (internal) to delineate the tax charged for the respective charges. Entity Use Code The entity use code passed from the IntelliDealer invoice
Customer/Vendor Code The IntelliDealer company, division and customer number Total Amount Total amount of the IntelliDealer line item
Document Status AvaTax system value Total Discount Not used
Document Date The date the invoice was created in IntelliDealer Total Non-Taxable AvaTax calculated value
Document Type AvaTax system value Total Taxable AvaTax calculated value
Location Code AvaTax system value Tax Override Type Set to 'TaxAmount' for General invoices or offline taxation
Tax Date The date the invoice Tax Override Reason Set to 'TaxDate' for General Invoices or 'Offline' for offline taxation
Purchase Order Number The PO Number from the IntelliDealer invoice Total Tax The total tax calculated by AvaTax
Reference Code IntelliDealer Invoice Number, System Number, Company, Division, Branch Total fee Not used
Is Seller Importer Of Record AvaTax system value Adjustment Description Not used
Adjustment Reason AvaTax system value Message Not used

AvaTax: Data Files

The data source files used by the AvaTax service are:

  • AVAETC—AvaTax Product Codes

  • AVARATEH—Header - Country & Zip Code/Province

  • AVARATED—Details - Rates by Country & Zip Code/Province

  • AVATAXC—Current Invoice Tax

  • AVATAXE—AvaTax Entity Use Codes

  • AVATAXH—History Invoice Tax

  • AVATAXLG—Communications Log

  • AVATAXO—Offline Tax Calculations