JournalTransactions
Usage information for the operation JournalTransactions.rsd.
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, DisplayID, Description, DateOccurred, DatePosted, JournalType, SourceTransactionID, SourceTransactionTransactionType. All the other columns and operators are processed client side.
SELECT * FROM JournalTransactions WHERE ID = "7cabea25-6250-4df5-bb37-77eb2d38f803" SELECT * FROM JournalTransactions WHERE Description = "description" AND SourceTransactionTransactionType = "type"
Columns
Name | Type | Description |
ID [KEY] | Uuid | |
DisplayID | String | |
Description | String | |
DateOccurred | Datetime | |
DatePosted | Datetime | |
JournalType | String | |
RowVersion | String | |
SourceTransactionID | Uuid | |
SourceTransactionTransactionType | String | |
SourceTransactionURI | String | |
URI | String | |
CompanyFileId | String | The ID of the company file. Takes precedence over the CompanyFileId connection property. |