Sales Tax Agency Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

The TAXAUTH.DAT file contains default information about the sales tax agencies maintained for your company's sales transactions.

To add Sage 50 sales tax agenc fields to your Crystal reports, select TAXAUTH.DAT.

This file has the following two keys:

0 = By ID

1 = By GUID

The following table shows the fields available in the TAXAUTH.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
ID	ZString	8	Tax agency ID.
Description	ZString	30	Description of the tax agency.
Rate1	Float		Single sales tax rate.
Rate2	Float		Tax rate based on a formula.
UsesFormula	Logical		Setting of the Formula option for Sales Tax Agencies. True => Uses a formula to calculate sales tax. False => Does not use a formula to calculate sales tax.
RateChangeAt	Float		Dollar amount entered in the up to box for Sales Tax Agencies. This is the dollar amount of sales over which sales taxes are calculated by formula.
TaxBasis	UBinary		Basis on which taxes are computed. Possible values include 0 = Total taxable sales 1 = per line item
GLAcntNumber	UBinary		Number of the sales tax payable G/L account.
VendorRecordNumber	UBinary		Record number associated with the vendor.
GUID	UBinary		GUID (Globally Unique Identifier) used for linking Sales Tax Agencies table.
LastUpdateCounter	Integer		This increases incrementally when the record is changed.
LastModified	Date	8