JDBC Driver for MYOB

Build 22.0.8462

PayrollCategorySummaryReport

Returns a Payroll Category Summary report for an AccountRight 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: EndDate, StartDate, ReportingBasis, YearEndAdjust. All the other columns and operators are processed client side. The default behavior is EndDate as today's date, StartDate as the first day of the year, ReportingBasis as Cash, and YearEndAdjust as false; if the EndDate, StartDate, ReportingBasis, and YearEndAdjust filters are left unset.

SELECT * FROM PayrollCategorySummaryReport
To override this behavior, the values can be set directly in the query. For example:
SELECT * FROM PayrollCategorySummaryReport WHERE StartDate = "12/01/2018" AND EndDate = "01/04/2019" AND ReportingBasis = "Cash" AND YearEndAdjust = false

Columns

Name Type Description
Amount Decimal Total amount for the Payroll Category for that date range.
Hours Decimal Total Hours for the Payroll Category for that date range.
PayrollCategoryID Uuid Unique category identifier in the form of a guid.
PayrollCategoryName String Name of the category.
PayrollCategoryType String Payroll Category Type.
PayrollCategoryURI String Uniform resource identifier associated with the category object.
EndDate Date Starting date of the period.
StartDate Date Ending date of the period.
ReportingBasis String Reporting basis for the period, will either be Cash or Accural.
YearEndAdjust Boolean If you are including Year end Adjustments. This is a true or False value.
CompanyFileId String The ID of the company file. Takes precedence over the CompanyFileId connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462