TDV Adapter for Sage 200

Build 22.0.8462


Tax codes are normally used for UK business VAT Rates. They are accessed by Sage 200 modules in order to: - Analyse the rates to Nominal Ledger accounts. - Analyse the rates to the VAT Return. - Read percentages for calculations in transactions.

Table Specific Information


The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM TaxCodes WHERE Id=1728
SELECT * FROM TaxCodes WHERE Name='Zero rated'
SELECT * FROM TaxCodes WHERE TaxRate=0
SELECT * FROM TaxCodes WHERE Terms='EcTermsNotApplicable'
SELECT * FROM TaxCodes WHERE TermsDescription='Not Applicable'
SELECT * FROM TaxCodes WHERE DateTimeUpdated='2018-02-28T15:23:46.133+01:00'


Name Type References Description
Id [KEY] Long Tax code record Id.
Code Short Tax code.
Name String Name of the tax code.
TaxRate Decimal Tax rate.
Terms String Name of the terms.
TermsDescription String Description of the terms.
DateTimeUpdated Datetime The date and time this entity was last updated (UTC).

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462