BizTalk Adapter for Zoho Books

Build 20.0.7654

ExpenseDetails

Get the details of an Expense.

Table Specific Information

Select

The {i 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 {i.
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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654