ODBC Driver for Zoho Books

Build 24.0.9060

OpeningBalances

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

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