ADO.NET Provider for Sage Intacct

Build 26.0.9655

ExpenseToApproveLine

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

Columns

Name Type Description
auditCreatedBy String The user who created the expense to approve line.
auditCreatedDateTime Datetime The date and time when the expense to approve line was created.
auditModifiedBy String The user who last modified the expense to approve line.
auditModifiedDateTime Datetime The date and time when the expense to approve line was last modified.
baseAmount Decimal The amount of this expense line in the base currency.
creditCardTxnLine_Href String The URL of the credit card transaction line associated with this expense line.
creditCardTxnLine_Id String The Id of the credit card transaction line associated with this expense line.
creditCardTxnLine_Key String The system-assigned key of the credit card transaction line associated with this expense line.
creditCardTxn_Href String The URL of the credit card transaction associated with this expense line.
creditCardTxn_Id String The Id of the credit card transaction associated with this expense line.
creditCardTxn_Key String The system-assigned key of the credit card transaction associated with this expense line.
electronicReceiptLine_Href String The URL of the electronic receipt line associated with this expense line.
electronicReceiptLine_Id String The Id of the electronic receipt line associated with this expense line.
electronicReceiptLine_Key String The system-assigned key of the electronic receipt line associated with this expense line.
electronicReceipt_Href String The URL of the electronic receipt associated with this expense line.
electronicReceipt_Id String The Id of the electronic receipt associated with this expense line.
electronicReceipt_Key String The system-assigned key of the electronic receipt associated with this expense line.
entryDate Date The date on which this expense line was entered.
expenseToApprove_Id String The Id of the expense to approve associated with this line.
expenseToApprove_Key String The system-assigned key of the expense to approve associated with this line.
expenseType_Href String The URL of the expense type associated with this expense line.
expenseType_Id String The Id of the expense type associated with this expense line.
expenseType_Key String The system-assigned key of the expense type associated with this expense line.
form1099Box String The Form 1099 box number associated with this expense line.
form1099IsForm1099 String Indicates whether this expense line is subject to Form 1099 reporting.
form1099Type String The Form 1099 type associated with this expense line.
glAccount_Href String The URL of the GL account associated with this expense line.
glAccount_Id String The Id of the GL account associated with this expense line.
glAccount_Key String The system-assigned key of the GL account associated with this expense line.
glAccount_Name String The name of the GL account associated with this expense line.
id String The unique identifier of the expense to approve line record.
isBillable Bool Indicates whether this expense line is billable to a customer or project.
isBilled Bool Indicates whether this expense line has been billed.
key [KEY] String The system-assigned key that uniquely identifies the expense to approve line record.
lineNumber Decimal The sequential line number of this expense line within the expense report.
paidFor String The description of what this expense line was paid for.
paidTo String The name of the person or vendor to whom this expense line was paid.
paymentType_Href String The URL of the payment type associated with this expense line.
paymentType_Id String The Id of the payment type associated with this expense line.
paymentType_IsNonReimbursable Bool Indicates whether the payment type associated with this expense line is non-reimbursable.
paymentType_Key String The system-assigned key of the payment type associated with this expense line.
paymentType_Name String The name of the payment type associated with this expense line.
quantity Decimal The quantity for this expense line.
reimburseToBaseConversionExchangeRate Decimal The exchange rate used to convert the reimbursement currency to the base currency for this expense line.
reimburseToBaseConversionExchangeRateDate Date The date of the exchange rate used to convert the reimbursement currency to the base currency for this expense line.
reimburseToBaseConversionExchangeRateTypeId String The Id of the exchange rate type used to convert the reimbursement currency to the base currency for this expense line.
reimbursementAmount Decimal The reimbursement amount for this expense line.
state String The current state of this expense line, such as draft, submitted, or approved.
totalPaid Decimal The total amount paid for this expense line.
totalSelected Decimal The total amount selected for payment on this expense line.
transactionToReimburseConversionExchangeRate Decimal The exchange rate used to convert the transaction currency to the reimbursement currency for this expense line.
transactionToReimburseConversionExchangeRateDate Date The date of the exchange rate used to convert the transaction currency to the reimbursement currency for this expense line.
transactionToReimburseConversionExchangeRateTypeId String The Id of the exchange rate type used to convert the transaction currency to the reimbursement currency for this expense line.
txnAmount Decimal The amount of this expense line in the transaction currency.
unitRate Decimal The unit rate applied to the quantity for this expense line.

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