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 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, 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 | References | 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 |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |