ADO.NET Provider for Exact Online

Build 26.0.9655

ExpenseReports

Use this endpoint to create, read, update and delete expense reports. Expense reports contain data on employee cost claims, including submission status, approval workflows, and monetary amounts.

Columns

Name Type ReadOnly Description
ID [KEY] String False

Primary key

ApprovedDate Datetime False

Date when the expense report was approved

Approver String False

User who approved the expense report

ApproverComment String False

Additional approver comment

ApproverFullName String False

Name of the user who approved the expense report

Claimant String False

The claimant (employee) who owns this expense report

ClaimantFullName String False

Name of the claimant

ControlledDate Datetime False

Date when the expense report was controlled

Controller String False

User who controlled the expense report

ControllerFullName String False

Name of the user who controlled the expense report

Created Datetime False

Date when the expense report was created

Creator String False

User ID of the creator

CreatorFullName String False

Name of the creator

Currency String False

Currency code of the expense report

Description String False

Description of the expense report

Division Int False

The division to which the expense report belongs

ExpenseCount Int False

Number of expense items in the report

Modified Datetime False

Date when the expense report was last modified

Modifier String False

User ID of the modifier

ModifierFullName String False

Name of the modifier

RejectedDate Datetime False

Date when the expense report was rejected

Rejecter String False

User who rejected the expense report

RejecterFullName String False

Name of the user who rejected the expense report

ReportNumber Int False

The expense report number

Status Int False

Status of the expense report

StatusDescription String False

Status description of the expense report

SubmittedDate Datetime False

Date when the expense report was submitted

Submitter String False

User who submitted the expense report

SubmitterFullName String False

Name of the user who submitted the expense report

TotalAmountDC Double False

Total amount of the expense report in division currency

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655