MuleSoft Connector for Zoho Books

Build 20.0.7654

RecurringExpenseDetails

Get the details of a recurring expense.

Table Specific Information

Select

The connector 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 connector.
Note: RecurringExpenseId is required in order to query RecurringExpenseDetails.

  • RecurringExpenseId supports the '=' comparison.
For example:
    SELECT * FROM RecurringExpenseDetails WHERE RecurringExpenseId = '1801553000000089750'

Columns

Name Type References SupportedOperators Description
RecurringExpenseId [KEY] String

RecurringExpenses.RecurringExpenseId

Id of a recurring expense.
AccountId String

BankAccounts.AccountId

ID of the Bank Account
AccountName String Name of the account.
Amount Decimal Amount of the recurring expenses.
BcyTotal Decimal Total Base Currency.
CreatedTime Datetime Time at which the recurring 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.
Description String Description of the recurring expense.
EmployeeEmail String Email of an employee.
EmployeeId String

Employees.EmployeeId

Id of an employee.
EmployeeName String Name of an employee.
EndDate Date End date of a recurring expense.
ExchangeRate Decimal Exchange rate of a recurring expense.
IsBillable Boolean Check if recurring expense is billable.
IsInclusiveTax Boolean Check if recurring expense is inclusive tax.
IsPreGst Boolean Check if recurring expense is pre GST.
LastCreatedDate Date Last created date of a recurring expense.
LastModifiedTime Datetime The time of last modification of the recurring expense.
MileageRate Double Mileage rate for a particular mileage expense.
MileageUnit String Unit of the distance travelled.
NextExpenseDate Date Next date of expense to be paid.
PaidThroughAccountId String

BankAccounts.AccountId

Account ID from which expense is paid through.
PaidThroughAccountName String Account name from which expense is paid through.
ProjectId String

Projects.ProjectId

ID of a project.
ProjectName String Name of the project.
RecurrenceFrequency String Frequency of a recurrence.
RecurrenceName String Name of a recurrence
RepeatEvery Integer Recurrence time of an expense.
StartDate Date Start date of recurring expense.
Status String Status of the recurring expense.
SubTotal Decimal Sub total of recurring expenses.
Tags String Details of tags related to recurring expenses.
TaxAmount Decimal Amount of a tax.
TaxId String

Taxes.TaxId

Id of a tax.
TaxName String Name of a tax.
TaxPercentage Integer Percentage of a tax.
Total Decimal Total of recurring expenses.
VendorId String ID of the vendor the recurring expense has been made.
VendorName String Name of the vendor the recurring expense has been made.

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