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