DataExtensionField
Represents individual fields within a data extension in Salesforce Marketing Cloud. Each field defines the data type, length, and attributes of a column in a data extension. This view provides metadata that supports schema validation and data integrity checks.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM DataExtensionField WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled identifier (Id) that uniquely identifies the data extension field object. This value is assigned internally and cannot be modified by users. |
| PartnerKey | String | Specifies the unique partner-provided key that is associated with the data extension field. This value is available only through API interactions. |
| CustomerKey | String | Specifies the user-supplied unique Id that identifies the data extension field within its object type. This value corresponds to the external key that is displayed in the user interface. |
| Name | String | Specifies the name of the data extension field. The name is visible in the user interface and is used to identify the column when interacting with the data extension. |
| DefaultValue | String | Specifies the default value that is assigned to the data extension field when no explicit value is provided during a data operation. |
| MaxLength | Int | Specifies the maximum allowable length for the field's stored value. This constraint is enforced during data writes and updates. |
| IsRequired | Bool | Returns a value of 'true' when the data extension field must contain a value and cannot be null. It returns a value of 'false' when the data extension field can remain empty during data operations. |
| Ordinal | Int | Specifies the position of the data extension field within the field collection. This value determines the ordering when the system processes or displays fields. |
| IsPrimaryKey | Bool | Returns a value of 'true' when the data extension field functions as a primary key for the data extension. It returns a value of 'false' when the data extension field does not participate in primary key enforcement. |
| FieldType | String | Specifies the data type of the data extension field. This value defines how the system stores, validates, and interprets the field's contents. |
| CreatedDate | Datetime | Indicates the date and time when the data extension field was created. This value is system-controlled. |
| ModifiedDate | Datetime | Indicates the date and time when the system last modified the data extension field. This information assists with auditing and lifecycle management. |
| Scale | Int | Specifies the numeric scale that is used for decimal fields. This value determines the number of digits that appear to the right of the decimal point. |
| Client_ID | Int | Specifies the Id of the client that is associated with the data extension field. |
| DataExtension_CustomerKey | String | Specifies the user-supplied unique Id of the data extension to which this field belongs. This value links the field definition to its parent data extension. |
| StorageType | String | Specifies the field's storage behavior. Valid values are Plain, Encrypted, Obfuscated, or Unspecified. These settings determine how the system stores and secures the field's data. |