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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Date | Datetime | As at date. |
| PaymentsOnly | Boolean | Set this to true to get cash transactions only. |