PayrollTaxes
Return payroll categories of type tax 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, TaxTableRevisionDate, PayableAccountID, PayableAccountDisplayID, PayableAccountName. All the other columns and operators are processed client side.
SELECT * FROM PayrollTaxes WHERE PayableAccountID = "02c3f70b-2570-4f2b-bd51-560c65ecb1df" SELECT * FROM PayrollTaxes WHERE Name = "PAYG Withholding" SELECT * FROM PayrollTaxes WHERE StpCategory = "PAYGWitholding"
Columns
Name | Type | References | Description |
ID [KEY] | Uuid | Unique identifier in the form of a guid. | |
Name | String | Name of the wage category. | |
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. | |
TaxTableRevisionDate | Datetime | The date payroll tax tables loaded in AccountRight were last updated. | |
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. |