ContactDetails
Get details of a contact.
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: ContactId is required in order to query ContactDetails.
- ContactId supports the '=' comparison.
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. | ||
| 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. | ||
| 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. |