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 | 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 |