August 18th, 2009

You are currently browsing the articles from KomKid.Net written on August 18th, 2009.

Axapta : Report Properties

Report

Property	Type/Section		Description
Report
Name		=	AOT name of the report.
AllowCheck		=	If set Configuration keys and Security keys will be validated at runtime.
Autojoin		=	Joins the reports query with the caller. If the report is called from a form,
			the report will be joined with the called record.
Interactive		=	Specify whether the dialog is shown to the user at runtime.

Report design
Name		=	Name of the design. Used to identify the design, if the report have more
			than one design.
AutoDeclaration		=	If set to Yes, the report design node referred from X++ by using the section
			name.
Caption		=	Caption for the report. If the standard report template InternalList is used,
			caption will be used to print the name of the report in the header.
Description		=	Will be printed in the top bar of the print to screen window. If not specified,
			the Caption text is printed instead.
JobType		=	Can be used to identify the design. JobType is not printed.
EmptyReportPrompt		=	Specify a text to be printed in the Infolog, if the report is empty. If not used,
			the default text is printed.
ArrangeWhen		=	Specify when the controls in the design must be arranged.
ColorScheme		=	Specify whether to use RGB colors, or Windows color scheme.
ForegroundColor		=	RGB value or name of Windows color scheme item.
ResolutionX		=	Seems as having no effect.
ResolutionY		=	Seems as having no effect.
Ruler		=	Used to set the measure units for the visual designer.
ReportTemplate		=	Choose a report template to be used for the design.
TopMargin		=	Set the top margin for the design.
BottomMargin		=	Set the bottom margin for the design.
LeftMargin		=	Set the left margin for the design.
RightMargin		=	Set the right margin for the design.
Language		=	Set a fixed language for the design. If not set the users default language will
			be used.
Font		=	The font to be used for the design. If not specified the default font is used.
FontSize		=	The font size to be used for the design. If not specified the default font size
			is used.
Italic		=	Set the design to italic.
Underline		=	Underline text in the design.
Bold		=	Set the design to bold.
PrintFormName		=	The application form used for the printer dialog. If the report is called using
			the report runbase framework, this form is not used.
HideBorder		=	Skip printing labels and lines around controls.
Orientation		=	Fix orientation to portrait or landscape. A design will default be printed
			landscape, if the there are too many controls to fit portrait without scaling.
FitToPage		=	Determine whether to scale the report, if the controls cannot fit in the width
			of the report.
RemoveRepeatedHeaders		=	Skip headers where no records are printed for the header.
RemoveRepeatedFooters		=	Skip footers where no records are printed for the footer.
RemoveRedundantFooters		=	Skip printing sum footers if only one record is to be summed.

Auto design
GrandHeader		=	Defines whether to print a header text at sorting breaks. This header text is
			identified as super grand header, and will be printed before the grand
			header which can be set at the body section.
GrandTotal		=	Will print a super grand total for controls where the property SumAll,
			SumPos or SumNeg is set.
HeaderText		=	This text will be printed as header text at sorting breaks if GrandHeader is
			set to Yes. If no text has been entered, the default test will be printed.
TotalText		=	If GrandTotal is set to Yes, this text will be printed as super grand total text,
			instead of the default text.

Sections controls
ArrangeMethod	All	=	Set the orientation for the arranged
			controls.
ArrangeWhen	All	=	Specify when the controls in the section
			must be arranged.
AutoDeclaration	ProgrammableSection	=	If set to Yes, the section can be referred
	Body		from X++ by using the section name.
	PageFooter
Bold	All	=	Set the bold level for headings and data in
			the section.
Bottom	ProgrammableSection	=	Set a fixed position for the section
	Prolog		calculated from the bottom of the page.
	Body
	Epilog
BottomMargin	All	=	Set the margin below the section data.
ColorScheme	All	=	Specify whether to use RGB colors, or
			Windows color scheme.
ColumnHeadingsStrategy	ProgrammableSection	=	Define whether labels must be word
	Body		wrapped or printed staggered. If set to
	PageFooter		DisplacedLines, the heading labels will be
			printed staggered on two lines, if the labels
			cannot be fit on a single line.
Columns	All	=	This property has no function. Used on
			forms to define the number of columns for
			arranging sub controls.
