KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== ZIPsales Database ======


The ZIPsales Database is a source of sales and use tax rates for import by DynamicZip into Microsoft Dynamics GP.

  * The ZIPsales Database subscription is a separate purchase, and __NOT__ included in the price of DynamicZip.
  *  The database can be purchased from [[https://kampdata.com/products/42-cch|CCH]]. Once you have subscribed, CCH should send you an email that contains a password, which you will use with their [[dynamiczip:glossary:zip_product_manager|ZIPproduct Manager]] software to download the database files to your computer. 
  * The contents of this database are read and utilized during the [[dynamiczip:features:import:rate_and_boundary_import|Rate & Boundary Import]] process.
  * Any time there is an update of the database (Usually, once a month), CCH will send out an email with a new password.
  * For questions about the database (ZIP Codes, tax rates, etc), or for help with obtaining the latest password, please contact 
      * Chat https://support.cch.com/chat; \\
      * Web Ticket http://support.cch.com/ticket/ContactUs.aspx; \\
      * Phone at 1-800-739-9998

The tables read from the [[dynamiczip:glossary:zipsales_database_folder|Rate & Boundary Database Folder]] by the Rate & Boundary Import process are the ZIPsales Database files:

  * City.txt 
  * County.txt 
  * DetailG.txt 
  * Local.txt 
  * State.txt 
  * Zip.txt

In addition, the [[dynamiczip:glossary:Flat_File_Test|Flat File Test]] uses the ZIPsales Database file: 

  * Flat.txt

Starting with Build 74, the source of Zip+4 data is the [[dynamiczip:glossary:kamp_database|KampDatabase]]. Prior to Build 74, the [[dynamiczip:features:Zip4 Option|Zip+4 Option]] required the ZIPsales Database file:
  * Plus4.txt

The ZIPsales database also includes this file which contains documentation on the various files content and layout:

  * DATABAS2.DOC 

See also [[dynamiczip:glossary:Zipsales Database Rules file]] 

----
[[dynamiczip:glossary:Glossary]]\\
[[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] \\
[[dynamiczip:features:import:database_comparison|Rate & Boundary Database Comparison]] \\
[[dynamiczip:troubleshooting:issues:known_cch_zipproductmanager_issue|CCH ZIPproduct Manager Known Issues]]