RetainerInvoicePayments
Get the list of payments made for a retainer invoices.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- RetainerInvoiceId supports the '=' comparison.
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. |