Provides metadata for attributes of type State, describing state-related fields used for status tracking or categorization. Only available when Edition is set to CustomerService, FieldService, Marketing, ProjectOperations, or Sales.

View-Specific Information

SELECT

The driver uses the Microsoft Dynamics 365 API to process WHERE clause conditions built with the following column and operators. The rest of the filter is executed client-side within the driver.

• TableName supports the = and IN operators.

For example, the following queries are processed server-side:

SELECT * FROM StateAttributeMetadata WHERE TableName = 'teams'

SELECT * FROM StateAttributeMetadata WHERE TableName IN ('accounts', 'teams')

To query this view, you must include a value for the TableName filter.

Columns

Name	Type	Description
ColumnName [KEY]	String	The name of the column in the table where the state attribute is defined.
MetadataId	String	The unique identifier for the metadata associated with this state attribute.
OptionSet_Description_LocalizedLabels	String	Localized descriptions for the state options in various supported languages.
OptionSet_Description_UserLocalizedLabel_HasChanged	String	Indicates whether the user-customized description label for the state options has been modified.
OptionSet_Description_UserLocalizedLabel_IsManaged	Boolean	Specifies if the user-customized description label for the state options is managed (part of a managed solution).
OptionSet_Description_UserLocalizedLabel_Label	String	The user-customized label text for the description of the state options.
OptionSet_Description_UserLocalizedLabel_LanguageCode	Integer	The language code associated with the user-customized description label.
OptionSet_Description_UserLocalizedLabel_MetadataId	String	The unique identifier for the metadata of the user-customized description label.
OptionSet_DisplayName_LocalizedLabels	String	Localized display names for the state options in various supported languages.
OptionSet_DisplayName_UserLocalizedLabel_HasChanged	String	Indicates whether the user-customized display name label for the state options has been modified.
OptionSet_DisplayName_UserLocalizedLabel_IsManaged	Boolean	Specifies if the user-customized display name label for the state options is managed (part of a managed solution).
OptionSet_DisplayName_UserLocalizedLabel_Label	String	The user-customized label text for the display name of the state options.
OptionSet_DisplayName_UserLocalizedLabel_LanguageCode	Integer	The language code associated with the user-customized display name label.
OptionSet_DisplayName_UserLocalizedLabel_MetadataId	String	The unique identifier for the metadata of the user-customized display name label.
OptionSet_ExternalTypeName	String	The external type name associated with the state options, if applicable.
OptionSet_HasChanged	String	Indicates whether the state option set has been modified since its creation or last update.
OptionSet_IntroducedVersion	String	The version of the system in which the state option set was introduced.
OptionSet_IsCustomizable_CanBeChanged	Boolean	Indicates whether the state option set can be customized by the user or administrators.
OptionSet_IsCustomizable_ManagedPropertyLogicalName	String	The logical name of the managed property controlling the customizability of the state option set.
OptionSet_IsCustomizable_Value	Boolean	Specifies if the state option set is customizable.
OptionSet_IsCustomOptionSet	Boolean	Indicates whether the state option set is custom or part of a default configuration.
OptionSet_IsGlobal	Boolean	Specifies if the state option set is global (shared across entities) or local (specific to one entity).
OptionSet_IsManaged	Boolean	Indicates if the state option set is managed (part of a managed solution).
OptionSet_MetadataId	String	The unique identifier for the metadata associated with the state option set.
OptionSet_Name	String	The name of the state option set.
OptionSet_OptionSetType	String	The type of the state option set (e.g., picklist, drop-down).
OptionSet_ParentOptionSetName	String	The name of the parent option set, if this state option set is part of a hierarchy.
TableName	String	The name of the table where this state attribute is defined.