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
- Perform Backup of Sales Tax Information
- Clear Tax Interface Table
- Verify and Define Tax Table Storage Parameters
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.
|
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.
|
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