ListFields
Lists the fields displayed in list views for a module, indicating column order and visibility.
View-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator.
- ModuleName supports the '=' operator.
For example, the following queries are processed server-side:
SELECT * FROM ListFields WHERE ModuleName = 'Deals'
Columns
| Name | Type | Description |
| ApiName | String | The name of the field used in API operations. |
| AssociationDetails | String | Details about associations configured for this field. |
| BlueprintSupported | Boolean | Indicates whether the field is supported in blueprint processes. |
| BusinesscardSupported | Boolean | Indicates whether the field is shown in business card views. |
| ConvertMappingAccounts | String | The account field mapping used during lead conversion. |
| ConvertMappingContacts | String | The contact field mapping used during lead conversion. |
| ConvertMappingDeals | String | The deal field mapping used during lead conversion. |
| CreatedSource | String | The source from which the field was created. |
| Crypt | String | Indicates whether the field is encrypted. |
| CurrencyPrecision | Integer | Number of digits allowed after the decimal point in currency values. |
| CurrencyRoundingOption | String | The rounding rule used for currency values in this field. |
| CustomField | Boolean | Indicates whether the field is custom-defined. |
| DataType | String | The data type assigned to the field. |
| DecimalPlace | Integer | Number of decimal places supported by the field. |
| DisplayField | Boolean | Indicates whether the field is used as a primary display field. |
| DisplayLabel | String | The display label shown in the user interface. |
| DisplayType | Integer | The display type identifier for the field. |
| External | String | Indicates external integration settings or dependencies. |
| FieldLabel | String | The label used to identify the field within the module. |
| FieldReadOnly | Boolean | Indicates whether the field is read-only. |
| Filterable | Boolean | Indicates whether the field can be used in filters. |
| HistoryTracking | String | Specifies whether changes to this field are tracked over time. |
| Id | String | The unique identifier of the field. |
| JsonType | String | The JSON data type used when interacting with the field in the API. |
| Length | Integer | The maximum number of characters allowed in the field. |
| MassUpdate | Boolean | Indicates whether the field supports bulk updates. |
| PickListValues | String | The list of allowed values for a picklist field. |
| PickListValuesSortedLexically | Boolean | Indicates whether picklist values are sorted alphabetically. |
| Profiles | String | The list of profiles for which the field is available or restricted. |
| QuickSequenceNumber | String | The sequence number assigned for quick access or display. |
| ReadOnly | Boolean | Indicates whether the field is restricted from being edited. |
| Sortable | Boolean | Indicates whether the field supports sorting operations. |
| SystemMandatory | Boolean | Indicates whether the field is required by the system. |
| Tooltip | String | The tooltip text shown for the field in the user interface. |
| Type | String | The internal type designation for the field. |
| UiType | Integer | The user interface type identifier used for rendering the field. |
| ViewTypeCreate | Boolean | Indicates whether the field appears during record creation. |
| ViewTypeEdit | Boolean | Indicates whether the field appears during record editing. |
| ViewTypeQuickCreate | Boolean | Indicates whether the field appears in quick create forms. |
| ViewTypeView | Boolean | Indicates whether the field is visible in the standard record view. |
| Visible | Boolean | Indicates whether the field is visible in the module layout. |
| Webhook | Boolean | Indicates whether changes to the field trigger webhook notifications. |
| Searchable | Boolean | Indicates whether the field can be used in search queries. |
| SharingProperties | String | For lookup fields, indicates whether the user has access to referenced records. |
| ModuleName | String | The name of the module that contains this field. |