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?

• See a list of Crystal Reports data (.DAT) files

Published: March 21, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks