Tableau Connector for Sage Intacct

Build 25.0.9434

TrialBalancesLocationDetail

Offers a location-based trial balance view, itemizing financial data and enabling site-specific financial oversight.

Columns

Name Type Description
reportingperiodname String The name of the reporting period for which the trial balance is generated.
glaccountno String The general ledger account number associated with the trial balance entry.
startbalance Double The opening balance for the specified account and period.
debits Double The total debits recorded for the account during the specified period.
credits Double The total credits recorded for the account during the specified period.
adjdebits Double The total adjusted debits for the account in the specified period.
adjcredits Double The total adjusted credits for the account in the specified period.
endbalance Double The closing balance for the specified account and period.
reportingbook String The financial reporting book used for generating the trial balance.
currency String The currency in which the trial balance amounts are reported.
locationid String The identifier for the location associated with the trial balance data.
departmentid String The identifier for the department associated with the trial balance data.

Pseudo-Columns

Name Type Description
StartDate String Specifies the start date for the trial balance data, required if ReportingPeriodName is not set.
EndDate String Specifies the end date for the trial balance data, required if ReportingPeriodName is not set.
ShowZeroBalances String Indicates whether to include accounts with zero balances in the report. Use true or false. (Default: false)
ShowDepartmentDetail String Indicates whether to expand the trial balance data to show department-specific details. Use true or false. (Default: false)
ShowLocationDetail String Indicates whether to expand the trial balance data to show location-specific details. Use true or false. (Default: true)

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