DataExtensionField
Represents a field within a data extension.
View-Specific Information
Select
The server 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 server processes other filters client-side within the server.
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 | System-controlled, read-only text string identifier for object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CustomerKey | String | User-supplied unique identifier for an object within an object type, which corresponds to the external key assigned to an object in the user interface. |
| Name | String | Name of the object or property. |
| DefaultValue | String | The default value for a data extension field if no value is supplied. |
| MaxLength | Int | Maximum length of the data. |
| IsRequired | Bool | Indicates whether the property must have a value specified. |
| Ordinal | Int | Indicates position of object within an array |
| IsPrimaryKey | Bool | Designates whether a data extension field is used as a primary key for that data extension. |
| FieldType | String | Designates data type for a data extension field. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Scale | Int | Indicates numeric precision for decimal properties. |
| Client_ID | Int | The Id of the client. |
| DataExtension_CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| StorageType | String | Indicates special storage properties for the field. Valid values are: Unspecified, Plain, Encrypted, or Obfuscated. |