BalanceSheet
Query a monthly Balance Sheet.
Columns
| Name | Type | Description |
| ID [KEY] | Integer | The row number. |
| Label1 | String | The Label column of the BalanceSheet report. |
| Label2 | String | The Value column of the BalanceSheet report. |
| Label3 | String | The Label column of the BalanceSheet report. |
| Label4 | String | The Value column of the BalanceSheet report. |
| Label5 | String | The Label column of the BalanceSheet report. |
| Label6 | String | The Value column of the BalanceSheet report. |
| Label7 | String | The Label column of the BalanceSheet report. |
| Label8 | String | The Value column of the BalanceSheet report. |
| Label9 | String | The Label column of the BalanceSheet report. |
| Label10 | String | The Value column of the BalanceSheet report. |
| Label11 | String | The Label column of the BalanceSheet report. |
| Label12 | String | The Value column of the BalanceSheet report. |
| Label13 | String | The Value column of the BalanceSheet report. |
| AccountId | String | The ID of the row's account from the BalanceSheet report. |
| 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. |
| Periods | Int | The number of periods to go back from ToDate. |
| Timeframe | String | How big each period should be (MONTH, QUARTER or YEAR) |
| TrackingOptionID1 | String | Show all payable invoices to this date for the contact. |
| TrackingOptionID2 | String | Show all payable invoices to this date for the contact. |
| PaymentsOnly | Boolean | Set this to true to get cash transactions only. |
| StandardLayout | Boolean | If you set this parameter to true then no custom report layouts will be applied to response. |