RecurringBills
To list, add, update and delete details of a bill.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- VendorId supports the '=' comparison.
- VendorName supports the '=, CONTAINS' comparisons.
- RecurrenceName supports the '=' comparison.
- Status supports the '=' comparison.
- StartDate supports the '=,<,>' comparisons.
- EndDate supports the '=' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM RecurringBills WHERE vendorid = '3255827000000081003' SELECT * FROM RecurringBills WHERE CONTAINS (vendorname, 'c') SELECT * FROM RecurringBills WHERE startdate > '2023-03-3'
Columns
Name | Type | References | SupportedOperators | Description |
RecurringBillId [KEY] | String | Id of a Bill. | ||
VendorId | String | = | Id of the vendor the bill has been made. | |
VendorName | String | = | Name of the vendor the bill has been made. | |
Status | String | = | Status of the bill. | |
RecurrenceName | String | = | Frequency at which recurring bill will be sent. | |
RecurrenceFrequency | String | Search recurring bills by recurrence number. | ||
RepeatEvery | Integer | Integer value denoting the frequency of bill. | ||
StartDate | Date | =,>,< | Date when bill was created. | |
LastSentDate | Date | Date when recurring bill was last sent. | ||
NextBillDate | Date | Date when bill will be sent next. | ||
EndDate | Date | = | Date when the payment is expected. | |
CreatedTime | Datetime | Time at which the bill was created. | ||
LastModifiedTime | Datetime | The time of last modification of the bill. | ||
Total | Integer | Total of the bill. |