Axapta : Data Dictionary Properties

Data Dictionary

Property	Type		Description
Tables, Table Maps and Table Views
CacheLookup		=	Used to specify the caching algorithm used when a specific record is
			selected by a WHERE statement.
ChangedBy		=	The user who last modified the table.
ChangedDate		=	The date the table was last modified.
ChangedTime		=	The time the table was last modified.
ClusterIndex		=	Which index should be used as the cluster index. Only unique indexes can
			be specified.
ConfigurationKey		=	Used to specify a Configuration Key for the table.
CreatedBy		=	The user who created the table. If enabled the system field createdBy will
			be updated when a record is inserted.
CreatedDate		=	The date of record creation. If enabled the system field createdDate will be
			updated when a record is inserted.
CreatedTime		=	The time the record was created. If enabled the system field createdTime
			will be updated when a record is inserted.
CreatedTransactionId		=	If set, the transaction id belonging to the transaction which created the
			record will be stored.
CreateRecIdIndex		=	If enabled, an index called RecId containing the field recId will be created.
CreationDate		=	The date the table was created. If enabled the system field createdDate will
			be updated when a record is inserted.
FormRef		=	The name of a display menu Item which should be used when going to
			main table.
ID		=	The id of the table.
Label		=	The label of the table. This is the label the application user would normally
			identify the table with.
LockedBy		=	The user who has currently locked the table.
MaxAccessMode		=	Defines the access mode for the table.
ModifiedBy		=	If set, the user id belonging to the user who modified the record will be
			stored.
ModifiedDate		=	If set, the date of record modification will be stored.
ModifiedTime		=	If set, the time of record modification will be stored.
ModifiedTransactionId		=	If set, the transaction id belonging to the transaction which modified the
			record will be stored.
Name		=	The name of the table, table map or table view.
PrimaryIndex		=	Which index should be used as the primary index. Only unique indexes can
			be selected as a primary index.
SaveDataPerCompany		=	Should data be saved by company.
SecurityKey		=	Used to specify a Security Key for the table.
Systemtable		=	If enabled, the table will be considered being a system table.
TableContents		=	Defines which type of data the table contains.
TableGroup		=	Defines which table group the table should be a member of. The property is
			used by the kernel to determine the execution plan for selects using joins.
Temporary		=	Set for temporary tables.
TitleField1		=	The first field which is used in the title of forms.
TitleField2		=	The second field which is used in the title of forms.
Table Field, Map Field
Adjustment	String	=	Specify the horizontal adjustment if an
			extended data type is not specified.
AliasFor	All	=	Which field should this field be alias for.
AllowEdit	All	=	If set, the field is editable.
AllowEditOnCreate	All	=	If set, the field is editable when creating
ConfigurationKey	All	=	Used to specify a Configuration Key for
			the field.
EnumType	Enum	=	Specity an enum to be used for the table
			field.
ExtendedDataType	All	=	Specify an extended data type to be used
			for the table field.
FieldUpdate	Integer	=	Default setting is Absolute which will
	Real		overwrite the current value when the
			field is changed. Relative will allow
			several application users to write the
			same record and have the values entered
			by the users summed.
GroupPrompt	All	=	The field label to be used when used in a
			field group.
HelpText	All	=	Helptext that will be displayed in the
			status bar.
ID	All	=	The id of the field.
Label	All	=	Used to override the label of the
			ExtendDataType, if specified.
Mandatory	All	=	If set, a value must be filled in by the
			application user.
Name	All	=	The field name.
SaveContents	All	=	If enabled, the table field value will be
			stored in the database.
StringSize	String	=	Used to define the field length in
			characters if no extended data type is
			specified.
Type	All	=	Displays the base field type.
Visible	All	=	If enabled, the field is visible on forms.
View Fields
Aggregation	All	=	Choose the aggregation to be performed
			on the field.
ConfigurationKey	All	=	Used to specify a Configuration Key for
			the field.
DataField	All	=	Select a field from the selected data
			source.
DataSource	All	=	Data source which is used in the control.
			Data will be retrieved from this data
			source.
EnumType	Enum	=	Displays the enum used for the table
			field.
ExtendedDataType	All	=	Displays the extended data type used for
			the table field.
GroupPrompt	All	=	The field label to be used when used in a
			field group.
HelpText	All	=	Helptext which will be shown in the help
			text section of Axapta when the field is
			selected.
ID	All	=	The id of the view field.
Label	All	=	Used to override the label of the
			ExtendDataType.
Name	All	=	The field name.
StringSize	String	=	Displays the string size of the table field
			which is used.
Type	All	=	Displays the base field type.
Table Field Group, Map field group, View field group
Name		=	The group name.
Label		=	The label of the field group.
Table index
Name		=	The index name.
AllowDuplicates		=	If enabled, the index can contain two or more records with the same index
			key.
ConfigurationKey		=	Used to specify a Configuration Key for the index.
Enabled		=	If enabled, the index will be enabled.
ID		=	The id of the index.
Table Relation
Name		=	The Table Relation name.
Table		=	The table to be related.
Validate		=	Determines whether relations must be validated. If disabled the table
			relation will not be used in objects as forms and reports.
Table Relation Field
Field	Normal	=	One of the fields which will be a part of
	Field fixed		the field relation.
RelatedField	Normal	=	One of the fields which will be a part of
	Related field fixed		the field relation.
Value	Field fixed	=	Specifies a fixed value for a relation.
	Related field fixed		Normally used for setting the value of an
			enum entry.
