Tableau Connector for MYOB

Build 24.0.9062

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 criteria 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 References Description
CategoryID Uuid

Categories.ID

Unique category identifier in the form of a guid for the category.
AccountID Uuid

Accounts.ID

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062