TDV Adapter for Sage Business Cloud Accounting

Build 22.0.8462

Transactions

Query Transactions in Sage Business Cloud Accounting.

Table Specific Information

Query the available Transactions

Select

The driver uses the Sage Accounting API to process search criteria that refer to TransactionTypeId,UpdatedOrCreatedSince,FromDate,ToDate,UpdatedFromDate,UpdatedToDate,HasAttachments columns. The driver processes other filters client-side within the driver.

  • TransactionTypeId supports the '=' operator.
  • UpdatedOrCreatedSince supports the '=' operator.
  • FromDate supports the '=' operator.
  • ToDate supports the '=' operator.
  • UpdatedFromDate supports the '=' operator.
  • UpdatedToDate supports the '=' operator.
  • HasAttachments supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Transactions WHERE TransactionTypeId='abc'
SELECT * FROM Transactions WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM Transactions WHERE FromDate='2018-12-15'
SELECT * FROM Transactions WHERE ToDate='2018-12-15'
SELECT * FROM Transactions WHERE UpdatedFromDate='2018-12-15'
SELECT * FROM Transactions WHERE UpdatedToDate='2018-12-15'
SELECT * FROM Transactions WHERE HasAttachments='abc'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
CreatedAt Datetime The datetime when the item was created
DisplayedAs String The name of the resource
NumberOfAttachments String The number of attachments related to the transaction
TransactionTypeId String

TransactionTypes.Id

The unique identifier for the item
Deleted Bool Indicates whether the transaction has been deleted
Date Datetime The date of the transaction
Reference String The transaction reference
ContactId String

Contacts.Id

The unique identifier for the item
UpdatedAt Datetime The datetime when the item was last updated
LegacyId Int The legacy ID for the item
Total String The transaction total
LinksAggregate String Links for the resource
OriginDisplayedAs String The name of the resource
OriginLegacyId Int The legacy ID for the item
OriginId String The unique identifier for the item
AuditTrailId String The original entity that generated the transaction
FromDate Datetime
ToDate Datetime
UpdatedFromDate Datetime
UpdatedToDate Datetime
HasAttachments String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462