Contacts - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update Contact records within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

Contacts are shared across the entire system and are used to send event notifications, to determine ship-to/bill-to, pay-to/return-to addresses in Order Entry and Purchasing transactions, and to determine tax on transactions.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTIVE	STATUS	Status	Optional	Text. Use `true` for Active or `false` for Inactive (Default: `true`)
ADDRESS1	MAILADDRESS.ADDRESS1	Address line 1	Optional	Expected value is free text
ADDRESS2	MAILADDRESS.ADDRESS2	Address line 2	Optional	Expected value is free text
CELLPHONE	CELLPHONE	Mobile	Optional	Expected value is free text (30)
CITY	MAILADDRESS.CITY	City	Optional	Expected value is free text (80)
COMPANYNAME	COMPANYNAME	Company name	Optional	Expected value is free text (100)
CONTACTNAME	CONTACTNAME	Contact name	Yes/Optional	Yes for Create, Optional for Update (Required if not using `RECORDNO`)
COUNTRY	MAILADDRESS.COUNTRY	Country	Optional	Expected value is free text (60)
EMAILADDRESS1	EMAIL1	Primary email address	Optional	Expected value is free text (200)
EMAILADDRESS2	EMAIL2	Secondary email addresses	Optional	Expected value is free text (200)
FAX	FAX	Fax	Optional	Expected value is free text (30)
FIRSTNAME	FIRSTNAME	First name	Optional	Expected value is free text (40)
LASTNAME	LASTNAME	Last name	Optional	Expected value is free text (40)
MIDDLENAME	INITIAL	Middle name	Optional	Expected value is free text (40)
PAGER	PAGER	Pager	Optional	Expected value is free text (30)
PHONE1	PHONE1	Primary phone	Optional	Expected value is free text (30)
PHONE2	PHONE2	Secondary phone	Optional	Expected value is free text (30)
POSTALCODE	MAILADDRESS.ZIP	Zip code/Post code	Optional	Expected value is free text (30)
PREFIX	PREFIX	Mr./Ms./Mrs.	Optional	Expected value is free text (15)
PRINTAS	PRINTAS	Print as	Yes	Expected value is free text (200)
RECORDNO	RECORDNO	Record number	Yes for Update	Expected value is integer
STATE	MAILADDRESS.STATE	State/Territory	Optional	Expected value is free text (40)
TAXABLE	TAXABLE	Taxable	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `true`)
TAXGROUP	TAXGROUP	Contact tax group	Optional	Expected value is free text
TAXSOLUTIONID	TAXSOLUTIONID	Tax solution	Optional	Tax solution name, such as `United Kingdom - VAT` or `Australia - GST`. Required only if the company is configured for multiple tax jurisdictions and the transaction is occurring at the top level of the company. The available tax solution names can be found in the Sage Intacct UI in the Taxes application from the top level of a multi-entity company. (GB, AU, and ZA only). Expected value is free text
TAXID	TAXID	Tax ID	Optional	Expected value is free text (20)
URL1	URL1	Primary URL	Optional	Expected value is free text (256)
URL2	URL2	Secondary URL	Optional	Expected value is free text (256)