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.

What do you want to do next?