RetainerInvoicePayments
Get the list of payments made for a retainer invoices.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- RetainerInvoiceId supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM RetainerInvoicePayments WHERE RetainerInvoiceId = '1894663000000085023'
Columns
| Name | Type | References | SupportedOperators | Description |
| PaymentId [KEY] | String | Id of a payment. | ||
| RetainerInvoiceId | String |
RetainerInvoices.RetainerInvoiceId | Id of a retainer invoice. | |
| PaymentMode | String | Mode through which payment is made. | ||
| ReferenceNumber | Currency | Reference number of retainer invoice payment. | ||
| Amount | Integer | Amount of the retainer invoice payments. | ||
| AttachmentName | String | Name of the attachment. | ||
| BankCharges | Integer | Charges of the bank. | ||
| CanSendInMail | Boolean | Check if the retainer invoice can be send through mail. | ||
| CurrencyCode | String | Currency code of the customer's currency. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency Id of the customer's currency. | |
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| Date | Date | Retainer Invoice date. | ||
| Description | String | Description of the retainer invoice payment. | ||
| DiscountAmount | Decimal | Amount given for discount. | ||
| ExchangeRate | Decimal | Exchange rate given for this retainer invoice. | ||
| HtmlString | String | HTML context of a retainer invoice. | ||
| IsClientReviewSettingsEnabled | Boolean | Check if the client review settings is enabled or not. | ||
| IsPaymentDrawnDetailsRequired | Boolean | Check if the payment drawn details is required. | ||
| LastFourDigits | String | It store the last four digits of customer's card details. | ||
| OnlineTransactionId | String | Id of online transaction. | ||
| Orientation | String | Orientation of the page. | ||
| PageHeight | String | Height of the page. | ||
| PageWidth | String | Width of the page. | ||
| RetainerinvceBalance | Integer | Total amount for retainer invoice. | ||
| RetainerInvceDate | Date | Date for retainer invoice. | ||
| RetainerInvceId | String |
RetainerInvoices.RetainerInvoiceId | Id for a retainer invoice. | |
| RetainerInvceNumber | String | Number of a retainer invoice. | ||
| RetainerInvceTotal | Integer | Total of retainer invoice. | ||
| TaxAmountWithheld | Integer | Amount withheld for tax. | ||
| TemplateId | String | Id of a template. | ||
| TemplateName | String | Name of a template. | ||
| TemplateType | String | Type of a template. | ||
| UnusedAmount | Integer | Total amount which is unused. |