JDBC Driver for MYOB

Build 22.0.8462

Activities

Return, update, create and delete a list of time billing activities 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, Description, DisplayID, IsActive, Name, Status, Type, UnitOfMeasurement, IncomeAccountID, IncomeAccountDisplayID, IncomeAccountName, ChargeableRate, UseDescriptionOnSales, TaxCodeID, TaxCodeCode. All the other columns and operators are processed client side.

SELECT * FROM Activities WHERE ID = REPLACE
SELECT * FROM Activities WHERE Description = "criteria"
SELECT * FROM Activities WHERE DisplayID = "criteria"

Insert

The following attributes are required when performing an insert: DisplayID, IncomeAccountID, TaxCodeID, Type, Status.

INSERT INTO Activities(DisplayID, IncomeAccountID, TaxCodeID, Type, Status) values("test", "0b9b6098-1a9e-499d-bf41-b863a6daad9c", "2619bed9-3750-45b5-b353-18f5651beb01", "Hourly", "Chargeable"

Columns

Name Type ReadOnly Description
ID [KEY] Uuid True

Unique identifier in the form of a guid.

Description String False

Description of the object.

DisplayID String False

Display ID for the object.

IsActive Boolean False

True or false.

Name String False

Name of the object.

Status String False

Can consist of the following: Chargeable used to include on time billing invoices. NonChargeable used when not charging customers but still wanting to include on activity slip.

Type String False

Hourly or NonHourly.

UnitOfMeasurement String False

Hourly - If Type = Hourly then UnitOfMeasurement = Hour. NonHourly - specify the type of measurement

IncomeAccountID Uuid False

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

IncomeAccountDisplayID String True

Account code. Format includes separator ie 4-1100

IncomeAccountName String True

Name of the account.

IncomeAccountURI String True

Uniform resource identifier associated with the account object.

ChargeableRate String True

Rate which can consit of the following: EmployeeBillingRate - sourced from the employee contact card. CustomerBillingRate - sourced from the customer contact card. ActivityRate - entered on activity and is exclusive of tax.

UseDescriptionOnSales Boolean True

True or false.

TaxCodeID Uuid False

Unique guid identifier belonging to the assigned tax code.

TaxCodeCode String True

3 digit tax code.

TaxCodeURI String True

Uniform resource identifier associated with the tax code 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.

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