TaxProfiles
Query TaxProfiles in Sage Business Cloud Accounting.
Table Specific Information
Query the available TaxProfiles
Select
The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince column. The driver processes other filters client-side within the driver.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaxProfiles WHERE UpdatedOrCreatedSince='2018-12-15'
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 | |
| DisplayedAs | String | False |
The name of the resource | |
| CollectTax | Bool | False |
Indicates whether tax is collected for this tax type | |
| LegacyId | Int | False |
The legacy ID for the item | |
| TaxReturnFrequencyId | String | False |
The unique identifier for the item | |
| UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
| TaxNumberSuffix | String | False |
The tax number suffix | |
| TaxNumber | String | False |
The tax number | |
| AddressRegionId | String | False |
The unique identifier for the item |