TaxCodes
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
Select
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 Code=0 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'
Columns
| 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). |