OpeningBalances
To list and delete opening balances.
Table Specific Information
Select
No filters are supported server-side for this table. All criteria will be handled client-side within the connector.
For example:
SELECT * FROM OpeningBalances
Delete
DELETE can be executed without specifying OpeningBalanceId in the WHERE Clause. It will delete all the opening balances associated with any of the accounts.
For example:
DELETE FROM OpeningBalances
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Description |
| OpeningBalanceId [KEY] | String | True |
ID of an opening balance. | ||
| CanShowCustomerOb | Boolean | True |
Check if opening balance can show customer ob. | ||
| CanShowVendorOb | Boolean | True |
Check if opening balance can show vendor ob. | ||
| Date | Date | False |
Date of an opening balance. | ||
| PricePrecision | Integer | True |
The precision for the price | ||
| Total | Decimal | True |
Total of opening balances. | ||
| Accounts | String | False |
Accounts. | ||
| Comments | String | True |
Comments. | ||
| TotalFormatted | String | True |
Formatted total amount of opening balance. |