Recurring_Bill table

Column Type

Recurring_Bill_Id

String

Recurrence_Name

String

Recurrence_Frequency

String

Next_Bill_Date

Date

Status

String

Total

Number

Last_Sent_Date

Date

Vendor_Id

String

Vendor_Name

String

Start_Date

Date

End_Date

Date

Last_Modified_Time

Timestamp

Repeat_Every

Number

Created_Time

Timestamp

Tax_Rounding

String

Currency_Code

String

Is_Item_Level_Tax_Calc

Boolean

Discount_Setting

String

Reference_Id

String

Vat_Treatment

String

Adjustment_Description

String

Contact_Category

String

Is_Reverse_Charge_Applied

String

Tax_Treatment

String

Tds_Calculation_Type

String

Tds_Tax_Name

String

Currency_Id

String

Payment_Terms

Number

Payment_Terms_Label

String

Discount_Amount

Number

Price_Precision

Number

Is_Inclusive_Tax

Boolean

Template_Id

String

Exchange_Rate

Number

Terms

String

Last_Modified_By_Id

String

Track_Discount_In_Account

Boolean

Discount_Account_Id

String

Subject_Content

String

Discount

Number

Sub_Total

Number

Tax_Total

Number

Adjustment

Number

Discount_Type

String

Discount_Applied_On_Amount

Number

Notes

String

Is_Discount_Before_Tax

Boolean

Created_By_Id

String

Template_Name

String

Tds_Percent

String

Tds_Amount

String

Source_Of_Supply

String

Destination_Of_Supply

String

Gst_No

String

Gst_Treatment

String

Tds_Tax_Id

String

Tax_Account_Id

String

Is_Pre_Gst

String

Is_Tds_Amount_In_Percent

String

Tds_Section

String

Tax_Override

String

Tds_Override_Preference

String

Place_Of_Supply

String

Tax_Reg_No

String

Permit_Number

String

Abn

String

Is_Discount_Tax_Inclusive

String

Is_Abn_Quoted

String

Tax_On_Discount_Preference

String

Billing_Address_Id

String

Billing_Address_Address

String

Billing_Address_Country

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_Fax

String

Billing_Address_State

String

Billing_Address_Zip

String

Billing_Address_Phone

String

Billing_Address_Attention

String

Tds_Summary

String

Taxes

Array

Line_Items

Array

Examples

DELETE FROM Recurring_Bill WHERE Recurring_Bill_Id='576438000000176002'