# FieldDefinition: Field Definition - Name: `FieldDefinition` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Field Definition ## Table Columns The columns of the table `FieldDefinition` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ControllingFieldDefinitionId` | `string` | Controlling Field Definition ID | ☐ | | | `DataType` | `string` | Data Type | ☐ | | | `DeveloperName` | `string` | Developer Name | ☐ | | | `DurableId` | `string` | Durable ID | ☐ | | | `EntityDefinitionId` | `string` | Entity Definition ID | ☐ | | | `ExtraTypeInfo` | `string` | Extra Type Info | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsApiFilterable` | `boolean` | Is API Filterable | ☐ | | | `IsApiGroupable` | `boolean` | Is API Groupable | ☐ | | | `IsApiSortable` | `boolean` | Is API Sortable | ☐ | | | `IsCalculated` | `boolean` | Is Calculated | ☐ | | | `IsCompactLayoutable` | `boolean` | Is Compact Layoutable | ☐ | | | `IsCompound` | `boolean` | Is Compound | ☐ | | | `IsFieldHistoryTracked` | `boolean` | Is Field History Tracked | ☐ | | | `IsHighScaleNumber` | `boolean` | Is High Scale Number | ☐ | | | `IsHtmlFormatted` | `boolean` | Is HTML Formatted | ☐ | | | `IsIndexed` | `boolean` | Is Indexed | ☐ | | | `IsListFilterable` | `boolean` | Is List Filterable | ☐ | | | `IsListSortable` | `boolean` | Is List Sortable | ☐ | | | `IsListVisible` | `boolean` | Is List Visible | ☐ | | | `IsNameField` | `boolean` | Is Name Field | ☐ | | | `IsNillable` | `boolean` | Is Nillable | ☐ | | | `IsWorkflowFilterable` | `boolean` | Is Workflow Filterable | ☐ | | | `Label` | `string` | Label | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `Length` | `int32` | Length | ☐ | | | `MasterLabel` | `string` | Master Label | ☐ | | | `NamespacePrefix` | `string` | Namespace Prefix | ☐ | | | `Precision` | `int32` | Precision | ☐ | | | `PublisherId` | `string` | Publisher ID | ☐ | | | `QualifiedApiName` | `string` | Qualified API Name | ☐ | | | `ReferenceTargetField` | `string` | Reference Target Field | ☐ | | | `ReferenceTo` | `string` | Reference to | ☐ | | | `RelationshipName` | `string` | Relationship Name | ☐ | | | `RunningUserFieldAccessId` | `string` | Running User Field Access ID | ☐ | | | `Scale` | `int32` | Scale | ☐ | | | `ServiceDataTypeId` | `string` | Service Data Type ID | ☐ | | | `ValueTypeId` | `string` | Value Type ID | ☐ | |