Skip to main content
Avalara Help Center

TM_00509_asciilog

KEY FOR COMMA-DELIMITED FILES CREATED WITH ASCIILOG.EXE 

FORMAT 

Country, State, County, City, Tax Type, Tax Level, Tax Rate, Tax Amount, Charges, Exemptions, Adjustments, Net Sales, Minutes, Invoice Number, Service Level Number, Optional, Lines, Locations, Calculation Type, Customer Number 

Specifying +p after the tax log filename in the argument list will output PCode before the country for each record. 

TAX TYPE 

See Tax Types table for listing. 

TAX LEVEL 

0 = Federal, 1 = State, 2 = County, 3 = City, 4 = Un-incorporated 

SAMPLE DATA 

USA, PA, , , 9, 1, 0.002662, 0.851840, 320.000000, 0.000000, 0.000000, 320.000000, 0.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608205 

USA, PA, BERKS, KEMPTON, 14, 1, 0.050000, 46.583018, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 

USA, CA, , , 10, 1, 0.007200, 4.317632, 599.671134, 0.000000, 0.000000, 599.671134, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608204 

USA, PA, BERKS, KEMPTON, 1, 1, 0.060000, 55.899620, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 

USA, , , , 6, 0, 0.030000, 27.949810, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 

USA, , , , 55, 0, 0.031640, 7.751800, 245.000000, 0.000000, 0.000000, 245.000000, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 

USA, , , , 18, 0, 0.111000, 35.858550, 323.049999, 0.000000, 0.000000, 323.049999, 0.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 

USA, DC, DISTRICT OF COLUMBIA, WASHINGTON, 14, 1, 0.110000, 102.482638, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608207 

USA, DC, , , 10, 1, 0.760000, 0.760000, 5.158200, 0.000000, 0.000000, 5.158200, 0.000000, 0, 0, 0, 0, 0, FIXED, 

 

  • Was this article helpful?