RecurringExpenseDetails

Get the details of a recurring 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: 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.

BizTalk Adapter for Zoho Books

RecurringExpenseDetails

Table Specific Information

Select

Columns