JDBC Driver for MYOB

Build 22.0.8462

PayrollSuperannuations

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

SELECT * FROM PayrollSuperannuations WHERE Threshold = 450
SELECT * FROM PayrollSuperannuations WHERE LimitType = "NoLimit"
SELECT * FROM PayrollSuperannuations WHERE Exclusion = 23

Columns

Name Type Description
ID [KEY] Uuid Unique identifier in the form of a guid.
ContributionType String The type of contribution basis, consist of the following: SuperannuationGuarantee, EmployeeAdditional, EmployerAdditional, Productivity, Redundancy, SalaySacrifice, Spouse.
Exclusion Decimal Amount to reduce an employees wage by before calculating superannuation.
PrintOnPayAdvice Boolean True indicates accrued superannuation will show on pay advices. False indicates accrued superannuation will not be shown on pay advices.
Threshold Decimal Amount if superannuation is only payable when wages exceed a certain $$ per month.
Type String Indicates the type of payroll category ie: Wage, Expense, Deduction.
LimitType String The type of calculation to use can be any of the following 3: NoLimit - no limits in place on contribution calculations. PercentageOfPayrollCategory - Equals x percentage, limit is calculated as a % of gross wages or another payroll category. FixedDollars - Equals x dollar limit set.
Name String Name of the object.
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.
Exemptions String An array of wage categories the superannuation category is exempt from.
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