TaxRates
Query TaxRates in Sage Business Cloud Accounting.
Table Specific Information
Query the available TaxRates
Select
The driver uses the Sage Accounting API to process search criteria that refer to Date,UpdatedOrCreatedSince,AddressRegionId,Date,IncludeHistoricalData columns. The driver processes other filters client-side within the driver.
- Date supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- AddressRegionId supports the '=' operator.
- Date supports the '=' operator.
- IncludeHistoricalData supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaxRates WHERE Date = '2018-12-15' SELECT * FROM TaxRates WHERE UpdatedOrCreatedSince = '2019-10-02T11:46:54' SELECT * FROM TaxRates WHERE AddressRegionId = 'CA-AB' SELECT * FROM TaxRates WHERE IncludeHistoricalData = false
Insert
INSERT INTO TaxRates (Name, Editable, IsVisible) VALUES ('Test', 'true', 'true')
Update
Updates are performed based on Id.
UPDATE TaxRates SET Name = 'test' WHERE Id = '1a756edcf15743ba8cc53804df6049da'
Delete
You must specify the Id of the TaxRates to delete it.
DELETE FROM TaxRates WHERE id = '1a756edcf15743ba8cc53804df6049da'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
IsCombinedRate | Bool | False |
Indicates whether the tax rate is made up of component tax rates | |
DisplayedAs | String | False |
The name of the resource | |
Name | String | False |
The name of the tax rate | |
TaxRatePercentageAggregate | String | False |
The tax rate percentage and date ranges they apply to | |
Editable | Bool | False |
Indicates whether a tax rate can be edited | |
Retailer | Bool | False |
Indicates if tax rate is a retailer rate or not | |
ComponentTaxRatesAggregate | String | False |
The component tax rates which make up a combined rate | |
Deletable | Bool | False |
Indicates whether a tax rate can be deleted | |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
Agency | String | False |
The agency name (US Only) | |
LegacyId | Int | False |
The legacy ID for the item | |
IsVisible | Bool | False |
Indicates whether the tax rate is displayed in the application | |
Percentage | String | False |
The current tax rate percentage | |
Date | Datetime | True | ||
AddressRegionId | String | True | ||
IncludeHistoricalData | Bool | True |