TrialBalance
Query a monthly Trial Balance.
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. |