Table DeleteAction
DeleteAction		=	Action to be performed when deleting a record.
Table		=	Table used for the delete action.
Map Mapping
MappingTable		=	Defines which table the map should be mapped to.
Map Field Mapping
MapField		=	The field in the map.
MapFieldTo		=	Defines which field the map should be mapped to.
Extended Data Type
Adjustment	String	=	Specify the horizontal adjustment, if the
			Extended Data Type does not extend
			another Extended Data Type.
Alignment	All	=	Horizontal alignment of the value.
AllowNegative	Integer	=	If disabled, only positive values can be
	Real		entered.
ArrayLength	All	=	Displays how many arrays the Extended
			Data Types consists of.
AutoInsSeparator	Real	=	Used to have MorphX to set a decimal
			separator.
ButtonImage	All	=	Which image should be displayed on the
			right side of the control when lookup is
			possible.
ChangeCase	String	=	Used to set the data to lower case or
			upper case.
ConfigurationKey	All	=	Used to specify a Configuration Key for
			the Extended Data Type.
DateDay	Date	=	Specify how day is shown. Windows
			regional settings are used as default.
DateFormat	Date	=	Set the date format. Windows regional
			settings are used as default.
DateMonth	Date	=	Specify how month is shown. Windows
			regional settings are used as default.
DateSeparator	Date	=	Set the date separator. Windows regional
			settings are used as default.
DateYear	Date	=	Specify how year is shown. Windows
			regional settings are used as default.
DecimalSeparator	Real	=	Specify the decimal separator. Windows
			regional settings are used as default.
DisplaceNegative	Real	=	Adjust the position of negative values
			printed.
DisplayHeight	String	=	Sets the maximal number of lines to be
			shown at one time for the control.
DisplayLength	All	=	Sets the maximal number of characters to
			be shown at one time for the control.
EnumType	Enum	=	Specify an enum to be used.
Extends	All	=	If set, certain properties will be inherited
			from this Extended Data Type like
			Alignment and StringSize.
FormatMST	Real	=	Format the value using the settings from
			the standard company currency.
FormHelp	All	=	Form to be used when performing
			lookup in the control.
HelpText	All	=	Help text that will be displayed in the
			status bar.
Label	All	=	Set the label to be used.
Name	All	=	Name of the Extended Data Type.
NoOfDecimals	Real	=	Set the number of decimals to be shown.
RotateSign	Integer	=	Used to invert negative values.
	Real
ShowZero	Integer	=	Defines whether zero values must be
	Real		shown.
SignDisplay	Integer	=	Set how to display negative values.
	Real
StringSize	String	=	Used to define the length in characters.
Style	Enum	=	Defines the graphical representation of
			the Extended Data Type.
ThousandSeparator	Real	=	Specify the thousand separators.
			Windows regional settings are used as
			default.
TimeFormat	Time	=	Set the time format. Windows regional
			settings are used as default.
TimeHours	Time	=	Specify whether to show hours.
			Windows regional settings are used as
			default.
TimeMinute	Time	=	Specify whether to show minutes.
			Windows regional settings are used as
			default.
TimeSeconds	Time	=	Specify whether to show seconds.
			Windows regional settings are used as
			default.
TimeSeparator	Time	=	Set the time separator. Windows regional
			settings are used as default.
Base Enum
ChangedBy		=	The user who last modified the Base Enum.
ChangedDate		=	The date the Base Enum was last modified.
ChangedTime		=	The time the Base Enum was last modified.
ConfigurationKey		=	Used to specify a Configuration Key for the Base Enum.
CreatedBy		=	The user who created the Base Enum.
CreatedTime		=	The time the Base Enum was created.
CreationDate		=	The date the table was created.
DisplayLength		=	Sets the maximal number of characters to be shown at one time for the
			control.
Help		=	Help text that will be displayed in the status bar.
ID		=	The id of the Base Enum.
Label		=	The label of the table. This is the label the user would normally identify the
			Base Enum with.
LockedBy		=	The user who has currently locked the table.
Name		=	The name of the Base Enum.
Style		=	Defines the graphical representation of the Base Enum.
UsedEnumValue		=	If disabled, Axapta will number the Base Enum entries and the property
			EnumValue on Base Enum entries will not be used.
Base Enum Entry
ConfigurationKey		=	Used to specify a Configuration Key for the Base Enum Item.
EnumValue		=	This is the Integer value that will be stored in the database.
Label		=	Name which will be shown.
Name		=	AOT name of the Base Enum Item.
License Codes
ChangedBy		=	The user who last modified the License Code.
ChangedDate		=	The date the License Code was last modified.
ChangedTime		=	The time the License Code was last modified.
CreatedBy		=	The user who created the License Code.
CreatedTime		=	The time the License Code was created.
CreationDate		=	The date the License Code was created.
Group		=	Which License Code Group should the License Code be a part of.
ID		=	The id of the License Code.
Label		=	The label for the License Code. This is the label the user would normally
			identify the License Code with.
LockedBy		=	The user who has currently locked the table.
Type		=	Most license codes are Boolean values. Only changed when counting the
			number of licenses such as users or COM users.
Configuration Key, Security Key
ChangedBy	Both	=	The user who last modified the key.
ChangedDate	Both	=	The date the key was last modified.
ChangedTime	Both	=	The time the key was last modified.
ConfigurationKey	Security Key	=	Used to specify a Configuration Key for
			the key.
CreatedBy	Both	=	The user who created the key.
CreatedTime	Both	=	The time the key was created.
CreationDate	Both	=	The date the key was created.
ID	Both	=	The id of the key.
Label	Both	=	The label of the key. This is the label the
			user would normally identify the key
			with.
LicenseCode	Configuration Key	=	License code used to activate this key.
LockedBy	Both	=	The user who has currently locked the
			key.
Name	Both	=	The key name.
ParentKey	Both	=	Parent key for this key. If the parent key
			is disabled, it will influence this key as
			well.