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.

JDBC Driver for MYOB

PayrollSuperannuations

Table Specific Information

Select

Columns