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 |
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 |
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 |
DISPLOCACCTNOCHECK |
DISPLOCACCTNOCHECK |
Display the vendor-assigned account number, per entity, on the check stub |
Optional |
Check Box. Use |
DONOTCUTCHECK |
DONOTCUTCHECK |
Do not pay |
Optional |
Check Box. Use |
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) |
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 |
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 |
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 |
OFFSETGLACCOUNTNO |
OFFSETGLACCOUNTNO |
AP Account |
Optional |
Expected value is free text |
ONETIME |
ONETIME |
One-time |
Optional |
Check Box. Use |
ONHOLD |
ONHOLD |
On Hold |
Optional |
On hold. Use |
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 |
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) |
RESTRICTEDDEPARTMENTS |
RESTRICTEDDEPARTMENTS |
Restricted department ID |
Optional |
Use if OBJECTRESTRICTION is |
RESTRICTEDLOCATIONS |
RESTRICTEDLOCATIONS |
Restricted location ID |
Optional |
Use if OBJECTRESTRICTION is |
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 |
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 |
|
|
|
|