MSD Navision Table and Field Property

Table Properties

A table in C/SIDE has a number of properties that determine the behavior of the table. When you create a table, C/SIDE automatically defines a number of default values for these properties.

Property name	Use
ID Property	Sets a unique identifier for the table.
Name Property	Defines the table name, which is used as the table caption.
Caption Property	Displays the table caption in the currently selected language. This value is taken from the CaptionML Property, if a value is set.
CaptionML Property	Provides the text that is used to identify a control or other object in the user interface. This property is multilanguage enabled and can contain a list of text in different languages. The text that is actually used is selected according to the current language setting of the user.
Description Property	Include an optional description of the table. This description is for internal purposes only and is not visible to the end user. A short description of the table’s purpose makes it easier to maintain the application.
DataPerCompany Property	Determines whether data in this table is available to all companies or only the current company. Yes if data is available only to this company; otherwise, No. The default value is Yes.
Permissions Property	Defines extended permissions for the table.
LookupFormID Property	Defines the ID of the form you want to use as a lookup.
DrillDownFormID Property	Defines the ID of the form you want to use as a drill down.
DataCaptionFields Property	Defines a list of fields to be used as captions when a record from this table is displayed in a form or a page.
PasteIsValid Property	Use this property to enable inserting records into this table using the paste command. Yes if you want to allow insert by pasting; otherwise, No. The default is Yes.
LinkedObject Property	Use this property to link to SQL Server objects. Yes to link the table to an existing SQL Server object.
LinkedInTransaction Property	Determines whether the table can read and modify data from linked data sources, such as Microsoft Office Excel, Access, or another SQL server. This property is only visible when the value of the LinkedObject Property is set to Yes.

Field Properties

C/SIDE contains the following field properties. The first table list the properties that are common to most field types.

Property name	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.

Property Name	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. For more information, see Setting Relationships Between Tables.
ValidateTableRelation Property	Indicates whether a table relationship is validated.
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.
SignDisplacement Property	Shifts negative values to the right for display purposes.
SQL Data Type Property	Specifies the data type you want to allow in a code field. This property applies to code fields in the SQL Server Option for Microsoft Dynamics NAV.
ClearOnLookup Property	Specifies whether the current contents of the field are deleted before the value the user selects via the lookup is added.
SubType Property	Defines the subtype of a BLOB field, for example a Bitmap or a Memo.
Compressed Property	Specifies whether a BLOB is compressed. This property only applies to BLOB fields and only on the SQL Server Option.
OptionCaption Property	Defines the text string options that are displayed to the user.
OptionCaptionML Properrty	Sets the strings that are displayed to the user for selecting an option. The OptionCaptionML property is only used if the field has an OptionString property. The OptionString property contains the set of values that are acceptable choices, and it is one of these values that will be saved in the database or used in C/AL code.