TDV Adapter for MYOB

Build 22.0.8462


Returns a Balance Sheet Summary.

Table Specific Information


MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering: AsOfDate, YearEndAdjust. All the other columns and operators are processed client side. The default behavior is AsOfDate as today's date and YearEndAdjust as false; if the AsOfDate and YearEndAdjust filters are left unset.

SELECT * FROM BalanceSheetSummaryReport
To override this behavior, the values can be set directly in the query. For example:
SELECT * FROM BalanceSheetSummaryReport WHERE AsOfDate = '2021-05-31 00:00:00' AND YearEndAdjust = false


Name Type Description
AccountTotal Decimal Total Amount for the Account for the given date range.
AccountID Uuid Unique identifier for the account in the form of a guid.
AccountDisplayID String Account code. Format includes separator ie 4-1100
AccountName String Name of the account.
AccountURI String Uniform resource identifier associated with the account object.
AsOfDate Date Date of the period, format YYYY-MM-DD HH:MM:SS
YearEndAdjust Boolean If you are including Year end Adjustments. This is a true or False value.
CompanyFileId String The ID of the company file. Takes precedence over the CompanyFileId connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462