Data Targets
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Data Targets

      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

       

      BILLTOCONTACTNAME

      BILLTOCONTACTNAME

      Bill to

      Optional

      Expected value is free text. Leave blank to use customer’s default.

      DESCRIPTION

      DESCRIPTION

      Description

      Optional

      Expected value is free text (2000)

      BEGINDATE

      BEGINDATE

      Start date

      Yes

      Start date in format mm/dd/yyyy

      BILLINGFREQUENCY

      BILLINGFREQUENCY

      Billing frequency

      Optional

      Billing frequency. Monthly, Quarterly, Annually

      TERMNAME

      TERMNAME

      Payment term

      Yes

      Expected value is free text

      PRCLIST

      PRCLIST

      Billing price list

      Optional

      Expected value is free text

      MEAPRCLIST

      MEAPRCLIST

      Fair value price list

      Optional

      Expected value is free text

      CONTRACTID

      CONTRACTID

      Contract ID

      Optional

      Update only. Required if not using RECORDNO.

      CUSTOMERID

      CUSTOMERID

      Customer

      Yes

      Expected value is free text

      NAME

      NAME

      Contract name

      Yes

      Expected value is free text (200)

      LOCATIONID

      LOCATIONID

      Location

      Yes

      Expected value is free text (20)

      SHIPTO

      SHIPTOCONTACTNAME

      Ship to

      Optional

      Expected value is free text

      ENDDATE

      ENDDATE

      End date

      Optional

      End date in format mm/dd/yyyy. Required when the term type is Termed.

      SUPDOCID

      SUPDOCID

      Attachment

      Optional

      Expected value is free text (20)

      DEPARTMENTID

      DEPARTMENTID

      Department

      Optional

      Expected value is free text (20)

      PROJECTID

      PROJECTID

      Project

      Optional

      Expected value is free text (20)

      VENDORID

      VENDORID

      Vendor

      Optional

      Expected value is free text (20)

      EMPLOYEEID

      EMPLOYEEID

      Employee

      Optional

      Expected value is free text (20)

      CLASSID

      CLASSID

      Class

      Optional

      Expected value is free text (50)

      CURRENCY

      CURRENCY

      Transaction currency

      Optional

      Expected value is free text

      EXCHRATETYPE

      EXCHRATETYPE

      Exchange rate type

      Optional

      Expected value is free text

      RECORDNO

      RECORDNO

      Record number

      Optional

      Expected value is integer

      RENEWAL

      RENEWAL

      Renew

      Optional

      Renewal. false - No (default), true - Yes. Applicable only for termed contracts

      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