JDBC Driver for MYOB

Build 24.0.9062

PayrollTaxTables

Return payroll tax tables loaded into 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. All the other columns and operators are processed client side.

SELECT * FROM PayrollTaxTables WHERE ID = "3a35e83a-5070-432d-b6ec-f4791f353352"
SELECT * FROM PayrollTaxTables WHERE Name = "criteria"

Columns

Name Type References Description
ID [KEY] Uuid Unique identifier in the form of a guid.
Name String Name of the payroll tax table.
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.
URI String Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062