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 criteria 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	References	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	PayrollCategories.ID	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	Accounts.ID	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	Accounts.ID	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.

JDBC Driver for MYOB

PayrollSuperannuations

Table Specific Information

Select

Columns