JournalLine
Query JournalLine in Sage Business Cloud Accounting.
Table Specific Information
Query the available JournalLine
Select
The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.
- UpdatedOrCreatedSince supports the '=' operator.
- DeletedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM JournalLine WHERE UpdatedOrCreatedSince = '2018-12-15' SELECT * FROM JournalLine WHERE DeletedSince = '2018-12-15'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the item | |
| Details | String | A description of the journal line | |
| Cleared | Bool | Indicates if the journal line is cleared or not. | |
| Credit | String | The credit amount of the journal line | |
| BankReconciled | Bool | Indicates if the journal line is bank reconciled or not. | |
| LedgerAccountId | String | The unique identifier for the item | |
| IncludeOnTaxReturn | Bool | Indicates whether the journal line should affect the tax return | |
| TaxReconciled | Bool | Indicates if the journal line is tax reconciled or not. | |
| Debit | String | The debit amount of the journal line | |
| JournalsId [KEY] | String | Parent ID | |
| DeletedSince | Datetime |