JDBC Driver for MYOB

Build 23.0.8839

CompanyFiles

Returns a list of company files.

Table Specific Information

Select

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: ID. All the other columns and operators are processed client side.

SELECT * FROM CompanyFiles WHERE ID = "68556195-8f87-4e1a-85e9-069f5fc52497"

Columns

Name Type Description
ID [KEY] Uuid Unique identifier in the form of a guid.
CheckedOutBy String my.MYOB user that has checked out the file offline.
CheckedOutDate Datetime Date the online file was checked out offline.
Country String The 2 character country code. EG: AU or NZ
LibraryPath String Path name to the company file.s
Name String Name of the object.
ProductVersion String MYOB AccountRight Live version this company file was created with. EG: 2013.3.
ProductLevelCode Integer AccountRight Live product code.
ProductLevelName String AccountRight Live product name, ie Basics, Standard, Plus.
SerialNumber String The 12 digit serial number of the AccountRight file.
UiAccessFlags Integer The file accessible product type identifier. 0-LocalAccountRight, 1-OnlineAccountRight, 2-New Essentials, 3-AccountRight and NewEssentials
Uri String Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.

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