Previous  Next          Contents  Index  Navigation  Glossary  Library

Preparing to Load Sales Tax Rates

To ensure that the Sales Tax Rate Interface works correctly, you should complete the following steps before loading sales tax records into Receivables:

Verify the Sales Tax Location Flexfield Structure

When you use the Tax Interface program for the first time, navigate to the Key Flexfields window and verify that your Sales Tax Location Flexfield structure is frozen and compatible with the location and tax rate data that you will be loading into Receivables.

You only need to perform this step once.

Perform Backup of Sales Tax Information

Before you load sales tax data into Receivables, you should perform a backup of your location and tax rate information. This information is stored in the following tables:

You need to perform this step every time you execute the Sales Tax Rate Interface program.

Clear Tax Interface Table

Verify that the AR_TAX_INTERFACE table does not contain any records. The SQL loader control scripts aravp.ctl and arvertex.ctl will clear all existing tax rate information before loading a new set of locations and rates. You can either rely upon these scripts to clear existing records or truncate the table AR_TAX_INTERFACE manually using the TRUNCATE command.

Note: You cannot rollback a TRUNCATE statement.

You need to perform this step every time you execute the Sales Tax Rate Interface program.

Verify and Define Tax Table Storage Parameters

Verify that the AR_LOCATION_VALUES and AR_LOCATION_RATES tables into which you will load locations and tax rates have sufficient allocations of space. If you are loading sales tax data for the entire United States, then your database administrator must allocate the following amount of space for Receivables tax interface, tax locations, and tax rates tables.

You need to perform this step every time you execute the Sales Tax Rate Interface program.

Table Data Storage Index Storage
AR_TAX_INTERFACE 8 Megabytes 11 Megabytes
AR_LOCATION_VALUES 7 Megabytes 8 Megabytes
AR_LOCATION_RATES 10 Megabytes 5 Megabytes
TOTAL: 25 Megabytes 24 Megabytes

A submission of sales tax information which includes every state, county, and city in the United States will load approximately 60, 000 records into the AR_TAX_INTERFACE table.

If you enter customer addresses which use every state, county, and city within the United States, Receivables creates sales tax rates to handle each of these distinct addresses. Receivables uses the table AR_LOCATION_COMBINATIONS to store each unique authority, and the table AR_SALES_TAX to store the composite sales tax rates that it generates for these authorities. In this case, your database will require the following storage space for these tables in addition to the storage requirements listed previously.

Table Data Storage Index Storage
AR_LOCATION_ COMBINATIONS 7 Megabytes 6 Megabytes
AR_SALES_TAX 8 Megabytes 5 Megabytes
TOTAL: 15 Megabytes 11 Megabytes

See Also

Importing Data From Your Feeder System

Using Sales Tax Rate Interface


         Previous  Next          Contents  Index  Navigation  Glossary  Library