JDBC Driver for MYOB

Build 22.0.8462

TransferringTransactions

Return, update, create and delete transfer money transactions 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, Amount, TransferNumber, Memo, Date, ToAccountID, ToAccountDisplayID, ToAccountName, FromAccountID, FromAccountDisplayID, FromAccountName, CategoryID, CategoryDisplayID, CategoryName. All the other columns and operators are processed client side.

SELECT * FROM TransferringTransactions WHERE ID = "bfaade84-1adf-4e2d-acfd-629e95d09de7"
SELECT * FROM TransferringTransactions WHERE Amount = 3300
SELECT * FROM TransferringTransactions WHERE TransferNumber = "TR000007" OR TransferNumber = "TR000008"

Insert

The following attributes are required when performing an insert: Date, Amount, ToAccountID, FromAccountID.

INSERT INTO TransferringTransactions(Date, Amount, ToAccountID, FromAccountID) VALUES ("01/01/2019", 6700.0, "446d2226-254b-4821-acc2-7031842e0166", "9421b774-20fa-4c5f-bced-fbb6ecd42ebd")

Columns

Name Type ReadOnly Description
ID [KEY] Uuid True

Unique identifier in the form of a guid.

Amount Double False

Amount to be allocated to the account, must be non zero.

TransferNumber String False

ID No of payment transaction, if left blank on POST will auto increment based upon last recorded #.

Memo String False

Memo text describing the transfer money transaction.

Date Datetime False

Transaction date entry.

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.

URI String True

Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.

ToAccountID Uuid False

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

ToAccountDisplayID String True

Account code. Format includes separator ie 4-1100

ToAccountName String True

Name of the account.

ToAccountURI String True

Uniform resource identifier associated with the account object.

FromAccountID Uuid False

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

FromAccountDisplayID String True

Account code. Format includes separator ie 4-1100

FromAccountName String True

Name of the account.

FromAccountURI String True

Uniform resource identifier associated with the account object.

CategoryID Uuid True

Unique category identifier in the form of a guid.

CategoryDisplayID String True

Display id for the category.

CategoryName String True

Name of the category.

CategoryURI String True

Uniform resource identifier associated with the category object.

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