ADO.NET Provider for Sage Intacct

Build 26.0.9655

EmployeeExpense

Represents employee expense reports, including reimbursement totals, non-reimbursable amounts, base payment details, and associated expense summary information.

Columns

Name Type ReadOnly Description
attachment_Href String True

The URL of the attachment associated with this employee expense.

attachment_Id String False

The Id of the attachment associated with this employee expense.

attachment_Key String False

The system-assigned key of the attachment associated with this employee expense.

auditCreatedBy String True

The user who created the employee expense.

auditCreatedDateTime Datetime True

The date and time when the employee expense was created.

auditModifiedBy String True

The user who last modified the employee expense.

auditModifiedDateTime Datetime True

The date and time when the employee expense was last modified.

basePaymentBaseCurrency String False

The base currency used for base payment amounts on this employee expense.

basePaymentPaidDate Date True

The date on which the base payment for this employee expense was made.

basePaymentTotalDue Decimal True

The total base currency amount due for this employee expense.

basePaymentTotalEntered Decimal True

The total base currency amount entered for this employee expense.

basePaymentTotalPaid Decimal True

The total base currency amount paid for this employee expense.

basePaymentTotalSelected Decimal True

The total base currency amount selected for payment on this employee expense.

createdDate Date False

The date on which the employee expense was created.

description String False

The description of the employee expense.

employee_Href String True

The URL of the employee associated with this expense.

employee_Id String False

The Id of the employee associated with this expense.

employee_Key String False

The system-assigned key of the employee associated with this expense.

entity_Href String True

The URL of the entity associated with this employee expense.

entity_Id String True

The Id of the entity associated with this employee expense.

entity_Key String True

The system-assigned key of the entity associated with this employee expense.

entity_Name String True

The name of the entity associated with this employee expense.

expenseReportNumber String False

The report number assigned to this employee expense.

expenseSummary_Href String True

The URL of the expense summary associated with this employee expense.

expenseSummary_Id String False

The Id of the expense summary associated with this employee expense.

expenseSummary_Key String False

The system-assigned key of the expense summary associated with this employee expense.

expenseSummary_PostingDate Date False

The posting date of the expense summary associated with this employee expense.

expenseSummary_PreventGLPosting Bool True

Indicates whether GL posting is prevented for the expense summary associated with this employee expense.

expenseSummary_State String True

The current state of the expense summary associated with this employee expense.

expenseSummary_Title String True

The title of the expense summary associated with this employee expense.

id String True

The unique identifier of the employee expense record.

key [KEY] String True

The system-assigned key that uniquely identifies the employee expense record.

memo String False

The memo or notes associated with this employee expense.

nonReimbursableBaseTotalEntered Decimal True

The total non-reimbursable amount entered in the base currency for this employee expense.

nonReimbursableReimbursementTotalEntered Decimal True

The total non-reimbursable amount entered in the reimbursement currency for this employee expense.

reimbursementReimbursementCurrency String False

The currency used for reimbursement amounts on this employee expense.

reimbursementTotalDue Decimal True

The total reimbursement amount due for this employee expense.

reimbursementTotalEntered Decimal True

The total reimbursement amount entered for this employee expense.

reimbursementTotalPaid Decimal True

The total reimbursement amount paid for this employee expense.

reimbursementTotalSelected Decimal True

The total reimbursement amount selected for payment on this employee expense.

state String False

The current state of this employee expense, such as draft, submitted, or approved.

ListAggregate_Lines String False

The aggregate list of expense lines associated with this employee expense.

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