Services
Query Services in Sage Business Cloud Accounting.
Table Specific Information
Query the available Services
Select
The driver uses the Sage Accounting API to process search criteria that refer to Active,Search,UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.
- Active supports the '=' operator.
- Search supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- DeletedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Services WHERE Active = false SELECT * FROM Services WHERE Search = 'abc' SELECT * FROM Services WHERE UpdatedOrCreatedSince = '2018-12-15' SELECT * FROM Services WHERE DeletedSince = '2018-12-15'
Insert
INSERT INTO StockItems (SalesLedgerAccountId, SalesTaxRateId, Active) VALUES ('1', '2', 'true')
Update
Updates are performed based on Id.
UPDATE Services SET SalesLedgerAccountId = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the Services to delete it.
DELETE FROM Services WHERE id = '123'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
SalesLedgerAccountId | String | False |
The unique identifier for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
SalesTaxRateDisplayedAs | String | False |
The name of the resource | |
SalesTaxRateLegacyId | Int | False |
The legacy ID for the item | |
SalesTaxRateId | String | False |
The unique identifier for the item | |
Active | Bool | False |
Indicates whether the service is active | |
ItemCode | String | False |
The item code for the service | |
PurchaseLedgerAccountId | String | False |
The unique identifier for the item | |
DeletedAt | Datetime | True |
The datetime when the item was deleted | |
PurchaseTaxRateId | String | False |
TaxRates.Id |
The unique identifier for the item |
Notes | String | False |
The notes for the service | |
UsualSupplierId | String | False |
Contacts.Id |
The unique identifier for the item |
SalesRatesAggregate | String | False |
The sales rates for the service | |
DisplayedAs | String | False |
The name of the resource | |
Description | String | False |
The service description | |
PurchaseDescription | String | False |
The service purchase description | |
LegacyId | Int | False |
The legacy ID for the item | |
SourceGuid | String | False |
Used when importing services from external sources | |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
Search | String | True | ||
DeletedSince | Datetime | True |