JDBC Driver for MYOB

Build 22.0.8462

PayrollExpenses

Return payroll categories of type expense 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, LimitAccrualPeriod, LimitFixedDollarsOf, LimitType, PrintOnPayAdvice, Threshold, Name, StpCategory, Type, PayrollCategoryID, PayrollCategoryName, PayrollCategoryType, CalculationBasisPercentageOf, CalculationBasisType, ExpenseAccountID, ExpenseAccountDisplayID, ExpenseAccountName, PayableAccountID, PayableAccountDisplayID, PayableAccountName. All the other columns and operators are processed client side.

SELECT * FROM PayrollExpenses WHERE PrintOnPayAdvice = true
SELECT * FROM PayrollExpenses WHERE LimitFixedDollarsOf = 350
SELECT * FROM PayrollExpenses WHERE StpCategory = "NotReportable"

Columns

Name Type Description
ID [KEY] Uuid Unique identifier in the form of a guid.
LimitAccrualPeriod String How the maximum expense is calculated if Limit.Type = FixedDollars. Can consist of any of the following: PayPeriod, Month, Year, Hour.
LimitFixedDollarsOf Decimal Maximum expense amount if Limit.Type = FixedDollars.
LimitType String The type of calculation to use can be any of the following 3: NoLimit - no limits in place on expense calculations. PercentageOfPayrollCategory - Equals x percentage, limit is calculated as a % of gross wages or another payroll category. FixedDollars - Equals x dollar limit set.
PrintOnPayAdvice Boolean True indicates accrued expenses will show on pay advices. False indicates accrued expenses will not be shown on pay advices.
Threshold Decimal Amount if expense is only payable when wages exceed a certain $$ per month.
Name String Name of the wage category.
StpCategory String STP Category for this payroll category. See MYOB help for more info. Valid values are: NotReportable (default), GrossPayments, PAYGWithholding, ExemptForeignIncome, CDEPPayments, AllowanceCar, AllowanceTransport, AllowanceTravel, AllowanceMeals, AllowanceLaundry, AllowanceOther, DeductionUnionProfAssocFees, DeductionWorkPlaceGiving, ReportableFringeBenefitsExemptAmount, ReportableFringeBenefitsTaxableAmount, ETPTaxableComponent, ETPTaxFreeComponent, ETPTaxWithholding, LumpSumPaymentATermination, LumpSumPaymentARedundancy, LumpSumPaymentB, LumpSumPaymentD, LumpSumPaymentE, SuperGuarantee, OrdinaryTimesEarnings, ReportableEmployerSuperContributions.
Type String Indicates the type of payroll category ie: Wage, Expense, Deduction.
PayrollCategoryID Uuid Unique category identifier in the form of a guid.
PayrollCategoryName String Name of the category.
PayrollCategoryType String Indicates the type of payroll category ie: Wage, Expense, Deduction.
PayrollCategoryURI String Uniform resource identifier associated with the category object.
CalculationBasisPercentageOf Decimal Percentage of super to calculate if CalculationBasis.Type = PercentageOfPayrollCategory.
CalculationBasisType String The type of calculation to use can be any of the following 3: UserEntered - use amount on employees standard pay when processing. PercentageOfPayrollCategory - Equals x percentage, calculate as a % of gross wages or another payroll category. FixedDollars - Equals x dollar to contribute for all linked employees.
ExpenseAccountID Uuid Unique identifier for the account in the form of a guid.
ExpenseAccountDisplayID String Account code. Format includes separator ie 4-1100
ExpenseAccountName String Name of the account.
ExpenseAccountURI String Uniform resource identifier associated with the account object.
PayableAccountID Uuid Unique identifier for the account in the form of a guid.
PayableAccountDisplayID String Account code. Format includes separator ie 4-1100
PayableAccountName String Name of the account.
PayableAccountURI String Uniform resource identifier associated with the account object.
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.

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