Retainer_Invoice table

Column Type

Retainerinvoice_Id

String

Retainerinvoice_Number

String

Date

String

Status

String

Is_Pre_Gst

String

Place_Of_Supply

String

Project_Id

String

Project_Name

String

Last_Payment_Date

Date

Reference_Number

String

Customer_Id

String

Customer_Name

String

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Exchange_Rate

Number

Is_Viewed_By_Client

Boolean

Client_Viewed_Time

Timestamp

Is_Inclusive_Tax

Boolean

Sub_Total

Number

Total

Number

Payment_Made

Number

Payment_Drawn

Number

Balance

Number

Allow_Partial_Payments

Boolean

Price_Precision

Number

Is_Emailed

Boolean

Notes

String

Terms

String

Template_Id

String

Template_Name

String

Page_Width

String

Page_Height

String

Orientation

String

Template_Type

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Created_By_Id

String

Attachment_Name

String

Can_Send_In_Mail

Boolean

Invoice_Url

String

Roundoff_Value

Number

Current_Sub_Status

String

Vat_Treatment

String

Mail_Last_Viewed_Time

String

Color_Code

String

Payments

Array

Current_Sub_Status_Id

String

Unused_Retainer_Payments

Number

Tax_Treatment

String

Transaction_Rounding_Type

String

Tax_Reg_No

String

Submitted_Date

Date

Tax_Rounding

String

Submitted_By_Photo_Url

String

Mail_First_Viewed_Time

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_City

String

Shipping_Address_State

String

Shipping_Address_Zip

String

Shipping_Address_Country

String

Shipping_Address_Fax

String

Shipping_Address_Street2

String

Shipping_Address_Phone

String

Shipping_Address_Attention

String

Last_Modified_By_Id

String

Submitted_By

String

Submitted_By_Name

String

Submitted_By_Email

String

Ach_Payment_Initiated

Boolean

Estimate_Number

String

Project_Or_Estimate_Name

String

Has_Attachment

Boolean

Tax_Specification

String

Special_Transaction_Type

String

Contact_Number

String

Contact_Persons

Array

Line_Items

Array

Taxes

Array

Documents

Array

Payment_Options

Object

Approvers_List

Array

Sub_Statuses

Array

Payment_Options_Payment_Gateways

Array

Examples

DELETE FROM Retainer_Invoice WHERE RetainerInvoice_id='579676000000091002'