ExpenseDetails

Get the details of an Expense.

Table Specific Information

Select

The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: ExpenseId is required in order to query ExpenseDetails.

ExpenseId supports the '=' comparison.

For example:

    SELECT * FROM ExpenseDetails WHERE ExpenseId = '1894553000000077244'

Columns


Name	Type	References	SupportedOperators	Description
ExpenseId [KEY]	String	Expenses.ExpenseId		Id of an expense.
AccountId	String	BankAccounts.AccountId		ID of the Bank Account.
AccountName	String			Name of the account.
Amount	Decimal			Amount of the expenses.
ApproverEmail	String			Email of an approver.
ApproverId	String	Users.UserId		Id of an approver.
ApproverName	String			Name of an approver.
BcySurchargeAmount	Decimal			Surcharge amount of Base Currency.
BcyTotal	Decimal			Total Base Currency.
CreatedById	String	Users.UserId		Id of a user who has created expense.
CreatedTime	Datetime			Time at which the Expense was created.
CurrencyCode	String			Currency code of the customer's currency.
CurrencyId	String	Currencies.CurrencyId		Currency ID of the customer's currency.
CustomerId	String	Contacts.ContactId		ID of the customer or vendor.
CustomerName	String			Name of the customer or vendor.
Date	Date			Expense date.
Description	String			Description of the expense.
EmployeeEmail	String			Email ID of an employee.
EmployeeId	String	Employees.EmployeeId		ID of an employee.
EmployeeName	String			Name of an employee.
EndReading	String			End Reading of the Odometer.
ExchangeRate	Decimal			Exchange rate of the currency.
ExpenseItemId	String			Item ID of an expense.
ExpenseReceiptName	String			Receipt name of an expense.
ExpenseReceiptType	String			Receipt type of an expense.
ExpenseType	String			Type of expense.
FcySurchargeAmount	Decimal			Surcharge amount of Foreign Currency.
InvoiceConversionType	String			Type of invoice conversion.
InvoiceId	String	Invoices.InvoiceId		ID of an invoice.
InvoiceNumber	String			Number of an invoice.
IsBillable	Boolean			Check if the expense is billable.
IsInclusiveTax	Boolean			Check if the expense is inclusive tax.
IsPersonal	Boolean			Check if the expense is personal.
IsPreGst	Boolean			Check if the pre GST is applied in the expense.
IsRecurringApplicable	Boolean			Check if the recurring is applicable.
IsReimbursable	Boolean			Check if the expense is reimbursable.
IsSurchargeApplicable	Boolean			Check if the surcharge is applicable in this expense.
LastModifiedById	String	Users.UserId		Id of the user last modified.
LastModifiedTime	Datetime			The time of last modification of the expense.
Location	String			Location of the expense.
MerchantId	String			ID of the merchant.
MerchantName	String			Name of the merchant.
MileageRate	Double			Mileage rate for a particular mileage expense.
MileageType	String			Type of Mileage.
MileageUnit	String			Unit of the distance travelled.
PaidThroughAccountId	String	BankAccounts.AccountId		Account ID from which expense amount was paid.
PaidThroughAccountName	String			Account name from which expense amount was paid.
PaymentMode	String			Mode through which payment is made.
ProjectId	String	Projects.ProjectId		ID of the project.
ProjectName	String			Name of the project.
ReferenceNumber	String			Reference number of expense.
ReportId	String			ID of the report.
ReportName	String			Name of the report.
ReportNumber	String			Number of the report.
ReportStatus	String			Status of the report.
StartReading	String			Start Reading of the Odometer.
Status	String			Status of the expense.
SubTotal	Decimal			Sub total of expenses.
Tags	String			Details of tags related to expenses.
TaxAmount	Decimal			Amount of tax.
TaxId	String	Taxes.TaxId		Id of tax.
TaxName	String			Name of tax.
TaxPercentage	Integer			Percentage of tax.
Total	Decimal			Total of expenses.
TransactionType	String			Type of the Transaction.
TripId	String			ID of a trip.
TripNumber	String			Number of a trip.
UserEmail	String			Email ID of a User.
UserId	String	Users.UserId		ID of a user.
UserName	String			Name of a user.
VehicleId	String			ID of a vehicle.
VehicleName	String			Name of a vehicle.
VendorId	String			ID of the vendor the expenses has been made.
VendorName	String			Name of the vendor the expenses has been made.

Power BI Connector for Zoho Books

ExpenseDetails

Table Specific Information

Select

Columns