KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== DZ Export Report Columns ======

The columns included in the export file depend on whether or not the [[dynamiczip:reports:Option F Tax Report]] or the [[dynamiczip:reports:Option D Tax Report]] is printed in detail or summary.

===== Detailed Report Columns =====

Sort (The sort by field such as Tax Detail ID)\\ 
Sort Description (A description of the sort field such as Tax Detail Description)\\ 
Sort Info (Additional information about the sort field such as tax rate, Location Code and Authority)\\ 
(The above sort fields repeat for each sort option selected in the [[dynamiczip:windows:DZ Report Section Options window]] \\ 
Document Number //(Voucher Number for purchasing)//\\ 
Document Type \\ 
Transaction Source \\ 
Module \\ 
Document Date \\ 
Customer ID //(Vendor ID for purchasing)//\\ 
City (based on [[dynamiczip:features:addressing:Address Source]])\\ 
County (based on Address Source)\\ 
State (based on Address Source)\\ 
ZIP Code \\ 
Subtotal \\ 
Trade Discounts \\ 
Freight\\ 
Miscellaneous\\ 
Tax Amount\\ 
Document Amount\\ 
Tax Schedule ID\\ 
Tax Schedule Description\\ 
Tax Rate\\ 
Tax Detail ID\\ 
Tax Detail Description\\ 
Tax Rate\\ 
Location ID (from the [[dynamiczip:tables:DZ Tax Detail Supplement table]]) \\ 
Jurisdiction State (from the DZ Tax Detail Supplement table) \\ 
Jurisdiction County (from the DZ Tax Detail Supplement table) \\ 
Jurisdiction City (from the DZ Tax Detail Supplement table) \\ 
Sales\\ 
Sales Taxable\\ 
Freight Taxable\\ 
Misc Taxable\\ 
Sales Tax\\ 
Freight Tax\\ 
Misc Tax\\ 
[[dynamiczip:glossary:document_warning_flag|Document Warning Flag]]

===== Summary Report Columns =====

Sort (The sort by field such as Tax Detail ID)\\ 
Sort Description (A description of the sort field such as Tax Detail Description)\\ 
Sort Info (Additional information about the sort field such as tax rate, Location Code and Authority)\\ 
(The above sort fields repeat for each sort option selected in the [[dynamiczip:windows:DZ Report Section Options window]] \\ 
Sales\\ 
Freight\\ 
Miscellaneous\\ 
Sales Taxable\\ 
Freight Taxable\\ 
Misc Taxable\\ 
Sales Tax\\ 
Freight Tax\\ 
Misc Tax\\ 

----

[[dynamiczip:reports:reports|DynamicZip Reports]]