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

      Location Entity - Sage Intacct Data Target Requirements

      DataBlend supports the API calls to Create and Update Location Entity 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

       

      ACCOUNTINGTYPE

      ACCOUNTINGTYPE

      Type

      Optional

      Expected value is free text (50)

      ADDRESSCOUNTRYDEFAULT

      ADDRESSCOUNTRYDEFAULT

      Default country for addresses

      Optional

      Expected value is free text

      BUSINESSDAYS

      BUSINESSDAYS

      Work days

      Optional

      Expected value is free text (100)

      CONTACTINFOCELLPHONE

      CONTACTINFO.CELLPHONE

      Mobile phone

      Optional

      Expected value is free text (30)

      CONTACTINFOCOMPANYNAME

      CONTACTINFO.COMPANYNAME

      Company name

      Optional

      Expected value is free text (100)

      CONTACTINFOCONTACTNAME

      CONTACTINFO.CONTACTNAME

      Entity

      Optional

      Expected value is free text (200)

      CONTACTINFOEMAIL1

      CONTACTINFO.EMAIL1

      Primary email address

      Optional

      Expected value is free text (200)

      CONTACTINFOEMAIL2

      CONTACTINFO.EMAIL2

      Secondary email addresses

      Optional

      Expected value is free text (200)

      CONTACTINFOFAX

      CONTACTINFO.FAX

      Fax

      Optional

      Expected value is free text (30)

      CONTACTINFOFIRSTNAME

      CONTACTINFO.FIRSTNAME

      First name

      Optional

      Expected value is free text (40)

      CONTACTINFOINITIAL

      CONTACTINFO.INITIAL

      Middle name

      Optional

      Expected value is free text (40)

      CONTACTINFOLASTNAME

      CONTACTINFO.LASTNAME

      Last name

      Optional

      Expected value is free text (40)

      CONTACTINFOMAILADDRESSADDRESS1

      CONTACTINFO.MAILADDRESS.ADDRESS1

      Address line 1

      Optional

      Expected value is free text (255)

      CONTACTINFOMAILADDRESSADDRESS2

      CONTACTINFO.MAILADDRESS.ADDRESS2

      Address line 2

      Optional

      Expected value is free text (255)

      CONTACTINFOMAILADDRESSCITY

      ONTACTINFO.MAILADDRESS.CITY

      City

      Optional

      Expected value is free text (80)

      CONTACTINFOMAILADDRESSCOUNTRY

      CONTACTINFO.MAILADDRESS.COUNTRY

      Country

      Optional

      Expected value is free text (60)

      CONTACTINFOMAILADDRESSCOUNTRYCODE

      CONTACTINFO.MAILADDRESS.COUNTRYCODE

      Country code

      Optional

      Expected value is free text

      CONTACTINFOMAILADDRESSSTATE

      CONTACTINFO.MAILADDRESS.STATE

      State or territory

      Optional

      Expected value is free text (40)

      CONTACTINFOMAILADDRESSZIP

      CONTACTINFO.MAILADDRESS.ZIP

      ZIP or postal code

      Optional

      Expected value is free text (30)

      CONTACTINFOPAGER

      CONTACTINFO.PAGER

      Pager

      Optional

      Expected value is free text (30)

      CONTACTINFOPHONE1

      CONTACTINFO.PHONE1

      Primary phone

      Optional

      Expected value is free text (30)

      CONTACTINFOPHONE2

      CONTACTINFO.PHONE2

      Secondary phone

      Optional

      Expected value is free text (30)

      CONTACTINFOPREFIX

      CONTACTINFO.PREFIX

      Prefix

      Optional

      Expected value is free text (15)

      CONTACTINFOPRINTAS

      CONTACTINFO.PRINTAS

      Location contact

      Optional

      Expected value is free text (200)

      CONTACTINFOURL1

      CONTACTINFO.URL1

      Primary URL

      Optional

      Expected value is free text (256)

      CONTACTINFOURL2

      CONTACTINFO.URL2

      Secondary URL

      Optional

      Expected value is free text (256)

      CONTACTKEY

      CONTACTKEY

      Contact record number

      Optional

      Expected value is integer

      CURRENCY

      CURRENCY

      Base currency

      Yes/Optional

      Required when Intacct instance is setup and multi base currency. Expected value is free text (12)

      CUSTENTITY

      CUSTENTITY

      Customer entity

      Optional

      Expected value is free text (20)

      CUSTOMERID

      CUSTOMERID

      Customer tied with

      Optional

      Expected value is free text (20)

      CUSTOMERNAME

      CUSTOMERNAME

      Customer name

      Optional

      Expected value is free text

      CUSTTITLE

      CUSTTITLE

      Entity title

      Optional

      Expected value is free text (250)

      DEFAULTPARTIALEXEMPT

      DEFAULTPARTIALEXEMPT

      Default input tax credit on

      Optional

      Checkbox

      EAN ISROOT

      ISROOT

      ISROOT

      Optional

      Expected value is free text

      ENABLELEGALCONTACT

      ENABLELEGALCONTACT

      Enable legal name and address on 1099 and 1096 forms

      Optional

      Checkbox

      ENDDATE

      ENDDATE

      End date

      Optional

      End date in format mm/dd/yyyy

      ENTITY

      ENTITY

      Entity ID and name

      Optional

      Expected value is free text (20)

      ENTITYRECORDNO

       

       

      Optional

       

      FEDERALID

      FEDERALID

      Federal ID

      Yes

      Expected value is free text (20)

      FIRSTMONTHTAX

      FIRSTMONTHTAX

      First tax month

      Optional

      Expected value is free text

      FOOTNOTETEXT

      FOOTNOTETEXT

      FOOTNOTETEXT

      Optional

      Expected value is free text

      HASIERELATION

      HAS_IE_RELATION

      Enable different accounts based on the target entity

      Optional

      Checkbox

      IEPAYABLEACCOUNT

      IEPAYABLE.ACCOUNT

      Inter-entity payable account

      Optional

      Expected value is free text (200)

      IEPAYABLEACCTKEY

       

       

      Optional

       

      IEPAYABLENUMBER

      IEPAYABLE.NUMBER

      IEPAYABLE.NUMBER

      Optional

      Expected value is free text (96)

      IERECEIVABLEACCOUNT

      IERECEIVABLE.ACCOUNT

      Inter-entity receivable account

      Optional

      Expected value is free text (200)

      IERECEIVABLEACCTKEY

       

       

      Optional

       

      IERECEIVABLENUMBER

      IERECEIVABLE.NUMBER

      IERECEIVABLE.NUMBER

      Optional

      Expected value is free text (96)

      LEGALADDRESS1

      LEGALADDRESS1

      Legal address line 1

      Optional

      Expected value is free text (100)

      LEGALADDRESS2

      LEGALADDRESS2

      Legal address line 2

      Optional

      Expected value is free text (100)

      LEGALCITY

      LEGALCITY

      Legal city

      Optional

      Expected value is free text (50)

      LEGALCOUNTRYCODE

      LEGALCOUNTRYCODE

      Legal country

      Optional

      Expected value is free text

      LEGALNAME

      LEGALNAME

      Legal name

      Optional

      Expected value is free text (100)

      LEGALSTATE

      LEGALSTATE

      Legal state or territory

      Optional

      Expected value is free text (50)

      LEGALZIPCODE

      LEGALZIPCODE

      Legal ZIP or postal code

      Optional

      Expected value is free text (15)

      LOCATIONENTITYLOCATIONTYPE

       

       

      Optional

       

      LOCATIONID

      LOCATIONID

      ID

      Yes

      Record name

      MARKETINGTEXT

      MARKETING_TEXT

      MARKETING_TEXT

      Optional

      Expected value is free text

      MESSAGETEXT

      MESSAGE_TEXT

      MESSAGE_TEXT

      Optional

      Expected value is free text

      NAME

      NAME

      Name

      Yes

      Expected value is free text (40)

      OPCOUNTRY

       

       

      Optional

       

      PARENTID

      PARENTID

      Parent

      Optional

      Expected value is free text (20)

      PARENTKEY

      PARENTKEY

      Parent location key

      Optional

      Expected value is integer

      PARTIALEXEMPT

      PARTIALEXEMPT

      Enable input tax credit

      Optional

      Checkbox

      RECORDNO

      RECORDNO

      Record number

      Yes/Optional

      Required for Update. Expected value is integer

      REPORTPRINTAS

      REPORTPRINTAS

      Print entity name as

      Optional

      Expected value is free text (100)

      RESERVEAMT

      RESERVEAMT

      Reserve amount

      Optional

      Expected value is decimal

      SHIPTOCELLPHONE

      SHIPTO.CELLPHONE

      Mobile phone

      Optional

      Expected value is free text (30)

      SHIPTOCOMPANYNAME

      SHIPTO.COMPANYNAME

      Company name

      Optional

      Expected value is free text (100)

      SHIPTOCONTACTNAME

      SHIPTO.CONTACTNAME

      Ship to

      Optional

      Expected value is free text (200)

      SHIPTOEMAIL1

      SHIPTO.EMAIL1

      Primary email address

      Optional

      Expected value is free text (200)

      SHIPTOEMAIL2

      SHIPTO.EMAIL2

      Secondary email addresses

      Optional

      Expected value is free text (200)

      SHIPTOFAX

      SHIPTO.FAX

      Fax

      Optional

      Expected value is free text (30)

      SHIPTOFIRSTNAME

      SHIPTO.FIRSTNAME

      First name

      Optional

      Expected value is free text (40)

      SHIPTOINITIAL

      SHIPTO.INITIAL

      Middle name

      Optional

      Expected value is free text (40)

      SHIPTOKEY

      SHIPTOKEY

      Ship-to contact record number

      Optional

      Expected value is integer

      SHIPTOLASTNAME

      SHIPTO.LASTNAME

      Last name

      Optional

      Expected value is free text (40)

      SHIPTOMAILADDRESSADDRESS1

      SHIPTO.MAILADDRESS.ADDRESS1

      Address line 1

      Optional

      Expected value is free text (255)

      SHIPTOMAILADDRESSADDRESS2

      SHIPTO.MAILADDRESS.ADDRESS2

      Address line 2

      Optional

      Expected value is free text (255)

      SHIPTOMAILADDRESSCITY

      SHIPTO.MAILADDRESS.CITY

      City

      Optional

      Expected value is free text (80)

      SHIPTOMAILADDRESSCOUNTRY

      SHIPTO.MAILADDRESS.COUNTRY

      Country

      Optional

      Expected value is free text (60)

      SHIPTOMAILADDRESSCOUNTRYCODE

      SHIPTO.MAILADDRESS.COUNTRYCODE

      Country code

      Optional

      Expected value is free text

      SHIPTOMAILADDRESSSTATE

      SHIPTO.MAILADDRESS.STATE

      State or territory

      Optional

      Expected value is free text (40)

      SHIPTOMAILADDRESSZIP

      SHIPTO.MAILADDRESS.ZIP

      ZIP or postal code

      Optional

      Expected value is free text (30)

      SHIPTOPAGER

      SHIPTO.PAGER

      Pager

      Optional

      Expected value is free text (30)

      SHIPTOPHONE1

      SHIPTO.PHONE1

      Primary phone

      Optional

      Expected value is free text (30)

      SHIPTOPHONE2

      SHIPTO.PHONE2

      Secondary phone

      Optional

      Expected value is free text (30)

      SHIPTOPREFIX

      SHIPTO.PREFIX

      Prefix

      Optional

      Expected value is free text (15)

      SHIPTOPRINTAS

      SHIPTO.PRINTAS

      Print as

      Optional

      Expected value is free text (200)

      SHIPTOURL1

      SHIPTO.URL1

      Primary URL

      Optional

      Expected value is free text (256)

      SHIPTOURL2

      SHIPTO.URL2

      Secondary URL

      Optional

      Expected value is free text (256)

      STARTDATE

      STARTDATE

      Start date

      Optional

      Start date in format mm/dd/yyyy

      STARTOPEN

      STARTOPEN

      Open books from

      Optional

      Date in format mm/dd/yyyy

      STATUS

      STATUS

      Status

      Optional

      Expected value is free text

      SUPERVISORID

      SUPERVISORID

      Manager

      Optional

      Expected value is free text

      SUPERVISORKEY

      SUPERVISORKEY

      Supervisor record number

      Optional

      Expected value is integer

      SUPERVISORNAME

      SUPERVISORNAME

      SUPERVISORNAME

      Optional

      Expected value is free text

      TAXID

       

       

      Optional

       

      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

      TAXSOLUTIONTAXMETHOD

       

       

      Optional

       

      UNRECOVERABLETAXACCTNO

      UNRECOVERABLETAXACCTNO

      Unrecoverable tax account

      Optional

      Expected value is free text

      VENDENTITY

      VENDENTITY

      Vendor entity

      Optional

      Expected value is free text (20)

      VENDORID

      VENDORID

      Vendor tied with

      Optional

      Expected value is free text (20)

      VENDORNAME

      VENDORNAME

      Vendor name

      Optional

      Expected value is free text

      WEEKENDS

      WEEKENDS

      Weekends

      Optional

      Expected value is free text (100)