RetainerInvoiceListPayments
Get payments of Retainer Invoice.
Table Specific Information
Select
The add-in will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- RetainerInvoiceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM RetainerInvoiceListPayments WHERE RetainerInvoiceId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| Amount | Integer | Amount | |
| AttachmentName | String | Attachment Name | |
| BankCharges | Integer | Bank Charges | |
| CanSendInMail | Boolean | Can Send In Mail | |
| CurrencyCode | String | Currency Code | |
| CurrencyId | Long | Currency Id | |
| CustomFields | String | Custom Fields | |
| CustomerId | Long | Customer Id | |
| CustomerName | String | Customer Name | |
| Date | Date | Date | |
| Description | String | Description | |
| DiscountAmount | Integer | DiscountAmount | |
| Documents | String | Documents | |
| ExchangeRate | Integer | ExchangeRate | |
| HtmlString | String | Html String | |
| Invoices | String | Invoices | |
| IsClientReviewSettingsEnabled | Boolean | Is Client Review Settings Enabled | |
| IsPaymentDrawnDetailsRequired | Boolean | Is Payment Drawn Details Required | |
| LastFourDigits | String | Last Four Digits | |
| OnlineTransactionId | String | Online Transaction Id | |
| Orientation | String | Orientation | |
| PageHeight | String | Page Height | |
| PageWidth | String | Page Width | |
| PaymentId [KEY] | String | Payment Id | |
| PaymentMode | String | Payment Mode | |
| PaymentRefunds | String | Payment Refunds | |
| ReferenceNumber | String | Reference Number | |
| RetainerInvoiceRetainerInvoiceBalance | Integer | Retainer Invoice Balance | |
| RetainerInvoiceRetainerInvoiceDate | Date | Retainer Invoice Date | |
| RetainerInvoiceRetainerInvoiceId | Long | Retainer Invoice Id | |
| RetainerInvoiceRetainerInvoiceNumber | String | Retainer Invoice Number | |
| RetainerInvoiceRetainerInvoiceTotal | Integer | Retainer Invoice Total | |
| RetainerInvoiceId | Long | Retainer Invoice Id | |
| TaxAmountWithheld | Integer | Tax Amount Withheld | |
| TemplateId | Long | Template Id | |
| TemplateName | String | Template Name | |
| TemplateType | String | Template Type | |
| UnusedAmount | Integer | Unused Amount |