Upload/Return File Instructions
|
|
Rates and jurisdictions provided through this upload are subject to revision on
a quarterly basis. Submitted files must be in comma delimited text format
(.CSV) with no header row and with the following fields in the order specified
in the Upload File Format description below. Note: Address, City, Zip Code, and
As of Date fields are required and must contain valid alpha/numeric text. If
the field is optional, you may leave that field blank in your file, but you
need to account for the field in the comma delimited format. If you have any
questions concerning the Upload File Format, please review the sample file at
the bottom of this page.
|
The structure of the upload file is as follows:
|
| Field Name |
Description |
Format |
Length |
|
Invoice # *
|
Optional Retailer Record ID |
alpha/numeric |
15 |
|
Address **
|
Street Name and Number |
alpha/numeric |
61 |
| Suite |
Suite, P.O. Box, Apt, Lot |
alpha/numeric |
61 |
|
City **
|
City Name |
alpha |
29 |
| State |
State Abbreviation (OH only) |
alpha |
2 |
|
Zip Code **
|
5-digit Zip Code |
numeric |
5 |
| Zip Plus |
Zip+4 Extension |
numeric |
4 |
|
As of Date **
†
|
MM/DD/YYYY Format |
numeric |
10 |
|
Taxable Amount ††
|
Currency Format (99999999.99) |
numeric |
11 |
|
|
* The Invoice # field in the
file format pertains to the record number in which you identify this address on
your system.
** Address, City, Zip Code, and
As of Date fields are required.
† Date cannot
be before 1/1/2004 and cannot be in the future.
†† Minimum is
$0.16, maximum is $90,000,000.
|
Following your submission, please check the
Upload/Return File Status Page. This page will display the status of
your submissions and upon completion of the batch processing, your return
file(s) will be available to download. The last 2 submissions will always be
available for re-download. Each retrieval will consist of two downloadable
files named "{user_id}_{job_id}STAR.csv" and "{user_id}_{job_id}STAE.csv" where
{user_id} represents the numeric identity of your online user account and
{job_id} corresponds to the sequential Upload Job ID of your file at the time
of submission.
|
The structure of the results file is as follows:
|
| Field Name |
Description |
Format |
Length |
| Invoice # |
Optional Retailer Record ID |
alpha/numeric |
15 |
| Reference # |
Reference ID for the specific transaction (9999-9999999999)
|
alpha/numeric |
15 |
| Address |
USPS Standardized Address Line 1 |
alpha/numeric |
61 |
| Suite |
USPS Standardized Address Line 2 |
alpha/numeric |
61 |
| City |
USPS Standardized City Name |
alpha |
29 |
| State |
State Abbreviation |
alpha |
2 |
| Zip Code |
USPS Standardized 5-digit Zip Code |
numeric |
5 |
| Zip Plus |
USPS Standardized Zip+4 Extension |
numeric |
4 |
| As of Date |
MM/DD/YYYY Format |
numeric |
10 |
| Taxable Amount |
Currency Format (99999999.99) |
numeric |
11 |
| State FIPS |
State FIPS Code |
numeric |
3 |
| County FIPS |
County FIPS Code |
numeric |
3 |
| Transit FIPS |
Transit FIPS Place (N/A, if transit does not exist)
|
alpha/numeric |
5 |
| Sales Tax Rate |
Decimal Value of Combined Sales Tax Rate (9.9999) |
numeric |
6 |
| Tax Amount |
Currency Format (99999999.99)
|
numeric |
11 |
| Taxable Amount with Tax |
Currency Format (99999999.99) |
numeric |
11 |
| Date Processed |
MM/DD/YYYY Format |
numeric |
10 |
|
The structure of the error file is as follows:
|
| Field Name |
Description |
Format |
Length |
| Invoice # |
Optional Retailer Record ID |
alpha/numeric |
15 |
| Reference # |
Reference ID for the specific transaction (9999-9999999999)
|
alpha/numeric |
15 |
| Address |
Street Name and Number |
alpha/numeric |
40 |
| Suite |
Suite, P.O. Box, Apt, Lot |
alpha/numeric |
40 |
| City |
City Name |
alpha |
40 |
| State |
State Abbreviation |
alpha |
2 |
| Zip Code |
5-digit Zip Code |
numeric |
5 |
| Zip Plus |
Zip+4 Extension |
numeric |
4 |
| As of Date |
MM/DD/YYYY Format |
numeric |
10 |
| Taxable Amount |
Currency Format (999999999.99) |
numeric |
12 |
| Result Type |
Error Match Code |
alpha/numeric |
4 |
|
|
| Error Match Code |
Description |
| E010 |
Required fields were not provided. |
| E011 |
Input zip code was not in Ohio. |
| E012 |
City was not found. |
| E020 |
Could not locate matching street. |
| E022 |
Could not locate this street number. |
| E023 |
Match is unresolved. |
| E024 |
Could not locate this street number. |
| E027 |
Could not match directional information. |
| E031 |
Invalid taxable amount. |
| E033 |
Address found was not in Ohio. |
| E035 |
Invalid input state (OH only). |
|
1,1615 GARFIELD AVE,,ASHLAND,OH,44805,,8/17/2004,2.91
2,7137 MARTIN RD,,WEST SALEM,OH,44287,,8/17/2004,9.03
3,5002 N MYERS RD,,GENEVA,OH,44041,,8/17/2004,9.3
4,6698 DEERVIEW DR,,LOVELAND,OH,45140,,8/17/2004,2.37
5,6702 US 20,,METAMORA,OH,43540,,8/17/2004,16.89
6,2383 RT 61 S,,NORWALK,OH,44857,,8/17/2004,12.34
7,13834 FANCHER RD,,JOHNSTOWN,OH,43031,,8/17/2004,3.86
8,29761 STANLEY RD,,NEW MARSHFIELD,OH,45766,,8/17/2004,18.38
9,4454 WING VIEW LN,,KETTERING,OH,45429,,8/17/2004,3.8
10,9439 MEADOWTRAIL CT,,LOVELAND,OH,45140,,8/17/2004,4.32
|
|
1,0904-2926,1615 GARFIELD AVE,
,ASHLAND,OH,44805,3549,8/17/2004,2.91,39,5,N/A,0.0725,0.22,3.13
2,0904-2927,7137 MARTIN RD, ,WEST
SALEM,OH,44287,9065,8/17/2004,9.03,39,169,N/A,0.0675,0.61,9.64
3,0904-2928,5002 N MYERS RD,
,GENEVA,OH,44041,7704,8/17/2004,9.3,39,7,N/A,0.07,0.66,9.96
4,0904-2929,6698 DEERVIEW DR,
,LOVELAND,OH,45140,5919,8/17/2004,2.37,39,25,N/A,0.07,0.17,2.54
5,1104-4398,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,8/17/2004,16.89,039,051,N/A,0.07,1.19,18.08,11/18/2004
6,0904-2931,2383 STATE ROUTE 61,
,NORWALK,OH,44857,9183,8/17/2004,12.34,39,77,N/A,0.075,0.93,13.27
7,0904-2932,13834 FANCHER RD,
,JOHNSTOWN,OH,43031,8129,8/17/2004,3.86,39,89,N/A,0.07,0.28,4.14
8,0904-2933,29761 STANLEY RD, ,NEW
MARSHFIELD,OH,45766,8903,8/17/2004,18.38,39,163,N/A,0.075,1.38,19.76
9,0904-2934,4454 WING VIEW LN,
,KETTERING,OH,45429,3102,8/17/2004,3.8,39,113,57000,0.075,0.29,4.09
|
|
|
10,1104-4403,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,8/17/2004,4.32,E022
|
|
|
Upload your
Customer Address File
|