RecurringSubExpense
Retrieves list of child expenses created from recurring expense.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- RecurringExpenseId supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM RecurringSubExpense WHERE RecurringExpenseId = '1801553000000089750'
Columns
Name | Type | References | SupportedOperators | Description |
RecurringExpenseId [KEY] | String |
RecurringExpenses.RecurringExpenseId | Sort expenses. | |
AccountName | String | Name of the account. | ||
CustomerName | String | Name of the customer. | ||
Date | Date | Date of a recurring expense. | ||
ExpenseId | String |
Expenses.ExpenseId | Id of an expense. | |
PaidThroughAccountName | String | Name of the account from which payment was made. | ||
Status | String | Status of the recurring expense. | ||
Total | Decimal | Total of child expenses of recurring expenses. | ||
VendorName | String | Name of the vendor. |