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.

JDBC Driver for MYOB

TransferringTransactions

Table Specific Information

Select

Insert

Columns