DataExtensionField

From $1

    Table of contents
    1. 1. Definition
    2. 2. Properties
    3. 3. Description
    4. 4. Methods
    5. 5. Use Cases
    Doc-Wiki-BannerHK.png

    (Click the banner to go to the related Docs.Code.ExactTarget.com page.)

    Definition

    Represents a field within a data extension.

    Properties

    This object has following properties.

    NameData TypeDescription
    AttributeMapsAttributeMap[]Reserved for future use.
    ClientClientIDSpecifies the account ownership and context of an object.
    CorrelationIDxsd:stringIdentifies correlation of objects across several requests.
    CreatedDatexsd:dateTimeRead-only date and time of the object's creation.
    CustomerKeyxsd:stringUser-supplied unique identifier for an object within an object type (corresponds to the external key assigned to an object in the user interface).
    DataExtensionDataExtensionSpecifies the data extension.
    DataTypexsd:stringThis has been deprecated.  Please use ValueType. (PropertyDefinition) The data type of the parameter that will be passed to the Data Extract (can be used to dynamically build a user interface with some basic data validation). (ExtractParameterDescription)
    DefaultValuexsd:stringThe default value for a data extension field if no value is supplied (Include Now() as the default value if you wish to have a field default to today's date). Used by ExtractParameterDescription as the default value for the parameter if not supplied when a data extract is executed. Used by PropertyDefinition if the default value for the attribute if not supplied for a data profile attribute.
    Descriptionxsd:stringDescribes and provides information regarding the object.
    DisplayOrderxsd:intSpecifies the position in which the attribute will appear on the Subscriber Profile Center page.
    FieldTypeDataExtensionFieldTypeDesignates data type for a data extension field.
    IDxsd:intRead-only legacy identifier for an object. Not supported on all objects. Some objects use the ObjectID property as the ExactTarget unique ID.
    IsAccountPropertyxsd:booleanIndicates whether the property is specific to the account.  Reserved for future use.
    IsContextSpecificxsd:booleanReserved for future use.
    IsCreatablexsd:booleanIndicates if the property can be set on a Create call. A value of true indicates it can be created. (PropertyDefinition) Indicates whether object can be created. A value of true indicates it can be created. (ObjectDefinition) Indicates whether the field can be created. A value of true indicates it can be created. (DataExtensionField)
    IsEditablexsd:booleanIndicates if the property can be edited by the end-user in the profile center
    IsFilterablexsd:booleanIndicates if you can filter on this property. A value of true indicates the property can be specified in a SimpleFilterPart in a Retrieve call. Reserved for future use.
    IsNillablexsd:booleanIndicates whether the property can contain a NULL value. Reserved for future use.
    IsPartnerPropertyxsd:booleanIndicates if the property is specific to a partner.  Reserved for future use.
    IsPrimaryKeyxsd:booleanDesignates whether a data extension field is used as a primary key for that data extension.
    IsQueryablexsd:booleanIndicates whether the property can be queried.  Reserved for future use.
    IsRequiredxsd:booleanIndicates whether the property must have a value specified. Create calls must include a supplied value, while Update and Delete calls do not require a value.
    IsRestrictedPicklistxsd:booleanIndicates whether the property has a restricted list of valid values.
    IsRetrievablexsd:booleanIndicates if object data can be retrieved.
    IsSendTimexsd:booleanIndicates whether the property is a send time attribute.
    IsUpdatablexsd:booleanIndicates whether object can be updated.
    IsViewablexsd:booleanIndicates whether the property is viewable by the end-user in the profile center.
    Labelxsd:stringName or text that is displayed next to the field.
    MarkupsAPIProperty[]Deprecated.
    MaxLengthxsd:intMaximum length of the data.
    MaxValuexsd:stringIndicates the maximum value that this property can be set to.
    MinLengthxsd:intSpecifies the minimum length of the data.
    MinValuexsd:stringSpecifies the minimum value that this property can be set to.
    ModifiedDateNullable`1Indicates the last time object information was modified.
    Namexsd:stringName of the object or property.
    ObjectIDxsd:stringSystem-controlled, read-only text string identifier for object.
    ObjectStatexsd:stringReserved for future use.
    Ordinalxsd:intIndicates position of object within an array
    OwnerOwnerDescribes account ownership of subscriber in an on-your-behalf account.
    PartnerKeyxsd:stringUnique identifier provided by partner for an object, accessible only via API.
    PartnerMapxsd:stringDeprecated.
    PartnerPropertiesAPIProperty[]A collection of metadata supplied by client and stored by system - only accessible via API.
    PicklistItemsPicklistItem[]Represents a list of the valid values for the property.
    Precisionxsd:intDefines numeric precision for decimal properties.
    PropertyTypePropertyType
    1. Indicates the ExactTarget data type of the property.
    ReferencesAPIObject[]Indicates the object types of the referenced objects. Reserved for future use.
    RelationshipNamexsd:stringIndicates the name of the relationship (e.g. One-to-One, One-to-Many). Reserved for future use.
    Scalexsd:intIndicates numeric precision for decimal properties.
    Statusxsd:stringDefines status of object.  Status of an address.
    ValueTypeSoapTypeValueType indicates the actual data type of the value that will be stored in this property. Reserved for future use.

    Description

    You can perform a Retrieve call on this object and request DataExtension.CustomerKey. You cannot update properties on this object, and it does not support the Delete method.

    Methods

    This object has the following methods.

    NameDescription
    RetrieveRetrieves an individual object or a batch of objects.

    Use Cases


    This page was last updated by Ryan Williams on Fri, 06 Jan 2012 22:01:02 GMT.

    If you require assistance with the ExactTarget application, please contact Global Support. If you wish to send Ryan direct feedback, fill out the form below:

     


    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 14805 backwards:
       
    Tags: (Edit tags)
    • No tags
     
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin