MuleSoft Connector for Sage Business Cloud Accounting

Build 21.0.8011

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

LedgerAccounts.Id

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.8011