TrialBalances
Retrieves TrialBalances data.
Table Specific Information
To retrieve LocationID and DepartmentId information from the TrialBalances table, Sage Intacct needs to have ShowLocationDetail and ShowDepartmentDetail set to true. In SQL, that means that:
select * from trialbalances where ShowLocationDetail=true and ShowDepartmentDetail=true
Columns
| Name | Type | Description |
| Reportingperiodname | String | The Reportingperiodname field of the TrialBalances object. |
| Glaccountno | String | The Glaccountno field of the TrialBalances object. |
| Startbalance | Double | The Startbalance field of the TrialBalances object. |
| Debits | Double | The Debits field of the TrialBalances object. |
| Credits | Double | The Credits field of the TrialBalances object. |
| Adjdebits | Double | The Adjdebits field of the TrialBalances object. |
| Adjcredits | Double | The Adjcredits field of the TrialBalances object. |
| Endbalance | Double | The Endbalance field of the TrialBalances object. |
| Reportingbook | String | The Reportingbook field of the TrialBalances object. |
| Currency | String | The Currency field of the TrialBalances object. |
| Locationid | String | The Locationid field of the TrialBalances object. |
| Departmentid | String | The Departmentid field of the TrialBalances object. |
Pseudo-Columns
| Name | Type | Description |
| StartDate | String | Required if ReportingPeriodName is not set. |
| EndDate | String | Required if ReportingPeriodName is not set. |
| ShowZeroBalances | String | Show zero balance accounts. Use true or false. (Default: false) |
| ShowDepartmentDetail | String | Expand department detail. Use true or false. (Default: false) |
| ShowLocationDetail | String | Expand location detail. Use true or false. (Default: false) |