Cmdlets for Sage Business Cloud Accounting

Build 24.0.9062

ContactOpeningBalances

Query ContactOpeningBalances in Sage Business Cloud Accounting.

Table Specific Information

Query the available ContactOpeningBalances

Select

The driver uses the Sage Accounting API to process search criteria that refer to ContactId,ContactTypeId,UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.

  • ContactId supports the '=' operator.
  • ContactTypeId supports the '=' operator.
  • UpdatedOrCreatedSince supports the '=' operator.
  • DeletedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM ContactOpeningBalances WHERE ContactId = 'abc'
SELECT * FROM ContactOpeningBalances WHERE ContactTypeId = 'CUSTOMER'
SELECT * FROM ContactOpeningBalances WHERE UpdatedOrCreatedSince = '2018-12-15'
SELECT * FROM ContactOpeningBalances WHERE DeletedSince = '2018-12-15'

Update

Updates are performed based on Id.

UPDATE ContactOpeningBalances SET TaxRateId = 'abc' WHERE Id = '123'

Delete

You must specify the Id of the ContactOpeningBalances to delete it.

DELETE FROM ContactOpeningBalances WHERE id = '123' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

TaxRateId String False

TaxRates.Id

The unique identifier for the item

CreatedAt Datetime True

The datetime when the item was created

TransactionTypeId String False

TransactionTypes.Id

The unique identifier for the item

NetAmount String False

The net amount of the opening balance

CurrencyId String False

Currencies.Id

The unique identifier for the item

Reference String False

The reference for the opening balance

TotalAmount String False

The total amount of the opening balance

TaxBreakdownAggregate String False

The tax breakdown for the opening balance

DeletedAt Datetime True

The datetime when the item was deleted

ContactOpeningBalanceTypeId String False

ContactOpeningBalances.Id

The unique identifier for the item

DisplayedAs String False

The name of the resource

TaxAmount String False

The tax amount of the opening balance

TransactionId String False

Transactions.Id

The unique identifier for the item

ContactId String False

Contacts.Id

The unique identifier for the item

Details String False

A description of the opening balance

LegacyId Int False

The legacy ID for the item

ContactTypeId String False

使用できる値は次のとおりです。CUSTOMER, VENDOR

Date String False

The date of the opening balance

UpdatedAt Datetime True

The datetime when the item was last updated

ExchangeRate String False

The exchange rate for the opening balance

DeletedSince Datetime True

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