Connectors
Sage Intacct
Connectors
Sage Intacct
Description
Sage Intacct is a financial management software.
Connector Details
| Name | Value |
|---|---|
| Platform | Sage Intacct |
| Auth Type | API Keys |
| Direction | Bidirectional |
| Unified Schema | Supported in Accounting Unified Schema |
Supported Data
See the table below for the list of data you can read with the Sage Intacct connector.
| Table Name | Fields |
|---|---|
| accounts_payable_bills | RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, FINANCIALENTITY, STATE, RAWSTATE, VENDORID, VENDORNAME, FORM1099TYPE, FORM1099BOX, VENDTYPE1099TYPE, TRX_ENTITYDUE, DOCNUMBER, DESCRIPTION, DESCRIPTION2, TERMNAME, TERMKEY, TERMVALUE, WHENCREATED, WHENPOSTED, WHENDISCOUNT, WHENDUE, WHENPAID, RECPAYMENTDATE, PAYMENTPRIORITY, ONHOLD, BASECURR, CURRENCY, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, TOTALENTERED, TOTALSELECTED, TOTALPAID, TOTALDUE, TRX_TOTALENTERED, TRX_TOTALSELECTED, TRX_TOTALPAID, TRX_TOTALDUE, BILLTOPAYTOCONTACTNAME, SHIPTORETURNTOCONTACTNAME, BILLTOPAYTOKEY, SHIPTORETURNTOKEY, PRBATCH, PRBATCHKEY, MODULEKEY, SCHOPKEY, SYSTEMGENERATED, AUWHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, DUE_IN_DAYS, PAYTO.TAXGROUP.NAME, PAYTO.TAXGROUP.RECORDNO, PAYTO.TAXID, INCLUSIVETAX, TAXSOLUTIONID, RETAINAGEPERCENTAGE, TRX_TOTALRETAINED, TRX_TOTALRELEASED, TOTALRETAINED, SUPDOCID, BILLBACKTEMPLATE, USERID, CREATEDUSERID, DOCSOURCE, UPLOADSTATUS, RECIPIENTEMAIL, SENDEREMAIL, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, VENDOR_NOTES, VOUCHER_NUMBER, RECORD_URL |
| accounts_payable_vendors | RECORDNO, VENDORID, NAME, NAME1099, PARENTKEY, PARENTID, PARENTNAME, DISPLAYCONTACT.CONTACTNAME, DISPLAYCONTACT.COMPANYNAME, DISPLAYCONTACT.PREFIX, DISPLAYCONTACT.FIRSTNAME, DISPLAYCONTACT.LASTNAME, DISPLAYCONTACT.INITIAL, DISPLAYCONTACT.PRINTAS, DISPLAYCONTACT.TAXABLE, DISPLAYCONTACT.TAXGROUP, DISPLAYCONTACT.TAXSOLUTIONID, DISPLAYCONTACT.TAXSCHEDULE, DISPLAYCONTACT.TAXID, DISPLAYCONTACT.PHONE1, DISPLAYCONTACT.PHONE2, DISPLAYCONTACT.CELLPHONE, DISPLAYCONTACT.PAGER, DISPLAYCONTACT.FAX, DISPLAYCONTACT.TAXIDVALIDATIONDATE, DISPLAYCONTACT.GSTREGISTERED, DISPLAYCONTACT.TAXCOMPANYNAME, DISPLAYCONTACT.TAXADDRESS, DISPLAYCONTACT.EMAIL1, DISPLAYCONTACT.EMAIL2, DISPLAYCONTACT.URL1, DISPLAYCONTACT.URL2, DISPLAYCONTACT.VISIBLE, DISPLAYCONTACT.MAILADDRESS.ADDRESS1, DISPLAYCONTACT.MAILADDRESS.ADDRESS2, DISPLAYCONTACT.MAILADDRESS.CITY, DISPLAYCONTACT.MAILADDRESS.STATE, DISPLAYCONTACT.MAILADDRESS.ZIP, DISPLAYCONTACT.MAILADDRESS.COUNTRY, DISPLAYCONTACT.MAILADDRESS.COUNTRYCODE, DISPLAYCONTACT.MAILADDRESS.LATITUDE, DISPLAYCONTACT.MAILADDRESS.LONGITUDE, DISPLAYCONTACT.STATUS, ENTITY, TERMNAME, TERMVALUE, VENDORACCOUNTNO, TAXID, CREDITLIMIT, TOTALDUE, BILLINGTYPE, VENDTYPE, VENDTYPE1099TYPE, GLGROUP, PRICESCHEDULE, DISCOUNT, PRICELIST, COMMENTS, ACCOUNTLABEL, APACCOUNT, APACCOUNTTITLE, FORM1099TYPE, FORM1099BOX, PAYMENTPRIORITY, CONTACTINFO.CONTACTNAME, CONTACTINFO.PREFIX, CONTACTINFO.FIRSTNAME, CONTACTINFO.INITIAL, CONTACTINFO.LASTNAME, CONTACTINFO.COMPANYNAME, CONTACTINFO.PRINTAS, CONTACTINFO.PHONE1, CONTACTINFO.PHONE2, CONTACTINFO.CELLPHONE, CONTACTINFO.PAGER, CONTACTINFO.FAX, CONTACTINFO.EMAIL1, CONTACTINFO.EMAIL2, CONTACTINFO.URL1, CONTACTINFO.URL2, CONTACTINFO.VISIBLE, CONTACTINFO.MAILADDRESS.ADDRESS1, CONTACTINFO.MAILADDRESS.ADDRESS2, CONTACTINFO.MAILADDRESS.CITY, CONTACTINFO.MAILADDRESS.STATE, CONTACTINFO.MAILADDRESS.ZIP, CONTACTINFO.MAILADDRESS.COUNTRY, CONTACTINFO.MAILADDRESS.COUNTRYCODE, PAYTO.CONTACTNAME, PAYTO.PREFIX, PAYTO.FIRSTNAME, PAYTO.INITIAL, PAYTO.LASTNAME, PAYTO.COMPANYNAME, PAYTO.PRINTAS, PAYTO.PHONE1, PAYTO.PHONE2, PAYTO.CELLPHONE, PAYTO.PAGER, PAYTO.FAX, PAYTO.EMAIL1, PAYTO.EMAIL2, PAYTO.URL1, PAYTO.URL2, PAYTO.VISIBLE, PAYTO.MAILADDRESS.ADDRESS1, PAYTO.MAILADDRESS.ADDRESS2, PAYTO.MAILADDRESS.CITY, PAYTO.MAILADDRESS.STATE, PAYTO.MAILADDRESS.ZIP, PAYTO.MAILADDRESS.COUNTRY, PAYTO.MAILADDRESS.COUNTRYCODE, PAYTO.TAXGROUP, PAYTO.TAXSOLUTIONID, PAYTO.TAXSCHEDULE, PAYTO.TAXID, RETURNTO.CONTACTNAME, RETURNTO.PREFIX, RETURNTO.FIRSTNAME, RETURNTO.INITIAL, RETURNTO.LASTNAME, RETURNTO.COMPANYNAME, RETURNTO.PRINTAS, RETURNTO.PHONE1, RETURNTO.PHONE2, RETURNTO.CELLPHONE, RETURNTO.PAGER, RETURNTO.FAX, RETURNTO.EMAIL1, RETURNTO.EMAIL2, RETURNTO.URL1, RETURNTO.URL2, RETURNTO.VISIBLE, RETURNTO.MAILADDRESS.ADDRESS1, RETURNTO.MAILADDRESS.ADDRESS2, RETURNTO.MAILADDRESS.CITY, RETURNTO.MAILADDRESS.STATE, RETURNTO.MAILADDRESS.ZIP, RETURNTO.MAILADDRESS.COUNTRY, RETURNTO.MAILADDRESS.COUNTRYCODE, STATUS, PAYDATEVALUE, ONETIME, ONHOLD, WHENMODIFIED, ISOWNER, DONOTCUTCHECK, OWNER.EQGLACCOUNT, OWNER.EQGLACCOUNTLABEL, OWNER.HOLDDIST, OWNER.ACCOUNTLABEL.LABEL, CURRENCY, PYMTCOUNTRYCODE, FILEPAYMENTSERVICE, ACHENABLED, WIREENABLED, CHECKENABLED, ACHBANKROUTINGNUMBER, ACHACCOUNTNUMBER, ACHACCOUNTTYPE, ACHREMITTANCETYPE, WIREBANKNAME, WIREBANKROUTINGNUMBER, WIREACCOUNTNUMBER, WIREACCOUNTTYPE, PMPLUSREMITTANCETYPE, PMPLUSEMAIL, PMPLUSFAX, DISPLAYTERMDISCOUNT, OEPRCLSTKEY, DISPLOCACCTNOCHECK, WHENCREATED, CREATEDBY, MODIFIEDBY, PAYMENTNOTIFY, PAYMETHODKEY, OBJECTRESTRICTION, MERGEPAYMENTREQ, DISPLAYCONTACTKEY, PRIMARYCONTACTKEY, PAYTOKEY, RETURNTOKEY, ACCOUNTLABELKEY, ACCOUNTKEY, VENDTYPEKEY, GLGRPKEY, TERMSKEY, VENDORACCTNOKEY, PAYMETHODREC, OUTSOURCECHECK, OUTSOURCECHECKSTATE, OUTSOURCEACH, OUTSOURCEACHSTATE, OUTSOURCECARD, OUTSOURCECARDOVERRIDE, CARDSTATE, VENDORACHACCOUNTID, VENDORACCOUNTOUTSOURCEACH, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTNOTITLE, CONTACTTO1099.CONTACTNAME, CONTACTTO1099.PREFIX, CONTACTTO1099.FIRSTNAME, CONTACTTO1099.INITIAL, CONTACTTO1099.LASTNAME, CONTACTTO1099.COMPANYNAME, CONTACTTO1099.PRINTAS, CONTACTTO1099.PHONE1, CONTACTTO1099.PHONE2, CONTACTTO1099.CELLPHONE, CONTACTTO1099.PAGER, CONTACTTO1099.FAX, CONTACTTO1099.EMAIL1, CONTACTTO1099.EMAIL2, CONTACTTO1099.URL1, CONTACTTO1099.URL2, CONTACTTO1099.VISIBLE, CONTACTTO1099.MAILADDRESS.ADDRESS1, CONTACTTO1099.MAILADDRESS.ADDRESS2, CONTACTTO1099.MAILADDRESS.CITY, CONTACTTO1099.MAILADDRESS.STATE, CONTACTTO1099.MAILADDRESS.ZIP, CONTACTTO1099.MAILADDRESS.COUNTRY, CONTACTTO1099.MAILADDRESS.COUNTRYCODE, CONTACTKEY1099, SUPDOCID, VENDOR_AMEX_ORGANIZATION_ID, VENDOR_AMEX_ORG_ADDRESS_ID, VENDOR_AMEX_CD_AFFILIATE_ID, VENDOR_AMEX_CARD_AFFILIATE_ID, AMEX_BANK_ACCOUNT_ID, AMEX_BANK_ACCOUNT_ADDRESS_ID, DEFAULT_LEAD_TIME, RETAINAGEPERCENTAGE, ISINDIVIDUAL, PROVIDERSTATUS, WHENLASTBILLED, WHENLASTPAID, PROVIDERMISMATCH, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, RECORD_URL |
| general_ledger_accounts | RECORDNO, ACCOUNTNO, TITLE, ACCOUNTTYPE, NORMALBALANCE, CLOSINGTYPE, CLOSINGACCOUNTNO, CLOSINGACCOUNTTITLE, STATUS, REQUIREDEPT, REQUIRELOC, TAXABLE, CATEGORYKEY, CATEGORY, TAXCODE, MRCCODE, CLOSETOACCTKEY, ALTERNATIVEACCOUNT, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, SUBLEDGERCONTROLON, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, REQUIREPROJECT, REQUIRECUSTOMER, REQUIREVENDOR, REQUIREEMPLOYEE, REQUIREITEM, REQUIRECLASS, REQUIREGLDIMUSER_DEFINED_DIMENSION, RECORD_URL |
| general_ledger_details | RECORDNO, BATCHKEY, BATCH_DATE, BATCH_TITLE, SYMBOL, BATCH_NO, BOOKID, CHILDENTITY, MODIFIED, REFERENCENO, ADJ, MODULEKEY, OWNERSHIPKEY, LINE_NO, ENTRY_DATE, TR_TYPE, DOCUMENT, ACCOUNTNO, ACCOUNTTITLE, STATISTICAL, DEPARTMENTID, DEPARTMENTTITLE, LOCATIONID, LOCATIONNAME, CURRENCY, BASECURR, DESCRIPTION, DEBITAMOUNT, CREDITAMOUNT, AMOUNT, TRX_DEBITAMOUNT, TRX_CREDITAMOUNT, TRX_AMOUNT, CLEARED, CLRDATE, CUSTENTITY, VENDENTITY, EMPENTITY, LOCENTITY, RECORDTYPE, RECORDID, DOCNUMBER, STATE, WHENCREATED, WHENDUE, WHENPAID, WHENMODIFIED, PRDESCRIPTION, PRCLEARED, PRCLRDATE, FINANCIALENTITY, TOTALENTERED, TOTALPAID, TOTALDUE, ENTRYDESCRIPTION, GLENTRYKEY, CREATEDBY, BATCH_STATE, ENTRY_STATE, AUWHENCREATED, AUCREATEDBY, MODIFIEDBY, PROJECTDIMKEY, PROJECTID, PROJECTNAME, CUSTOMERDIMKEY, CUSTOMERID, CUSTOMERNAME, VENDORDIMKEY, VENDORID, VENDORNAME, EMPLOYEEDIMKEY, EMPLOYEEID, EMPLOYEENAME, ITEMDIMKEY, ITEMID, ITEMNAME, CLASSDIMKEY, CLASSID, CLASSNAME, GLDIMUSER_DEFINED_DIMENSION, RECORD_URL |
| general_ledger_journal_entries | RECORDNO, BATCHNO, BATCH_TITLE, BALANCE, JOURNAL, BATCH_DATE, MODULE, USERKEY, REFERENCENO, REVERSED, REVERSEDKEY, REVERSEDFROM, TEMPLATEKEY, PRBATCHKEY, MODIFIED, MODIFIEDBYID, SCHOPKEY, BASELOCATION, BASELOCATION_NO, USERINFO.LOGINID, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, STATE, JOURNALSEQNO, TAXIMPLICATIONS, VATVENDORID, VATCUSTOMERID, VATCONTACTID, TAXSOLUTIONID, TRANSACTIONSOURCE, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, RECORD_URL |
| general_ledger_journal_entry_lines | RECORDNO, BATCHNO, USERNO, LINE_NO, TR_TYPE, ENTRY_DATE, AMOUNT, TRX_AMOUNT, BATCH_NUMBER, BATCH_DATE, BATCHTITLE, ACCOUNTKEY, ACCOUNTNO, ACCOUNTTITLE, STATISTICAL, DEPARTMENTKEY, DEPARTMENT, DEPARTMENTTITLE, LOCATIONKEY, LOCATION, LOCATIONNAME, DOCUMENT, DESCRIPTION, UNITS, BASECURR, CURRENCY, CLEARED, CLRDATE, TIMEPERIOD, ADJ, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, RECON_DATE, ALLOCATION, ALLOCATIONKEY, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, STATE, BILLABLE, BILLED, GLDIMUSER_DEFINED_DIMENSION, PROJECTDIMKEY, PROJECTID, PROJECTNAME, CUSTOMERDIMKEY, CUSTOMERID, CUSTOMERNAME, VENDORDIMKEY, VENDORID, VENDORNAME, EMPLOYEEDIMKEY, EMPLOYEEID, EMPLOYEENAME, ITEMDIMKEY, ITEMID, ITEMNAME, CLASSDIMKEY, CLASSID, CLASSNAME, RECORD_URL |
| projects | RECORDNO, PROJECTID, NAME, DESCRIPTION, CURRENCY, PROJECTCATEGORY, PROJECTSTATUSKEY, PROJECTSTATUS, PREVENTTIMESHEET, PREVENTEXPENSE, PREVENTAPPO, PREVENTGENINVOICE, STATUS, BEGINDATE, ENDDATE, BUDGETAMOUNT, CONTRACTAMOUNT, ACTUALAMOUNT, BUDGETQTY, ESTQTY, ACTUALQTY, APPROVEDQTY, REMAININGQTY, PERCENTCOMPLETE, OBSPERCENTCOMPLETE, BILLINGTYPE, SONUMBER, PONUMBER, POAMOUNT, PQNUMBER, SFDCKEY, QARROWKEY, OAKEY, PARENTKEY, PARENTID, PARENTNAME, INVOICEWITHPARENT, CUSTOMERKEY, CUSTOMERID, CUSTOMERNAME, SALESCONTACTKEY, SALESCONTACTID, SALESCONTACTNAME, PROJECTTYPEKEY, PROJECTTYPE, MANAGERKEY, MANAGERID, MANAGERCONTACTNAME, PROJECTDEPTKEY, DEPARTMENTID, DEPARTMENTNAME, PROJECTLOCATIONKEY, LOCATIONID, LOCATIONNAME, CONTACTINFO.CONTACTNAME, SHIPTO.CONTACTNAME, BILLTO.CONTACTNAME, TERMSKEY, TERMNAME, DOCNUMBER, CUSTUSERKEY, CUSTUSERID, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, BUDGETEDCOST, CLASSID, CLASSNAME, CLASSKEY, USERRESTRICTIONS, BILLABLEEXPDEFAULT, BILLABLEAPPODEFAULT, BUDGETID, BUDGETKEY, BILLINGRATE, BILLINGPRICING, EXPENSERATE, EXPENSEPRICING, POAPRATE, POAPPRICING, CONTACTKEY, SHIPTOKEY, BILLTOKEY, INVOICEMESSAGE, INVOICECURRENCY, BILLINGOVERMAX, EXCLUDEEXPENSES, CONTRACTKEY, CONTRACTID, SUPDOCID, ROOTPARENTKEY, ROOTPARENTID, ROOTPARENTNAME, CFDA, FUNDEDNAME, AGENCY, PAYER, FUNDINGOTHERID, ASSISTANCETYPE, REVRESTRICTION, RESTRICTIONEXPIRY, RESTRICTIONEXPIRATIONDATE, TIMESATISFACTIONSCHEDULED, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, RECORD_URL |
| invoices | RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, STATE, RAWSTATE, CUSTOMERID, CUSTOMERNAME, CUSTEMAILOPTIN, TRX_ENTITYDUE, CUSTMESSAGEID, CUSTMESSAGE.MESSAGE, DELIVERY_OPTIONS, DOCNUMBER, DESCRIPTION, DESCRIPTION2, TERMNAME, TERMKEY, TERMVALUE, WHENCREATED, WHENPOSTED, WHENDISCOUNT, WHENDUE, WHENPAID, BASECURR, CURRENCY, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, TOTALENTERED, TOTALSELECTED, TOTALPAID, TOTALDUE, TRX_TOTALENTERED, TRX_TOTALSELECTED, TRX_TOTALPAID, TRX_TOTALDUE, BILLTOPAYTOCONTACTNAME, SHIPTORETURNTOCONTACTNAME, BILLTOPAYTOKEY, SHIPTORETURNTOKEY, CONTACT.CONTACTNAME, CONTACT.PREFIX, CONTACT.FIRSTNAME, CONTACT.INITIAL, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.PRINTAS, CONTACT.PHONE1, CONTACT.PHONE2, CONTACT.CELLPHONE, CONTACT.PAGER, CONTACT.FAX, CONTACT.EMAIL1, CONTACT.EMAIL2, CONTACT.URL1, CONTACT.URL2, CONTACT.VISIBLE, CONTACT.MAILADDRESS.ADDRESS1, CONTACT.MAILADDRESS.ADDRESS2, CONTACT.MAILADDRESS.CITY, CONTACT.MAILADDRESS.STATE, CONTACT.MAILADDRESS.ZIP, CONTACT.MAILADDRESS.COUNTRY, CONTACT.MAILADDRESS.COUNTRYCODE, SHIPTO.CONTACTNAME, SHIPTO.PREFIX, SHIPTO.FIRSTNAME, SHIPTO.INITIAL, SHIPTO.LASTNAME, SHIPTO.COMPANYNAME, SHIPTO.PRINTAS, SHIPTO.PHONE1, SHIPTO.PHONE2, SHIPTO.CELLPHONE, SHIPTO.PAGER, SHIPTO.FAX, SHIPTO.EMAIL1, SHIPTO.EMAIL2, SHIPTO.URL1, SHIPTO.URL2, SHIPTO.VISIBLE, SHIPTO.MAILADDRESS.ADDRESS1, SHIPTO.MAILADDRESS.ADDRESS2, SHIPTO.MAILADDRESS.CITY, SHIPTO.MAILADDRESS.STATE, SHIPTO.MAILADDRESS.ZIP, SHIPTO.MAILADDRESS.COUNTRY, SHIPTO.MAILADDRESS.COUNTRYCODE, BILLTO.CONTACTNAME, BILLTO.PREFIX, BILLTO.FIRSTNAME, BILLTO.INITIAL, BILLTO.LASTNAME, BILLTO.COMPANYNAME, BILLTO.PRINTAS, BILLTO.PHONE1, BILLTO.PHONE2, BILLTO.CELLPHONE, BILLTO.PAGER, BILLTO.FAX, BILLTO.EMAIL1, BILLTO.EMAIL2, BILLTO.URL1, BILLTO.URL2, BILLTO.VISIBLE, BILLTO.MAILADDRESS.ADDRESS1, BILLTO.MAILADDRESS.ADDRESS2, BILLTO.MAILADDRESS.CITY, BILLTO.MAILADDRESS.STATE, BILLTO.MAILADDRESS.ZIP, BILLTO.MAILADDRESS.COUNTRY, BILLTO.MAILADDRESS.COUNTRYCODE, PRBATCH, PRBATCHKEY, MODULEKEY, SCHOPKEY, SYSTEMGENERATED, HASPOSTEDREVREC, BILLBACKTEMPLATEKEY, AUWHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, DUE_IN_DAYS, SHIPTO.TAXGROUP.NAME, SHIPTO.TAXGROUP.RECORDNO, SHIPTO.TAXID, TAXSOLUTIONID, RETAINAGEPERCENTAGE, TRX_TOTALRETAINED, TRX_TOTALRELEASED, TOTALRETAINED, SUPDOCID, PROJECTCONTRACTKEY, PROJECTCONTRACTID, DUNNINGCOUNT, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, SALES_TYPE, RECORD_URL |
| adjustments | RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, STATE, RAWSTATE, CUSTOMERID, CUSTOMERNAME, CUSTEMAILOPTIN, TRX_ENTITYDUE, DOCNUMBER, DESCRIPTION, WHENCREATED, WHENPOSTED, WHENPAID, BASECURR, CURRENCY, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, TOTALENTERED, TOTALSELECTED, TOTALPAID, TOTALDUE, TRX_TOTALENTERED, TRX_TOTALSELECTED, TRX_TOTALPAID, TRX_TOTALDUE, BILLTOPAYTOCONTACTNAME, SHIPTORETURNTOCONTACTNAME, BILLTOPAYTOKEY, SHIPTORETURNTOKEY, SHIPTO.CONTACTNAME, SHIPTO.PREFIX, SHIPTO.FIRSTNAME, SHIPTO.INITIAL, SHIPTO.LASTNAME, SHIPTO.COMPANYNAME, SHIPTO.PRINTAS, SHIPTO.PHONE1, SHIPTO.PHONE2, SHIPTO.CELLPHONE, SHIPTO.PAGER, SHIPTO.FAX, SHIPTO.EMAIL1, SHIPTO.EMAIL2, SHIPTO.URL1, SHIPTO.URL2, SHIPTO.VISIBLE, SHIPTO.MAILADDRESS.RECORDKEY, SHIPTO.MAILADDRESS.ADDRESS1, SHIPTO.MAILADDRESS.ADDRESS2, SHIPTO.MAILADDRESS.CITY, SHIPTO.MAILADDRESS.STATE, SHIPTO.MAILADDRESS.ZIP, SHIPTO.MAILADDRESS.COUNTRY, SHIPTO.MAILADDRESS.COUNTRYCODE, BILLTO.CONTACTNAME, BILLTO.PREFIX, BILLTO.FIRSTNAME, BILLTO.INITIAL, BILLTO.LASTNAME, BILLTO.COMPANYNAME, BILLTO.PRINTAS, BILLTO.PHONE1, BILLTO.PHONE2, BILLTO.CELLPHONE, BILLTO.PAGER, BILLTO.FAX, BILLTO.EMAIL1, BILLTO.EMAIL2, BILLTO.URL1, BILLTO.URL2, BILLTO.VISIBLE, BILLTO.MAILADDRESS.RECORDKEY, BILLTO.MAILADDRESS.ADDRESS1, BILLTO.MAILADDRESS.ADDRESS2, BILLTO.MAILADDRESS.CITY, BILLTO.MAILADDRESS.STATE, BILLTO.MAILADDRESS.ZIP, BILLTO.MAILADDRESS.COUNTRY, BILLTO.MAILADDRESS.COUNTRYCODE, PRBATCH, PRBATCHKEY, MODULEKEY, AUWHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, PARENTPAYMENT, SUPDOCID, CONTACT.CONTACTNAME, CONTACT.PREFIX, CONTACT.FIRSTNAME, CONTACT.INITIAL, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.PRINTAS, CONTACT.PHONE1, CONTACT.PHONE2, CONTACT.CELLPHONE, CONTACT.PAGER, CONTACT.FAX, CONTACT.EMAIL1, CONTACT.EMAIL2, CONTACT.URL1, CONTACT.URL2, CONTACT.VISIBLE, CONTACT.MAILADDRESS.ADDRESS1, CONTACT.MAILADDRESS.ADDRESS2, CONTACT.MAILADDRESS.CITY, CONTACT.MAILADDRESS.STATE, CONTACT.MAILADDRESS.ZIP, CONTACT.MAILADDRESS.COUNTRY, CONTACT.MAILADDRESS.COUNTRYCODE, SHIPTO.TAXGROUP.NAME, SHIPTO.TAXGROUP.RECORDNO, SHIPTO.TAXID, TAXSOLUTIONID, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, RECORD_URL |
| customers | RECORDNO, CUSTOMERID, NAME, ENTITY, PARENTKEY, PARENTID, PARENTNAME, DISPLAYCONTACT.CONTACTNAME, DISPLAYCONTACT.COMPANYNAME, DISPLAYCONTACT.PREFIX, DISPLAYCONTACT.FIRSTNAME, DISPLAYCONTACT.LASTNAME, DISPLAYCONTACT.INITIAL, DISPLAYCONTACT.PRINTAS, DISPLAYCONTACT.TAXABLE, DISPLAYCONTACT.TAXGROUP, DISPLAYCONTACT.TAXSOLUTIONID, DISPLAYCONTACT.TAXSCHEDULE, DISPLAYCONTACT.TAXID, DISPLAYCONTACT.PHONE1, DISPLAYCONTACT.PHONE2, DISPLAYCONTACT.CELLPHONE, DISPLAYCONTACT.PAGER, DISPLAYCONTACT.FAX, DISPLAYCONTACT.TAXIDVALIDATIONDATE, DISPLAYCONTACT.GSTREGISTERED, DISPLAYCONTACT.TAXCOMPANYNAME, DISPLAYCONTACT.TAXADDRESS, DISPLAYCONTACT.EMAIL1, DISPLAYCONTACT.EMAIL2, DISPLAYCONTACT.URL1, DISPLAYCONTACT.URL2, DISPLAYCONTACT.VISIBLE, DISPLAYCONTACT.MAILADDRESS.ADDRESS1, DISPLAYCONTACT.MAILADDRESS.ADDRESS2, DISPLAYCONTACT.MAILADDRESS.CITY, DISPLAYCONTACT.MAILADDRESS.STATE, DISPLAYCONTACT.MAILADDRESS.ZIP, DISPLAYCONTACT.MAILADDRESS.COUNTRY, DISPLAYCONTACT.MAILADDRESS.COUNTRYCODE, DISPLAYCONTACT.MAILADDRESS.LATITUDE, DISPLAYCONTACT.MAILADDRESS.LONGITUDE, DISPLAYCONTACT.STATUS, TERMNAME, TERMVALUE, CUSTREPID, CUSTREPNAME, RESALENO, TAXID, CREDITLIMIT, TOTALDUE, COMMENTS, ACCOUNTLABEL, ARACCOUNT, ARACCOUNTTITLE, LAST_INVOICEDATE, LAST_STATEMENTDATE, DELIVERY_OPTIONS, TERRITORYID, TERRITORYNAME, SHIPPINGMETHOD, CUSTTYPE, GLGRPKEY, GLGROUP, PRICESCHEDULE, DISCOUNT, PRICELIST, VSOEPRICELIST, CURRENCY, CONTACTINFO.CONTACTNAME, CONTACTINFO.PREFIX, CONTACTINFO.FIRSTNAME, CONTACTINFO.INITIAL, CONTACTINFO.LASTNAME, CONTACTINFO.COMPANYNAME, CONTACTINFO.PRINTAS, CONTACTINFO.PHONE1, CONTACTINFO.PHONE2, CONTACTINFO.CELLPHONE, CONTACTINFO.PAGER, CONTACTINFO.FAX, CONTACTINFO.EMAIL1, CONTACTINFO.EMAIL2, CONTACTINFO.URL1, CONTACTINFO.URL2, CONTACTINFO.VISIBLE, CONTACTINFO.MAILADDRESS.ADDRESS1, CONTACTINFO.MAILADDRESS.ADDRESS2, CONTACTINFO.MAILADDRESS.CITY, CONTACTINFO.MAILADDRESS.STATE, CONTACTINFO.MAILADDRESS.ZIP, CONTACTINFO.MAILADDRESS.COUNTRY, CONTACTINFO.MAILADDRESS.COUNTRYCODE, SHIPTO.CONTACTNAME, SHIPTO.PREFIX, SHIPTO.FIRSTNAME, SHIPTO.INITIAL, SHIPTO.LASTNAME, SHIPTO.COMPANYNAME, SHIPTO.PRINTAS, SHIPTO.TAXABLE, SHIPTO.TAXGROUP, SHIPTO.TAXSOLUTIONID, SHIPTO.TAXSCHEDULE, SHIPTO.TAXID, SHIPTO.PHONE1, SHIPTO.PHONE2, SHIPTO.CELLPHONE, SHIPTO.PAGER, SHIPTO.FAX, SHIPTO.EMAIL1, SHIPTO.EMAIL2, SHIPTO.URL1, SHIPTO.URL2, SHIPTO.VISIBLE, SHIPTO.MAILADDRESS.ADDRESS1, SHIPTO.MAILADDRESS.ADDRESS2, SHIPTO.MAILADDRESS.CITY, SHIPTO.MAILADDRESS.STATE, SHIPTO.MAILADDRESS.ZIP, SHIPTO.MAILADDRESS.COUNTRY, SHIPTO.MAILADDRESS.COUNTRYCODE, BILLTO.CONTACTNAME, BILLTO.PREFIX, BILLTO.FIRSTNAME, BILLTO.INITIAL, BILLTO.LASTNAME, BILLTO.COMPANYNAME, BILLTO.PRINTAS, BILLTO.TAXABLE, BILLTO.TAXGROUP, BILLTO.TAXSOLUTIONID, BILLTO.TAXSCHEDULE, BILLTO.PHONE1, BILLTO.PHONE2, BILLTO.CELLPHONE, BILLTO.PAGER, BILLTO.FAX, BILLTO.EMAIL1, BILLTO.EMAIL2, BILLTO.URL1, BILLTO.URL2, BILLTO.VISIBLE, BILLTO.MAILADDRESS.ADDRESS1, BILLTO.MAILADDRESS.ADDRESS2, BILLTO.MAILADDRESS.CITY, BILLTO.MAILADDRESS.STATE, BILLTO.MAILADDRESS.ZIP, BILLTO.MAILADDRESS.COUNTRY, BILLTO.MAILADDRESS.COUNTRYCODE, STATUS, ONETIME, CUSTMESSAGEID, ONHOLD, PRCLST_OVERRIDE, OEPRCLSTKEY, OEPRICESCHEDKEY, ENABLEONLINECARDPAYMENT, ENABLEONLINEACHPAYMENT, VSOEPRCLSTKEY, WHENMODIFIED, ARINVOICEPRINTTEMPLATEID, OEQUOTEPRINTTEMPLATEID, OEORDERPRINTTEMPLATEID, OELISTPRINTTEMPLATEID, OEINVOICEPRINTTEMPLATEID, OEADJPRINTTEMPLATEID, OEOTHERPRINTTEMPLATEID, WHENCREATED, CREATEDBY, MODIFIEDBY, OBJECTRESTRICTION, DISPLAYCONTACTKEY, CONTACTKEY, SHIPTOKEY, BILLTOKEY, CUSTREPKEY, SHIPVIAKEY, TERRITORYKEY, TERMSKEY, ACCOUNTLABELKEY, ACCOUNTKEY, CUSTTYPEKEY, PRICESCHEDULEKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTNOTITLE, ADVBILLBY, ADVBILLBYTYPE, SUPDOCID, RETAINAGEPERCENTAGE, EMAILOPTIN, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, SALES_REP, SALES_PERSON, CHECKBOX, CURRENCYCHECK, DATE_CHECK, EMAIL, NUMBER, PERCENT, PICKLIST, PICKLISTMULTISELECT, SEQUENCE, TEXTAREA, URL, DATEKSHITIJ, TEXTAREAKSHITIJ, TEXTKSHITIJ, NUMBERKSHITIJ, KSHITIJURL, KSHITIJPICKLIST, KSHITIJEMAIL, KSHITIJCHECKBOX, REGION, RECORD_URL |
| items | RECORDNO, ITEMID, STATUS, MRR, NAME, EXTENDED_DESCRIPTION, PODESCRIPTION, SODESCRIPTION, PRODUCTLINEID, CYCLE, CNBILLINGTEMPLATENAME, CNREVENUETEMPLATENAME, CNREVENUE2TEMPLATENAME, CNEXPENSETEMPLATENAME, CNEXPENSE2TEMPLATENAME, CNDEFAULTBUNDLE, CNMEACATEGORYNAME, PRODUCTTYPE, SUBSTITUTEID, SHIP_WEIGHT, WHENLASTSOLD, WHENLASTRECEIVED, INCOMEACCTKEY, EXPENSEACCTKEY, INVACCTKEY, COGSACCTKEY, OFFSETOEGLACCOUNTKEY, OFFSETPOGLACCOUNTKEY, DEFERREDREVACCTKEY, DEFAULTREVRECTEMPLKEY, ALLOW_BACKORDER, TAXABLE, TAXGROUP.NAME, TAXCODE, COST_METHOD, STANDARD_COST, UOMGRP, BASEUOM, UOM.INVUOMDETAIL.UNIT, UOM.POUOMDETAIL.UNIT, UOM.POUOMDETAIL.CONVFACTOR, UOM.SOUOMDETAIL.UNIT, UOM.SOUOMDETAIL.CONVFACTOR, DEFAULT_WAREHOUSE, GLGROUP, NOTE, INV_PRECISION, PO_PRECISION, SO_PRECISION, ITEMTYPE, ENABLE_SERIALNO, SERIAL_MASKKEY, ENABLE_LOT_CATEGORY, LOT_CATEGORYKEY, ENABLE_BINS, ENABLE_EXPIRATION, UPC, REVPOSTING, REVPRINTING, VSOECATEGORY, VSOEDLVRSTATUS, VSOEREVDEFSTATUS, HASSTARTENDDATES, TERMPERIOD, TOTALPERIODS, COMPUTEFORSHORTTERM, RENEWALMACROID, RENEWALMACROKEY, ITEMGLGROUP.INCOMEACCOUNT.ACCTNO, ITEMGLGROUP.EXPENSEACCOUNT.ACCTNO, ITEMGLGROUP.INVENTORYACCOUNT.ACCTNO, ITEMGLGROUP.COGSACCOUNT.ACCTNO, ITEMGLGROUP.DEFRRGLACCOUNT.ACCTNO, ITEMGLGROUP.OEGLACCOUNT.ACCTNO, ITEMGLGROUP.POGLACCOUNT.ACCTNO, ENABLELANDEDCOST, DEFCONTRACTDELIVERYSTATUS, DEFCONTRACTDEFERRALSTATUS, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, IONORDER, IONHAND, IONHOLD, GLGRPKEY, UOMGRPKEY, TAXGROUPKEY, DROPSHIP, BUYTOORDER, IALLOCATED, IRESERVED, IUNCOMMITTED, IINTRANSIT, BASEPRICE, ENABLE_REPLENISHMENT, REPLENISHMENT_METHOD, DEFAULT_REPLENISHMENT_UOM, REORDER_POINT, SAFETY_STOCK, REORDER_QTY, MAX_ORDER_QTY, AUTOPRINTLABEL, ALLOWMULTIPLETAXGRPS, TAXGROUP.TAXSOLUTION.SOLUTIONID, WEIGHTUOM, NETWEIGHT, LWHUOM, LENGTH, WIDTH, HEIGHT, THICKNESSUOM, THICKNESS, MINIMUMTHICKNESS, MAXIMUMTHICKNESS, AREAUOM, AREA, VOLUMEUOM, VOLUME, DIAMETERUOM, INNERDIAMETER, OUTERDIAMETER, DUROMETER, DENSITYUOM, DENSITY, UPC12, EAN13, SAFETYITEM, RESTRICTEDITEM, COMPLIANTITEM, CONDITION, ENGINEERINGALERT, SPECIFICATION1, SPECIFICATION2, SPECIFICATION3, ENGINEERINGAPPROVAL, QUALITYCONTROLAPPROVAL, SALESAPPROVAL, PRIMARYCOUNTRYOFORIGIN, BRAND, SUBBRAND, CATEGORY, SUBCATEGORY, CATALOGREF, COLOR, STYLE, SIZE1, SIZE2, GIFTCARD, WEBENABLED, WEBNAME, WEBSHORTDESC, WEBLONGDESC, ENABLEFULFILLMENT, CONTRACTENABLED, MEGAENTITYKEY, MEGAENTITYID, MEGAENTITYNAME, EXTRA_FIELD, RECORD_URL |
| invoice_items | RECORDNO, RECORDKEY, ACCOUNTKEY, ACCOUNTNO, OFFSETACCOUNTKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTTITLE, ACCOUNTTITLE, ACCOUNTLABELKEY, ACCOUNTLABEL, ENTRY_DATE, AMOUNT, TRX_AMOUNT, DEPARTMENTID, DEPARTMENTNAME, LOCATIONID, LOCATIONNAME, ENTRYDESCRIPTION, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, ALLOCATIONKEY, ALLOCATION, LINEITEM, LINE_NO, CURRENCY, BASECURR, TOTALPAID, TRX_TOTALPAID, TOTALSELECTED, TRX_TOTALSELECTED, SUBTOTAL, PARENTENTRY, DEFERREVENUE, REVRECTEMPLATEKEY, REVRECTEMPLATE, DEFERREDREVACCTKEY, DEFERREDREVACCTNO, DEFERREDREVACCTTITLE, REVRECSTARTDATE, REVRECENDDATE, BASELOCATION, STATE, RECORDTYPE, DETAILKEY, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, RETAINAGEPERCENTAGE, TRX_AMOUNTRETAINED, AMOUNTRETAINED, TRX_AMOUNTRELEASED, RETAINAGE_OFFSETGLACCOUNTNO, PROJECTCONTRACTID, PROJECTCONTRACTKEY, PROJECTCONTRACTLINEID, PROJECTCONTRACTLINEKEY, GLDIMUSER_DEFINED_DIMENSION, PROJECTDIMKEY, PROJECTID, PROJECTNAME, CUSTOMERDIMKEY, CUSTOMERID, CUSTOMERNAME, VENDORDIMKEY, VENDORID, VENDORNAME, EMPLOYEEDIMKEY, EMPLOYEEID, EMPLOYEENAME, ITEMDIMKEY, ITEMID, ITEMNAME, CLASSDIMKEY, CLASSID, CLASSNAME, RECORD_URL |
| adjustment_items | RECORDNO, RECORDKEY, ACCOUNTKEY, ACCOUNTNO, OFFSETACCOUNTKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTTITLE, ACCOUNTTITLE, ACCOUNTLABELKEY, ACCOUNTLABEL, PRENTRYOFFSETACCOUNTNO, ENTRY_DATE, AMOUNT, TRX_AMOUNT, DEPARTMENTID, DEPARTMENTNAME, LOCATIONID, LOCATIONNAME, ENTRYDESCRIPTION, EXCH_RATE_DATE, EXCH_RATE_TYPE_ID, EXCHANGE_RATE, LINEITEM, LINE_NO, CURRENCY, BASECURR, TOTALPAID, TRX_TOTALPAID, TOTALSELECTED, TRX_TOTALSELECTED, PARENTENTRY, BASELOCATION, STATE, RECORDTYPE, DETAILKEY, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, GLDIMUSER_DEFINED_DIMENSION, PROJECTDIMKEY, PROJECTID, PROJECTNAME, CUSTOMERDIMKEY, CUSTOMERID, CUSTOMERNAME, VENDORDIMKEY, VENDORID, VENDORNAME, EMPLOYEEDIMKEY, EMPLOYEEID, EMPLOYEENAME, ITEMDIMKEY, ITEMID, ITEMNAME, CLASSDIMKEY, CLASSID, CLASSNAME, RECORD_URL |
Credentials Setup
Follow the steps below to get the credentials you need to use the Sage Intacct connector.
The Sage Intacct tap requires the following fields:
| Field Name | Description |
|---|---|
| Company Id | Your Sage Intacct Company Id |
| Sender Id | Your Sage Intacct Sender Id |
| Sender Password | Your Sage Intacct Sender Password |
| User Id | Your Sage Intacct User Id |
| User Password | Your Sage Intacct User Password |
To find these credentials, follow the Sage Intacct developer guide.