CData Python Connector for Sage Intacct

Build 25.0.9454

TrialBalancesDepartmentDetail

Breaks down trial balances by department, showing account-level debits, credits, and adjustments for departmental analysis.

Columns

Name Type Description
reportingperiodname String The reporting period name for the trial balance data.
glaccountno String The general ledger account number associated with the trial balance data.
startbalance Double The starting balance for the trial balance period.
debits Double The total debits recorded for the trial balance period.
credits Double The total credits recorded for the trial balance period.
adjdebits Double The total adjustments to debits for the trial balance period.
adjcredits Double The total adjustments to credits for the trial balance period.
endbalance Double The ending balance for the trial balance period.
reportingbook String The reporting book associated with the trial balance.
currency String The currency used for the trial balance.
locationid String The location identifier for the trial balance.
departmentid String The department identifier for the trial balance.

Pseudo-Columns

Name Type Description
StartDate String The start date for the trial balance report, required if ReportingPeriodName is not set.
EndDate String The end date for the trial balance report, 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: true)
ShowLocationDetail String Expand location detail. Use true or false. (Default: false)

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454