User Tools

Site Tools


dynamiczip:reports:export_columns

DZ Export Report Columns

The columns included in the export file depend on whether or not the Option F Tax Report or the 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 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 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 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
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 DZ Report Section Options window
Sales
Freight
Miscellaneous
Sales Taxable
Freight Taxable
Misc Taxable
Sales Tax
Freight Tax
Misc Tax


DynamicZip Reports

dynamiczip/reports/export_columns.txt · Last modified: 2017/09/13 21:00 by conni