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. |