Tracks the balances of GL accounts, including details on transactions and period summaries, to aid in financial reporting and reconciliation.

Table Specific Information

To retrieve information from the GlAccountBalance table, Sage Intacct needs to have a Period to retrieve balances for. By default, CData Tableau Connector 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	Int64	Unique identifier for the GL account balance record.
Accountno	String	Account number associated with the GL account.
Accounttitle	String	Title or name of the GL account.
Departmentid	String	Identifier for the department associated with this account balance.
Locationid	String	Identifier for the location associated with this account balance.
Bookid	String	Identifier for the book associated with this account balance.
Currency	String	Currency used for the GL account balance.
Period	String	Accounting period for this GL account balance.
Openbal	Double	Opening balance for the GL account in the specified period.
Totdebit	Double	Total debit transactions for the GL account in the specified period.
Totcredit	Double	Total credit transactions for the GL account in the specified period.
Totadjdebit	Double	Total adjusted debit transactions for the GL account in the specified period.
Totadjcredit	Double	Total adjusted credit transactions for the GL account in the specified period.
Forbal	Double	Foreign balance for the GL account in the specified period.
Endbal	Double	Ending balance for the GL account in the specified period.
Projectdimkey	Int64	Key for the project dimension associated with the GL account balance.
Projectid	String	Identifier for the project associated with the GL account balance.
Projectname	String	Name of the project associated with the GL account balance.
Customerdimkey	Int64	Key for the customer dimension associated with the GL account balance.
Customerid	String	Identifier for the customer associated with the GL account balance.
Customername	String	Name of the customer associated with the GL account balance.
Vendordimkey	Int64	Key for the vendor dimension associated with the GL account balance.
Vendorid	String	Identifier for the vendor associated with the GL account balance.
Vendorname	String	Name of the vendor associated with the GL account balance.
Employeedimkey	Int64	Key for the employee dimension associated with the GL account balance.
Employeeid	String	Identifier for the employee associated with the GL account balance.
Employeename	String	Name of the employee associated with the GL account balance.
Itemdimkey	Int64	Key for the item dimension associated with the GL account balance.
Itemid	String	Identifier for the item associated with the GL account balance.
Itemname	String	Name of the item associated with the GL account balance.
Classdimkey	Int64	Key for the class dimension associated with the GL account balance.
Classid	String	Identifier for the class associated with the GL account balance.
Classname	String	Name of the class associated with the GL account balance.
Record_url	String	URL link to view the GL account balance record.