Expenses

Use this endpoint to create, read, update and delete individual expense entries. Supports receipt, mileage, and per diem expense types with details on amounts, currencies, projects, and approval workflow.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	Expense ID
ApproverComment	String	False	Approver comment
Claimant	String	False	Employee who made the expense
ClaimantFullName	String	False	Full name of the employee who made the expense
Country	String	False	Country code (3 characters)
Currency	String	False	Currency code (3 characters)
Description	String	False	Description of the expense
Distance	Decimal	False	Distance (for mileage expenses)
DistanceUnit	Int	False	Distance unit: 1=KM, 2=MILE
DistanceUnitDescription	String	False	Distance unit description
Division	Int	False	Division expense belong to
DocumentId	String	False	Document ID associated with the expense
ExpenseDate	Datetime	False	Date of the expense
ExpenseNumber	Int	False	Expense number - auto-generated
ExpenseType	Int	False	Expense type: 1=Receipts, 2=Mileage, 3=Per Diem
ExpenseTypeDescription	String	False	Expense type description
MileageRate	String	False	Rate applied to mileage expenses
MileageRateDescription	String	False	Mileage rate description
PaymentMethod	Int	False	Payment method (0:Others , 1=Company Credit Card)
PerDiemRate	String	False	Per diem rate (for per diem expenses only)
PerDiemRateDescription	String	False	Per diem rate description
Project	String	False	Project associated with the expense
ProjectDescription	String	False	Project description
RateFC	Double	False	Rate in foreign currency
Report	String	False	Associated expense report
ReportDescription	String	False	Expense report description
Status	Int	False	Status: 1=Not reviewed, 2=Reviewed, 3=Flagged
StatusDescription	String	False	Status description
SysCreated	Datetime	False	Created date
SysCreator	String	False	Creator
SysCreatorFullName	String	False	Creator full name
SysModified	Datetime	False	Modified date
SysModifier	String	False	Modifier
SysModifierFullName	String	False	Modifier full name
TotalAmountDC	Double	False	Total amount in division currency
TotalAmountFC	Double	False	Total amount in foreign currency
LinkedExpenseLines	String	False	Receipt-type expense line items
LinkedWaypoints	String	False	Route location data for mileage expenses

ADO.NET Provider for Exact Online

Expenses

Columns