CustomerPaymentDetails

List, add, update and delete details of a payment.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

PaymentId supports the '=' and IN operators.

NOTE: PaymentId is required to query CustomerPaymentDetails.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM CustomerPaymentDetails WHERE PaymentId = '1894553000000083001'
	SELECT * FROM CustomerPaymentDetails WHERE PaymentId IN (SELECT PaymentId FROM CustomerPayments)
	SELECT * FROM CustomerPaymentDetails WHERE PaymentId IN ('1894553000000083001','1894553000000083002')

Insert

INSERT can be executed by specifying the CustomerId, PaymentMode, Amount, Date, InvoiceId, and AmountApplied columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO CustomerPaymentDetails (customerid, paymentmode, amount, date, invoiceid, amountapplied) VALUES ('3285934000000104002', 'cash', '1999', '2023-01-18', '3285934000000220356', '1999')

Update

UPDATE can be executed by specifying the PaymentId in the WHERE Clause. The columns that are not read-only can be updated. For example:

UPDATE CustomerPaymentDetails SET CustomerId = '3285934000000104002', PaymentMode = 'bank', Amount = '1999', Date = '2023-01-18', InvoiceId = '3285934000000220356', AmountApplied = '1999' WHERE PaymentId = '3285934000000269021'

Delete

DELETE can be executed by specifying the PaymentId in the WHERE Clause For example:

DELETE FROM CustomerPaymentDetails WHERE PaymentId = '3285934000000269021'

Columns


Name	Type	ReadOnly	References	SupportedOperators	Description
PaymentId [KEY]	String	True	CustomerPayments.PaymentId		Id of a payment.
AccountId	String	False	BankAccounts.AccountId		Id of the Bank Account.
AccountName	String	True			Name of the account.
AccountType	String	True			Type of the account.
Amount	Decimal	False			Amount of the customer payments.
AmountApplied	Decimal	False			Amount paid for the invoice.
AttachmentName	String	True			Name of the attachment.
BankCharges	Decimal	False			Charges of bank.
CanSendInMail	Boolean	True			Check if the customer payment can be send in mail.
CanSendPaymentSms	Boolean	True			Check if the customer payment can send payment SMS.
CardType	String	True			Type of card.
CurrencyCode	String	True			Currency code of the customer's currency.
CurrencyId	String	False	Currencies.CurrencyId		Currency Id of the customer's currency.
CustomerId	String	False	Contacts.ContactId		Id of the customer or vendor.
CustomerName	String	True			Name of the customer or vendor.
CustomFields	String	False			Custom fields of the contact.
CustomerAdvanceAccountId	String	True			CustomerAdvanceAccountId.
CustomerAdvanceAccountName	String	True			CustomerAdvanceAccountName.
ContactPersons	String	False			Contact persons of a contact.
Date	Date	False			Date of a customer payment.
Description	String	False			Description of the customer payment.
DiscountAmount	Decimal	True			Total discount amount applied in customer payment.
Documents	String	False			Documents.
ExchangeRate	Decimal	False			Exchange rate of the currency.
ImportedTransactions	String	True			ImportedTransactions.
IsClientReviewSettingsEnabled	Boolean	True			Check if the client review settings is enabled or not.
IsPaymentDetailsRequired	Boolean	True			Check if the payment details is required.
IsPreGst	Boolean	True			Check if pre GST is applied.
InvoiceId	String	False	Invoices.InvoiceId		Invoice Id for credit note.
LastFourDigits	String	True			It store the last four digits of customer's card details.
OnlineTransactionId	String	True			Id of online transaction.
Orientation	String	True			Orientation of the page.
PageHeight	String	True			Height of the page.
PageWidth	String	True			Width of the page.
PaymentLinkId	String	True			PaymentLinkId.
PaymentMode	String	False			Mode through which payment is made.
PaymentNumber	String	True			Number through which payment is made.
PaymentNumberPrefix	String	True			Prefix of the payment number.
PaymentNumberSuffix	String	True			Suffix of the payment number.
PaymentRefunds	String	True			PaymentRefunds.
ProductDescription	String	True			Description of the product.
ReferenceNumber	String	False			Reference number of a customer payment.
SettlementStatus	String	True			Status of the settlement.
TaxAccountId	String	False	BankAccounts.AccountId		Account Id of tax.
TaxAccountName	String	True			Account name of tax.
TaxAmountWithheld	Decimal	False			Amount withheld for tax.
TemplateId	String	True			Id of a template.
TemplateName	String	True			Name of a template.
TemplateType	String	True			Type of a template.
UnusedAmount	Decimal	True			Unused amount of the customer payment.
UpdatedTime	Datetime	True			Time at which the payment details were last updated.
Invoices	String	False			List of invoices associated with the payment.