Intacct Integration Default Field Mappings

Mapping Notes

Many of the mappings are hard coded and have built-in logic, meaning that some fields have more than one source.
Not all fields will be listed in the mappings below.
Mapping based on the out of the box configuration and does not reflect any custom changes made for each individual systems

Sugar Accounts to Intacct Customers

Sugar Field	Intacct Field
name	NAME

 

Intacct Customers to Sugar Accounts

Intacct Field	Sugar Field
CUSTOMERID	intacct_customer_id
NAME	name
COMMENTS	description
DISPLAYCONTACT.MAILADDRESS.ADDRESS1	billing_address_street
DISPLAYCONTACT.MAILADDRESS.ADDRESS2	billing_address_street_2
DISPLAYCONTACT.MAILADDRESS.CITY	billing_address_city
DISPLAYCONTACT.MAILADDRESS.STATE	billing_address_state
DISPLAYCONTACT.MAILADDRESS.ZIP	billing_address_postalcode
DISPLAYCONTACT.MAILADDRESS.COUNTRY	billing_address_country
SHIPTO.MAILADDRESS.ADDRESS1	shipping_address_street
SHIPTO.MAILADDRESS.ADDRESS2	shipping_address_street_2
SHIPTO.MAILADDRESS.CITY	shipping_address_city
SHIPTO.MAILADDRESS.STATE	shipping_address_state
SHIPTO.MAILADDRESS.ZIP	shipping_address_postalcode
SHIPTO.MAILADDRESS.COUNTRY	shipping_address_country
SHIPTO.FAX	phone_fax
DISPLAYCONTACT.EMAIL1	email1
DISPLAYCONTACT.PHONE1	phone_office
DISPLAYCONTACT.CELLPHONE	phone_alternate

 

Sugar Contacts to Intacct Contacts

Sugar Field	Intacct Field
name	CONTACTNAME
name	PRINTAS
first_name	FIRSTNAME
last_name	LASTNAME
email1	EMAIL1
phone_mobile	CELLPHONE
phone_home	PHONE2
phone_work	PHONE1
phone_fax	FAX
primary_address_street	MAILADDRESS.ADDRESS1
primary_address_city	MAILADDRESS.CITY
primary_address_state	MAILADDRESS.STATE
primary_address_postalcode	MAILADDRESS.ZIP
primary_address_country	MAILADDRESS.COUNTRY

 

Intacct Contacts to Sugar Contacts

Intacct Field	Sugar Field
PRINTAS	name
FIRSTNAME	first_name
LASTNAME	last_name
MAILADDRESS.ADDRESS1	primary_address_street
MAILADDRESS.ADDRESS2	primary_address_street_2
MAILADDRESS.CITY	primary_address_city
MAILADDRESS.STATE	primary_address_state
MAILADDRESS.ZIP	primary_address_postalcode
MAILADDRESS.COUNTRYCODE	primary_address_country
DISPLAYCONTACT.EMAIL1	email1
PHONE1	phone_work
PHONE2	phone_other
CELLPHONE	phone_mobile
PAGER	phone_other
FAX	phone_fax

 

Sugar Quotes to Intacct Sales Order (SODOCUMENT)

