Vendors - Sage Intacct Data Target Requirement

DataBlend supports the standard API calls (non-legacy) to Create and Update vendor 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.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
RECORDNO	RECORDNO	Record Number	Yes, leave blank for Create.	Required for Get, Update and Delete vendor. Expected value is integer.
ACHACCOUNTNUMBER	ACHACCOUNTNUMBER	Account number	Optional	ACH bank account number. Expected value is free text (17)
ACHACCOUNTTYPE	ACHACCOUNTTYPE	Account Type	Optional	ACH bank account type. Expected value is free text
ACHBANKROUTINGNUMBER	ACHBANKROUTINGNUMBER	ACH bank routing number	Optional	ACH bank routing number. Expected value is free text (9)
ACHENABLED	ACHENABLED	Enable ACH	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `false`)
ACHREMITTANCETYPE	ACHREMITTANCETYPE	Account classification	Optional	ACH bank account class. Expected value is free text
ADDRESS1	ADDRESS1	Address line 1	Optional	Expected value is free text (255)
ADDRESS2	ADDRESS2	Address line 2	Optional	Expected value is free text (255)
APACCOUNT	APACCOUNT	Default expense account	Optional	Default expense GL account number. Expected value is free text
BILLINGTYPE	BILLINGTYPE	Vendor Billing Type	Optional	Expected value is free text
CATEGORYNAME	CATEGORYNAME	Contact category	Yes/Optional	Contact category, such as work, home, and so forth. Expected value is free text
CELLPHONE	CELLPHONE	Cellular Phone Number	Optional	Expected value is free text (30)
CITY	CITY	City	Optional	Expected value is free text (80)
COMMENTS	COMMENTS	Comments	Optional	Expected value is free text (200)
COMPANYNAME	COMPANYNAME	Company Name	Optional	Display contact company name.
CONTACTINFO	CONTACTINFO	Primary contact	Optional	Object. If blank system will use DISPLAYCONTACT.
CONTACTNAME	CONTACTNAME	Contact name	Yes/Optional	Optional in DISPLAYCONTACT object / Required in CONTACTINFO, PAYTO and RETURNTO objects. If left blank, system will create the name as `[NAME](V[VENDORID])`. Expected value is free text (200)
COUNTRY	COUNTRY	Country	Optional	Expected value is free text (60)
CREDITLIMIT	CREDITLIMIT	Credit Limit	Optional	Expected decimal value
CURRENCY	CURRENCY	Default Currency	Optional	Expected value is free text
DEFAULT_LEAD_TIME	DEFAULT_LEAD_TIME	Lead time default (days)		Expected value is integer
DISPLAYCONTACT	DISPLAYCONTACT	Contact info	Yes	Object - See Create Contact Contacts - Sage Intacct - DataBlend Knowledge Base - Confluence (atlassian.net)
DISPLAYTERMDISCOUNT	DISPLAYTERMDISCOUNT	Display the term discount on the check stub	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `true`)
DISPLOCACCTNOCHECK	DISPLOCACCTNOCHECK	Display the vendor-assigned account number, per entity, on the check stub	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
DONOTCUTCHECK	DONOTCUTCHECK	Do not pay	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
EMAIL1	EMAIL1	Primary email	Optional	Expected value is free text (200)
EMAIL2	EMAIL2	Secondary email	Optional	Expected value is free text (200)
FAX	FAX	Fax	Optional	Expected value is free text (30)
FILEPAYMENTSERVICE	FILEPAYMENTSERVICE	Enable Service	Optional	Enable direct payments to this vendor using a bank file. Choose ACH, BANKFILE, or NONE. (Default: NONE)
FIRSTNAME	FIRSTNAME	First Name	Optional	Expected value is free text (40)
FORM1099BOX	FORM1099BOX	Form 1099 Box	Optional	Expected value is free text (4)
FORM1099TYPE	FORM1099TYPE	Form 1099 Type	Optional	Expected value is free text (4)
GLGROUP	GLGROUP	GL group name	Optional	Expected value is free text (80)
HIDEDISPLAYCONTACT	HIDEDISPLAYCONTACT	Exclude from contact list	Optional	Use `false` for No, `true` for Yes. (Default: `false`)
INITIAL	INITIAL	Middle name	Optional	Middle name. Expected value is free text (40)
LASTNAME	LASTNAME	Last Name	Optional	Expected value is free text (40)
MAILADDRESS	MAILADDRESS	Mail address	Optional	Object
MERGEPAYMENTREQ	MERGEPAYMENTREQ	Merge payment requests	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `true`)
NAME	NAME	Vendor name	Yes	Expected value is free text (100)
NAME1099	NAME1099	Form 1099 Name	Optional	Expected value is free text (100)
OBJECTRESTRICTION	OBJECTRESTRICTION	Restriction type	Optional	Use `Unrestricted`, `RootOnly`, or `Restricted`. (Default `Unrestricted`)
OFFSETGLACCOUNTNO	OFFSETGLACCOUNTNO	AP Account	Optional	Expected value is free text
ONETIME	ONETIME	One-time	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
ONHOLD	ONHOLD	On Hold	Optional	On hold. Use `false` for No, `true` for Yes. (Default: `false`)
PAGER	PAGER	Pager	Optional	Expected value is free text (30)
PARENTID	PARENTID	Parent Vendor ID	Optional	Expected value is free text
PAYMENTNOTIFY	PAYMENTNOTIFY	Send Automatic Payment Notification	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
PAYMENTPRIORITY	PAYMENTPRIORITY	Payment Priority	Optional	Expected value is free text
PAYMETHODKEY	PAYMETHODKEY	Preferred Payment Method	Optional	Expected value is free text
PAYTO	PAYTO	Pay To Contact	Optional	Object. If blank system will use DISPLAYCONTACT.
PHONE1	PHONE1	Phone number	Optional	Primary phone number. Expected value is free text (30)
PHONE2	PHONE2	Secondary phone	Optional	Secondary phone number. Expected value is free text (30)
PREFIX	PREFIX	Prefix	Optional	Expected value is free text (15)
PRINTAS	PRINTAS	Print As	Yes	Expected value is free text (200)
PYMTCOUNTRYCODE	PYMTCOUNTRYCODE	Payment Country	Optional	Country code for a vendor. Required if the vendor is to receive bank file payments. Choose AU, ZA, or GB. (AU, GB, ZA only)
PYMTCURRENCY	PYMTCURRENCY	Payment Currency	Optional	Payment currency for a vendor.
RESTRICTEDDEPARTMENTS	RESTRICTEDDEPARTMENTS	Restricted department ID	Optional	Use if OBJECTRESTRICTION is `Restricted`. Implode multiple ID’s with `#~#`. Separate values by a comma.
RESTRICTEDLOCATIONS	RESTRICTEDLOCATIONS	Restricted location ID	Optional	Use if OBJECTRESTRICTION is `Restricted`. Implode multiple ID’s with `#~#`. Separate values by a comma.
RETURNTO	RETURNTO	Return To Contact	Optional	Object. If blank system will use DISPLAYCONTACT
STATE	STATE	State/Territory	Optional	Geographical state or province
True	STATUS	Status	Optional	Status. STATUS is set to "true" for Active and "false" for Inactive. (Default: active). String
SUPDOCID	SUPDOCID	Attachment	Optional	Attachments ID. Expected value is free text.
TAXABLE	TAXABLE	Taxable	Optional	Use `false` for No, `true` for Yes. (Default: `true`)
TAXGROUP	TAXGROUP	Contact tax group name	Optional	Expected value is free text
TAXID	TAXID	Tax ID	Optional	Expected value is free text (20)
TAXSCHEDULE	TAXSCHEDULE	Default Tax Schedule	Optional	Expected value is free text
TAXSOLUTIONID	TAXSOLUTIONID	Tax Solution ID	Optional	Expected value is free text
TERMNAME	TERMNAME	Term	Optional	Selected value must exist in Sage Intacct
URL1	URL1	URL	Optional	Expected value is free text (256)
URL2	URL2	Secondary URL	Optional	Expected value is free text (256)
VENDORACCOUNTNO	VENDORACCOUNTNO	Number	Optional	Vendor account number. Expected value is free text (30)
VENDORID	VENDORID	Vendor ID	Yes, leave blank if company uses auto-numbering	Leave blank for autonumbering of new vendors
VENDTYPE	VENDTYPE	Vendor Type ID	Optional	Vendor Type, selected value must exist in Sage Intacct. Type - string
ZIP	ZIP	Zip code/Post code	Optional	Zip or Postal Code
Bank file fields
VENDORBANKFILEDETAIL_BANKACCOUNTNUMBER
VENDORBANKFILEDETAIL_ACCOUNTNAME
VENDORBANKFILEDETAIL_BSBNUMBER
VENDORBANKFILEDETAIL_PYMTREFERENCE
VENDORBANKFILEDETAIL_BRANCHCODE
VENDORBANKFILEDETAIL_ACCOUNTTYPE
VENDORBANKFILEDETAIL_PROOFOFPYMT
VENDORBANKFILEDETAIL_SORTCODE