CData Python Connector for Zoho Books

Build 20.0.7740

ContactDetails

Get details of a contact.

Table Specific Information

Select

The {i 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 {i.
Note: ContactId is required in order to query ContactDetails.

  • ContactId supports the '=' comparison.
For example:
    SELECT * FROM ContactDetails WHERE ContactId = '1894952000000071009'

Columns

Name Type References SupportedOperators Description
ContactId [KEY] String

Contacts.ContactId

Id of a contact.
AchSupported Boolean Check if ACH is supported.
AssociatedWithSquare Boolean Check if the contact is associated with square.
BillingAddress String Billing address of a contact.
BillingAddressId String

ContactAddresses.AddressId

Id of a billing address.
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.
BillingAddressStateCode String State code of a billing address.
BillingAddressStreet2 String Street two of a billing address.
BillingAddressZip String ZIP code of a billing address.
CanShowCustomerOb Boolean Check if contact can show customer ob.
CanShowVendorOb Boolean Check if contact can show vendor ob.
CompanyName String Name of the company.
ContactCategory String Category of this contact.
ContactName String Display Name of the contact. Max-length [200].
ContactSalutation String Salutation of a contact.
CreatedTime Datetime Time at which the contact was created.
CreditLimitExceededAmount Decimal Amount if the credit limit exceeded.
CurrencyCode String Currency code of the customer's currency.
CurrencySymbol String Currency symbol of the customer's currency.
CustomerSubType String Sub type of a customer.
DefaultTemplatesBillTemplateId String ID of a bill template in default template.
DefaultTemplatesBillTemplateName String Name of a bill template in default template.
DefaultTemplatesCreditnoteEmailTemplateId String ID of a credit note email template in default template.
DefaultTemplatesCreditnoteEmailTemplateName String Name of a credit note email template in default template.
DefaultTemplatesCreditnoteTemplateId String ID of a credit note template in default template.
DefaultTemplatesCreditnoteTemplateName String Name of a credit note template in default template.
DefaultTemplatesEstimateEmailTemplateId String ID of a estimate email template in default template.
DefaultTemplatesEstimateEmailTemplateName String Name of a estimate email template in default template.
DefaultTemplatesEstimateTemplateId String ID of a estimate template in default template.
DefaultTemplatesEstimateTemplateName String Name of a estimate template in default template.
DefaultTemplatesInvoiceEmailTemplateId String ID of a invoice email template in default template.
DefaultTemplatesInvoiceEmailTemplateName String Name of a invoice email template in default template.
DefaultTemplatesInvoiceTemplateId String ID of a invoice template in default template.
DefaultTemplatesInvoiceTemplateName String Name of a invoice template in default template.
DefaultTemplatesPaymentRemittanceEmailTemplateId String ID of a payment remittance template in default template.
DefaultTemplatesPaymentRemittanceEmailTemplateName String Name of a payment remittance template in default template.
DefaultTemplatesPaymentthankyouEmailTemplateId String ID of a payment thank you email template in default template.
DefaultTemplatesPaymentthankyouEmailTemplateName String Name of a payment thank you email template in default template.
DefaultTemplatesPaymentthankyouTemplateId String ID of a payment thank you template in default template.
DefaultTemplatesPaymentthankyouTemplateName String Name of a payment thank you template in default template.
DefaultTemplatesPurchaseorderEmailTemplateId String ID of a purchase order email template in default template.
DefaultTemplatesPurchaseorderEmailTemplateName String Name of a purchase order email template in default template.
DefaultTemplatesPurchaseorderTemplateId String ID of a purchase order template in default template.
DefaultTemplatesPurchaseorderTemplateName String Name of a purchase order template in default template.
DefaultTemplatesSalesorderEmailTemplateId String ID of a sales order email template in default template.
DefaultTemplatesSalesorderEmailTemplateName String Name of a sales order email template in default template.
DefaultTemplatesSalesorderTemplateId String ID of a sales order template in default template.
DefaultTemplatesSalesorderTemplateName String Name of a sales order template in default template.
Email String Email ID of a contact.
ExchangeRate Decimal Exchange rate of the currency.
HasTransaction Boolean Check if this contact has transaction.
IsClientReviewAsked Boolean Check if the client review is asked.
IsClientReviewSettingsEnabled Boolean Check if the client review settings is enabled for this contact.
IsSmsEnabled Boolean Check if SMS is enabled.
LanguageCode String Language code used for a contact.
LastModifiedTime Datetime The time of last modification of the contact.
Mobile String Mobile number of a contact.
Notes String Notes of a contact.
OpeningBalanceAmount Decimal Opening balance amount of a contact.
OpeningBalanceAmountBcy Decimal Base Currency of Opening balance amount of a contact.
OutstandingPayableAmount Decimal Outstanding OB payable amount of a contact.
OutstandingReceivableAmount Decimal Outstanding OB receivable amount of a contact.
OwnerId String ID of the owner.
OwnerName String Name of the owner.
PaymentReminderEnabled Boolean Check if payment reminder is enabled.
PaymentTerms Integer Net payment term for the customer.
PaymentTermsLabel String Label for the paymet due details.
PortalStatus String Status of a portal.
PricePrecision Integer The precision for the price.
PricebookId String ID of a price book.
PricebookName String Name of a price book.
PrimaryContactId String Primary ID of a contact.
SalesChannel String Channel of sales.
ShippingAddress String Shipment Address.
ShippingAddressId String

ContactAddresses.AddressId

ID of a shipping 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.
ShippingAddressStateCode String State code of a shipping address.
ShippingAddressStreet2 String Street two details of a shipping address.
ShippingAddressZip String Zip code of a shipping address.
Source String Source of the contact.
Status String Status of the contact.
Twitter String Twitter account.
UnusedCreditsPayableAmount Decimal Payable amount of Unused credits of a contact.
UnusedCreditsPayableAmountBcy Decimal Base Currency Payable amount of Unused credits of a contact.
UnusedCreditsReceivableAmount Decimal Receivable amount of Unused credits of a contact.
UnusedCreditsReceivableAmountBcy Decimal Base Currency Receivable amount of Unused credits of a contact.
UnusedRetainerPayments Decimal Payment of the contact which is unused.
Website String Link of a website.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740