API Data Provider - Online Help

ExpenseDetails

Returns the details of an expense.

Columns

Name Type References
OrganizationId Long

Organizations.OrganizationId

ExpenseId [KEY] Long

Expenses.ExpenseId

AccountId Long
AccountName String
Amount Double
Total Double
ApproverEmail String
ApproverId String
ApproverName String
BcySurchargeAmount Double
BcyTotal Double
CreatedById String
CreatedTime Datetime
CurrencyCode String
CurrencyId String
CustomFields String
CustomerId String
CustomerName String
Date Date
Description String
Documents String
EmployeeEmail String
EmployeeId String
EmployeeName String
EndReading String
ExchangeRate Double
ExpenseItemId String
ExpenseReceiptName String
ExpenseReceiptType String
ExpenseType String
FcySurchargeAmount Double
InvoiceId String
InvoiceNumber String
IsBillable Boolean
IsInclusiveTax Boolean
IsPersonal Boolean
IsRecurringApplicable Boolean
IsReimbursable Boolean
IsSurchargeApplicable Boolean
LastModifiedById String
LastModifiedTime Datetime
LineItems String
Location String
MarkupPercent Double
MerchantId String
MerchantName String
MileageRate Double
MileageType String
MileageUnit String
PaymentMode String
ProjectId String
ProjectName String
ReferenceNumber String
ReportId String
ReportName String
ReportNumber String
ReportStatus String
StartReading String
Status String
SubTotal Double
TaxAmount Double
TaxId String
TaxName String
TaxPercentage Integer
Taxes String
TransactionType String
TripId String
TripNumber String
UserEmail String
UserId String
UserName String
VehicleId String
VehicleName String
ZcrmPotentialId String
ZcrmPotentialName String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0