Retrieves GLAccountBalance report data.

Table Specific Information

To retrieve information from the GlAccountBalance table, Sage Intacct needs to have a Period to retrieve balances for. By default, CData JDBC Driver for Sage Intacct will automatically find all budgetable reports and run GLAccountBalance on each of them. In SQL, that means that:

SELECT * FROM GLAccountBalance

Is the same as this:

SELECT * FROM GLAccountBalance WHERE Period IN (SELECT Name FROM ReportingPeriod WHERE Budgeting = 'true')

Since this query can be slow if you have many reporting periods, it's recommended that you provide a specific Period name if you know which one you're interested in:

SELECT * FROM GLAccountBalance WHERE Period = 'Month Ended September 2011'

Columns

Name	Type	Description
Accountrec [KEY]	Int64	The Accountrec field of the GLAccountBalance object.
Accountno	String	The Accountno field of the GLAccountBalance object.
Accounttitle	String	The Accounttitle field of the GLAccountBalance object.
Departmentid	String	The Departmentid field of the GLAccountBalance object.
Locationid	String	The Locationid field of the GLAccountBalance object.
Bookid	String	The Bookid field of the GLAccountBalance object.
Currency	String	The Currency field of the GLAccountBalance object.
Period	String	The Period field of the GLAccountBalance object.
Openbal	Double	The Openbal field of the GLAccountBalance object.
Totdebit	Double	The Totdebit field of the GLAccountBalance object.
Totcredit	Double	The Totcredit field of the GLAccountBalance object.
Totadjdebit	Double	The Totadjdebit field of the GLAccountBalance object.
Totadjcredit	Double	The Totadjcredit field of the GLAccountBalance object.
Forbal	Double	The Forbal field of the GLAccountBalance object.
Endbal	Double	The Endbal field of the GLAccountBalance object.
Projectdimkey	Int64	The Projectdimkey field of the GLAccountBalance object.
Projectid	String	The Projectid field of the GLAccountBalance object.
Projectname	String	The Projectname field of the GLAccountBalance object.
Customerdimkey	Int64	The Customerdimkey field of the GLAccountBalance object.
Customerid	String	The Customerid field of the GLAccountBalance object.
Customername	String	The Customername field of the GLAccountBalance object.
Vendordimkey	Int64	The Vendordimkey field of the GLAccountBalance object.
Vendorid	String	The Vendorid field of the GLAccountBalance object.
Vendorname	String	The Vendorname field of the GLAccountBalance object.
Employeedimkey	Int64	The Employeedimkey field of the GLAccountBalance object.
Employeeid	String	The Employeeid field of the GLAccountBalance object.
Employeename	String	The Employeename field of the GLAccountBalance object.
Itemdimkey	Int64	The Itemdimkey field of the GLAccountBalance object.
Itemid	String	The Itemid field of the GLAccountBalance object.
Itemname	String	The Itemname field of the GLAccountBalance object.
Classdimkey	Int64	The Classdimkey field of the GLAccountBalance object.
Classid	String	The Classid field of the GLAccountBalance object.
Classname	String	The Classname field of the GLAccountBalance object.
Record_url	String	The Record_url field of the GLAccountBalance object.