====== Replication of SQL tables for use with the KampData TaxEngine ======
At times, your Microsoft Dynamics GP databases may not be accessible from your [[taxengine:install:Web Server]]. In this situation, you may still wish to allow orders to be placed on your website.

To allow for the above functionality, you would need to copy certain tables and table data from your Microsoft Dynamics GP SQL Server onto your [[taxengine:install:Web Server]].

The KampData TaxEngine uses a number of SQL tables for calculating tax on documents. Some of these tables are located in the company database(s), and some are located in the DYNAMICS database. The list includes KampData TaxEngine tables, DynamicZip tables and Microsoft Dynamics GP tables.
 
The initial login to the KampData TaxEngine Control Center should be made by sa. Logging in as sa ensures that you will have the proper rights to create/update the TaxEngine's SQL tables. Subsequent logins can be made by any user that has been granted the same SQL security permissions that DYNGRP is granted automatically by Microsoft Dynamics GP These include Delete, Insert, Select and Update.

**NOTE:** The TaxEngine tables will probably be created on the GP Server and then copied/replicated out to the web server. However, if the TaxEngine tables are going to be created new on the [[taxengine:install:Web Server]] instead of being copied over, then the DYNGRP database role and DYNGRP schema must exist in the web server's DYNAMICS and company databases. Please see [[taxengine:install:Web Server]] for more information.

===== TaxEngine Tables =====
The following [[taxengine:tables:tables|KampData TaxEngine Tables]] will be automatically created by the TaxEngine when sa logs in:

  * DzTe0010 [[taxengine:tables:Transaction Document Table]]
  * DzTe0011 [[taxengine:tables:Transaction Line Table]]
  * DzTe0012 [[taxengine:tables:Transaction Tax Table]]
  * DzTe0310 [[taxengine:tables:Log Header Table]]
  * DzTe0311 [[taxengine:tables:Log Detail Table]]
  * DzTe0420 [[dynamiczip:tables:dz_taxengine_module_setup_table|Module Setup Table]]
  * DzTe0421 [[dynamiczip:tables:dz_document_type_setup_table|Document Type Setup table]]
  * DzTe0430 [[taxengine:tables:Registration Table]] <sup>1</sup>
  * DzTe0510 [[taxengine:tables:Report Options Table]]
  * DzTe0511 [[taxengine:tables:Report Restrictions Table]]

===== DynamicZip tables =====

Copy the following [[dynamiczip:tables:tables|DynamicZip Tables]] and their data.

  * DZ00100 [[dynamiczip:tables:DZ Item Supplement table]] <sup>4</sup>
  * DZ00101 [[dynamiczip:tables:DZ Item Category By Geocode Table]] <sup>4</sup>
  * DZ00400 [[dynamiczip:tables:DZ Tax Detail Supplement table]]  <sup>3</sup>
  * DZ00500 [[dynamiczip:tables:DZ State Setup Table]] <sup>3</sup>
  * DZ00800 [[dynamiczip:tables:dz_plus4_geocode_table|DZ Plus4 Geocode table]] (used with the Zip+4 option)  <sup>3</sup>
  * DZ00900 [[dynamiczip:tables:DZ Geocode Master table]]  <sup>3</sup>
  * DZ01100 [[dynamiczip:tables:DZ Customer Supplement table]] <sup>3</sup>
  * DZ01101 [[dynamiczip:tables:DZ Customer Address Supplement table]]  <sup>3</sup>
  * DZ01102 [[dynamiczip:tables:DZ Customer Tax by State table]] <sup>3</sup>
  * DZ01300 [[dynamiczip:tables:DZ Exemption Type Table]]
  * DZ01400 [[dynamiczip:tables:DZ Tax Schedule Supplement table]]  <sup>3</sup>
  * DZ02101 [[dynamiczip:tables:dz_vendor_address_supplement_table|DZ Vendor Address Supplement table]] <sup>3</sup>
  * DZ40300 [[dynamiczip:tables:DynamicZip Setup table]] <sup>3</sup>
  * DZ40400 [[dynamiczip:tables:DZ Zip Address table]]  <sup>3</sup>
  * DZ40500 [[dynamiczip:tables:DZ Tax By Item Category Setup table]]  <sup>4</sup>
  * DZ40550 [[dynamiczip:tables:DZ Item Category Master Table]] <sup>4</sup>
  * DZ40700 [[dynamiczip:tables:DZ Site Supplement Table]] <sup>3</sup>

===== Microsoft Dynamics GP tables =====

Copy the following Microsoft Dynamics GP [[dynamics:tables:tables]] and their data (unless otherwise noted).
  * GL00100 [[dynamics:tables:Gl Account Master Table]]
  * IV00101 [[dynamics:tables:Item Master Table]]
  * IV40700 [[dynamics:tables:Iv Site Setup Table]]
  * PM00200 [[dynamics:tables:Vendor Master Table]]
  * PM00300 [[dynamics:tables:Vendor Address Master Table]]
  * RM00101 [[dynamics:tables:Customer Master Table]] <sup>3</sup>
  * RM00102 [[dynamics:tables:Customer Master Address Table]]  <sup>3</sup>
  * RM20101 [[dynamics:tables:Rm Open Table]] <sup>2</sup>
  * RM30101 [[dynamics:tables:Rm History Table]] <sup>2</sup>
  * SOP30200 [[dynamics:tables:Sales Transaction History Table]] <sup>2</sup>
  * SOP30300 [[dynamics:tables:Sales Transaction Amounts History Table]] <sup>2</sup>
  * SOP40100 [[dynamics:tables:Sales Setup Table]]
  * SY01100 [[dynamics:tables:Posting Account Master Table]]
  * SY01500 [[dynamics:tables:Company Master Table]] <sup>1</sup>
  * SY03000 [[dynamics:tables:Shipping Methods Master Table]]
  * SY03500 [[dynamics:tables:Registration Master Table]] <sup>1</sup>
  * TX00101 [[dynamics:tables:Sales Purchases Tax Schedule Header Master table]]  <sup>3</sup>
  * TX00102 [[dynamics:tables:Sales Purchases Tax Schedule Master Table]] <sup>3</sup>
  * TX00202 [[dynamics:tables:Sales Purchase Tax Summary Master Table]] <sup>3</sup>
  * TX00201 [[dynamics:tables:Sales Purchases Tax Master Table]] <sup>3</sup>
  * VAT10001 [[dynamics:tables:Vat Country Code Master Table]]

----

<sup>1</sup> These tables are in the system (ie DYNAMICS) database.\\
<sup>2</sup> These tables do not need to contain any data.\\
<sup>3</sup> These tables need to be refreshed as needed to remain in sync with the accounting system.\\
<sup>4</sup> These tables need to be refreshed after making changes to [[dynamiczip:features:tbic:tax_by_item_category|DynamicZip Tax by Item Category]].

**NOTE:** All tables listed here except those flagged with a <sup>2</sup> should be updated whenever their content changes in Microsoft Dynamics GP.


----


[[taxengine:faq:Frequently Asked Questions]]