RecurringBillDetails
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 本製品.
- RecurringBillId supports the '=' comparison.
SELECT * FROM RecurringBillDetails where RecurringBillId='3255827000000084031'
Insert
Insert can be executed by specifying StartDate, RecurrenceName, RecurrenceFrequency, VendorID, LineItems columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
Insert INTO RecurringBillLineItems#TEMP(Name,itemid) values('rubberband','3255827000000081058')
INSERT INTO RecurringBillDetails (vendorid,startdate,recurrencename,lineitems,recurrencefrequency) VALUES ('3255827000000081003','2023-03-01','recurring7',RecurringBillLineItems#TEMP,'days')
Update
Update can be executed by specifying the RecurringBillId in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE RecurringBillDetails SET RecurrenceName='recurrence3' WHERE RecurringBillId='3255827000000084031'
Delete
Delete can be executed by specifying the BillId in the WHERE Clause
For example:
DELETE FROM RecurringBillDetails WHERE BillId = '3255827000000084031'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
RecurringBillId [KEY] | String | True |
ID of a Recurring Bill. | ||
Adjustment | Integer | True |
Adjustment. | ||
AdjustmentDescription | String | True |
Status of the bill. | ||
CreatedById | String | True |
Created By Id. | ||
CreatedTime | Datetime | True |
Created Time. | ||
CurrencyId | String | False |
Currencies.CurrencyId |
Currency ID of the customer's currency. | |
CurrencyCode | String | True |
Currency code of the customer's currency. | ||
CustomFields | String | False |
Custom fields of the items. | ||
Discount | String | False |
Discount of recurring bills. | ||
DiscountAccountId | String | True |
Account ID of discount. | ||
DiscountAmount | Integer | True |
Discount amount. | ||
DiscountAppliedOnAmount | String | True |
Discount applied on amount. | ||
DiscountSetting | String | True |
Discount setting. | ||
DiscountType | String | True |
Discount type. | ||
EndDate | Date | False |
Date when the payment is expected. | ||
ExchangeRate | Integer | True |
Exchange Rate. | ||
IsDiscountBeforeTax | Boolean | False |
Check if discount should be applied before tax. | ||
IsInclusiveTax | Boolean | False |
Check if the tax is inclusive in the bill. | ||
IsItemLevelTax | Boolean | True |
Item Level Tax. | ||
IsPreGST | Boolean | True |
Is Pre GST. | ||
IsTDSAmountInPercent | Boolean | True |
Is TDS Amount In Percent | ||
LastModifiedById | String | True |
Last Modified By Id. | ||
LastModifiedTime | Datetime | True |
The time of last modification of the bill. | ||
LastSentDate | Date | True |
Date when recurring bill was last sent. | ||
LineItems | String | False |
Line items of an recurring bill. | ||
NextBillDate | Date | True |
Date when bill will be sent next. | ||
Notes | String | False |
Notes of the bill. | ||
PaymentTerms | Integer | False |
Net payment term for the customer. | ||
PaymentTermsLabel | String | False |
Label for the paymet due details. | ||
RecurrenceFrequency | String | False |
Frequency at which recurring bill will be sent. 使用できる値は次のとおりです。days, weeks, months, years | ||
RecurrenceName | String | False |
Search recurring bills by recurrence number. | ||
VendorId | String | False |
ID of the vendor the bill has been made. | ||
VendorName | String | True |
Name of the vendor the bill has been made. | ||
Total | Integer | True |
Total of the bill. | ||
ReferenceId | String | True |
Reference Id. | ||
RepeatEvery | Integer | False |
Integer value denoting the frequency of bill. | ||
StartDate | Date | False |
Date when bill was created. | ||
Status | String | True |
Status of the bill. 使用できる値は次のとおりです。active, stopped, expired | ||
SubTotal | Integer | True |
Sub total of the bill. | ||
TaxAccountId | String | True |
Tax Account ID. | ||
TaxRounding | String | True |
Tax Rounding. | ||
TaxTotal | String | True |
Tax Total. | ||
TdsTaxId | String | True |
Tax ID of TDS. | ||
TdsTaxName | String | True |
Tds tax name. | ||
TdsAmount | Integer | True |
TDS Amount. | ||
TdsPercent | Decimal | True |
TDS Percent. | ||
TrackDiscountInAccount | Boolean | True |
Track Discount In Account. |