CategoryRegisters
Return transactions grouped with categories
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: CategoryID, AccountID, Year, Month, Activity, YearEndActivity. All the other columns and operators are processed client side.
SELECT * FROM CategoryRegisters WHERE CategoryID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM CategoryRegisters WHERE AccountID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM CategoryRegisters WHERE Year = "2019" SELECT * FROM CategoryRegisters WHERE Month = "09"
Columns
| Name | Type | Description |
| CategoryID | Uuid | Unique category identifier in the form of a guid for the category. |
| AccountID | Uuid | Unique category identifier in the form of a guid for the account. |
| Year | Integer | Financial year in which the activity was generated ie 2014. |
| Month | Integer | Month in which the activity was generated ie December = 12. |
| Activity | Decimal | Net activity within profit & loss account or net movement within balance sheet accounts. |
| YearEndActivity | Decimal | Net activity within profit & loss account or net movement within balance sheet accounts for YearEndAdjustments. |
| 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. |