taxengine:faq:replicate_sql_faq
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
taxengine:faq:replicate_sql_faq [2015/04/13 23:50] – external edit 127.0.0.1 | taxengine:faq:replicate_sql_faq [2018/12/06 16:56] (current) – chuck | ||
---|---|---|---|
Line 4: | Line 4: | ||
To allow for the above functionality, | To allow for the above functionality, | ||
- | 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), | + | 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), |
- | \\ | + | |
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/ | 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/ | ||
- | **NOTE: **The TaxEngine tables will probably be created on the GP Server and then copied/ | + | **NOTE:** The TaxEngine tables will probably be created on the GP Server and then copied/ |
===== TaxEngine Tables ===== | ===== TaxEngine Tables ===== | ||
- | Copy all [[taxengine: | + | The following |
* DzTe0010 [[taxengine: | * DzTe0010 [[taxengine: | ||
Line 31: | Line 31: | ||
* DZ00101 [[dynamiczip: | * DZ00101 [[dynamiczip: | ||
* DZ00400 [[dynamiczip: | * DZ00400 [[dynamiczip: | ||
- | * DZ00500 [[dynamiczip: | + | * DZ00500 [[dynamiczip: |
* DZ00800 [[dynamiczip: | * DZ00800 [[dynamiczip: | ||
- | * DZ00900 [[dynamiczip: | + | * DZ00900 [[dynamiczip: |
- | * DZ01100 [[dynamiczip: | + | * DZ01100 [[dynamiczip: |
* DZ01101 [[dynamiczip: | * DZ01101 [[dynamiczip: | ||
- | * DZ01102 [[dynamiczip: | + | * DZ01102 [[dynamiczip: |
* DZ01300 [[dynamiczip: | * DZ01300 [[dynamiczip: | ||
* DZ01400 [[dynamiczip: | * DZ01400 [[dynamiczip: | ||
- | * DZ40300 [[dynamiczip: | + | |
- | * DZ40400 [[dynamiczip: | + | |
+ | * DZ40400 [[dynamiczip: | ||
* DZ40500 [[dynamiczip: | * DZ40500 [[dynamiczip: | ||
* DZ40550 [[dynamiczip: | * DZ40550 [[dynamiczip: | ||
- | * DZ40700 [[dynamiczip: | + | * DZ40700 [[dynamiczip: |
===== Microsoft Dynamics GP tables ===== | ===== Microsoft Dynamics GP tables ===== | ||
- | Copy the following Microsoft Dynamics GP [[dynamics: | + | Copy the following Microsoft Dynamics GP [[dynamics: |
* GL00100 [[dynamics: | * GL00100 [[dynamics: | ||
* IV00101 [[dynamics: | * IV00101 [[dynamics: | ||
Line 75: | Line 76: | ||
< | < | ||
< | < | ||
- | < | + | < |
**NOTE:** All tables listed here except those flagged with a < | **NOTE:** All tables listed here except those flagged with a < |
taxengine/faq/replicate_sql_faq.1428969056.txt.gz · Last modified: 2015/06/12 17:12 (external edit)