JDBC Driver for MYOB

Build 22.0.8462

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 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, 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 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

Unique identifier for the account in the form of a guid.

OverriddenWagesExpenseAccountName String True

Name of the account.

OverriddenWagesExpenseAccountNumber String True

Account name belonging to the account record.

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.

CompanyFileId String True

The ID of the company file. Takes precedence over the CompanyFileId connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462