Sugar Field	Intacct Field
(Sugar Account's linked Intacct Customer) CUSTOMER.CUSTOMERID	CUSTOMERID
(Sugar Account's linked Intacct Customer) CUSTOMER.SHIPPINGMETHOD	SHIPPINGMETHOD
(Sugar Account's linked Intacct Customer) CUSTOMER.TERMNAME	TERMNAME
(Sugar Shipping Contact's linked Intacct Contact) CONTACT.CONTACTNAME	SHIPTO.CONTACTNAME
(Sugar Billing Contact's linked Intacct Contact) CONTACT.CONTACTNAME	BILLTO.CONTACTNAME
purchase_order_num|intacct_docid	REFERENCENO
date_quote_expected_closed	DATEDUE
id	EXTERNALID
(Sugar Location) intacct_location_id	LOCATIONID

Sugar Quoted Line Items to Intacct Sales Order Lines (SOTRANSITEMS)

Sugar Field	Intacct Field
(Sugar Product Catalog Item's linked Intacct Item ) ITEMID	ITEMID
(Sugar Product Catalog Item's related Sugar Location) id	LOCATIONID
(Sugar Product Catalog Item) intacct_baseuom|'Each'	UNIT
quantity	QUANTITY
(Intacct Default) warehouse	WAREHOUSEID
description	ITEMDESC
discount_amount_usdollar	DISCOUNTPERCENT
discount_usdollar - deal_calc_usdollar	PRICE

 

Intacct Sales Document (Sales Invoice, Sales Order, and Sales Quote) to Sugar Sales History 

Intacct Field	Sugar Field
DOCNO	docno
DOCID	docid
CREATEDFROM	createdfrom
STATE	state
CLOSED	closed
WHENCREATED	whencreated
WHENMODIFIED	whenmodified
WHENDUE	whendue
STATUS	status
PONUMBER	ponumber
VENDORDOCNO	vendordocno
DOCPARID	docparid
DOCPARKEY	docparkey
TERM.NAME	term_name
NOTE	note
WAREHOUSE.LOCATIONID	warehouse_locationid
SHIPVIA	shipvia
USER	user
CREATEDUSER	createduser
USERID	userid
CREATEUSERID	createuserid
SHIPTOKEY	shiptokey
BILLTOKEY	billtokey
MESSAGE	message
PRRECORDKEY	prrecordkey
INVBATCHKEY	invbatchkey
PRINVBATCHKEY	prinvbatchkey
PRINTED	printed
BACKORDER	backorder
SUBTOTAL	subtotal
TOTAL	total
ENTGLGROUP	entglgroup
CURRENCY	currency
EXCHRATEDATE	exchratedate
EXCHRATETYPES.NAME	exchratetypes_name
EXCHRATE	exchrate
SCHOPKEY	schopkey
SALESCONTRACT	salescontract
USEDASCONTRACT	usedascontract
RENEWEDDOC	reneweddoc
BASECURR	basecurr
SYSTEMGENERATED	systemgenerated
INVOICERUNKEY	invoicerunkey
CUSTVENDID	custvendid
CUSTVENDNAME	custvendname
HASPOSTEDREVREC	haspostedrevrec
CONTRACTID	contractid
CONTRACTDESC	contractdesc
TOTALPAID	totalpaid
TOTALENTERED	totalentered
TOTALDUE	totaldue
PAYMENTSTATUS	paymentstatus
VSOEPRICELIST	vsoepricelist
VSOEPRCLSTKEY	vsoeprclstkey
ORIGDOCDATE	origdocdate
HASADVBILLING	hasadvbilling
INVOICERUN.EXPENSEPRICEMARKUP	invoicerun_expensepricemarkup
INVOICERUN.DESCRIPTION	invoicerun_description
SUBTOTAL.SUBTOTAL	subtotal_subtotal
SUBTOTAL.FREIGHT	subtotal_freight

Intacct Sales Document Lines to Sugar Sales History Line Items

Intacct Field	Sugar Field
RECORDNO	recordno
DOCHDRNO	dochdrno
ITEMID	itemid
ITEMDESC	itemdesc
UNIT	unit
QUANTITY	quantity
RETAILPRICE	retailprice
PRICE	price
TOTAL	total
WHENCREATED	whencreated
STATUS	status
UIQTY	uiqty
UIPRICE	uiprice
UIVALUE	uivalue
ITEM.ITEMTYPE	item_itemtype
ITEM.REVPOSTING	item_revposting
ITEM.COMPUTEFORSHORTTERM	item_computeforshortterm
ITEM.UOMGRPKEY	item_uomgrpkey
ITEM.REVPRINTING	item_revprinting
CURRENCY	currency
EXCHRATE	exchrate
TRX_PRICE	trx_price
TRX_VALUE	trx_value

Intacct Items to Sugar Product Catalog

Intacct Field	Sugar Field	Hard coded
RECORDNO	fbsg_intacct_recordno
NAME	name
EXTENDED_DESCRIPTION	description
BASEUOM	intacct_baseuom	Y
PRODUCTTYPE	type (related record)	Y
PRODUCTLINEID	category (related record)	Y
INVPRICELISTENTRY.VALUE	list_price	Y
INVPRICELISTENTRY.VALUE	discount_price	Y
INVPRICELISTENTRY.VALUE	cost_price	Y
ITEMWAREHOUSEINFO.WONHAND	intacct_on_hand	Y