Cmdlets for Sage Business Cloud Accounting

Build 24.0.9062

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

LedgerAccounts.Id

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

LedgerAccounts.Id

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062