CustomerPaymentInvoices
Get invoices related to customer payments.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- PaymentId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM CustomerpaymentInvoices where PaymentId = '3255827000000101040' SELECT * FROM CustomerpaymentInvoices where PaymentId IN ('3255827000000101040','3255827000000102354')
Columns
Name | Type | References | SupportedOperators | Description |
InvoicePaymentId [KEY] | Long | Invoice PaymentId | ||
InvoiceId | String |
Invoices.InvoiceId | Invoice Id | |
PaymentId | String |
CustomerPayments.PaymentId | Customer Payment Id | |
InvoiceCustomerId | Long | Invoice Customer Id | ||
InvoiceCustomerName | String | Invoice Customer Name | ||
AmountApplied | Integer | Amount applied to the Entity | ||
Balance | Integer | The unpaid amount | ||
DiscountAmount | Integer | Discount Amount | ||
Date | Date | Date when invoice was created | ||
Total | Integer | Total amount | ||
InvoiceNumber | String | Invoice Number |