Columnspace	All	=	Set the space between columns.
ControlNumber	ProgrammableSection	=	The identification for a programmable
			section. Used to execute the section from
			X++.
Font	All	=	The font to be used for the section. If not
			specified the default font is used.
FontSize	All	=	The font size to be used for the section. If
			not specified the default font size is used.
FooterText	Body	=	Only available in auto designs. This text
			will be printed as grand total text, instead
			of the default text.
ForegroundColor	All	=	RGB value or name of Windows color
			scheme item.
GrandHeader	Body	=	Only available in auto designs. Defines
			whether to print a header text at sorting
			breaks.
GrandTotal	Body	=	Only available in auto designs. Will print a
			grand total for controls where the property
			SumAll, SumPos or SumNeg is set.
HeaderText	Body	=	Only available in auto designs. This text
			will be printed as header text at sorting
			breaks. If not text entered, the default test
			will be printed.
Height	All	=	Set a fixed height for the section.
Italic	All	=	Set the font to italic for headings and data
			in the section.
LabelBottomMargin	ProgrammableSection	=	Set the margin below the heading labels,
	Body		and before section data.
	PageFooter
LabelTopMargin	ProgrammableSection	=	Set the margin above the heading labels.
	Body
	PageFooter
LeftMargin	All	=	Left margin for the section.
LineAbove	All	=	Add a line above the section data.
LineBelow	All	=	Add a line below the section data.
LineLeft	All	=	Add a line to the left of the section data.
LineRight	All	=	Add a line to the right of the section data.
Name	All	=	The name of the section. This is the name
			used from X++ to refer to the section,
			when the property AutoDeclaration is set.
NoOfHeadingLines	ProgrammableSection	=	Labels are printed as heading lines. Used
	Body		to set NoOfHeadingLines to a fixed value.
	PageFooter		Set to zero if no header should be printed.
ResolutionX	All	=	Seems as having no effect.
ResolutionY	All	=	Seems as having no effect.
RightMargin	All	=	Right margin for the section.
Ruler	All	=	Used to set the measure unit for the
			current section in the visual designer.
Table	Body	=	Used by element.send() to determine
			which body sections to be printed.
Thickness	All	=	Set thickness of the lines added for the
			section data.
Top	ProgrammableSection	=	Set a fixed position for the section
	Prolog		calculated from the top of the page.
	Body
	Epilog
TopMargin	All	=	Set the margin above the section data.
Underline	All	=	Underline headings and data in the
			section.

Section Template
SectionTemplate		=	Name of the section template.
Table		=	The table used for the section template. The table must a part of the map
			used for the section template.

Section Group
DataField		=	Can be used to identify a section group if a report contains two section
			group using the same table.
Name		=	Name of the section group.
Table		=	The table used in the section group. Used by element.send() to determine
			when to print the section group.

Type controls
Alignment	String	=	Align the control data. Can be used to left
	Real		align control data, when controls are
	Integer		positioned vertical.
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
AllowNegative	Real	=	This property is of no use on reports. The
	Integer		property is used on forms to prevent
	Sum		negative values to be entered by the user.
ArrayIndex	String	=	If the selected field or method is an array a
	Real		single element of the array can be
	Integer		specified to be printed only.
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
AutoDeclaration	All	=	If set to Yes the properties for the control
			can be referenced from X++ by using the
			control name.
AutoInsSeparator	Real	=	Used to have MorphX to set a decimal
	Sum		separator.
BackgroundColor	String	=	RGB value or name of Windows color
	Text		scheme item.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
BackStyle	String	=	Set the background for the control to
	Text		transparent. Used if the background color
	Real		of bitmaps should not be shown, or to set
	Integer		the color of the background for the control
	Enum		data to the color set with the property
	Date		BackGroundColor.
	Time
	Sum
	Bitmap
	Prompt
Bold	String	=	Set the bold level for control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
BottomMargin	All	=	Set the margin below the controls data.
ChangeCase	String	=	Used to set the control data to lower case
	Text		or upper case.
	Enum
	Prompt
ChangeLabelCase	String	=	Used to set the label to lower case or
	Real		upper case.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
ColorScheme	All	=	Specify whether to use RGB colors, or
			Windows color scheme.
