Project - Sage Intacct Data Target Requirements

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

Projects enable services companies to automate many of the functions of project management.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
RECORDNO	RECORDNO	Record number	Yes/Optional	Required for Update/Delete if not using `PROJECTID`.
ACTIVE	STATUS	Status	Optional	Expected value of true or false.
APPURCHASINGPRICINGOPTION	POAPPRICING	AP/PO pricing option	Optional	AP/purchasing pricing option. Expected value is free text
APPURCHASINGPRICINGRATE	POAPRATE	AP/purchasing pricing default rate	Optional	AP/purchasing pricing default rate. Expected value is numeric
ATTACHMENTSID	SUPDOCID	Attachment	Optional	Attachments ID. Expected value is free text
BEGINDATE	BEGINDATE	Begin date	Optional	Begin date in format `mm/dd/yyyy`
BILLABLEAPPURCHASING	BILLABLEAPPODEFAULT	Billable AP / PO	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
BILLABLEEMPLOYEEEXPENCE	BILLABLEEXPDEFAULT	Billable employee expenses	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
BILLINGCOST	BUDGETEDCOST	Budgeted cost	Optional	Expected value is decimal
BILLINGTYPE	BILLINGTYPE	Billing type	Optional	Expected value is free text
BILLTOCONTACTNAME	BILLTO.CONTACTNAME	Bill-to contact	Optional	Expected value is free text (200)
BUDGETEDBILLINGAMOUNT	BUDGETAMOUNT	Budgeted billing amount	Optional	Expected value is decimal
BUDGETEDDURATION	BUDGETQTY	Budgeted duration (hours)	Optional	Expected value is decimal
CATEGORY	PROJECTCATEGORY	Project category	Yes	Expected value is free text
CLASSID	CLASSID	Class ID	Optional	Expected value is free text
CONTRACTAMOUNT	CONTRACTAMOUNT	Contract amount	Optional	Expected value is decimal
CURRENCY	CURRENCY	Project currency	Optional	Expected value is free text
CUSTOMERID	CUSTOMERID	Customer ID	Optional	Expected value is free text
DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Expected value is free text (40)
DESCRIPTION	DESCRIPTION	Description	Optional	Expected value is free text (4000)
ENDDATE	ENDDATE	End date	Optional	End date in format `mm/dd/yyyy`
EXPENSEPRICINGOPTION	EXPENSEPRICING	Expense pricing option	Optional	Expected value is free text
EXPENSIVEPRICINGDEFAULTRATE	EXPENSERATE	Default expense rate/fee %	Optional	Expected value is decimal
EXTERNALUSERID	CUSTUSERID	External user ID	Optional	Expected value is free text
GLBUDGETID	BUDGETID	GL budget ID	Optional	Expected value is free text
ID	PROJECTID	Project ID	Yes	Required if not using `RECORDNO`. Expected value is free text
INVOICECURRENCY	INVOICECURRENCY	Invoice currency override	Optional	Expected value is free text
INVOICEMESSAGE	INVOICEMESSAGE	Invoice message	Optional	Expected value is free text (4000)
INVOICEWITHPARENT	INVOICEWITHPARENT	Invoice with parent	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `false`)
LABORPRICINGDEFAULTRATE	BILLINGRATE	Default labor rate/fee %	Optional	Expected value is decimal
LABORPRICINGOPTION	BILLINGPRICING	Labor pricing option	Optional	Expected value is free text
LOCATIONID	LOCATIONID	Location ID	Optional	Expected value is free text (40)
MANAGERID	MANAGERID	Project manager ID	Yes/Optional	Project manager employee ID. Expected value is free text
NAME	NAME	Project name	Optional	Expected value is free text (200)
PARENTPROJECTID	PARENTID	Parent project ID	Optional	Expected value is free text
PAYMENTTERMS	TERMNAME	Term	Optional	Expected value is free text
PRIMARYCONTACTNAME	CONTACTINFO.CONTACTNAME	Primary contact	Optional	Expected value is free text (200)
PURCHASEORDERAMOUNT	POAMOUNT	Purchase order amount	Optional	Expected value is decimal
PURCHASEORDERNO	PONUMBER	Purchase order number	Optional	Expected value is free text (40)
REFERENCENO	DOCNUMBER	Reference number	Optional	Expected value is free text (120)
SALESCONTACTID	SALESCONTACTID	Sales contact	Optional	Expected value is free text
SALESORDERNO	SONUMBER	Sales order number	Optional	Expected value is free text (40)
SHIPTOCONTACTNAME	SHIPTO.CONTACTNAME	Ship-to contact	Optional	Expected value is free text (200)
STATUS	PROJECT STATUS	Project Status	Optional	Expected value is free text
TYPE	PROJECTTYPE	Project type	Optional	Expected value is free text
USERRESTRICTIONS	USERRESTRICTIONS	Timesheet and expense user restrictions	Optional	Expected value is free text