Sales Tax ID Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: TAXCODE.DAT
The TAXCODE.DAT file contains default information about the sales tax IDs maintained for your company's sales transactions.
- To add Sage 50 sales tax code fields to your Crystal reports, select TAXCODE.DAT.
Indexes and Their Uses
This file has the following three keys:
0 = By ID
1 = By Description
2 = By GUID
Fields
The following table shows the fields available in the TAXCODE.DAT file and includes the type and size in number of bytes of each field.
Field Name |
Type |
Size |
Comment |
---|---|---|---|
ID |
ZString |
8 |
Tax ID. |
Description |
ZString |
30 |
Description of the tax. |
TaxAuthority1 |
ZString |
8 |
First tax agency. |
TaxAuthority2 |
ZString |
8 |
Second tax agency. |
TaxAuthority3 |
ZString |
8 |
Third tax agency. |
TaxAuthority4 |
ZString |
8 |
Fourth tax agency. |
TaxAuthority5 |
ZString |
8 |
Fifth tax agency. |
TaxFreight |
Integer |
Setting of Tax Freight check box for Sales Taxes. 1 (True) => Sales tax must be charged for freight. 0 (False) => No sales tax required for freight charges. |
|
GUID |
Binary |
GUID (Globally Unique Identifier) used for linking Sales Tax Codes table. |
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |