Wednesday, August 19, 2009

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.

1 comment:

Axapta Properties | KomKid.Net said...

[...] Data Dictionary 2. Form 3. Report 4. Query 5. Menus 6. Menu [...]