Customer_Payment table

Column Type

Payment_Id

String

Payment_Mode

String

Amount

Number

Amount_Refunded

Number

Bank_Charges

Number

Date

String

Status

String

Reference_Number

String

Description

String

Customer_Id

String

Customer_Name

String

Email

String

Currency_Code

String

Currency_Symbol

String

Account_Name

String

Exchange_Rate

Number

Documents

Array

Currency_Id

String

Payment_Number

String

Payment_Link_Id

String

Created_Time

Timestamp

Updated_Time

Timestamp

Is_Client_Review_Settings_Enabled

Boolean

Payment_Number_Prefix

String

Customer_Advance_Account_Id

String

Card_Type

String

Payment_Number_Suffix

String

Tax_Treatment

String

Can_Send_In_Mail

Boolean

Offline_Created_Date_With_Time

Date

Template_Type

String

Account_Id

String

Account_Type

String

Customer_Advance_Account_Name

String

Unused_Amount

Number

Tax_Account_Id

String

Is_Payment_Details_Required

Boolean

Tax_Account_Name

String

Online_Transaction_Id

String

Tax_Amount_Withheld

Number

Can_Send_Payment_Sms

Boolean

Payment_Gateway

String

Settlement_Status

String

Payment_Refunds

Array

Last_Four_Digits

String

Template_Id

String

Template_Name

String

Page_Width

String

Page_Height

String

Orientation

String

Attachment_Name

String

Is_Pre_Gst

Boolean

Product_Description

String

Tds_Type

String

Tds_Tax_Id

String

Txn_Posting_Date

Date

Payment_Status

String

Tax_Id

String

Tax_Percentage

String

Tax_Type

String

Gst_Treatment

String

Gst_Return_Details_Return_Period

String

Gst_Return_Details_Status

String

Place_Of_Supply

String

Gst_No

String

Tax_Name

String

Is_Advance_Payment

Boolean

Invoice_Numbers

String

Last_Modified_Time

Timestamp

Retainerinvoice_Id

String

Payment_Mode_Formatted

String

Custom_Fields_List

String

Bcy_Amount

Number

Bcy_Unused_Amount

Number

Bcy_Refunded_Amount

Number

Has_Attachment

Boolean

Gateway_Transaction_Id

String

Applied_Invoices

Array

Payment_Type

String

Contact_Number

String

Invoices

Array

Imported_Transactions

Array

Examples

UPDATE Customer_Payment
SET
    Description = 'Customer paid at till'
WHERE
    Payment_Id = '576438000000168003'
DELETE FROM Customer_Payment
WHERE
    Payment_Id = '576438000000168003'