Data Types for a field

You can specify different data types for a field, in the Add Field or Edit Field window. The attribute types are displayed based on the selected Data Type.

The table lists the available data types and the related attributes:


Type	Attributes
Binary	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.
Calculated Number	Description The description of the calculated field. Add Field To define the calculation, see Defining a Calculated Number field
Calculated String	Description The description of the calculated field. Add Field To add fields for this attribute,see Defining a Calculated String field
Decimal	Precision The maximum number of digits allowed for this field. For example, the number 123.45 has a precision of 5. Scale The maximum number of decimal places. For example, the number 123.45 has a scale of 2.
Double	Is Percentage If this check box is selected, the field is identified as percentage value. The Numeric control is incompatible with entity properties of Data Type set to Double that have Is Percentage set to True. To display values of such entity properties correctly either bind to another control type such as text box, or change Is Percentage to False and set the Numeric control property, Format Type, to Percent.
Email	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.
Memo	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.
Phone	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.
Pick List	Length The maximum length of the field. Storage The format in which the data is stored. Possible values: Code ID Number Text Pick List To define the pick list, see Defining a Pick List field
Text	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.
URL	Is Encrypted If this check box is selected, the field is encrypted automatically when written to the database and decrypted when read. The value is displayed as plain text in the business objects. For example, this attribute can be used to secure a password property. Length The maximum length of the field.

Note: Additional attributes do no exist for these data types:

Boolean
Byte
Char
Date/Time
Guid
Integer
Owner
Short
Single
Standard Id
True/False
Yes/No