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 |