Returns a list of company files.
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: ID. All the other columns and operators are processed client side.
SELECT * FROM CompanyFiles WHERE ID = "68556195-8f87-4e1a-85e9-069f5fc52497"
|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.|