Tableau Connector for Sage Business Cloud Accounting

Build 22.0.8342

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

TransactionTypes.Id

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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342