Excise Certification
Depending on the scope of your integration and your business practice, your test cases will vary. For development partners, many of these are requirements for certification. If you were to give us full functionality demo, here’s what we’d like to see:
Transaction Tax Functions

This table describes specific functions used to process tax transactions with Avalara AvaTax Excise:

Required Function Comment
R Sequence Id Avalara AvaTax Excise application calculated value that uniquely identifies the tax item within the transaction results.
R Product Category Numeric representation of the type of product being taxed defined in the product_categories table in the Avalara AvaTax Excise application.
N Send optional data elements:
  • Transaction Line
  • Invoice Line
  • Country Code
  • Jurisdiction
  • Local Jurisdiction
  • Tax Type
  • Rate Type
  • Rate Subtype
  • Calculation Type Indicator
  • Tax Rate
  • Tax Quantity
  • Tax Amount
  • Tax Exempt Indicator
  • Deferred Indicator
  • Payable To Code
  • Sales Tax Base Amount
  • License Number
  • User Returned Value
  • Scenario Id
  • Scenario Tax Group Id
  • Scenario Sequence
  • Rate Description
  • Currency
  • Unit of Measure
  • Subtotal Indicator
  • Transaction Tax Amounts
  • Status Code
  • Quantity Indicator
  • Reporting Tax Amount
  • Reporting Tax Currency
  • License Number - The tax jurisdiction license number that applies to this transaction.
  • User Returned Value - String to hold any data you may want to pass into a transaction and potentially receive back untouched. May also be used for customizing calculations based on business rules.
  • Scenario Id and Scenario Tax Group Id - Definition that was applied to these tax items.
  • Subtotal Indicator - Indication of which field(s) to use for the sales tax base of the tax (Freight Only, Unit Price Only, Combined).
  • Status Code - The calculation status of the tax.