ConfigurationKey	All	=	Used to specify a Configuration Key for
			the control.
CssClass	All	=	Web property.
DataField	String	=	Select a field from the selected data
	Real		source. Instead of selecting a field, a
	Integer		display method can be specified in the
	Enum		property DataMethod.
	Date
	Time
	Sum
	Bitmap
	Prompt
DataFieldName	Sum	=	Name of the control to be summed.
DataMethod	String	=	Select a display method to be printed. If
	Real		the display method is from a table, the
	Integer		data source must be specified in the
	Enum		property Table.
	Date
	Time
	Bitmap
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
	Sum		regional settings are used as default.
DisplaceNegative	Real	=	Adjust the position of negative values
	Integer		printed.
	Sum
DynamicHeight	String	=	If set to Yes the height will be set
			according to the text.
ExtendedDataType	String	=	Specify an extended data type for the
	Text		control if a DataField or a DataMethod is
	Real		not specified.
	Integer
	Enum
	Date
	Time
	Prompt
ExtraSumWidth	Real	=	Defines extra space for the summed value.
	Integer		Useful in currencies with a lot of digits.
	Sum
Font	String	=	The font to be used for the control data. If
	Text		not specified the default font is used.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
FontSize	String	=	The font size to be used for the control
	Text		data. If not specified the default font size
	Real		is used.
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
ForegroundColor	All	=	RGB value or name of Windows color
			scheme item.
FormatMST	Real	=	Format the value using the settings for the
	Sum		standard company currency.
Height	All	=	Set a fixed height for the control.
ImageName	Bitmap	=	Path and filename for bitmap.
ImageRessource	Bitmap	=	Used to specify a resource id for the
			bitmap. Use the report
			Tutorial_Resources to get an overview
			of the resource id’s.
Italic	String	=	Set the font to italic for the control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
Label	All	=	Used to override the default label or if no
			DataField or ExtendDataType is specified.
			The label will not be printed, if the
			property ShowLabel is set to false.
LabelBold	String	=	Set the label to bold.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelCssClass	All	=	Web property.
LabelFont	String	=	Set the font for the label. If not specified
	Real		the default font will be used.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelFontSize	String	=	Set the font size for the label. If not
	Real		specified the default font size will be used.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelItalic	String	=	Set the label to Italic.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelLineBelow	String	=	Print a line with the width of the control
	Real		below the label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelLineThickness	String	=	Set the thickness of the line below the
	Real		label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelPosition	String	=	Position the label above or to the left.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelTabLeader	String	=	Used when the property LabelPosition is
	Real		et to Left. Put tabs or dots follow by a
	Integer		colon after the label.
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelUnderline	String	=	Underline the label text. The property
	Real		LabelLineBelow is used to set a line
	Integer		below in the full width of the label.
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelWidth	String	=	Used when the property LabelPosition is
	Real		set to Left. Set a fixed width for the label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
Left	All	=	Set the control to a fixed position
			calculated from left. If controls are
			horizontal aligned and one control is set to
			a fixed position, all controls must be fixed.
LeftMargin	All	=	Set a left margin for the control.
Line	Shape	=	Specify the line type for the shape.
LineAbove	All	=	Add a line above the control data.
LineBelow	All	=	Add a line below the control data.
LineLeft	All	=	Add a line to the left of the control data.
LineRight	All	=	Add a line to the right of the control data.
MenuItemName	All	=	Web property.
MenuItemType	All	=	Web property.
ModelFieldName	All	=	Enter the name of a control which this
			control must be position according to. Is
			often used to position prompt and sums
			controls to be on line with the data
			controls.
Name	All	=	Name of the control.
NoOfDecimals	Real	=	Set the number of decimals to be shown.
	Sum
ResizeBitmap	Bitmap	=	Used to resize the bitmap if a fixed width
			and height is specified for the bitmap.
RightMargin	All	=	Set a right margin for the control.
RotateSign	Real	=	Used to invert negative values.
	Integer
	Sum
SecurityKey	All	=	Used to specify a Security Key for the
			control.
ShowLabel	String	=	If set to No, the label will not be printed.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
ShowPicAsText	Bitmap	=	Print the image path or the resource id
			instead of printing the bitmap.
