Data Extension fields verified

Quick reference about Data Extension fields in Salesforce Marketing Cloud (SFMC) with SSJS (server-side JavaScript).

Allowed attributes per field type

[
    {
        "Name": "MyTextField",
        "FieldType": "Text",
        "MaxLength": 50,
        "DefaultValue": "Example text"
    },
    {
        "Name": "MyNumberField",
        "FieldType": "Number",
        "DefaultValue": "25"
    },
    {
        "Name": "MyDateField",
        "FieldType": "Date",
        "DefaultValue": "2022-09-30T13:30:00"
    },
    {
        "Name": "MyBooleanField",
        "FieldType": "Boolean",
        "DefaultValue": "False"
    },
    {
        "Name": "MyEmailField",
        "FieldType": "EmailAddress"
    },
    {
        "Name": "MyPhoneField",
        "FieldType": "Phone"
    },
    {
        "Name": "MyDecimalField",
        "FieldType": "Decimal",
        "Scale": 2,
        "MaxLength": 18
    },
    {
        "Name": "MyLocaleField",
        "FieldType": "Locale"
    }
    
]

Commonly allowed attributes

{
    "IsPrimaryKey": true,
    "IsRequired" : true,
    "Ordinal": 0
}

WARNING

The fields of type EmailAddress, Phone and Locale are not allowed to have a DefaultValue attribute. Decimal type field should be allowed, but returns an error.