ContactDetails
Returns the list of all contacts .
Columns
Name | Type | References | |
OrganizationId | Long |
Organizations.OrganizationId | |
ContactId [KEY] | Long |
Contacts.ContactId | |
FirstName | String | ||
LastName | String | ||
ContactName | String | ||
ContactType | String | ||
String | |||
Status | String | ||
AchSupported | Boolean | ||
Addresses | String | ||
AssociatedWithSquare | Boolean | ||
BankAccounts | String | ||
BillingAddressAddress | String | ||
BillingAddressAddressId | String | ||
BillingAddressAttention | String | ||
BillingAddressCity | String | ||
BillingAddressCountry | String | ||
BillingAddressFax | String | ||
BillingAddressPhone | String | ||
BillingAddressState | String | ||
BillingAddressStateCode | String | ||
BillingAddressStreet2 | String | ||
BillingAddressZip | String | ||
Cards | String | ||
Checks | String | ||
CompanyName | String | ||
ConsentDate | String | ||
ContactCategory | String | ||
ContactPersons | String | ||
ContactSalutation | String | ||
CreatedTime | Datetime | ||
CreditLimitExceededAmount | Double | ||
CrmOwnerId | String | ||
CurrencyCode | String | ||
CurrencyId | String | ||
CurrencySymbol | String | ||
CustomFields | String | ||
CustomerSubType | String | ||
DefaultTemplatesBillTemplateId | String | ||
DefaultTemplatesBillTemplateName | String | ||
DefaultTemplatesCreditnoteEmailTemplateId | String | ||
DefaultTemplatesCreditnoteEmailTemplateName | String | ||
DefaultTemplatesCreditnoteTemplateId | String | ||
DefaultTemplatesCreditnoteTemplateName | String | ||
DefaultTemplatesEstimateEmailTemplateId | String | ||
DefaultTemplatesEstimateEmailTemplateName | String | ||
DefaultTemplatesEstimateTemplateId | String | ||
DefaultTemplatesEstimateTemplateName | String | ||
DefaultTemplatesInvoiceEmailTemplateId | String | ||
DefaultTemplatesInvoiceEmailTemplateName | String | ||
DefaultTemplatesInvoiceTemplateId | String | ||
DefaultTemplatesInvoiceTemplateName | String | ||
DefaultTemplatesPaymentRemittanceEmailTemplateId | String | ||
DefaultTemplatesPaymentRemittanceEmailTemplateName | String | ||
DefaultTemplatesPaymentthankyouEmailTemplateId | String | ||
DefaultTemplatesPaymentthankyouEmailTemplateName | String | ||
DefaultTemplatesPaymentthankyouTemplateId | String | ||
DefaultTemplatesPaymentthankyouTemplateName | String | ||
Department | String | ||
Designation | String | ||
Documents | String | ||
String | |||
HasTransaction | Boolean | ||
IsClientReviewAsked | Boolean | ||
IsClientReviewSettingsEnabled | Boolean | ||
IsConsentAgreed | Boolean | ||
IsCrmCustomer | Boolean | ||
IsLinkedWithZohocrm | Boolean | ||
IsSmsEnabled | Boolean | ||
LanguageCode | String | ||
LanguageCodeFormatted | String | ||
LastModifiedTime | Datetime | ||
Mobile | String | ||
Notes | String | ||
OutstandingReceivableAmount | Double | ||
OutstandingReceivableAmountBcy | Double | ||
OwnerId | String | ||
OwnerName | String | ||
PaymentReminderEnabled | Boolean | ||
PaymentTerms | Integer | ||
PaymentTermsLabel | String | ||
Phone | String | ||
PortalReceiptCount | Integer | ||
PortalStatus | String | ||
PricePrecision | Integer | ||
PricebookId | String | ||
PricebookName | String | ||
PrimaryContactId | String | ||
SalesChannel | String | ||
ShippingAddressAddress | String | ||
ShippingAddressAddressId | String | ||
ShippingAddressAttention | String | ||
ShippingAddressCity | String | ||
ShippingAddressCountry | String | ||
ShippingAddressFax | String | ||
ShippingAddressLatitude | String | ||
ShippingAddressLongitude | String | ||
ShippingAddressPhone | String | ||
ShippingAddressState | String | ||
ShippingAddressStateCode | String | ||
ShippingAddressStreet2 | String | ||
ShippingAddressZip | String | ||
Source | String | ||
String | |||
UnusedCreditsReceivableAmount | Double | ||
UnusedCreditsReceivableAmountBcy | Double | ||
UnusedRetainerPayments | Double | ||
VpaList | String | ||
Website | String | ||
ZcrmAccountId | String | ||
ZcrmContactId | String | ||
ZohopeopleClientId | String |