AvaTax for Communications override file format
AFC Override File Format
- The first line of the override file contains the version number of the override file format. This is used so that AvaTax for Communications (AFC) and the AFC Manager (RLM) know how to interpret the contents of the override file. If any modifications are made to the override file format (such as adding new logic fields), this version number must be incremented and the appropriate changes be made to AFC and the AFC Manager to read the new format correctly, while still providing the ability to read previous versions of the file for backwards compatibility. If a client opens up an old version of the file and makes any modifications to it, the AFC Manager will automatically convert it and save it into the new format.
- Consecutive lines in the override file contain the actual overrides. There are three types of overrides:
- Sales tax rate overrides (for tax types 1 and 49 only).
- Other tax rate overrides (for any other tax types).
- Logic overrides.
The overrides may be contained in any order. The format for each type of override is presented in the sections below.
AFC and the AFC Manager determine what type of override is in the file by looking at the field count in the first line of the override.
Tax rate Overrides
Fields in first line
- PCode
- Tax Type
- Tax Level
- Scope
- History count (number of tax rate history records that follow this line)
- Add Tax
Fields in each sales tax history record
- Effective date
- Bracket count (number of bracket records that immediately follow the history record). For tax types 1 and 49, the format will be in the Sales tax bracket format specified below. For other taxes, it will be in the Telecom tax bracket record.
Telecom tax bracket record
- Rate
- Max base
- Level exempt flag
Sales tax bracket record
- Rate
- Max base
- Replace county flag
- County override flag
- Replace state flag
- State override flag
Logic Override Format
Fields in first line
- PCode
- Transaction type id
- Service type id
- Tax type id
- Tax level id
- Scope
- History count (number of tax logic history records for the logic)
Fields in logic history record
- Effective date
- Jurisdiction rule
- Data type
- Effect on sales
- Surcharge
- Sale
- Resale
- Business
- Residential
- Regulated
- Unregulated
- Senior citizen
- Industrial
- Lifeline
- Lifeline only
- Ilec
- Clec
- Primary long distance
- Primary local
- Franchise
- Non-franchise
- Facilities
- Non-facilities
- Tier at transaction
- Billable
- Compliance
- Pro-rated
- Report level
- Rate at final
- Tax By all others
- TAM
- TAS
- Log zero tax
- Prepaid
- Tax Taxes Count (number of tax taxes record that immediately follow)
Fields in Tax Taxes records
- Tax type id
- Tax level id