Expenses
Retrieves list of all the Expenses.
Table Specific Information
Select
The connector 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 connector.
- 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.
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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。Status.All, Status.Billable, Status.Nonbillable, Status.Reimbursed, Status.InvoicedStatus.Unbilled | |
RecurringExpenseId | String | Id of the recurring expense. |