TDS Complete+ Edition Data File Format The data file is a tab delimited text file. The fields contained are: Field Name: Field Contains: Zip Code Numeric 5 digit zip code (non-unique) State Abbrev 2 letter state abbreviation County Name County Name City Name City Name State Sales Tax Numeric to 6 decimal places State Use Tax Numeric to 6 decimal places County Sales Tax Numeric to 6 decimal places County Use Tax Numeric to 6 decimal places City Sales Tax Numeric to 6 decimal places City Use Tax Numeric to 6 decimal places MTA Sales Tax Numeric to 6 decimal places MTA Use Tax Numeric to 6 decimal places SPD Sales Tax Numeric to 6 decimal places SPD Use Tax Numeric to 6 decimal places Other1 Sales Tax Numeric to 6 decimal places Other1 Use Tax Numeric to 6 decimal places Other2 Sales Tax Numeric to 6 decimal places Other2 Use Tax Numeric to 6 decimal places Other3 Sales Tax Numeric to 6 decimal places Other3 Use Tax Numeric to 6 decimal places Other4 Sales Tax Numeric to 6 decimal places Other4 Use Tax Numeric to 6 decimal places Total Sales Tax Numeric to 6 decimal places Total Use Tax Numeric to 6 decimal places County Number State Assigned county code City Number State Assigned city code MTA Name MTA Name MTA Number MTA Number SPD Name SPD Name SPD Number SPD Number Other1 Name Other1 Name Other1 Number Other1 Number Other2 Name Other2 Name Other2 Number Other2 Number Other3 Name Other3 Name Other3 Number Other3 Number Other4 Name Other4 Name Other4 Number Other4 Number Tax Shipping Alone? Y/N Tax Shipping and Handling Together? Y/N FIPS State 2 digit FIPS State code FIPS County 3 digit FIPS County code FIPS City 5 digit FIPS City Code FIPS Geocode 10 digit FIPS geocode MTA Geocode 10 character MTA geocode SPD Geocode 10 character SPD geocode Other1 Geocode 10 character Other1 geocode Other2 Geocode 10 character Other2 geocode Other3 Geocode 10 character Other3 geocode Other4 Geocode 10 character Other4 geocode Geocode Long 60 character long geocode State Effective Date Date (x/x/xxxx) County Effective Date Date (x/x/xxxx) City Effective Date Date (x/x/xxxx) MTA Effective Date Date (x/x/xxxx) SPD Effective Date Date (x/x/xxxx) Other1 Effective Date Date (x/x/xxxx) Other2 Effective Date Date (x/x/xxxx) Other3 Effective Date Date (x/x/xxxx) Other4 Effective Date Date (x/x/xxxx) County Tax Collected by Who collects the county tax City Tax Collected by Who collects the city tax State Taxable Max Dollar amount or N State tax over max n/a or numberic to 6 decimal places County Taxable Max Dollar amount or N County tax over max n/a or numberic to 6 decimal places City Taxable Max Dollar amount or N City tax over max n/a or numberic to 6 decimal places Sales tax holiday Y or N Sales tax holday dates n/a or date range Sales tax holiday items what single items and what dollar limit applies