ListFields
Lists fields configured for list views, indicating which columns appear and in what sequence.
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 the API. |
| AssociationDetails | String | Details about the field's association with other modules or entities. |
| BlueprintSupported | Boolean | Indicates whether this field is supported in Blueprint. |
| BusinesscardSupported | Boolean | Indicates whether this field is available in the business card view. |
| ConvertMappingAccounts | String | Mapping information when converting to an account. |
| ConvertMappingContacts | String | Mapping information when converting to a contact. |
| ConvertMappingDeals | String | Mapping information when converting to a deal. |
| CreatedSource | String | Indicates how or where the field was created. |
| Crypt | String | Encryption-related settings for the field. |
| CurrencyPrecision | Integer | Specifies the number of decimal places for currency values in this field. |
| CurrencyRoundingOption | String | Rounding option used for currency values in this field. |
| CustomField | Boolean | Indicates whether this field is a custom field. |
| DataType | String | The data type of the field, such as string, integer, or boolean. |
| DecimalPlace | Integer | Number of decimal places used for numeric values in the field. |
| DisplayField | Boolean | Indicates whether this field is used as a display field. |
| DisplayLabel | String | The label shown to users in the user interface. |
| DisplayType | Integer | Defines the display type setting of the field. |
| External | String | Details about external data linkage if the field is synced with an external system. |
| FieldLabel | String | The name of the field shown in the user interface. |
| FieldReadOnly | Boolean | Indicates whether the field is read-only. |
| Filterable | Boolean | Indicates whether the field can be used in filters. |
| HistoryTracking | String | Indicates whether historical changes to this field are tracked. |
| Id | String | The unique identifier for the field. |
| JsonType | String | Specifies the JSON data type used for the field when handling API responses. |
| Length | Integer | The maximum length allowed for the field value. |
| MassUpdate | Boolean | Indicates whether this field can be updated in bulk operations. |
| PickListValues | String | Comma-separated list of allowed values for picklist fields. |
| PickListValuesSortedLexically | Boolean | Indicates whether the picklist values are sorted alphabetically. |
| Profiles | String | List of user profiles that have access to this field. |
| QuickSequenceNumber | String | Sequence number used for quick field rendering. |
| ReadOnly | Boolean | Indicates whether the field is read-only for users. |
| Sortable | Boolean | Indicates whether the field is sortable in list views. |
| Subform | String | Name of the subform this field belongs to, if applicable. |
| SystemMandatory | Boolean | Indicates whether the field is required by the system. |
| Tooltip | String | Text shown to help users understand the purpose of the field. |
| Type | String | The field type, such as text, number, or date. |
| UiType | Integer | Defines the user interface rendering type of the field. |
| ViewTypeCreate | Boolean | Indicates whether the field is shown during record creation. |
| ViewTypeEdit | Boolean | Indicates whether the field is shown during record editing. |
| ViewTypeQuickCreate | Boolean | Indicates whether the field is available in quick create forms. |
| ViewTypeView | Boolean | Indicates whether the field is shown in record detail views. |
| Visible | Boolean | Indicates whether the field is visible to users. |
| Webhook | Boolean | Indicates whether the field can trigger a webhook. |
| ModuleName | String | The name of the module containing the field. |