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 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, 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 | References | 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 |
Accounts.ID |
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 |
Accounts.ID |
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. |