Differences

This shows you the differences between two versions of the page.

--- taxengine:faq:replicate_sql_faq [2015/06/12 17:12] – conni
+++ taxengine:faq:replicate_sql_faq [2018/12/06 16:56] (current) – chuck
@@ Line 5: / Line 5: @@
 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.
@@ Line 11: / Line 11: @@
 ===== TaxEngine Tables =====
-Copy all [[taxengine:tables:tables|KampData TaxEngine Tables]] and their data from both the company and DYNAMICS databases.
+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]]
@@ Line 31: / Line 31: @@
   * 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]]
+  * 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>1, 3</sup>
+  * DZ00900 [[dynamiczip:tables:DZ Geocode Master table]]  <sup>3</sup>
-  * DZ01100 [[dynamiczip:tables:DZ Customer Supplement table]]
+  * 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]]
+  * 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>
-  * DZ40300 [[dynamiczip:tables:DynamicZip Setup table]]
+  * DZ02101 [[dynamiczip:tables:dz_vendor_address_supplement_table|DZ Vendor Address Supplement table]] <sup>3</sup>
-  * DZ40400 [[dynamiczip:tables:DZ Zip Address table]]  <sup>1, 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]]
+  * 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.
+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]]
@@ Line 75: / Line 76: @@
 <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]].\\
+<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.