Differences

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

--- taxengine:faq:replicate_sql_faq [2015/07/02 17:40] – conni
+++ taxengine:faq:replicate_sql_faq [2018/12/06 16:56] (current) – chuck
@@ 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>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>
+  * 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.