PayrollWages
Return, update, create and delete payroll categories of type wage 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, StpCategory, Type, WageType, PayRate, FixedHourlyRate, AutomaticallyAdjustBaseAmounts, RegularRateMultiplier, OverriddenWagesExpenseAccountID, OverriddenWagesExpenseAccountName, OverriddenWagesExpenseAccountNumber. All the other columns and operators are processed client side.
SELECT * FROM PayrollWages WHERE ID = "e57725b2-c4f0-47ce-8103-299c7a675112" SELECT * FROM PayrollWages WHERE Name = "Base Hourly" SELECT * FROM PayrollWages WHERE StpCategory = "NotReportable" OR Type = "Wage"
Insert
The following attribute is required when performing an insert: WageType, Name.
INSERT INTO PayrollWages (WageType, Name) VALUES ("Salary", "Example salary")
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. | |
Name | String | False |
Name of the wage category. | |
StpCategory | String | False |
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 | True |
Indicates the type of payroll category ie: Wage, Expense, Deduction. | |
WageType | String | True |
Indicates whether the wage category is a salary type or an hourly type. Use either Hourly or Salary | |
PayRate | String | True |
How to calculate the rate, can be either RegularRate or FixedHourly. | |
FixedHourlyRate | Decimal | False |
Fixed hourly rate for all employees linked to this wage category if PayRate = FixedHourly, otherwise null. | |
AutomaticallyAdjustBaseAmounts | Boolean | False |
When entering leave amounts on a pay, base hourly or base salary amount will automatically be adjusted if set to True. | |
RegularRateMultiplier | Decimal | False |
Calculate as a multiple of the hourly rate setup on each employee's card if PayRate = RegularRate, otherwise null. | |
OverriddenWagesExpenseAccountID | Uuid | False |
Accounts.ID |
Unique identifier for the account in the form of a guid. |
OverriddenWagesExpenseAccountName | String | True |
Name of the account. | |
OverriddenWagesExpenseAccountNumber | String | True |
Account code format includes separator ie 6-1200. | |
OverriddenWagesExpenseAccountURI | String | True |
Uniform resource identifier associated with the account object. | |
URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. | |
RowVersion | String | True |
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 | False |
An array of tax and deductions this wage category is exempt from. |