Extended Data Type Properties

Extended data type properties are divided into the following groups:

  • Common to all extended data types

  • Available only for certain base data types

The following properties are related to report models that are used to add information to a report. For more information see, Create Reports Using Report Builder.

  • AnalysisDefaultSort

  • AnalysisGrouping

Property

Description

ID

Read-only property.

Name

Specifies the name of the type.

The name is used when referring to the type from X++.

Label

Specifies a label for the type that is shown when the type is used in a form or report.

HelpText

Creates a Help string for the extended data type. The Help string is displayed when the type is used in a form.

FormHelp

Specifies a form to be used when performing lookup from a field in a form.

ArrayLength

Read-only property.

By default, the ArrayLength is 1. To add array elements to the extended data type, right-click the Array Element node and select New Array Element. The value of the ArrayLength property will increase to reflect this.

DisplayLength

Specify a maximum number of characters to be displayed in a form or report.

ConfigurationKey

Specifies the configuration key for the extended data type.

ButtonImage

Specifies the image to be displayed when the extended data type is used for a lookup button on a form.

The possible values are:

  • Arrow (default)

  • Mail (possible use: the email type)

  • URL (possible use: the URL type)

  • ThreeDots (...)

  • OpenFile (possible uses: the FilenameOpen and FilenameSave types)

  • Calendar (possible use: date types)

AnalysisDefaultSort

Specifies the default sort order for a field in a report model with this extended data type. For more information about report models, see Create an Ad Hoc Report Model.

AnalysisGrouping

Specifies whether a field with this extended data type is grouped by default when the field is added to a report using the Report Builder for Microsoft SQL Server Reporting Services.

The property is automatically set to Discouraged for currency amounts. For other fields that are highly unique, you should set the property to Discouraged. For more information about report models, see Create an Ad Hoc Report Model.

CollectionLabel

Specifies the label that is used to display the plural name of a field with this extended data type.

CreatedBy, CreationDate, CreatedTime, ChangedBy, ChangedDate, ChangedTime, LockedBy

Read-only properties.

Extends

Enables you to base the extended data type on another extended data type.

Alignment

Changes the alignment of the text (Left, Right, Center).

For rules and hints about setting these properties, see Best Practice for extended data types.

Leave these properties set to Auto unless specified otherwise in the following table.

Property

Exists for these types:

Description

AllowNegative

Integer

Real

Specifies whether the field can accept negative values.

AutoInsSeparator

Real

Specifies whether the system inserts a decimal separator automatically. For example, if you enter 2222, the system automatically shows 2222.00.

ChangeCase

String

Specifies how text entered in a string control should be formatted.

For example, the text can be formatted as upper case, or with title capitalization.

DateDay

Date

Specifies how the day should be displayed.

DateFormat

Date

Specifies the layout of a date.

DateMonth

Date

Specifies how the month should be displayed.

DateSeparator

Date

Specifies the separators between year, month, and day.

DateYear

Date

Specifies how the year should be displayed.

DecimalSeparator

Real

Specifies the decimal separator. The default (Auto) setting is whatever is specified in your system setup.

DisplaceNegative

Integer

Real

Specifies if negative numbers should be indented to the left.

DisplayHeight

String

Specifies the number of lines to be displayed simultaneously when the extended data type is displayed in a form.

EnumType

Enum

Specifies the base enum used to create the extended data type.

NoOfDecimals

Real

Determines the number of decimals when a value displays on a form or a report.

RotateSign

Integer

Real

Choose this to negate the number, that is, change - to + and + to -.

ShowZero

Integer

Real

Specifies whether the value zero should be shown as an empty field.

If the value zero in fields of this type means null/nothing, ShowZero set to No.

SignDisplay

Integer

Real

Specifies whether the sign of a number should be displayed, if it is a negative number, and also whether the sign should be before or after the number.

Normally set to Auto. Can be set to None if used with DisplaceNegative.

StringSize

String

Specifies the maximum size of the string.

TimeFormat

Time

Specifies how times should be formatted.

TimeHours

Time

Specifies whether hours should be included.

TimeMinute

Time

Specifies whether minutes should be included.

TimeSeconds

Time

Specifies whether seconds should be included.

TimeSeparator

Time

Specifies the separator to be used when displaying times.

ThousandSeparator

Real

Specifies the thousand separator.

Community Additions

ADD
Show: