RecurringExpenses
Retrieves list of all the Expenses.
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 本製品.
- AccountName supports the '=' comparison.
- CustomerName supports the '=' comparison.
- LastCreatedDate supports the '=,<,>' comparisons.
- NextExpenseDate supports the '=,<,>' comparisons.
- PaidThroughAccountName supports the '=' comparison.
- RecurrenceName supports the '=' comparison.
- Status supports the '=' comparison.
- CustomerId supports the '=' comparison.
- AccountId supports the '=' comparison.
- Amount supports the '=,<,<=,>,>=' comparisons.
- RecurringExpenseFilter supports the '=' comparison.
SELECT * FROM RecurringExpenses WHERE Amount = 500 AND PaidThroughAccountName = 'Petty Cash' AND RecurrenceName = 'Vehicle Rent'
SELECT * FROM RecurringExpenses WHERE LastCreatedDate > '2017-07-16'
Columns
| Name | Type | References | SupportedOperators | Description |
| RecurringExpenseId [KEY] | String | ID of recurring expense. | ||
| AccountName | String | Account name of an expense. | ||
| 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. | |
| CustomerName | String | Name of the customer. | ||
| Description | String | Description of the recurring expense. | ||
| IsBillable | Boolean | Check if recurring expense is billable or not. | ||
| LastCreatedDate | Date | =,<,> | Recurring expenses date on when last expense was generated. | |
| LastModifiedTime | Datetime | The time of last modification of the recurring expense. | ||
| NextExpenseDate | Date | =,<,> | Recurring expenses date on which next expense will be generated. | |
| PaidThroughAccountName | String | Name of the account from which expenses was paid. | ||
| RecurrenceName | String | Name of the recurrence. | ||
| Status | String | Status of a recurring expenses.
使用できる値は次のとおりです。active, stopped, expired | ||
| Total | Decimal | Total of recurring expenses. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| CustomerId | String | Id of a customer. | |
| AccountId | String | ID of the Bank Account. | |
| Amount | Decimal | Amount of a recurring expenses. | |
| RecurringExpenseFilter | String | Filter expenses by expense status.
使用できる値は次のとおりです。Status.All, Status.Active, Status.Expired, Status.Stopped |