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.
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 |