Sales Tax Agency Fields

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

Filename: TAXAUTH.DAT

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.

Indexes and Their Uses

This file has the following two keys:

0 = By ID

1 = By GUID

Fields

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

What do you want to do next?