Return categories for cost center tracking
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 = operator. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison type for server side filtering: ID, DisplayID, Name, Description, IsActive. All the other columns and operators are processed client side.
SELECT * FROM Categories WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM Categories WHERE DisplayID = "TestDisplayID" SELECT * FROM Categories WHERE Name = "Category 1" OR Description = "Test description"
|ID [KEY]||Uuid||Unique category identifier in the form of a guid.|
|DisplayId||String||Display id assigned to the category.|
|Name||String||Name assigned to the category.|
|Description||String||Description text for the category.|
|IsActive||Boolean||True indicates the category is active. False indicates the category is inactive.|
|RowVersion||String||Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.|
|URI||String||Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.|
|CompanyFileId||String||The ID of the company file. Takes precedence over the CompanyFileId connection property.|