ContactAllocations
Query ContactAllocations in Sage Business Cloud Accounting.
Table Specific Information
Query the available ContactAllocations
Select
The driver uses the Sage Accounting API to process search criteria that refer to TransactionTypeId,ContactId,UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.
- TransactionTypeId supports the '=' operator.
- ContactId supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- DeletedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ContactAllocations WHERE TransactionTypeId = 'abc' SELECT * FROM ContactAllocations WHERE ContactId = 'abc' SELECT * FROM ContactAllocations WHERE UpdatedOrCreatedSince = '2018-12-15' SELECT * FROM ContactAllocations WHERE DeletedSince = '2018-12-15'
Update
Updates are performed based on Id.
UPDATE ContactAllocations SET TransactionTypeId = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the ContactAllocations to delete it.
DELETE FROM ContactAllocations WHERE id = '123'
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 | |
TransactionTypeId | String | False |
The unique identifier for the item | |
TransactionId | String | False |
Transactions.Id |
The unique identifier for the item |
Date | Datetime | True |
The date the allocation was made | |
AllocatedArtefactsAggregate | String | False |
The payment lines of the payment | |
ContactId | String | False |
Contacts.Id |
The unique identifier for the item |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
LegacyId | Int | False |
The legacy ID for the item | |
DeletedAt | Datetime | True |
The datetime when the item was deleted | |
LinksAggregate | String | False |
Links for the resource | |
DeletedSince | Datetime | True |