TrialBalance

Columns

Name	Type	Description
ID [KEY]	Integer	The row number.
Account	String	Account name.
Debit	String	Debit trial balance for current month up to the date specified.
Credit	String	Credit trial balance for current month up to the date specified.
YTDDebit	String	Year to Date Debit.
YTDCredit	String	Year to Date Credit.
AccountId	String	Account ID
TenantId	String	The ID of the tenant to query instead of the connection tenant

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Date	Datetime	As at date.
PaymentsOnly	Boolean	Set this to true to get cash transactions only.