RetainerInvoiceDetails

Get the details of a retainer invoice.

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 本製品.
Note: RetainerInvoiceId is required in order to query RetainerInvoiceDetails.

RetainerInvoiceId supports the '=' comparison.

For example:

    SELECT * FROM RetainerInvoiceDetails WHERE RetainerInvoiceId = '1894663000000085023'

Columns


Name	Type	References	SupportedOperators	Description
RetainerInvoiceId [KEY]	String	RetainerInvoices.RetainerInvoiceId		Id of retainer invoice.
RetainerinvoiceNumber	String			Number of a retainer invoice.
AllowPartialPayments	Boolean			Check if the retainer invoice allows partial payments.
AttachmentName	String			Name of the attachment.
Balance	Decimal			Total amount left.
BillingAddress	String			Billing address of a retainer invoice.
BillingAddressAttention	String			Name of a person in billing address.
BillingAddressCity	String			City of a billing address.
BillingAddressCountry	String			Country of a billing address.
BillingAddressFax	String			Fax of a billing address.
BillingAddressPhone	String			Phone number of a billing address.
BillingAddressState	String			State of a billing address.
BillingAddressStreet2	String			Street two of a billing address.
BillingAddressZip	String			ZIP code of a billing address.
CanSendInMail	Boolean			Check if retainer invoice can be send in mail.
ClientViewedTime	Datetime			Last time when client viewed retainer invoice.
ColorCode	String			Color code of retainer invoice.
CreatedById	String	Users.UserId		Id of a user who has created retainer invoice.
CreatedTime	Datetime			Time at which the retainer invoice was created.
CurrencyCode	String			Currency code of the customer's currency.
CurrencyId	String	Currencies.CurrencyId		Currency ID of the customer's currency.
CurrencySymbol	String			Symbol of currency used for retainer invoice.
CurrentSubStatus	String			Current sub status of a retainer invoice.
CurrentSubStatusId	String			Current sub status ID of a retainer invoice.
CustomerId	String	Contacts.ContactId		ID of the customer or vendor.
CustomerName	String			Name of the customer or vendor.
Date	Date			Date of a retainer invoice.
ExchangeRate	Decimal			Exchange rate of the currency.
InvoiceUrl	String			URL of invoice.
IsEmailed	Boolean			Check if the retainer invoice is emailed.
IsInclusiveTax	Boolean			Check if the retainer invoice is inclusive of tax.
IsPreGst	Boolean			Check if the retainer invoice is applied by pre GST.
IsViewedByClient	Boolean			Check if retainer invoice is viewed by client.
LastModifiedById	String	Users.UserId		Id of a user who has last modified the retainer invoice.
LastModifiedTime	Datetime			The time of last modification of the retainer invoice.
LastPaymentDate	Date			Date of payment which was last paid.
Notes	String			Notes of retainer invoice.
Orientation	String			Orientation of a page.
PageHeight	String			Height of a page.
PageWidth	String			Width of a page.
PaymentDrawn	Decimal			The payment which was drawn for retainer invoice.
PaymentMade	Decimal			Payment which was made for the invoice.
PricePrecision	Integer			The precision for the price.
ReferenceNumber	String			Reference number of a retainer invoice.
RoundoffValue	Decimal			Round Off value.
ShippingAddress	String			Shipment Address.
ShippingAddressAttention	String			Name of a person of shipping address.
ShippingAddressCity	String			City of a shipping address.
ShippingAddressCountry	String			Country of a shipping address.
ShippingAddressFax	String			Fax of a shipping address.
ShippingAddressPhone	String			Phone number of a shipping address.
ShippingAddressState	String			State of a shipping address.
ShippingAddressStreet2	String			Street two details of a shipping address.
ShippingAddressZip	String			Zip code of a shipping address.
Status	String			Status of the retainer invoice.
SubTotal	Decimal			Sub total of retainer invoices.
SubmittedBy	String			Detail of the user who has submitted the retainer invoice.
SubmittedDate	Date			Date of submission of retainer invoice.
TemplateId	String			ID of a template.
TemplateName	String			Name of a template.
TemplateType	String			Type of a template.
Terms	String			Terms and Conditions apply of a retainer invoice.
Total	Decimal			Total of retainer invoices.
TransactionRoundingType	String			Type of round off used for transaction.
VatTreatment	String			VAT treatment for the retainer invoice.
PlaceOfSupply	String			The place of supply is where a transaction is considered to have occurred for VAT purposes.
TaxSpecification	String			Working of tax when specifying special tax options and tax methods for earnings codes.
UnusedRetainerPayments	Decimal			Payment of the retainer invoice which is unused.

CData Python Connector for Zoho Books

RetainerInvoiceDetails

Table Specific Information

Select

Columns