Contracts - Sage Intacct Data Target Requirements
DataBlend supports the API calls to Create and Update Contract 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.
Contract is a dimension that can be defined by the company and set on transactions to expand report functionality and insight.
|
DataBlend Query Object (SDK) |
Sage Intacct Object (API) |
Sage Intacct UI Name |
Required |
Notes |
| ADVBILLBY | ADVBILLBY | Optional | Expected value is integer | |
| ADVBILLBYTYPE | ADVBILLBYTYPE | Optional | Values: days, months | |
| BEGINDATE | BEGINDATE | Start date | Yes | Start date in format mm/dd/yyyy |
| BILLINGFREQUENCY | BILLINGFREQUENCY | Billing frequency | Optional | Billing frequency. Monthly, Quarterly, Annually |
| BILLTOCONTACTNAME | BILLTOCONTACTNAME | Bill to | Optional | Expected value is free text. Leave blank to use customer’s default. |
| CLASSID | CLASSID | Class | Optional | Expected value is free text (50) |
| CONTRACTID | CONTRACTID | Contract ID | Optional | Update only. Required if not using RECORDNO. |
| CONTRACTTYPE | CONTRACTTYPE | Contract Type | Optional | Valid values as configured in Intacct instance |
| CURRENCY | CURRENCY | Transaction currency | Optional | Expected value is free text |
| CUSTOMERID | CUSTOMERID | Customer | Yes | Expected value is free text |
| DEPARTMENTID | DEPARTMENTID | Department | Optional | Expected value is free text (20) |
| DESCRIPTION | DESCRIPTION | Description | Optional | Expected value is free text (2000) |
| EMPLOYEEID | EMPLOYEEID | Employee | Optional | Expected value is free text (20) |
| ENDDATE | ENDDATE | End date | Optional | End date in format mm/dd/yyyy. Required when the term type is Termed. |
| EVERGREENMACRO | EVERGREENMACRO | Optional | Perpetual (Evergreen) template. Required for an Evergreen term type. | |
| EXCHRATETYPE | EXCHRATETYPE | Exchange rate type | Optional | Expected value is free text |
| LOCATIONID | LOCATIONID | Location | Yes | Expected value is free text (20) |
| MEAPRCLIST | MEAPRCLIST | Fair value price list | Optional | Expected value is free text |
| NAME | NAME | Contract name | Yes | Expected value is free text (200) |
| PRCLIST | PRCLIST | Billing price list | Optional | Expected value is free text |
| PROJECTID | PROJECTID | Project | Optional | Expected value is free text (20) |
| RECORDNO | RECORDNO | Record number | Optional | Expected value is integer |
| RENEWAL | RENEWAL | Renew | Optional | Renewal. false - No (default), true - Yes. Applicable only for termed contracts |
| RENEWALADVBILLBY | RENEWALADVBILLBY | Optional | Expected value is integer | |
| RENEWALADVBILLBYTYPE | RENEWALADVBILLBYTYPE | Optional | Values: days, months | |
| RENEWALMACRO | RENEWALMACRO | Renewal template | Optional | Expected value is free text (40) |
| RENEWTERMLENGTH | RENEWTERMLENGTH | Renewal term length | Optional | Expected value is integer |
| RENEWTERMPERIOD | RENEWTERMPERIOD | Renewal term period | Optional | Expected value is free text |
| SHIPTO | SHIPTOCONTACTNAME | Ship to | Optional | Expected value is free text |
| STATE | STATE | Optional | Values: In progress (default), Draft | |
| STATUS | STATUS | Status | Optional | Values: active, inactive |
| SUPDOCID | SUPDOCID | Attachment | Optional | Expected value is free text (20) |
| TERMNAME | TERMNAME | Payment term | Yes | Expected value is free text |
| TERMTYPE | TERMTYPE | Yes | Values: Termed (default), Evergreen | |
| VENDORID | VENDORID | Vendor | Optional | Expected value is free text (20) |