Previous  Next          Contents  Index  Navigation  Glossary  Library

Importing Data From Your Feeder System

After you finish preparing to run the Sales Tax Rate Interface program, use a SQL*Loader script to transfer sales tax records from your sales tax feeder system into the tax interface table.

Receivables provides two SQL*Loader scripts - arvertex.ctl and aravp.ctl - as model files for loading your sales tax data into the tax interface table from your feeder system. These scripts are designed for the 'State.County.City' Sales Tax Location Flexfield structure and must be modified if you are using a different structure. The scripts reside in your ar/bin directory.

Note: These SQL*Loader control files upload current sales tax rate data only. If you need to upload historical sales tax data, you will have to customize the supplied scripts. Additionally, you should check with your Tax Vendor to ensure that they can supply you with historic sales tax rates.

The SQL*Loader scripts support several sales tax features. You can use these scripts to define sales tax locations and tax rates for each of the segments in the structure. These scripts support and will upload the following:

Truncated City Names

Receivables tax windows and the list of values support up to 60 characters for each location. Your tax feeder system may support a smaller number of characters. For example, if you have a State, County and City name of Arizona, Havasupai, Havasupai Indian Reservation, and your Sales Tax feeder system only supports 25 characters for each name, the city named Havasupai Indian Reservation is truncated to "Havasupai Indian Reservat". You must update any truncated city names in the Tax Locations and Rates window to reflect the correct names. See: Tax Locations and Rates.

See Also

Running the Tax Rate Interface Program

Sales Tax Rate Interface Validation

         Previous  Next          Contents  Index  Navigation  Glossary  Library