Tableau Connector for Sage Intacct

Build 21.0.7930

GLAccountBalance

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 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 Budgetable = '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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930