Categories

Return categories for cost center tracking

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 = 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"

Columns


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

JDBC Driver for MYOB

Categories

Table Specific Information

Select

Columns