JDBC Driver for Sage Intacct

Build 24.0.9062

AccountBalance

View containing detailed account balance data.

Columns

Name Type Description
Glaccountno Double The Glaccountno field of the AccountBalance object.
StartBalance Double The StartBalance field of the AccountBalance object.
Debits Double The Debits field of the AccountBalance object.
Credits Double The Credits field of the AccountBalance object.
AdjDebits Double The AdjDebits field of the AccountBalance object.
AdjCredits Double The AdjCredits field of the AccountBalance object.
EndBalance Double The EndBalance field of the AccountBalance object.
ReportingBook String The ReportingBook field of the AccountBalance object.
Currency String The Currency field of the AccountBalance object.

Pseudo-Columns

Name Type Description
StartDate String Required if not using reportingperiodname
EndDate String Required if not using reportingperiodname
StartAccountNo String Required if not using reportingperiodname
EndAccountNo String Required if not using reportingperiodname
ShowZeroBalances String Return zero balances

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062