RecurringBills
To list, add, update and delete details of a bill.
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 本製品.
- 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.
Select * FROM RecurringBills 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. |