Field Properties in Navision

Just like tables, all the fields in C/SIDE have a number of properties that determine their behavior. When you create a field, C/SIDE automatically suggests a number of default values for these properties. Depending on the purpose of the field, you will sometimes want to change these default values.
The above table list the properties that are common to most field types.

PropertyName	Description
Field No. Property	Assigns a unique numeric ID to this Field.
Name Property	Specifies the name of the field.
Caption Property	Specifies the text used to identify a control based on the field.
CaptionML Property	Specifies the text that is used to identify a control or other object in the user interface. The CaptionML property is multilanguage enabled and can contain a list of text in different languages. The text that is used is selected according to the current language setting of the user.
CaptionClass Property	Controls the caption that is used in the label of a field in a database table or in the label of a control on a form.
Description Property	Includes an optional description of the field. This description is for internal purposes only and is not visible to the end user.
Data Type Property	Specifies the data type of a table field.
Enabled Property	Determines whether the field is enabled.

A field may have additional properties, depending on its data type. The following table lists properties that apply to various field types.

PropertyName	Description
DataLength Property	Specifies the maximum length of the data stored in a code or text field.
InitValue Property	Defines an initial value for a field.
FieldClass Property	Define the class for a field. That is, specifies whether it is a normal field, a FlowField, or a FlowFilter field.
CalcFormula Property	Defines a formula used by a FlowField.
AltSearchField Property	Defines an alternative search field.
DecimalPlaces Property	Sets the number of decimal places shown to the user. This property also performs validation of whether user input conforms to this setting.
Editable Property	Determines whether a field can be edited.
NotBlank Property	Forces the user to make a non-blank entry in this field.
BlankNumbers Property	Determines whether a range of numbers will be set to blank as they are formatted.
Numeric Property	Forces the user to enter numbers in this field.
CharAllowed Property	Sets the characters you will allow the user to enter in this field.
DateFormula Property	Validates the syntax of a date expression entered by the user.
Standard day/time unit Property	Specifies the unit of measure that is used when you enter data into Duration fields.
MinValue Property	Sets the minimum value for the contents of a field.
MaxValue Property	Sets the maximum value for the contents of a field.
Title Property	Adds a title to a field. The first letter in each word is capitalized.
ValuesAllowed Property	Specifies the values you want to allow in the field. Can be specified either as a range or as distinct values, or as a combination of these.
AutoIncrement Property	Specifies whether each field value is automatically given a new number that is greater than the number given to the previous value.
TableRelation Property	Defines relationships to other tables.
TestTableRelation Property	Indicates whether the field is included in table relationship tests.
TableIDExpr Property	Specifies the ID of the table to which you want to apply a table filter.
BlankZero Property	Determines whether the fields appears blank if the value is 0 (zero) or FALSE.
DataLength Property	Defines the length of a data field.
OptionString Property	Defines an option string (a comma-separated string of options). The maximum size is 1000 characters.
ClosingDates Property	Determines whether closing dates are allowed.
AutoFormatType Property	Determines how data is formatted.
AutoFormatExpr Property	Determines how data is formatted.
OptionCaption Property	Defines the text string options that are displayed to the user.