CustomerDetails
Returns details of a customer.
Columns
Name | Type | References | |
OrganizationId | Long |
Organizations.OrganizationId | |
CustomerId [KEY] | Long |
Customers.CustomerId | |
FirstName | String | ||
LastName | String | ||
Status | String | ||
AchSupported | Boolean | ||
Addresses | String | ||
CanAddBankAccount | Boolean | ||
CanAddCard | Boolean | ||
CanInvite | Boolean | ||
Category | String | ||
ChannelCustomerId | String | ||
ChannelSource | String | ||
CompanyName | String | ||
CreatedTime | Datetime | ||
CurrencyCode | String | ||
CurrencyId | String | ||
CurrencySymbol | String | ||
CustomFields | String | ||
CustomerSubType | String | ||
DefaultTemplatesCreditnoteTemplateId | String | ||
DefaultTemplatesInvoiceTemplateId | String | ||
Department | String | ||
Designation | String | ||
DisplayName | String | ||
Documents | String | ||
String | |||
EncryptionKeyMapExponent | String | ||
EncryptionKeyMapModulus | String | ||
String | |||
Fax | String | ||
IpAddress | String | ||
IsAddedInPortal | Boolean | ||
IsClientReviewAsked | Boolean | ||
IsClientReviewSettingsEnabled | Boolean | ||
IsGappsCustomer | Boolean | ||
IsLinkedWithZohocrm | Boolean | ||
IsPortalInvitationAccepted | Boolean | ||
IsSmsEnabled | Boolean | ||
IsSmsEnabledForPrimaryCp | Boolean | ||
LanguageCode | String | ||
Mobile | String | ||
Notes | String | ||
Outstanding | Double | ||
OutstandingReceivableAmount | Double | ||
PaymentReminderEnabled | Boolean | ||
PaymentTerms | Integer | ||
PaymentTermsLabel | String | ||
Phone | String | ||
PhotoUrl | String | ||
PricePrecision | Integer | ||
PricebookId | String | ||
PrimaryContactpersonId | String | ||
Salutation | String | ||
ShippingAddressAddressId | String | ||
ShippingAddressAttention | String | ||
ShippingAddressCity | String | ||
ShippingAddressCountry | String | ||
ShippingAddressFax | String | ||
ShippingAddressPhone | String | ||
ShippingAddressState | String | ||
ShippingAddressStateCode | String | ||
ShippingAddressStreet | String | ||
ShippingAddressStreet2 | String | ||
ShippingAddressZip | String | ||
BillingAddressAddressId | String | ||
BillingAddressAttention | String | ||
BillingAddressCity | String | ||
BillingAddressCountry | String | ||
BillingAddressFax | String | ||
BillingAddressPhone | String | ||
BillingAddressState | String | ||
BillingAddressStateCode | String | ||
BillingAddressStreet | String | ||
BillingAddressStreet2 | String | ||
BillingAddressZip | String | ||
BillingDay | String | ||
Skype | String | ||
Source | String | ||
String | |||
UnusedCredits | Double | ||
UnusedCreditsPayableAmount | Double | ||
UnusedCreditsPayableAmountBcy | Double | ||
UnusedCreditsReceivableAmount | Double | ||
UnusedCreditsReceivableAmountBcy | Double | ||
UpdatedTime | Datetime | ||
Website | String | ||
ZcrmAccountId | String | ||
ZcrmContactId | String |