Skip to main content
Avalara Help Center

TM_00516_ezlogcustptslnl

Key for Comma-Delimited LOG.RPT Files from EZLOGCUSTPTSLnL.EXE 

FORMAT 

PCode, Transaction type, Service Type, Country, State, County, Locality, Tax type, Tax level, Tax rate, Tax amount, Gross sales, Exempt, Adjustments, Taxable measure, Minutes, Customer Number, Lines, Locations 

The Transaction type and Service type fields are only available using the API’s. They are populated as follows from the EZtax_data structure: optional = transaction type, and srv_lvl_no = Service type. 

TAX TYPE 

See Tax Types table for listing. 

TAX LEVEL 

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

SAMPLE DATA FROM COMMA-DELIMITED SSF FILE 

0, 0, 0, USA, , , , 6, 0, 0.030000, 2.462930, 82.097663, 0.000000, 0.000000, 82.097663, 0.000000, Avalara, Inc. , 6, 2 

0, 0, 0, USA, , , , 18, 0, 0.089000, 1.157000, 13.000000, 0.000000, 0.000000, 13.000000, 0.000000, Avalara, Inc. , 0, 0 

0, 0, 0, USA, , , , 31, 0, 0.000000, 0.000000, 13.000000, 13.000000, 0.000000, 0.000000, 0.000000, Avalara, Inc. , 0, 0 

1210800, 0, 0, USA, KS, , , 13, 1, 0.048700, 1.458565, 29.949999, 0.000000, 0.000000, 29.949999, 0.000000, Avalara, Inc. , 0, 0 

1284800, 0, 0, USA, KS, SALINE, , 10, 2, 0.750000, 2.250000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, Avalara, Inc. , 3, 0 

1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 1, 0.053000, 2.039814, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, Avalara, Inc. , 0, 0 

1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 2, 0.010000, 0.384871, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, Avalara, Inc. , 0, 0 

1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 3, 0.007500, 0.288653, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, Avalara, Inc. , 0, 0 

2502500, 0, 0, USA, NY, , , 5, 1, 0.025000, 0.925712, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, Avalara, Inc. , 0, 0 

2502500, 0, 0, USA, NY, , , 45, 1, 0.003750, 0.138857, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, Avalara, Inc. , 0, 0 

2604000, 0, 0, USA, NY, NEW YORK, , 10, 2, 1.000000, 3.000000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, Avalara, Inc. , 3, 0 

2604000, 0, 0, USA, NY, NEW YORK, , 27, 2, 0.005950, 0.220320, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, Avalara, Inc. , 0, 0 

2604000, 0, 0, USA, NY, NEW YORK, , 28, 2, 0.001275, 0.047211, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, Avalara, Inc. , 0, 0 

2604100, 0, 0, USA, NY, NEW YORK, NEW YORK, 1, 1, 0.042500, 1.630325, 38.360599, 0.000000, 0.000000, 38.360599, 0.000000, Avalara, Inc. , 0, 0 

2604100, 0, 0, USA, NY, NEW YORK, NEW YORK, 1, 3, 0.043750, 1.678276, 38.360599, 0.000000, 0.000000, 38.360599, 0.000000, Avalara, Inc. , 0, 0 

2604100, 0, 0, USA, NY, NEW YORK, NEW YORK, 29, 3, 0.023500, 0.870170, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, Avalara, Inc. , 0, 0

  • Was this article helpful?