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