Sales Tax Jurisdiction Import Format

A

1

Jurisdiction

12

Character

Yes

Enter a sales tax jurisdiction.

B

2

Short Description

20

Character

Yes

Enter a short description of the sales tax jurisdiction.

C

3

Detailed Description

100

Character

No

Enter a detailed description of the sales tax jurisdiction.

D

4

State/Province

3

Character

Yes, only if a state or province is required for the country of the sales tax jurisdiction

Enter a valid state or province for the sales tax jurisdiction.

E

5

Country

20

Character

Yes

Enter a valid country for the sales tax jurisdiction.

F

6

City

40

Character

No

Enter a city for the sales tax jurisdiction (if applicable).

G

7

District

20

Character

No

Enter a district for the sales tax jurisdiction (if applicable).

H

8

County

20

Character

No

Enter a county for the sales tax jurisdiction (if applicable).

I

9

Postal Code

11

Character

No

Enter a valid postal code for the sales tax jurisdiction (if applicable). The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For more information on postal codes, see Postal Code Maintenance.

J

10

Parent Jurisdiction

12

Character

No

Enter a valid parent jurisdiction (if applicable). When the software calculates sales tax, it searches the jurisdiction chain from child to parent, to grandparent, etc. and accumulates the tax rate to use.

NOTE If the import file has both parent and child sales tax jurisdictions, the parent jurisdictions must be before the child jurisdictions in the file.