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 | 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. | |
| CompanyFileId | String |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |