EstimateDetails

Get the details of an estimate.

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: EstimateId is required in order to query EstimateDetails.

EstimateId supports the '=' comparison.

For example:

    SELECT * FROM EstimateDetails WHERE EstimateId = '1894553000000077244'

Columns


Name	Type	References	SupportedOperators	Description
EstimateId [KEY]	String	Estimates.EstimateId		Id of an estimate.
Adjustment	Decimal			Adjustments made to the estimate.
AdjustmentDescription	String			Description of adjustments made to the estimate.
AllowPartialPayments	Boolean			Check if estimate allows partial payments.
ApproverId	String	Users.UserId		Id of an approver.
AttachmentName	String			Name of the attachment.
BcyAdjustment	Decimal			Adjustment made for base currency.
BcyDiscountTotal	Decimal			Total amount get on discount for base currency.
BcyShippingCharge	Decimal			Shipping charge applied for base currency.
BcySubTotal	Decimal			Sub total of base currency.
BcyTaxTotal	Decimal			Total tax applied for the base currency.
BcyTotal	Decimal			Total Base Currency.
BillingAddress	String			Billing address of a estimate.
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 the estimate can be send in mail.
ClientViewedTime	Datetime			Time when client viewed the estimate.
ColorCode	String			Color code for estimate.
ContactCategory	String			Category for contact.
CreatedById	String	Users.UserId		Id of a user who has created estimate.
CreatedTime	Datetime			Time at which the estimate was created.
CurrencyCode	String			Currency code of the customer's currency.
CurrencyId	String	Currencies.CurrencyId		Currency ID of the customer's currency.
CurrencySymbol	String			Currency symbol of the customer's currency.
CurrentSubStatus	String			Current sub status of an estimate .
CurrentSubStatusId	String			Current sub status ID of an estimate .
CustomerDefaultBillingAddress	String			Customer default billing address of an estimate.
CustomerDefaultBillingAddressCity	String			City of a customer default billing address.
CustomerDefaultBillingAddressCountry	String			Country of a customer default billing address.
CustomerDefaultBillingAddressFax	String			Fax of a customer default billing address.
CustomerDefaultBillingAddressPhone	String			Phone number of a customer default billing address.
CustomerDefaultBillingAddressState	String			State of a customer default billing address.
CustomerDefaultBillingAddressStateCode	String			State code of a customer default billing address.
CustomerDefaultBillingAddressStreet2	String			Street two of a customer default billing address.
CustomerDefaultBillingAddressZip	String			ZIP code of a customer default billing address.
CustomerId	String	Contacts.ContactId		ID of the customer or vendor.
CustomerName	String			Name of the customer or vendor.
Date	Date			Date of an estimate.
Discount	String			Discount applied for estimate.
DiscountAppliedOnAmount	Decimal			Discount applied on amount for estimate.
DiscountPercent	Decimal			Percent of discount applied for estimate.
DiscountTotal	Decimal			Total discount applied for estimate.
DiscountType	String			Type of discount applied for estimate.
EstimateNumber	String			Number of estimate.
EstimateUrl	String			URL of estimate.
ExchangeRate	Decimal			Exchange rate of the currency.
ExpiryDate	Date			Expiration date of estimate.
InvoiceConversionType	String			Conversion type of an invoice in estimate.
IsConvertedToOpen	Boolean			Check if the estimate is converted to open.
IsDiscountBeforeTax	Boolean			Check if the discount is applied before tax. .
IsInclusiveTax	Boolean			Check if the expense is inclusive tax.
IsPreGst	Boolean			Check if estimate includes pre GST.
IsTransactionCreated	Boolean			Check if the transaction os created for estimate.
IsViewedByClient	Boolean			Check if the estimate is viewed by client.
LastModifiedById	String	Users.UserId		Id of the user last modified.
LastModifiedTime	Datetime			The time of last modification of the estimate.
Notes	String			Notes of Estimate.
Orientation	String			Orientation of page.
PageHeight	String			Height of page.
PageWidth	String			Width of page.
PricePrecision	Integer			The precision for the price.
ProjectId	String			Id of a project.
ProjectName	String			Name of a project.
ProjectCustomerId	String			Id of a customer.
ProjectCustomerName	String			Name of a customer.
ProjectDescription	String			Details about the project.
ProjectStatus	String			Status of the project.
ProjectBillingType	String			Type of billing.
ProjectRate	Decimal			Overall rate of the project.
ReferenceNumber	String			Reference number of estimates.
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.
VatTreatment	String			VAT treatment for the estimates.
IsTaxable	Boolean			Check if estimate is taxble.
GstNo	String			GST number.
GstTreatment	String			Choose whether the estimate is GST registered/unregistered/consumer/overseas. .
TaxTreatment	String			VAT treatment for the Estimate.
ReverseChargeTaxTotal	String			Total amount of tax reverse charge.
CanSendEstimateSms	String			Check if the estimate can send the estimate SMS.
RetainerPercentage	String			Percentage of the retainer in estimate.
AcceptRetainer	Boolean			Check if estimate can accept the retainer.
RoundoffValue	Decimal			Rounding off the values to precise number.
SalespersonId	String			ID of a sales person.
SalespersonName	String			Name of a sales person.
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 of a shipping address.
ShippingAddressZip	String			Zip of a shipping address.
ShippingCharge	Decimal			Shipping charge of estimates.
Status	String			Status of the estimate.
SubTotal	Decimal			Sub total of estimates.
SubTotalExclusiveOfDiscount	Decimal			Subtotal amount which are exclusive of discount.
SubTotalInclusiveOfTax	Decimal			Subtotal amount which are inclusive of tax.
SubmittedBy	String			Detail of the user who has submitted the estimate.
SubmittedDate	Date			Date when estimate was submitted.
SubmitterId	String	Users.UserId		ID of the submitter.
TaxTotal	Decimal			Total amount of tax.
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 estimate.
Total	Decimal			Total of estimates.
TransactionRoundingType	String			Type of round off used for transaction.

CData Python Connector for Zoho Books

EstimateDetails

Table Specific Information

Select

Columns