ShowZero	Real	=	Defines whether zero values must be
	Integer		shown.
	Sum
SignDisplay	Real	=	Set how to display negative values.
	Integer
	Sum
SumAll	Real	=	Sum all values. Used by sum controls to
	Integer		define which controls to be summed. If set
			in auto design, the control will be summed
SumNeg	Real	=	if the user add a group total in the dialog.
	Integer		Set if only negative values should be
			summed.
SumPos	Real	=	Set if only positive values should be
	Integer		summed.
SumType	Sum	=	Set to sum only positive or negative
			values.
Table	String	=	Select a data source to be used for the
	Real		control.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
Text	Text	=
Thickness	All	=	Enter the text to be printed.
			Set thickness of the lines added for the
			control data.
ThousandSeparator	Real	=	Specify the thousand separator. Windows
	Sum		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.
Top	All	=	Set a fixed position for the control
			calculated from the top of the section. If
			controls are horizontal aligned and one
			control is set to a fixed position, all
			controls must be fixed.
TopMargin	All	=	Set the margin above the controls data.
Type	Shape	=	Set the type of shape to be printed.
TypeHeaderPrompt	Text	=	Specify whether to put following dots and
	Prompt		a colon after the text.
Underline	String	=	Underline the control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
Visible	All	=	Used to hide the control. If the follow
			controls are auto positioned, the controls
			will be adjusted.
WarnIfMissing	Bitmap	=	Print a warning in the Infolog if the
			bitmap cannot be located from the
			ImageName, ImageRessource or the
			DataMethod.
WebTarget	All	=	Web property.
Width	All	=	Set a fixed width for the control. If set to
			default, the extended data type will set the
			width.
Field Group
AutoFieldGroupOrder		=	Determine whether properties and field order must be saved. The field
			group will automatically be updated according to changes made to the field
			group from the data dictionary.
DataGroup		=	Field group name.
Table		=	Table from which the field group is picked.

Written by Komkid on August 18th, 2009 with no comments.
Read more articles on Axapta.

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.

Written by Komkid on August 18th, 2009 with 1 comment.
Read more articles on Axapta.

Axapta : Query Properties

Query

Property		Description
Query
AllowCheck	=	If set Configuration keys and Security keys will be validated at runtime.
Form	=	Specifies the Axapta form used for the query dialog. This is normally not
		changed.
Interactive	=	Specify whether the query dialog is shown to the user.
Literals	=	Choose either default, forceliterals or forceplaceholders. All statements
		which are frequently executed should use forceplaceholders and
		forceliterals can be used against non-frequent skewed data.
Name	=	AOT name of the query.
Title	=	Caption for the query.
UserUpdate	=	Defines whether user settings to the query are saved.

Data sources
AllowAdd	=	If disabled, the user can not add or delete table ranges. The same applies for
		sorting fields.
Company	=	Fetch data from a specify company. It is normally not used, as the user
		expect data to be fetched from the active company.
Enabled	=	Should the data source be enabled or disabled. If disabled, it will be ignored
		in the sql statement.
FetchMode	=	Only joined data sources has this property. Can be used to change a one to
		many relation to one to one relation. This property is not used very often. In
		the most cases the property JoinMode will be sufficient.
FirstFast	=	Should the first record be fetched faster than the remaining records.
FirstOnly	=	Only select the first record.
JoinMode	=	How should the data sources be joined.
Name	=	AOT name of the data source.
OrderMode	=	Choose either order by or group by. This will influence the way data is
		ordered or grouped from the database.
Relations	=	If enabled, relations between this data source and the data source one level
		above will be added using the actual data model.
Update	=	If set to yes, the record will be fetched forupdate allowing the record to be
		updated.

Fields	=
Dynamic	=	Show default all fields for the table. If the reports order mode is group by,
		the property will be set to no, and only aggregated values can be chosen for
		the Fields node.

Sorting fields
AutoHeader	=	Should a group title be printed each time the value in this field changes.
		Only used by report queries.
AutoSum	=	Should a sum be printed each time the value in this field changes. Only
		used by report queries.
