RecurringExpenseDetails
To list, add, update and delete details of a recurring expense.
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 本製品.
Note: RecurringExpenseId is required in order to query RecurringExpenseDetails.
- RecurringExpenseId supports the '=' comparison.
SELECT * FROM RecurringExpenseDetails WHERE RecurringExpenseId = '1801553000000089750'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
RecurringExpenseId [KEY] | String | True |
RecurringExpenses.RecurringExpenseId |
Id of a recurring expense. | |
AccountId | String | False |
BankAccounts.AccountId |
ID of the Bank Account | |
AccountName | String | True |
Name of the account. | ||
Amount | Decimal | False |
Amount of the recurring expenses. | ||
BcyTotal | Decimal | True |
Total Base Currency. | ||
CreatedTime | Datetime | True |
Time at which the recurring expense was created. | ||
CurrencyCode | String | True |
Currency code of the customer's currency. | ||
CurrencyId | String | False |
Currencies.CurrencyId |
Currency ID of the customer's currency. | |
CustomerId | String | False |
Contacts.ContactId |
ID of the customer or vendor. | |
CustomerName | String | True |
Name of the customer or vendor. | ||
Description | String | True |
Description of the recurring expense. | ||
EmployeeEmail | String | True |
Email of an employee. | ||
EmployeeId | String | True |
Employees.EmployeeId |
Id of an employee. | |
EmployeeName | String | True |
Name of an employee. | ||
EndDate | Date | False |
End date of a recurring expense. | ||
ExchangeRate | Decimal | False |
Exchange rate of a recurring expense. | ||
IsBillable | Boolean | False |
Check if recurring expense is billable. | ||
IsInclusiveTax | Boolean | False |
Check if recurring expense is inclusive tax. | ||
IsPreGst | Boolean | True |
Check if recurring expense is pre GST. | ||
LastCreatedDate | Date | True |
Last created date of a recurring expense. | ||
LastModifiedTime | Datetime | True |
The time of last modification of the recurring expense. | ||
MileageRate | Double | True |
Mileage rate for a particular mileage expense. | ||
MileageUnit | String | True |
Unit of the distance travelled. | ||
NextExpenseDate | Date | True |
Next date of expense to be paid. | ||
PaidThroughAccountId | String | True |
BankAccounts.AccountId |
Account ID from which expense is paid through. | |
PaidThroughAccountName | String | True |
Account name from which expense is paid through. | ||
ProjectId | String | False |
Projects.ProjectId |
ID of a project. | |
ProjectName | String | True |
Name of the project. | ||
RecurrenceFrequency | String | False |
Frequency of a recurrence. | ||
RecurrenceName | String | False |
Name of a recurrence | ||
RepeatEvery | Integer | False |
Recurrence time of an expense. | ||
StartDate | Date | False |
Start date of recurring expense. | ||
Status | String | True |
Status of the recurring expense. | ||
SubTotal | Decimal | True |
Sub total of recurring expenses. | ||
Tags | String | True |
Details of tags related to recurring expenses. | ||
TaxAmount | Decimal | True |
Amount of a tax. | ||
TaxId | String | False |
Taxes.TaxId |
Id of a tax. | |
TaxName | String | True |
Name of a tax. | ||
TaxPercentage | Integer | True |
Percentage of a tax. | ||
Total | Decimal | True |
Total of recurring expenses. | ||
VendorId | String | True |
ID of the vendor the recurring expense has been made. | ||
VendorName | String | True |
Name of the vendor the recurring expense has been made. | ||
GstNo | String | False |
GST number. | ||
SourceOfSupply | String | False |
Place from where the goods/services are supplied. (If not given, place of contact given for the contact will be taken). | ||
DestinationOfSupply | String | False |
Place where the goods/services are supplied to. | ||
PlaceOfSupply | String | False |
The place of supply is where a transaction is considered to have occurred for VAT purposes. | ||
LineItems | String | False |
Line items of an estimate. | ||
VatTreatment | String | False |
VAT treatment for the bills. | ||
TaxTreatment | String | False |
VAT treatment for the Bill. | ||
ProductType | String | False |
Type of the journal. This denotes whether the journal is to be treated as goods or service. | ||
AcquisitionVatId | String | False |
This is the ID of the tax applied in case this is an EU - goods expense and acquisition VAT needs to be reported. | ||
ReverseChargeVatId | String | False |
This is the ID of the tax applied in case this is a non UK - service expense and reverse charge VAT needs to be reported. |