Skip to main content
Avalara Help Center

TM_00524_srtcomma20ld

KEY FOR COMMA-DELIMITED SSF FILES SORTED WITH SRTCOMMA20LD.EXE 

FORMAT (when not using –p option to generate PCodes and using –ct to generate calc_type) 

Country, State, County, Locality, Tax type, Tax level, Discount type, Calculation type, Tax rate, Tax amount, Gross sales, Exempt, Adjustments, Taxable measure, Minutes, Lines 

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 (when not using –p option to generate PCodes) 

USA, , , , 18, 0, 0, 1, 0.091000, 470.360800, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 

USA, , , , 55, 0, 0, 1, 0.033761, 132.343120, 3920.000000, 0.000000, 0.000000, 3920.000000, 3840.0, 0 

USA, , , , 169, 0, 0, 1, 0.002430, 12.560184, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 

USA, , , , 170, 0, 0, 2, 0.018333, 0.293328, 80.000000, 50.320000, 0.000000, 29.680000, 0.0, 0 

USA, CA, , , 9, 1, 0, 1, 0.001100, 0.704000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 10, 1, 0, 1, 0.007200, 4.823194, 669.888000, 0.000000, 0.000000, 669.888000, 0.0, 0 

USA, CA, , , 19, 1, 0, 1, 0.024300, 15.552000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 21, 1, 0, 1, 0.001600, 1.024000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 22, 1, 0, 1, 0.015500, 9.920000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 23, 1, 0, 1, 0.002700, 1.728000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 44, 1, 0, 1, 0.007200, 3.817705, 530.236821, 0.000000, 0.000000, 530.236821, 480.0, 0 

USA, CA, , , 60, 1, 0, 1, 0.001500, 0.960000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

USA, CA, , , 232, 1, 0, 1, 0.002700, 1.367765, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, CA, , , 302, 1, 0, 1, 0.001500, 0.759869, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, CA, , , 303, 1, 0, 1, 0.001600, 0.810527, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, CA, , , 305, 1, 0, 1, 0.024300, 12.309883, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, CA, , , 306, 1, 0, 1, 0.001100, 0.557238, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, CA, , , 307, 1, 0, 1, 0.015500, 7.851983, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

USA, DC, , , 44, 1, 0, 2, 0.760000, 1.520000, 0.000000, 0.000000, 0.000000, 0.000000, 0.0, 0 

USA, DC, , , 160, 1, 0, 1, 0.110000, 203.834915, 1853.044679, 0.000000, 0.000000, 1853.044679, 480.0, 0 

FORMAT (when using –p option and using –ct option to generate calc_type) 

P-Codes displayed in SSF file instead of country, county, and locality 

P-Code, Tax type, Tax level, Discount type, Calculation type, Tax rate, Tax amount, Gross sales, Exempt, Adjustments, Taxable measure, Minutes, Lines 

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 (when using –p options) 

P-Codes displayed in SSF file instead of country, county, and locality 

0, 18, 0, 0, 1, 0.091000, 470.360800, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 

0, 55, 0, 0, 1, 0.033761, 132.343120, 3920.000000, 0.000000, 0.000000, 3920.000000, 3840.0, 0 

0, 169, 0, 0, 1, 0.002430, 12.560184, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 

0, 170, 0, 0, 2, 0.018333, 0.293328, 80.000000, 50.320000, 0.000000, 29.680000, 0.0, 0 

253500, 9, 1, 0, 1, 0.001100, 0.704000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 10, 1, 0, 1, 0.007200, 4.823194, 669.888000, 0.000000, 0.000000, 669.888000, 0.0, 0 

253500, 19, 1, 0, 1, 0.024300, 15.552000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 21, 1, 0, 1, 0.001600, 1.024000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 22, 1, 0, 1, 0.015500, 9.920000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 23, 1, 0, 1, 0.002700, 1.728000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 44, 1, 0, 1, 0.007200, 3.817705, 530.236821, 0.000000, 0.000000, 530.236821, 480.0, 0 

253500, 60, 1, 0, 1, 0.001500, 0.960000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 

253500, 232, 1, 0, 1, 0.002700, 1.367765, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

253500, 302, 1, 0, 1, 0.001500, 0.759869, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

253500, 303, 1, 0, 1, 0.001600, 0.810527, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

253500, 305, 1, 0, 1, 0.024300, 12.309883, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

253500, 306, 1, 0, 1, 0.001100, 0.557238, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

253500, 307, 1, 0, 1, 0.015500, 7.851983, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 

533800, 44, 1, 0, 2, 0.760000, 1.520000, 0.000000, 0.000000, 0.000000, 0.000000, 0.0, 0 

533800, 160, 1, 0, 1, 0.110000, 203.834915, 1853.044679, 0.000000, 0.000000, 1853.044679, 480.0, 0 

  • Was this article helpful?