Table of Contents
Replication of SQL tables for use with the KampData TaxEngine
At times, your Microsoft Dynamics GP databases may not be accessible from your 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 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 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 Web Server for more information.
TaxEngine Tables
The following KampData TaxEngine Tables will be automatically created by the TaxEngine when sa logs in:
- DzTe0010 Transaction Document Table
- DzTe0011 Transaction Line Table
- DzTe0012 Transaction Tax Table
- DzTe0310 Log Header Table
- DzTe0311 Log Detail Table
- DzTe0420 Module Setup Table
- DzTe0421 Document Type Setup table
- DzTe0430 Registration Table 1
- DzTe0510 Report Options Table
- DzTe0511 Report Restrictions Table
DynamicZip tables
Copy the following DynamicZip Tables and their data.
- DZ00100 DZ Item Supplement table 4
- DZ00101 DZ Item Category By Geocode Table 4
- DZ00400 DZ Tax Detail Supplement table 3
- DZ00500 DZ State Setup Table 3
- DZ00800 DZ Plus4 Geocode table (used with the Zip+4 option) 3
- DZ00900 DZ Geocode Master table 3
- DZ01100 DZ Customer Supplement table 3
- DZ01101 DZ Customer Address Supplement table 3
- DZ01102 DZ Customer Tax by State table 3
- DZ01300 DZ Exemption Type Table
- DZ01400 DZ Tax Schedule Supplement table 3
- DZ02101 DZ Vendor Address Supplement table 3
- DZ40300 DynamicZip Setup table 3
- DZ40400 DZ Zip Address table 3
- DZ40500 DZ Tax By Item Category Setup table 4
- DZ40550 DZ Item Category Master Table 4
- DZ40700 DZ Site Supplement Table 3
Microsoft Dynamics GP tables
Copy the following Microsoft Dynamics GP tables and their data (unless otherwise noted).
- GL00100 Gl Account Master Table
- IV00101 Item Master Table
- IV40700 Iv Site Setup Table
- PM00200 Vendor Master Table
- PM00300 Vendor Address Master Table
- RM00101 Customer Master Table 3
- RM00102 Customer Master Address Table 3
- RM20101 Rm Open Table 2
- RM30101 Rm History Table 2
- SOP30200 Sales Transaction History Table 2
- SOP30300 Sales Transaction Amounts History Table 2
- SOP40100 Sales Setup Table
- SY01100 Posting Account Master Table
- SY01500 Company Master Table 1
- SY03000 Shipping Methods Master Table
- SY03500 Registration Master Table 1
- TX00202 Sales Purchase Tax Summary Master Table 3
- TX00201 Sales Purchases Tax Master Table 3
- VAT10001 Vat Country Code Master Table
1 These tables are in the system (ie DYNAMICS) database.
2 These tables do not need to contain any data.
3 These tables need to be refreshed as needed to remain in sync with the accounting system.
4 These tables need to be refreshed after making changes to DynamicZip Tax by Item Category.
NOTE: All tables listed here except those flagged with a 2 should be updated whenever their content changes in Microsoft Dynamics GP.