ADO.NET Provider for Sage Intacct

Build 26.0.9655

EmployeeExpenseLine

Represents individual line items on employee expense reports, capturing GL account allocations, expense types, payment types, credit card transaction links, and currency conversion details.

Columns

Name Type ReadOnly Description
auditCreatedBy String True

The user who created the employee expense line.

auditCreatedDateTime Datetime True

The date and time when the employee expense line was created.

auditModifiedBy String True

The user who last modified the employee expense line.

auditModifiedDateTime Datetime True

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

baseAmount Decimal True

The amount of this expense line in the base currency.

creditCardTxnLine_Href String True

The URL of the credit card transaction line associated with this expense line.

creditCardTxnLine_Id String False

The Id of the credit card transaction line associated with this expense line.

creditCardTxnLine_Key String False

The system-assigned key of the credit card transaction line associated with this expense line.

creditCardTxn_Href String True

The URL of the credit card transaction associated with this expense line.

creditCardTxn_Id String True

The Id of the credit card transaction associated with this expense line.

creditCardTxn_Key String True

The system-assigned key of the credit card transaction associated with this expense line.

electronicReceiptLine_Href String True

The URL of the electronic receipt line associated with this expense line.

electronicReceiptLine_Id String False

The Id of the electronic receipt line associated with this expense line.

electronicReceiptLine_Key String False

The system-assigned key of the electronic receipt line associated with this expense line.

electronicReceipt_Href String True

The URL of the electronic receipt associated with this expense line.

electronicReceipt_Id String False

The Id of the electronic receipt associated with this expense line.

electronicReceipt_Key String False

The system-assigned key of the electronic receipt associated with this expense line.

employeeExpense_Href String True

The URL of the employee expense associated with this line.

employeeExpense_Id String False

The Id of the employee expense associated with this line.

employeeExpense_Key String False

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

entryDate Date False

The date on which this expense line was entered.

expenseType_Href String True

The URL of the expense type associated with this expense line.

expenseType_Id String False

The Id of the expense type associated with this expense line.

expenseType_Key String False

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

form1099Box String False

The Form 1099 box number associated with this expense line.

form1099IsForm1099 String False

Indicates whether this expense line is subject to Form 1099 reporting.

form1099Type String False

The Form 1099 type associated with this expense line.

glAccount_Href String True

The URL of the GL account associated with this expense line.

glAccount_Id String False

The Id of the GL account associated with this expense line.

glAccount_Key String False

The system-assigned key of the GL account associated with this expense line.

glAccount_Name String True

The name of the GL account associated with this expense line.

href String True

The URL of the employee expense line resource.

id String True

The unique identifier of the employee expense line record.

isBillable Bool False

Indicates whether this expense line is billable to a customer or project.

isBilled Bool True

Indicates whether this expense line has been billed.

key [KEY] String True

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

lineNumber Decimal True

The sequential line number of this expense line within the expense report.

paidFor String False

The description of what this expense line was paid for.

paidTo String False

The name of the person or vendor to whom this expense line was paid.

paymentType_Href String True

The URL of the payment type associated with this expense line.

paymentType_Id String False

The Id of the payment type associated with this expense line.

paymentType_IsNonReimbursable Bool True

Indicates whether the payment type associated with this expense line is non-reimbursable.

paymentType_Key String False

The system-assigned key of the payment type associated with this expense line.

quantity Decimal False

The quantity for this expense line.

reimburseToBaseConversionExchangeRate Decimal True

The exchange rate used to convert the reimbursement currency to the base currency for this expense line.

reimburseToBaseConversionExchangeRateDate Date True

The date of the exchange rate used to convert the reimbursement currency to the base currency for this expense line.

reimburseToBaseConversionExchangeRateTypeId String True

The Id of the exchange rate type used to convert the reimbursement currency to the base currency for this expense line.

reimbursementAmount Decimal True

The reimbursement amount for this expense line.

state String True

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

totalPaid Decimal True

The total amount paid for this expense line.

totalSelected Decimal True

The total amount selected for payment on this expense line.

transactionToReimburseConversionExchangeRate Decimal False

The exchange rate used to convert the transaction currency to the reimbursement currency for this expense line.

transactionToReimburseConversionExchangeRateDate Date False

The date of the exchange rate used to convert the transaction currency to the reimbursement currency for this expense line.

transactionToReimburseConversionExchangeRateTypeId String False

The Id of the exchange rate type used to convert the transaction currency to the reimbursement currency for this expense line.

txnAmount Decimal False

The amount of this expense line in the transaction currency.

unitRate Decimal False

The unit rate applied to the quantity for this expense line.

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