Expenses
Retrieves list of all the Expenses.
Table Specific Information
Select
- AccountName supports the '=' comparison.
- CustomerId supports the '=' comparison.
- CustomerName supports the '=' comparison.
- Description supports the '=' comparison.
- PaidThroughAccountName supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- Status supports the '=' comparison.
- VendorId supports the '=' comparison.
- VendorName supports the '=' comparison.
- RecurringExpenseId supports the '=' comparison.
- ExpenseFilter supports the '=' comparison.
- Date supports the '=,<,>' comparisons.
- Amount supports the '=,<,<=,>,>=' comparisons.
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators: The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM Expenses WHERE Amount < 10000.0 AND Amount > 300.0
SELECT * FROM Expenses WHERE ExpenseFilter = 'Status.Billable'
Columns
| Name | Type | References | SupportedOperators | Description |
| ExpenseId [KEY] | String | Id of an expense. | ||
| AccountName | String | Name of the account. | ||
| BcyTotal | Decimal | Total Base Currency. | ||
| BcyTotalWithoutTax | Decimal | Base Currency total amount without tax. | ||
| CreatedTime | Datetime | Time at which the 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. | ||
| Date | Date | =,<,> | Date of an expense. | |
| Description | String | Description of the expense. | ||
| Distance | Double | Distance Covered. | ||
| EndReading | String | End reading of odometer when creating a mileage expense where mileage_type is odometer. | ||
| ExchangeRate | Decimal | Exchange rate of the currency. | ||
| ExpenseReceiptName | String | Name of the expense receipt. | ||
| ExpenseType | String | Type of an expense. | ||
| HasAttachment | Boolean | Check if the expense has attachment. | ||
| IsBillable | Boolean | Check if the expense is billable. | ||
| IsPersonal | Boolean | Check if the expense is personal. | ||
| LastModifiedTime | Datetime | The time of last modification of the expense. | ||
| MileageRate | Double | Mileage rate for a particular mileage expense. | ||
| MileageType | String | Type of Mileage. | ||
| MileageUnit | String | Unit of the distance travelled. | ||
| PaidThroughAccountName | String | Name of account which payment was paid. | ||
| ReferenceNumber | String | Reference number of a expense. | ||
| ReportId | String | Id of report. | ||
| ReportName | String | Name of the report. | ||
| StartReading | String | Start reading of odometer when creating a mileage expense where mileage_type is odometer. | ||
| Status | String | Status of the expense.
The allowed values are unbilled, invoiced, reimbursed, non-billable, billable. | ||
| Total | Decimal | Total of expenses. | ||
| TotalWithoutTax | Decimal | Total amount of expense calculated without tax. | ||
| VendorId | String | Id of the vendor the expense has been made. | ||
| VendorName | String | Name of the vendor the expense has been made. |
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 | |
| Amount | Decimal | Amount of the expenses. | |
| ExpenseFilter | String | Filter expenses by their status.
The allowed values are Status.All, Status.Billable, Status.Nonbillable, Status.Reimbursed, Status.InvoicedStatus.Unbilled. | |
| RecurringExpenseId | String | Id of the recurring expense. |