Sage Intacct
SourceUse Dataddo's Sage Intacct connector to explore any data available via the official API of Sage Intacct. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.
Explore Data You Can Extract from Sage Intacct
Data Category
- All Attributes (298)
- Company And Console Departments (17)
- Company And Console Location (44)
- General Ledger Account Balance (45)
- General Ledger Budget (74)
- General Ledger Detail (83)
- General Ledger Journal Entries (35)
Need fields you don't see?
Let us know and we'll add them to the connector. Just send a request here..
Available Attributes (298)
| Attribute |
|---|
DEPARTMENTID Department ID |
RECORDNO Record Number |
TITLE Title |
MANAGER.EMPLOYEEID Manager Employee ID |
PARENTID Parent ID |
PARENTNAME sensitive Parent Name |
SUPERVISORKEY Supervisor Key |
SUPERVISORID Supervisor ID |
WHENCREATED When Created |
WHENMODIFIED When Modified |
SUPERVISORNAME sensitive Supervisor Name |
STATUS Status |
CUSTTITLE Custom Title |
CREATEDBY sensitive Created By |
MODIFIEDBY sensitive Modified By |
IS_ROLLUP_DEPARTMENT_GROUPING Is Rollup Department Grouping |
RECORD_URL Record URL |
LOCATIONID Location ID |
RECORDNO Record Number |
NAME Name |
PARENTID Parent ID |
SUPERVISORNAME sensitive Supervisor Name |
STARTDATE Start Date |
ENDDATE End Date |
STATUS Status |
WHENCREATED When Created |
WHENMODIFIED When Modified |
FEDERALID Federal ID |
FIRSTMONTH First Month |
WEEKSTART Week Start |
MESSAGE_TEXT Message Text |
MARKETING_TEXT Marketing Text |
FOOTNOTETEXT Footnote Text |
REPORTPRINTAS Report Print As |
ISROOT Is Root |
RESERVEAMT Reserve Amount |
VENDORNAME sensitive Vendor Name |
VENDORID Vendor ID |
CUSTOMERID Customer ID |
CUSTOMERNAME sensitive Customer Name |
CURRENCY Currency |
ENTITY Entity |
ENTITYRECORDNO Entity Record Number |
HAS_IE_RELATION Has IE Relation |
CUSTTITLE Custom Title |
BUSINESSDAYS Business Days |
WEEKENDS Weekends |
FIRSTMONTHTAX First Month Tax |
CONTACTKEY Contact Key |
SUPERVISORKEY Supervisor Key |
PARENTKEY Parent Key |
SHIPTOKEY Ship To Key |
IEPAYABLEACCTKEY IE Payable Account Key |
IERECEIVABLEACCTKEY IE Receivable Account Key |
VENDENTITY Vendor Entity |
CUSTENTITY Customer Entity |
TAXID Tax ID |
SIRET SIRET |
CREATEDBY sensitive Created By |
MODIFIEDBY sensitive Modified By |
ADDRESSCOUNTRYDEFAULT sensitive Address Country Default |
CLASSDIMKEY Class Dimension Key |
ACCOUNTNO Account Number |
EMPLOYEEID Employee ID |
LOCATIONNO Location Number |
EMPLOYEENAME sensitive Employee Name |
PERIOD Period |
DEPARTMENTTITLE Department Title |
CLASSID Class ID |
ITEMDIMKEY Item Dimension Key |
LOCATIONDIMKEY Location Dimension Key |
WHENCREATED When Created |
TOTADJCREDIT Total Adjusted Credit |
FORBAL For Balance |
EMPLOYEEDIMKEY Employee Dimension Key |
ACCOUNTTITLE Account Title |
WAREHOUSEID Warehouse ID |
WAREHOUSENAME Warehouse Name |
CURRENCY Currency |
TOTADJDEBIT Total Adjusted Debit |
VENDORID Vendor ID |
PROJECTDIMKEY Project Dimension Key |
TOTDEBIT Total Debit |
ITEMID Item ID |
CUSTOMERDIMKEY Customer Dimension Key |
LOCATIONNAME Location Name |
VENDORDIMKEY Vendor Dimension Key |
PROJECTID Project ID |
BOOKID Book ID |
OPENBAL Open Balance |
ACCOUNTREC Account Rec |
MODIFIEDBY sensitive Modified By |
PROJECTNAME sensitive Project Name |
CREATEDBY sensitive Created By |
DEPARTMENTID Department ID |
ITEMNAME Item Name |
ENDBAL End Balance |
LOCATIONID Location ID |
TOTCREDIT Total Credit |
CUSTOMERID Customer ID |
CUSTOMERNAME sensitive Customer Name |
VENDORNAME sensitive Vendor Name |
DEPARTMENTDIMKEY Department Dimension Key |
WHENMODIFIED When Modified |
WAREHOUSEDIMKEY Warehouse Dimension Key |
CLASSNAME Class Name |
RECORDNO Record Number |
BUDGETID Budget ID |
DESCRIPTION Description |
SYSTEMGENERATED System Generated |
DEFAULT_BUDGET Default Budget |
MODIFIED Modified |
USER User |
STATUS Status |
MEGALOCATIONID Mega Location ID |
MEGADEPARTMENTID Mega Department ID |
WHENCREATED When Created |
WHENMODIFIED When Modified |
CREATEDBY sensitive Created By |
MODIFIEDBY sensitive Modified By |
ISCONSOLIDATED Is Consolidated |
CURRENCY Currency |
ISPABUDGET Is PA Budget |
ISPCNBUDGET Is PCN Budget |
MEGAENTITYKEY Mega Entity Key |
MEGAENTITYID Mega Entity ID |
MEGAENTITYNAME Mega Entity Name |
EXTERNALID External ID |
GLITEM_RECORDNO GL Item Record Number |
GLITEM_BUDGETKEY GL Item Budget Key |
GLITEM_BUDGETID GL Item Budget ID |
GLITEM_CURRENCY GL Item Currency |
GLITEM_SYSTEMGENERATED GL Item System Generated |
GLITEM_PERIODKEY GL Item Period Key |
GLITEM_ACCOUNTKEY GL Item Account Key |
GLITEM_DEPTKEY GL Item Department Key |
GLITEM_LOCATIONKEY GL Item Location Key |
GLITEM_AMOUNT sensitive GL Item Amount |
GLITEM_BASEDON GL Item Based On |
GLITEM_GROWBY GL Item Grow By |
GLITEM_PERPERIOD GL Item Per Period |
GLITEM_NOTE GL Item Note |
GLITEM_GLACCOUNTNO GL Item GL Account No |
GLITEM_ACCT_NO GL Item Account No |
GLITEM_ACCOUNT_TYPE GL Item Account Type |
GLITEM_ACCTTITLE GL Item Account Title |
GLITEM_NORMALBALANCE GL Item Normal Balance |
GLITEM_STATISTICAL GL Item Statistical |
GLITEM_DEPARTMENTID GL Item Department ID |
GLITEM_DEPT_NO GL Item Department No |
GLITEM_DEPTITLE GL Item Department Title |
GLITEM_LOCATIONID GL Item Location ID |
GLITEM_LOCATION_NO GL Item Location No |
GLITEM_LOCATIONTITLE GL Item Location Title |
GLITEM_PERIODNAME GL Item Period Name |
GLITEM_REPORTINGPERIODNAME GL Item Reporting Period Name |
GLITEM_PSTARTDATE GL Item Start Date |
GLITEM_PENDDATE GL Item End Date |
GLITEM_MEGAENTITYKEY GL Item Mega Entity Key |
GLITEM_MEGAENTITYID GL Item Mega Entity ID |
GLITEM_MEGAENTITYNAME GL Item Mega Entity Name |
GLITEM_CUSTOMERDIMKEY GL Item Customer Dimension Key |
GLITEM_CUSTOMERID GL Item Customer ID |
GLITEM_CUSTOMERNAME GL Item Customer Name |
GLITEM_VENDORDIMKEY GL Item Vendor Dimension Key |
GLITEM_VENDORID GL Item Vendor ID |
GLITEM_VENDORNAME GL Item Vendor Name |
GLITEM_EMPLOYEEDIMKEY GL Item Employee Dimension Key |
GLITEM_EMPLOYEEID GL Item Employee ID |
GLITEM_EMPLOYEENAME sensitive GL Item Employee Name |
GLITEM_ITEMDIMKEY GL Item Item Dimension Key |
GLITEM_ITEMID GL Item Item ID |
GLITEM_ITEMNAME GL Item Item Name |
GLITEM_CLASSDIMKEY GL Item Class Dimension Key |
GLITEM_CLASSID GL Item Class ID |
GLITEM_CLASSNAME GL Item Class Name |
GLITEM_PROJECTDIMKEY GL Item Project Dimension Key |
GLITEM_PROJECTID GL Item Project ID |
GLITEM_PROJECTNAME sensitive GL Item Project Name |
GLITEM_EXTERNALID GL Item External ID |
CREATEDBY sensitive Created By |
VENDORID Vendor ID |
TOTALDUE sensitive Total Due |
SYMBOL Symbol |
CUSTENTITY Customer Entity |
ITEMDIMKEY Item Dimension Key |
RECORDTYPE Record Type |
LOCATIONNAME Location Name |
TOTALENTERED Total Entered |
TRX_CREDITAMOUNT sensitive Transaction Credit Amount |
ITEMID Item ID |
RECORDID Record ID |
CUSTOMERDIMKEY Customer Dimension Key |
STATE State |
BATCH_STATE Batch State |
CURRENCY Currency |
EMPLOYEEID Employee ID |
BATCH_DATE Batch Date |
ACCOUNTTITLE Account Title |
CREDITAMOUNT sensitive Credit Amount |
VENDORNAME sensitive Vendor Name |
RECORDNO Record Number |
VENDORDIMKEY Vendor Dimension Key |
WHENCREATED When Created |
DOCUMENT Document |
TRX_DEBITAMOUNT sensitive Transaction Debit Amount |
CUSTOMERNAME Customer Name |
ACCOUNTNO Account Number |
ADJ Adjustment |
WHENMODIFIED When Modified |
DESCRIPTION Description |
PRCLEARED Payment Cleared |
BATCHKEY Batch Key |
WHENPAID When Paid |
TOTALPAID sensitive Total Paid |
ITEMNAME Item Name |
MODULEKEY Module Key |
EMPENTITY Employee Entity |
WAREHOUSENAME Warehouse Name |
CLEARED Cleared |
AMOUNT sensitive Amount |
MODIFIEDBY sensitive Modified By |
LINE_NO Line Number |
PROJECTID Project ID |
VENDENTITY Vendor Entity |
DEPARTMENTID Department ID |
STATISTICAL Statistical |
PRCLRDATE Payment Clear Date |
LOCATIONID Location ID |
ENTRYDESCRIPTION Entry Description |
BATCH_TITLE Batch Title |
EMPLOYEENAME sensitive Employee Name |
LOCENTITY Location Entity |
CLASSNAME Class Name |
DEBITAMOUNT sensitive Debit Amount |
PROJECTDIMKEY Project Dimension Key |
MODIFIED Modified |
ENTRY_STATE Entry State |
REFERENCENO Reference Number |
AUWHENCREATED AU When Created |
BOOKID Book ID |
WAREHOUSEDIMKEY Warehouse Dimension Key |
WHENDUE When Due |
TR_TYPE Transaction Type |
WAREHOUSEID Warehouse ID |
CLRDATE Clear Date |
CLASSID Class ID |
FINANCIALENTITY Financial Entity |
BASECURR Base Currency |
BATCH_NO Batch Number |
CHILDENTITY Child Entity |
GLENTRYKEY GL Entry Key |
DOCNUMBER Document Number |
CUSTOMERID Customer ID |
PROJECTNAME sensitive Project Name |
PRDESCRIPTION Payment Request Description |
OWNERSHIPKEY Ownership Key |
TRX_AMOUNT sensitive Transaction Amount |
EMPLOYEEDIMKEY Employee Dimension Key |
AUCREATEDBY sensitive AU Created By |
DEPARTMENTTITLE Department Title |
ENTRY_DATE Entry Date |
CLASSDIMKEY Class Dimension Key |
RECORDNO Record Number |
BATCH_TITLE Batch Title |
BATCHNO Batch Number |
BALANCE sensitive Balance |
JOURNAL Journal |
BATCH_DATE Batch Date |
MODULE Module |
USERKEY User Key |
REFERENCENO Reference Number |
REVERSED Reversed |
REVERSEDKEY Reversed Key |
REVERSEDFROM Reversed From |
TEMPLATEKEY Template Key |
PRBATCHKEY PR Batch Key |
MODIFIED Modified |
MODIFIEDBYID Modified By ID |
SCHOPKEY SCHOP Key |
GLACCTALLOCATIONRUNKEY GL Account Allocation Run Key |
BASELOCATION Base Location |
BASELOCATION_NO Base Location Number |
WHENCREATED When Created |
WHENMODIFIED When Modified |
CREATEDBY sensitive Created By |
MODIFIEDBY sensitive Modified By |
STATE State |
JOURNALSEQNO Journal Sequence Number |
TAXIMPLICATIONS Tax Implications |
VATVENDORID VAT Vendor ID |
VATCUSTOMERID VAT Customer ID |
VATCONTACTID VAT Contact ID |
TAXSOLUTIONID Tax Solution ID |
MEGAENTITYKEY Mega Entity Key |
MEGAENTITYID Mega Entity ID |
MEGAENTITYNAME Mega Entity Name |
RECORD_URL Record URL |
Pricing
See all Dataddo plans
Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.
View pricingWhy Dataddo?
One Ingestion Layer for SaaS, Databases, and Files
Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.
Built for Cloud and On-Premise Environments
Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.
Full API Control - No UI Required
Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.
Managed Ingestion Operations. We Own the Reliability.
Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.
Full Visibility Into Every Data Flow
Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.
The Data Foundation Your AI Needs
Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.
See What Other Organizations Have Achieved with Dataddo
3x
Faster
data
collection
1
FTE saved
full-time equivalent
saved
50+
man-hours
per week saved
on data collection
Our Customers Love Us
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”
Andrew Hart
Chief Operations Officer
Sat 7
“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo opens up gates and takes away the hurdles of working with data.”
Laurent Partouche
CPO
FoodChéri & Seazon
“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”
Natheer Maloon
Technology Solutions Manager
Boldr
“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”
Greg Senior
Business Operations Manager
Farm Focus
“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”