Recurring_Expense table

Column Type

Recurring_Expense_Id

String

Recurrence_Name

String

Start_Date

Date

End_Date

Date

Is_Pre_Gst

String

Source_Of_Supply

String

Destination_Of_Supply

String

Place_Of_Supply

String

Gst_No

String

Gst_Treatment

String

Tax_Treatment

String

Destination_Of_Supply_State

String

Hsn_Or_Sac

String

Vat_Treatment

String

Reverse_Charge_Tax_Id

String

Reverse_Charge_Tax_Name

String

Reverse_Charge_Tax_Percentage

String

Reverse_Charge_Tax_Amount

String

Is_Reverse_Charge_Applied

String

Acquisition_Vat_Total

String

Reverse_Charge_Vat_Total

String

Recurrence_Frequency

String

Repeat_Every

Number

Amount

Number

Total

Number

Sub_Total

Number

Bcy_Total

Number

Product_Type

String

Acquisition_Vat_Id

String

Reverse_Charge_Vat_Id

String

Tax_Id

String

Tax_Name

String

Tax_Percentage

Number

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Is_Inclusive_Tax

Boolean

Is_Billable

Boolean

Customer_Id

String

Currency_Id

String

Exchange_Rate

Number

Project_Id

String

Project_Name

String

Paid_Through_Account_Id

String

Paid_Through_Account_Name

String

Vendor_Id

String

Vendor_Name

String

Vendor_Country_Code

String

Tax_Exemption_Code

String

Next_Expense_Date

Date

Last_Created_Date

Date

Markup_Percent

Number

Account_Id

String

Account_Name

String

Created_By_Id

String

Status

String

Currency_Code

String

Employee_Id

String

Employee_Name

String

Employee_Email

String

Tax_Amount

Number

Tax_Exemption_Id

String

Customer_Vat_Treatment

String

Tax_Name_Formatted

String

Itc_Eligibility

String

Description

String

Customer_Name

String

Last_Modified_By_Id

String

Mileage_Rate

Number

Mileage_Unit

String

Gst_Treatment_Code

String

Tax_Reg_No

String

Line_Items

Array

Acquisition_Vat_Summary

String

Reverse_Charge_Vat_Summary

String

Tags

Array

Examples

DELETE FROM Recurring_Expense WHERE Recurring_Expense_Id='576438000000176002'