PayrollCategories
Returns generic information on all payroll category types for an AccountRight company file.
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, Name, Type. All the other columns and operators are processed client side.
SELECT * FROM PayrollCategories WHERE ID = "3a35e83a-5070-432d-b6ec-f4791f353352" SELECT * FROM PayrollCategories WHERE Name = "criteria"
Columns
| Name | Type | Description |
| ID [KEY] | Uuid | Unique identifier in the form of a guid. |
| Name | String | Name of the payroll category. |
| Type | String | Indicates the type of payroll category ie: Wage, Expense, Deduction, Tax, Superannuation, Entitlement. |
| URI | String | Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| 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. |
| CompanyFileId | String | The ID of the company file. Takes precedence over the CompanyFileId connection property. |