Recurring_Invoice table

Column Type

Recurring_Invoice_Id

String

Recurrence_Name

String

Reference_Number

String

Status

String

Total

Number

Customer_Id

String

Customer_Name

String

Child_Entity_Type

String

Recurrence_Frequency

String

Repeat_Every

Number

Is_Pre_Gst

String

Gst_No

String

Gst_Treatment

String

Tax_Treatment

String

Cfdi_Usage

String

Vat_Treatment

String

Place_Of_Supply

String

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Created_By_Id

String

Last_Modified_By_Id

String

Start_Date

Date

End_Date

Date

Last_Sent_Date

Date

Next_Invoice_Date

Date

Avatax_Exempt_No

String

Avatax_Use_Code

String

Salesperson_Id

String

Salesperson_Name

String

Last_Four_Digits

String

Subject_Content

String

Payment_Terms

Number

Payment_Terms_Label

String

Is_Taxable

String

Contact_Category

String

Customer_Email

String

Customer_Phone

String

Customer_Mobile_Phone

String

Photo_Url

String

Company_Name

String

Contact_Persons

Array

Price_Precision

Number

Exchange_Rate

Number

Discount

Number

Discount_Applied_On_Amount

Number

Is_Discount_Before_Tax

Boolean

Discount_Type

String

Tax_Rounding

String

Is_Inclusive_Tax

Boolean

Paid_Invoices_Total

Number

Unpaid_Invoices_Balance

Number

Is_Reverse_Charge_Applied

String

Bcy_Shipping_Charge

Number

Bcy_Adjustment

Number

Bcy_Sub_Total

Number

Bcy_Discount_Total

Number

Bcy_Tax_Total

Number

Bcy_Total

Number

Bcy_Shipping_Charge_Tax

String

Discount_Percent

Number

Discount_Total

Number

Adjustment

Number

Adjustment_Description

String

Recurrence_Preferences

String

Is_General_Preference

Boolean

Shipping_Charge_Tax_Id

String

Shipping_Charge_Tax_Name

String

Shipping_Charge_Tax_Type

String

Shipping_Charge_Tax_Percentage

String

Shipping_Charge_Tax_Exemption_Id

String

Shipping_Charge_Tax_Exemption_Code

String

Shipping_Charge_Tax

String

Shipping_Charge_Exclusive_Of_Tax

String

Shipping_Charge_Inclusive_Of_Tax

String

Shipping_Charge_Tax_Formatted

String

Shipping_Charge_Exclusive_Of_Tax_Formatted

String

Shipping_Charge_Inclusive_Of_Tax_Formatted

String

Shipping_Charge

Number

Roundoff_Value

Number

Transaction_Rounding_Type

String

Sub_Total

Number

Sub_Total_Inclusive_Of_Tax

Number

Tax_Total

Number

Reverse_Charge_Tax_Total

String

Allow_Partial_Payments

Boolean

Tds_Calculation_Type

String

Template_Id

String

Template_Name

String

Page_Width

String

Page_Height

String

Orientation

String

Notes

String

Terms

String

Actual_Child_Invoices_Count

Number

Manual_Child_Invoices_Count

Number

Is_Autobill_Enabled

Boolean

Unpaid_Child_Invoices_Count

String

Tax_Specification

String

Shipping_Charge_Sac_Code

String

Tds_Override_Preference

String

Contact_Number

String

Tax_Exemption_Code

String

Tax_Authority_Id

String

Tax_Exemption_Id

String

Tax_Authority_Name

String

Tax_Override_Preference

String

Tax_Reg_No

String

Billing_Address_Address

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_State

String

Billing_Address_Zip

String

Billing_Address_Country

String

Billing_Address_Fax

String

Billing_Address_Phone

String

Billing_Address_Attention

String

Shipping_Address_Address

String

Shipping_Address_Street2

String

Shipping_Address_City

String

Shipping_Address_State

String

Shipping_Address_Zip

String

Shipping_Address_Country

String

Shipping_Address_Fax

String

Shipping_Address_Phone

String

Shipping_Address_Attention

String

Line_Items

Array

Payment_Options

Object

Taxes

Array

Comments

Array

Project_Details

Array

Tds_Summary

String

Payment_Options_Payment_Gateways

Array

Examples

UPDATE Recurring_Invoice
SET
    Repeat_Every = '2'
WHERE
    Recurring_Invoice_Id = '579676000000076008'

DELETE FROM Recurring_Invoice
WHERE
    Recurring_Invoice_Id = '579676000000076008'