Expense Reports - Sage Intacct Data Target Requirements

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

Expense report for an employee.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTION	STATE	State	Optional	Use `Draft` or `Submitted`. (Default: `Submitted`)
ATTACHMENTSID	SUPDOCID	Attachment	Optional	Expected value is free text (30)
BASECURRENCY	BASECURR	Base currency	Yes/Optional	Expected value is free text
BILLABLE	BILLABLE	Billable	Optional	Check Box. Use `false` for No, `true` for Yes. (Default: `false`)
CLASSID	CLASSID	Class	Optional	Expected value is free text (50)
CONTRACTID	CONTRACTID	Contract	Optional	Expected value is free text (20)
CUSTOMERID	CUSTOMERID	Customer	Optional	Expected value is free text (20)
DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Expected value is free text
EMPLOYEEID	EMPLOYEEID	Employee	Yes	Expected value is free text (20)
EXCHANGERATEDATE	ORG_EXCHRATEDATE	Exchange rate date	Yes/Optional	Expected value is date
EXCHANGERATETYPE	ORG_EXCHRATETYPE	Exchange rate type	Yes/Optional	Expected value is free text (40)
EXCHANGERATEVALUE	ORG_EXCHRATE	Exchange rate	Optional	Expected value is decimal
EXPENSEDATE	EXPENSEDATE	Expense date	Yes	Expected value is date
EXPENSEREPORTNUM	EXPENSEREPORTNO	Expense report number	Yes/Optional	Expected value is free text
EXPENSETYPE	EXPENSETYPE	Expense type	Yes/Optional	Required if not using `glaccountno`
EXTERNALID	EXTERNALID	External ID	Optional	Expected value is free text
FORM1099	FORM1099	Form 1099	Optional	Use `false` for No, `true` for Yes. Employee must be set up for 1099s.
GLACCOUNTNUMBER	GLACCOUNTNO	Account number	Optional	Expected value is free text (24). Required if not using `expensetype`.
GLPOSTINGDATE	DATEPOSTED	GL posting date	Yes	GL posting date
ITEMID	ITEMID	Item	Optional	Expected value is free text (30)
LINEEMPLOYEEID	EMPLOYEEID	Employee	Optional	Expected value is free text (20)
LOCATIONID	LOCATIONID	Location	Optional	Expected value is free text (40)
MEMO	MEMO	Memo	Optional	Expected value is free text
PAIDFOR	DESCRIPTION	Paid for	Optional	Expected value is free text (1000)
PAIDTO	DESCRIPTION	Paid to	Optional	Expected value is free text (1000)
PAYMENTTYPENAME	PAYMENTTYPE	Payment method	Optional	Expected value is free text (21)
PROJECTID	PROJECTID	Project	Optional	Expected value is free text (20)
QUANTITY	QTY	Quantity	Optional	Expected value is decimal
REASON	DESCRIPTION	Reason for expense	Optional	Expected value is free text (1000)
RECORDNO	RECORDNO	Record number	Optional	Record name
REIMBURSEMENTAMOUNT	PAYMENTAMOUNT	Payment amount	Optional	Expected value is decimal
REIMBURSEMENTCURRENCY	CURRENCY	Payment currency	Optional	Expected value is free text (3)
SUMMARYRECORDNO	BATCHKEY	Summary record number	Optional	Expected value is integer
TRANSACTIONAMOUNT	ORG_AMOUNT	Transaction amount	Yes	Expected value is decimal
TRANSACTIONCURRENCY	ORG_CURRENCY	Transaction currency	Yes/Optional	Expected value is free text
TRANSACTIONDATE	PAYMENTDATE	Date	Yes	Date
TRX_TAX	TRANSACTION TAX	TRANSACTION TAX (override)	Optional (to override the calculated value for the tax)	Manually calculated value to override the calculated value for the tax.
UNITRATE	UNITRATE	Unit rate	Optional	Expected value is decimal
VENDORID	VENDORID	Vendor	Optional	Expected value is free text (20)
WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Expected value is free text (40)