HeaderDetailLevel	=	Used in report queries by the property AutoHeader. Default a header is
		printed when the value of the sorting field changes. The property can be
		used to determine for which part of a field an index break should occur.
		Fields using the characters dot, space, dash, back slash forward slash
		consists of several sub fields. If the value of customer account is
		“CUST100.10 “, the field value consists of two subfields. Setting
		HeaderDetailLevel to 2 will cause an index break to occur, when the value
		after the dot is changed.
Ordering	=	Set the ordering to either ascending or descending.
SumDetailLevel	=	Used in report queries by the property AutoSum. Default a header is printed
		when the value of the sorting field changes. The property can be used to
		determine for which part of a field an index break should occur. Fields
		using the characters dot, space, dash, back slash forward slash consists of
		several sub fields. If the value of customer account is “CUST100.10 “, the
		field value consists of two subfields. Setting SumDetailLevel to 2 will
		cause an index break to occur, when the value after the dot is changed.

Ranges
Enabled	=	If disabled, the range will be ignored.
Label	=	This is the label of the range field.
Name	=	AOT name of the range.
Status	=	Choose either open, locked or hide. If open, the range can be modified and
		deleted. If locked, the range can not be modified or deleted. If hidden, the
		range will not be shown in the query dialog.
Value	=	Fixed value for the range.

Written by Komkid on August 18th, 2009 with no comments.
Read more articles on Axapta.

Axapta : Menu Properties

Menus

Property		Description
ChangedBy	=	The user who last modified the Menu.
ChangedDate	=	The date the Menu was last modified.
ChangedTime	=	The time the Menu was last modified.
ConfigurationKey	=	Used to specify a Configuration Key for the menu.
CreatedBy	=	The user who created the Menu.
CreatedTime	=	The time the menu was created.
CreationDate	=	The date the menu was created.
HelpText	=	Help text that will be displayed in the status bar.
Label	=	The label of the menu.
LockedBy	=	The user who has currently locked the menu.
Name	=	The menu name.
NeededAccessLevel	=	Required access level to activate this menu.
SecurityKey	=	Used to specify a Security Key for the control.
SetCompany	=	Would you like to set the company when the form is activated.

Written by Komkid on August 18th, 2009 with no comments.
Read more articles on Axapta.

Axapta : Menu Items Properties

Menu Items

Property		Description
ChangedBy	=	The user who last modified the menu item.
ChangedDate	=	The date the menu item was last modified.
ChangedTime	=	The time the menu item was last modified.
Class	=	The object type that will be executed when activating the menu item.
ConfigurationKey	=	Used to specify a Configuration Key for the menu.
CountryConfigurationKey	=	Used to specify a country specific Configuration Key for the menu.
CreatedBy	=	The user who created the menu item.
CreatedTime	=	The time the menu item was created.
CreationDate	=	The date the menu item was created.
EnumParameter	=	Set a base enum entry, see also the parameter EnumTypeParameter.
EnumTypeParameter	=	Select a base enum to be passed to the args.parmEnum() in the object which
		is called. See properties Class and Object.
HelpText	=	Help text that will be displayed in the status bar.
Label	=	The label of the menu item.
LockedBy	=	The user who has currently locked the menu item.
MultiSelect	=	Can this menu item be executed when multiple records are selected in the
		form.
Name	=	The name of the menu item.
NeededAccessLevel	=	Required access level to activate this menu item.
Object	=	The object that will be executed when activating the menu item.
Parameters	=	Enter a string value to be passed to the args.parm() in the object which is
		called. See properties Class and Object.
RunOn	=	This property will specify whether the object is executed on AOS or not.
SecurityKey	=	Used to specify a Security Key for the control.
Web	=	Web property.
WebConfigurationKey	=	Web property.
WebPage	=	Web property.
WebSecureTransaction	=	Web property.

Written by Komkid on August 18th, 2009 with 2 comments.
Read more articles on KomKid.

No older articles

Newer articles »

August 18th, 2009

Axapta : Report Properties

Report

Axapta : Data Dictionary Properties

Data Dictionary

Axapta : Query Properties

Query

Axapta : Menu Properties

Menus

Axapta : Menu Items Properties

Menu Items

Identification

Article search

Sections

Last articles

Categories

Monthly archives

Favourite sites

Subscribe to this site