PayrollEntitlements
Return payroll categories of type entitlement 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, Name, PrintOnPayAdvice, StpCategory, Type, CalculationAccrualPeriod, CalculationFixedHoursOf, CalculationBasisType, CarryEntitlementOverToNextYear. All the other columns and operators are processed client side.
SELECT * FROM PayrollEntitlements WHERE ID = "3a35e83a-5070-432d-b6ec-f4791f353352" SELECT * FROM PayrollEntitlements WHERE Name = "criteria"
Columns
| Name | Type | References | Description |
| ID [KEY] | Uuid | Unique identifier in the form of a guid. | |
| Name | String | Name of the object. | |
| PrintOnPayAdvice | Boolean | True indicates accrued leave hours will show on pay advices. False indicates accrued leave hours will not be shown on pay advices. | |
| 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. | |
| CalculationAccrualPeriod | String | How the specified hours are accrued if CalculationBasis.Type = FixedHours. Can consist of any of the following: PayPeriod, Month, Year, Hour. | |
| CalculationFixedHoursOf | Decimal | Number of hours to accrue if CalculationBasis.Type = FixedHours. | |
| 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. | |
| CarryEntitlementOverToNextYear | Boolean | True indicates to carry over any unused leave hours when starting a new payroll year. False indicates not to carry over unused leave hours when starting a new payroll year. | |
| 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. | |
| PayrollWages | String | An array of linked wage category information, when recording hours for selected linked wage on an employee's pay, the entitlement balance will reduce accordingly. |