RetainerInvoiceListPayments
Get payments of Retainer Invoice.
Table Specific Information
Select
The connector 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 connector.
- 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 |