PayrollDeductions
Return payroll categories of type deduction 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, CalculationBasisPercentageOf, CalculationBasisType, CalculationFixedDollarsOf, LimitAccrualPeriod, LimitFixedDollarsOf, LimitType, Name, StpCategory, Type, PayableAccountID, PayableAccountDisplayID, PayableAccountName. All the other columns and operators are processed client side.
SELECT * FROM PayrollDeductions WHERE ID = "PayrollEntitlements" SELECT * FROM PayrollDeductions WHERE CalculationBasisPercentageOf = 28 SELECT * FROM PayrollDeductions WHERE PayableAccountName = "PayableAccountName"
Columns
| Name | Type | Description |
| ID [KEY] | Uuid | Unique identifier in the form of a guid. |
| 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. |
| CalculationFixedDollarsOf | Decimal | Nominated deduction amount CalculationBasis.Type = FixedDollars. |
| 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. |
| Name | String | Name of the object. |
| 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. |
| 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. |