JournalCodes
Query JournalCodes in Sage Business Cloud Accounting.
Table Specific Information
Query the available JournalCodes
Select
The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince column. The driver processes other filters client-side within the driver.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM JournalCodes WHERE UpdatedOrCreatedSince = '2018-12-15'
Update
Updates are performed based on Id.
UPDATE JournalCodes SET Name = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the JournalCodes to delete it.
DELETE FROM JournalCodes WHERE id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the item | |
| CreatedAt | Datetime | True |
The datetime when the item was created | |
| DisplayedAs | String | False |
The name of the resource | |
| Name | String | False |
The name of the journal code | |
| Code | String | False |
The code of the journal code | |
| Reserved | Bool | False |
Indicates whether the journal code is reserved | |
| UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
| LegacyId | Int | False |
The legacy ID for the item | |
| ControlName | String | False |
The control name of the journal code |