最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

System Tables

网络文摘 William 2863浏览 0评论

Table of Contents

Common

The Common table is the base class for all tables. It does not contain any data. It is primarily used in X++ code to refer to any table in a polymorphic way.

Methods

Method Description
aosValidateDelete Validates on the server that the specified record can be deleted from a table.
aosValidateInsert Validates on the server that the specified record can be inserted.
aosValidateRead Validates on the server that the specified record can be read.
aosValidateUpdate Validates on the server that the specified record can be updated.
buf2con Packs the table buffers of an xRecord instance into an X++ container.
canSubmitToWorkflow Indicates whether submission to workflow is possible.
caption Gets and sets the caption property of a table.
checkInvalidFieldAccess Gets and sets invalid field access.
checkRecord Gets and sets the property that indicates whether to check mandatory fields.
checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted.
clear Removes all rows from the table buffer.
company Gets and sets the property that indicates a legal entity for the record.
con2buf Unpacks a container into the table buffers.
concurrencyModel Gets and sets the default concurrency model to use to update records.
context Gets and sets the context property.
data Retrieves a row from the table.
dataSource Retrieves the data source of the table.
dbOpInTransaction Makes sure that database operations are correctly closed if they fail.
defaultField Populates default values in a field in the table.
defaultRow Populates default values in fields in the table in the non-interactive case.
delete Deletes the current record from the table.
disableCache Gets and sets the property that indicates whether caching is disabled.
dispose Releases resources that are used by the xRecord object.
doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table.
doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table.
doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table.
doUpdate Updates the current record and bypasses any additional logic in the update method of the table.
doValidateDelete Performs the action to validate that a record can be deleted.
equal Determines whether the specified object is equal to the current one.
fieldAccessRight Returns the field access right.
fieldBufferAccessRight Returns the field access right for the current record.
fieldState Sets or returns the state of a field in the table buffer.
getAllowRedefault Returns the list of fields that are allowed to re-default.
getDefaultingDependencies Returns the container that holds defaulting dependencies.
getExtension Returns the table extension.
getFieldValue Gets the value of the specified field from a table buffer.
getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID.
getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name.
getPresenceFieldData Retrieves the PresenceInfo value from the specified field.
getSQLStatement Gets the SQL statement that is used to return records from the database.
getTableInInstanceHierarchy
getTableType Indicates the type of the table.
helpField Retrieves a string that contains the Help text for the specified field.
initValue Initializes a field to the default value.
inputStatus Sets or returns the current input status of the table buffer.
insert Inserts the record into the table.
interactiveContext Sets or returns the current interactive context of the table buffer.
isFieldDataRetrieved Checks whether the data of the given field has been retrieved.
isFieldSet Checks whether a field has a Set or Defaulted state.
isFormDataSource Indicates whether the data source is a form.
isNewRecord Returns true if the record is a new record that hasn’t been persisted yet.
isPartOfUOWSaveChanges
isTempDb Indicates whether the type of the table is SQL TempDB.
isTmp Indicates whether this is a temporary table.
joinChild Finds the join child of the current record.
joinParent Finds the join parent of the current record.
linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record.
merge Merges the current table with the specified table.
modifiedField Modifies the specified field to the original.
modifiedFieldValue Modifies the specified field to the original value.
orig Retrieves the original values of the current record.
overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten.
postLoad Is executed after a record is read.
queryTimedOut Indicates whether the query exceeded the time limit for execution.
queryTimeout Gets and sets the property that indicates the time limit for the execution of a query.
readCommittedLock
readPast Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read.
recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level.
relatedTable Sets or returns the related buffer of a link of a table buffer.
hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table.
renamePrimaryKey Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table.
reread Rereads the record from the table.
RowCount Retrieves the number of rows in the table.
selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read.
selectLocked Indicates whether to select locked records.
selectRefRecord Selects the record by referenced field ID.
selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled.
setConnection Sets the user connection for this table.
setCrossPartition Sets or resets cross-partitioning for the table.
setFieldValue Sets the field value in the record buffer.
setSQLTracing Enables or disables SQL tracing mode.
setTempDB
setTmp Sets the table so that it is not persisted to the database.
setTmpData Sets the contents of the temporary table to the specified data.
setXDSContext Sets new XDS context.
skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests.
skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods.
skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table.
skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods.
skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object.
skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table.
skipTTSCheck Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update.
suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer.
tableAccessRight Returns the table access right.
tableBufferAccessRight Returns the table access right for the current record.
toolTipField Retrieves the HelpText value for the specified field.
toolTipRecord Retrieves the ToolTip value for the current record.
ttsabort Aborts a transaction that was started by a call to the ttsbegin method.
ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method.
ttscommit Commits a transaction that was started by a call to the ttsbegin method.
update Updates the current record.
validateDelete Determines whether the current record is valid and ready to be deleted from the database.
validateField Determines whether the specified field is valid.
validateFieldValue
validateRelations
validateWrite Determines whether the current record is valid and ready to be written.
validTimeStateUpdateMode Sets a valid time state update mode on the cursor.
wasCached Specifies the location from which the data was retrieved.
write Updates a record if it exists; otherwise, inserts a record.
xml Retrieves an XML string that represents the current object.
takeOwnershipOfTempDBTable
useExistingTempDBTable

Fields

Field Type Extended Type Enumeration Type Description
CreatedBy String CreatedBy
CreatedDateTime UtcDateTime CreatedDateTime
CreatedTransactionId Int64 CreatedTransactionId
dataAreaId String DataAreaId
DEL_CreatedTime Int DEL_CreatedTime
DEL_ModifiedTime Int DEL_ModifiedTime
ModifiedBy String ModifiedBy
ModifiedDateTime UtcDateTime ModifiedDateTime
ModifiedTransactionId Int64 ModifiedTransactionId
Partition Int64 Partition
RecId Int64 RecId
recVersion Integer RecVersion
RelationType Int64 RelationType
RowNumber Int RowNumber
SequenceNum Int64 SequenceNum
TableId Int TableId
UnionAllBranchId Int UnionAllBranchId

Relations

Relation Table
dataAreaId DataArea

Indexes

Index Allow Duplicates Fields
RecId No

Inheritance Hierarchy

xRecord Class
Common Table

DataArea

The DataArea table contains a list of companies that have been created in the database.

Fields

Field Type Extended Type Enumeration Type Description
alwaysNative Enum boolean
id String DataAreaId ID for an area of data
isVirtual Enum boolean
name String UserIdStr Name
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
timeZone Enum Timezone

Relations

Relation Table
id DataArea
Partition Partitions

Indexes

Index Allow Duplicates Fields
Id No
IdOnly Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
DataArea Table

DatabaseLog

The DatabaseLog table stores configuration information for the SysDatabaseLog table.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
domainId String DomainId ID for the domain
logField Integer FieldId ID for the field
logTable Integer TableId ID for the table
logType Enum DatabaseLogType
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion

Field Groups

Field Group Fields
logFieldRelation

Relations

Relation Table
Relation_DatabaseLog DEL_DomainInfo

Indexes

Index Allow Duplicates Fields
Loglist No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
DatabaseLog Table

DEL_AccessRightsList

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Fields

Field Type Extended Type Enumeration Type Description
accessType Enum AccessType
accessTypeFkeyUse Enum AccessType
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
domainId String DomainId ID for the domain
elementName String UtilElementName Name of the application element.
groupId String UserGroupId ID for the user group
id Int
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
parentId Int
RecId Int64 RecId
recordType Enum AccessRecordType
recVersion Integer RecVersion

Relations

Relation Table
Relation_AccessRightsList1 UtilIdElements
Relation_AccessRightsList2 UtilIdElements
Relation_AccessRightsList3 DEL_DomainInfo
Relation_AccessRightsList4 DEL_UserGroupInfo

Indexes

Index Allow Duplicates Fields
Element Yes
Group No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
DEL_AccessRightsList Table

DEL_CompanyDomainList

The CompanyDomainList table contains associations between the DomainInfo and DataArea tables. Security rights are granted per domain.

Fields

Field Type Extended Type Enumeration Type Description
companyId String SelectableDataArea ID for the company you can select
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
domainId String DomainId ID for the domain
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion

Relations

Relation Table
companyId DataArea
domainId DEL_DomainInfo

Indexes

Index Allow Duplicates Fields
Company No
Domain No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
DEL_CompanyDomainList Table

DEL_DomainInfo

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Fields

Field Type Extended Type Enumeration Type Description
id String DomainId ID for the domain
name String UserIdStr Name
RecId Int64 RecId
recVersion Integer RecVersion

Relations

Relation Table
id DEL_DomainInfo

Indexes

Index Allow Duplicates Fields
Id No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
DEL_DomainInfo Table

DEL_UserGroupInfo

The UserGroupInfo table contains the list of available user groups.

Fields

Field Type Extended Type Enumeration Type Description
id String UserGroupId ID for the user group
name String UserIdStr Name
RecId Int64 RecId
recVersion Integer RecVersion

Relations

Relation Table
id UserGroupInfo

Indexes

Index Allow Duplicates Fields
Id No

Inheritance Hierarchy

xRecord Class
Common Table
DEL_UserGroupInfo Table

DEL_UserGroupList

The UserGroupList table contains the list of users associated with each user groups.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
groupId String UserGroupId ID for the user group
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
userId String UserId ID for the user

Relations

Relation Table
Relation_UserGroupList1 DEL_UserGroupInfo
Relation_UserGroupList2 UserInfo

Indexes

Index Allow Duplicates Fields
GroupId No
RecId No
UserId No

Inheritance Hierarchy

xRecord Class
Common Table
DEL_UserGroupList Table

ModelSecPolRuntimeEx

The ModelSecPolRuntimeEx table stores the runtime metadata that is necessary to apply security policies.

Fields

Field Type Extended Type Enumeration Type Description
ConstrainedTable String
ContextString String
ContextType Int
DEL_ElementHandle Int
DEL_IsEnabled Int
DEL_LayerId Int
ElementHandle Int
IsDirty Int
IsEnabled Int
IsModeled Int
LayerId Int
ModeledQueryDebugInfo String
ModeledQueryPackData Container
Name String
Operation Int
PrimaryTableAOTName String
QueryObjectAOTName String
RecId Int64 RecId
recVersion Integer RecVersion

Indexes

Index Allow Duplicates Fields
ConstrainedTableIdx Yes ConstrainedTable
RecIDIdx No RecId

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
ModelSecPolRuntimeEx Table

ModelSecPolRuntimeView

The ModelSecPolRuntimeView view shows the runtime metadata for the currently active security policies.

Fields

Field Type Extended Type Enumeration Type Description
ConstrainedTable String
ContextString String
ContextType Int
ElementHandle Int
IsDirty Int
IsModeled Int
LayerId Int
ModeledQueryDebugInfo String
ModeledQueryPackData Container
Name String
Operation Int
PrimaryTableAOTName String
QueryObjectAOTName String
RecId Int64 RecId
recVersion Integer RecVersion

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
ModelSecPolRuntimeView Table

Partitions

The Partitions table contains the list of data partitions in the system.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
createdDateTime UtcDateTime CreatedDateTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
modifiedBy String ModifiedBy (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
modifiedDateTime UtcDateTime ModifiedDateTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
name String UserIdStr Name (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PartitionKey String PartitionKey Partition Key (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
recVersion Integer RecVersion (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))

Field Groups

Field Group Fields
AutoIdentification

Relations

Relation Table
PartitionKey Partitions

Indexes

Index Allow Duplicates Fields
PartitionIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
Partitions Table

PrintJobHeader

The PrintJobHeader table contains information regarding the current print job

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dataAreaId String DataAreaId
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
deviceName String
format Enum PrintFormat
jobDescription String
jobStatus Enum PrintJobStatus
jobType String
numberOfPages Int
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
printedBy String UserId ID for the user
printedDate date
printedTime Int
printerInfo Container
printFromPage Int
printNumcopies Int
printOnServer Enum boolean
printToPage Int
RecId Int64 RecId
recVersion Integer RecVersion
unlimitedPageHeight Enum boolean

Relations

Relation Table
dataAreaId DataArea
Partition Partitions
printedBy UserInfo

Indexes

Index Allow Duplicates Fields
CreatedBy Yes
CreatedDate Yes
JobType Yes
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
PrintJobHeader Table

PrintJobPages

The PrintJobPages table contains information regarding the currently printing page of a print job

Fields

Field Type Extended Type Enumeration Type Description
dataAreaId String DataAreaId
numberOfLines Int
pageContents Container
pageNo Int
pagesHeaderRecId Int64 RecId Unique ID for the record in the database
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion

Relations

Relation Table
dataAreaId DataArea
pagesHeaderRecId PrintJobHeader
Partition Partitions
Relation_PrintJobPages1 PrintJobHeader

Indexes

Index Allow Duplicates Fields
PageNo No
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
PrintJobPages Table

SecurableObject

The SecurableObject table contains all security artifacts reference by the security framework.

Fields

Field Type Extended Type Enumeration Type Description
ChildName String SecurableChildName The child name of the securable object.
Name String SecurableName The name of the securable object.
RecId Int64 RecId
recVersion Integer RecVersion
Type Enum SecurableType

Field Groups

Field Group Fields
AutoLookup

Indexes

Index Allow Duplicates Fields
NameChildTypeIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurableObject Table

SecurityDuty

Fields

Field Type Extended Type Enumeration Type Description
Identifier String SecurityDutyIdentifier
Name String SecurityDutyName
Description String SecurityDutyDescription

Field Groups

Field Group Fields
AutoIdentification Name

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
IdentifierIdx No Identifier
NameIdx Yes Name

Inheritance Hierarchy

xRecord Class
Common Table
SecurityDuty Table

SecurityEntryPointInferredTables

Fields

Field Type Extended Type Enumeration Type Description
EntryPointName String SecurableName
Type Enum SecurableType
TableName String SecurableName
AllowEdit Enum boolean
AllowCreate Enum boolean
AllowDelete Enum boolean
ValidTimeStateUpdate Enum ValidTimeStateUpdate

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
EntryPointTableIdx No EntryPointName, Type, TableName, ValidTimeStateUpdate

Inheritance Hierarchy

xRecord Class
Common Table
SecurityEntryPointInferredTables Table

SecurityEntryPointLink

The SecurityEntryPointLink table contains the entry point to securable object mapping that has been specified on the AOT nodes of menu items and web menu items.

Fields

Field Type Extended Type Enumeration Type Description
EntryPoint Int64 RecId Unique ID for the record in the database
PermissionOwner Int64 RecId Unique ID for the record in the database
RecId Int64 RecId
recVersion Integer RecVersion
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecurityEntryPointLink1 SecurableObject
Relation_SecurityEntryPointLink2 SecurableObject

Indexes

Index Allow Duplicates Fields
EntryPointIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityEntryPointLink Table

SecurityPermission

The SecurityPermission table contains the list of permissions that have been specified on the AOT nodes of forms, reports, security code permissions, and service operations.

Fields

Field Type Extended Type Enumeration Type Description
Access Enum AccessRight
Group Enum AccessRight
Owner Int64 RecId Unique ID for the record in the database
RecId Int64 RecId
recVersion Integer RecVersion
SecurableObject Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecurityPermission1 SecurableObject
Relation_SecurityPermission2 SecurableObject

Indexes

Index Allow Duplicates Fields
OwnerGroupObjectIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityPermission Table

SecurityPrivilege

Fields

Field Type Extended Type Enumeration Type Description
Identifier String SecurityPrivilegeIdentifier
Name String SecurityPrivilegeName
Description String SecurityPrivilegeDescription

Field Groups

Field Group Fields
AutoIdentification Name

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
IdentifierIdx No Identifier
NameIdx Yes Name

Inheritance Hierarchy

xRecord Class
Common Table
SecurityPrivilege Table

SecurityRole

The SecurityRole table reflects the list of roles defined by the security AOT role node.

Fields

Field Type Extended Type Enumeration Type Description
AllowCurrentRecords Enum AccessRight
AllowFutureRecords Enum AccessRight
AllowPastRecords Enum AccessRight
AotName String SecurityRoleAotName The name of the role in the AOT.
ContextString String
DEL_AllowCurrentRecords Enum AccessRight
DEL_AllowFutureRecords Enum AccessRight
DEL_AllowPastRecords Enum AccessRight
DEL_IsEnabled Enum boolean
Description String SecurityRoleDescription Description of the security role.
IsEnabled Enum boolean
Name String SecurityRoleName The name of the security role.
RecId Int64 RecId
recVersion Integer RecVersion
UserLicenseType Enum UserLicenseType

Field Groups

Field Group Fields
AutoIdentification

Indexes

Index Allow Duplicates Fields
AotNameIdx No
NameIdx Yes
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRole Table

SecurityRoleAssignmentRule

Rules for dynamically assigning users to role

Fields

Field Type Extended Type Enumeration Type Description
MembershipRuleDescription String MembershipRuleDescription Description of the automatic role membership rule
MembershipRuleName String MembershipRuleName Name of the automatic role membership rule
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
RuleQuery Container
SecurityRole Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Partition Partitions
SecurityRole SecurityRole
SecurityRoleRelationShip SecurityRole

Indexes

Index Allow Duplicates Fields
AlternateKey No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRoleAssignmentRule Table

SecurityRoleDutyExplodedGraph

Fields

Field Type Extended Type Enumeration Type Description
SecurityRole Int64 RecId
SecurityDuty Int64 RecId

Relations

Relation Table
SecurityRole SecurityRole
SecurityDuty SecurityDuty

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
RoleDutyIdx No SecurityRole, SecurityDuty

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRoleDutyExplodedGraph Table

SecurityRoleExplodedGraph

The SecurityRoleExplodedGraph table contains all role relationships, direct or indirect, as defined by the AOT sub role nodes of the security role nodes.

Fields

Field Type Extended Type Enumeration Type Description
RecId Int64 RecId
recVersion Integer RecVersion
RefCount Int
SecurityRole Int64 RecId Unique ID for the record in the database
SecuritySubRole Int64 RecId Unique ID for the record in the database

Relations

Relation Table
Relation_SecurityRole1 SecurityRole
Relation_SecurityRole2 SecurityRole
SecurityRole SecurityRole
SecuritySubRole SecurityRole

Indexes

Index Allow Duplicates Fields
RecIDIdx No
RoleSubRoleIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRoleExplodedGraph Table

SecurityRolePermissionOverride

The SecurityRolePermissionOverride table contains the list of permissions that have been specified on the security role AOT nodes.

Fields

Field Type Extended Type Enumeration Type Description
Access Enum AccessRight
RecId Int64 RecId
recVersion Integer RecVersion
SecurableObject Int64 RecId Unique ID for the record in the database
SecurityRole Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecurityRolePermissionOverride1 SecurityRole
Relation_SecurityRolePermissionOverride2 SecurableObject

Indexes

Index Allow Duplicates Fields
RecIDIdx No
RoleObjectIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRolePermissionOverride Table

SecurityRolePrivilegeExplodedGraph

Fields

Field Type Extended Type Enumeration Type Description
SecurityRole Int64 RecId
SecurityPrivilege Int64 RecId

Relations

Relation Table
SecurityRole SecurityRole
SecurityPrivilege SecurityPrivilege

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
RolePrivilegeIdx No SecurityRole, SecurityPrivilege

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRolePrivilegeExplodedGraph Table

SecurityRoleRuntime

Fields

Field Type Extended Type Enumeration Type Description
SecurityRole Int64 RecId
Name String SecurableName
ChildName String SecurableChildName
Type Enum SecurableType
CreateAccess Int
ReadAccess Int
UpdateAccess Int
DeleteAccess Int
CorrectAccess Int
InvokeAccess Int
PastCreateAccess Int
PastReadAccess Int
PastUpdateAccess Int
PastDeleteAccess Int
PastCorrectAccess Int
PastInvokeAccess Int
CurrentCreateAccess Int
CurrentReadAccess Int
CurrentUpdateAccess Int
CurrentDeleteAccess Int
CurrentCorrectAccess Int
CurrentInvoke Int
FutureCreateAccess Int
FutureReadAccess Int
FutureUpdateAccess Int
FutureDeleteAccess Int
FutureCorrectAccess Int
FutureInvokeAccess Int

Field Groups

Field Group Fields
AutoIdentification Name, ChildName, Type

Indexes

Index Allow Duplicates Fields
RecIDIdx No RecId
RoleIDIdx Yes SecurityRole
SecurableObjectIdx Yes Type, Name, ChildName

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRoleRuntime Table

SecurityRoleTaskGrant

The SecurityRoleTaskGrant table contains the list of role to duty mappings and role to privilege mappings as defined by the AOT security role node.

Fields

Field Type Extended Type Enumeration Type Description
RecId Int64 RecId
recVersion Integer RecVersion
SecurityRole Int64 RecId Unique ID for the record in the database
SecurityTask Int64 RecId Unique ID for the record in the database

Relations

Relation Table
Relation_SecurityRoleTaskGrant1 SecurityRole
Relation_SecurityRoleTaskGrant2 SecurityTask

Indexes

Index Allow Duplicates Fields
RecIDIdx No
RoleTaskIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityRoleTaskGrant Table

SecuritySegregationOfDutiesConflict

The SecuritySegregationOfDutiesConflict table stores information about segregation of duties conflicts that result from attempted assignments of users to roles, and resolutions to the conflicts provided by authorized users.

Fields

Field Type Extended Type Enumeration Type Description
AssignmentMode Enum RoleAssignmentMode
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DEL_ExistingTask Int64 RecId
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DEL_NewTask Int64 RecId
ExistingDuty Int64 RecId
ExistingRole Int64 RecId Unique ID for the record in the database
ExistingTask Int64 RecId Unique ID for the record in the database
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
NewDuty Int64 RecId
NewRole Int64 RecId Unique ID for the record in the database
NewTask Int64 RecId Unique ID for the record in the database
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ReasonForOverride VarString SegregationOfDutiesOverrideComment Comment explaining the reason for overriding the segregation of duties violation
RecId Int64 RecId
recVersion Integer RecVersion
Resolution Enum SegregationOfDutiesResolution
SegregationOfDutiesRule Int64 RecId Unique ID for the record in the database
User String UserId ID for the user

Relations

Relation Table
ExistingDuty SecurityDuty
ExistingRole SecurityRole
ExistingRoleRelationship SecurityRole
ExistingTaskRelationship SecurityTask
NewDuty SecurityDuty
NewRole SecurityRole
NewRoleRelationship SecurityRole
NewTaskRelationship SecurityTask
Partition Partitions
Relation_SecuritySegregation7 UserInfo
SecuritySODRuleRelationship SecuritySegregationOfDutiesRule
SegregationOfDutiesRule SecuritySegregationOfDutiesRule
User UserInfo

Indexes

Index Allow Duplicates Fields
AlternateKey No
ExistingDutyIdx Yes ExistingDuty
ExistingRoleIdx Yes
ExistingTaskIdx Yes
NewDutyIdx Yes NewDuty
NewRoleIdx Yes
NewTaskIdx Yes
RecIDIdx No
UserInfoIdx Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecuritySegregationOfDutiesConflict Table

SecuritySegregationOfDutiesRule

The SecuritySegregationOfDutiesRule table stores the rules governing segregation of duties.

Fields

Field Type Extended Type Enumeration Type Description
DEL_FirstSecurityTask Int64 RecId
DEL_SecondSecurityTask Int64 RecId
FirstDuty Int64 RecId
FirstSecurityTask Int64 RecId Unique ID for the record in the database
Mitigation String SecurityMitigation Mitigation for the risk associated with violating the segregation of duties rule
Name String SegregationOfDutiesRuleName Name of the segregation of duties rule
RecId Int64 RecId
recVersion Integer RecVersion
Risk String SecurityRisk Risk associated with violating the segregation of duties rule
SecondDuty Int64 RecId
SecondSecurityTask Int64 RecId Unique ID for the record in the database
Severity Enum SegregationOfDutiesSeverity
ValidFrom UtcDateTime
ValidTo UtcDateTime

Field Groups

Field Group Fields
AutoIdentification

Relations

Relation Table
FirstDuty SecurityDuty
FirstSecurityTaskRelationship SecurityTask
SecondDuty SecurityDuty
SecondSecurityTaskRelationship SecurityTask

Indexes

Index Allow Duplicates Fields
AlternateKey No
FirstSecurityDuty Yes FirstDuty
NameIdx No
RecIDIdx No
SecondSecurityDuty Yes SecondDuty
SecondSecurityTask Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecuritySegregationOfDutiesRule Table

SecuritySubRole

The SecuritySubRole table contains all sub roles that have been specified on the security role AOT nodes.

Fields

Field Type Extended Type Enumeration Type Description
RecId Int64 RecId
recVersion Integer RecVersion
SecurityRole Int64 RecId Unique ID for the record in the database
SecuritySubRole Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecuritySubRole1 SecurityRole
Relation_SecurityTaskPermission2 SecurityRole
SecurityRole SecurityRole
SecuritySubRole SecurityRole

Indexes

Index Allow Duplicates Fields
RecIDIdx No
RoleSubRoleIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecuritySubRole Table

SecuritySubTask

The SecuritySubTask table contains the duty to privilege mappings that have been specified on the security duty AOT nodes.

Fields

Field Type Extended Type Enumeration Type Description
RecId Int64 RecId
recVersion Integer RecVersion
SecuritySubTask Int64 RecId Unique ID for the record in the database
SecurityTask Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecuritySubTask1 SecurityTask
Relation_SecuritySubTask2 SecurityTask

Indexes

Index Allow Duplicates Fields
RecIDIdx No
TaskSubTaskIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecuritySubTask Table

SecurityTask

The SecurityTask table contains the list of duties and privileges that have been defined by the AOT security duty and security privilege nodes.

Fields

Field Type Extended Type Enumeration Type Description
AotName String SecurityTaskAotName The name of the task in the AOT.
Description String SecurityTaskDescription Description of the process cycle, duty, or privilege.
IsEnabled Enum boolean
IsPermissionSet Enum boolean
Name String SecurityTaskName The name of the process cycle, duty, or privilege.
RecId Int64 RecId
recVersion Integer RecVersion
Type Enum SecurityTaskType

Field Groups

Field Group Fields
AutoIdentification

Indexes

Index Allow Duplicates Fields
AotNameIdx No
NameIdx Yes
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityTask Table

SecurityTaskEntryPoint

The SecurityTaskEntryPoint table contains the list of privilege to entry point mappings that have been specified on the AOT security privilege node.

Fields

Field Type Extended Type Enumeration Type Description
EntryPoint Int64 RecId Unique ID for the record in the database
PermissionGroup Enum AccessRight
RecId Int64 RecId
recVersion Integer RecVersion
SecurityTask Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecurityTaskEntryPoint1 SecurityTask
Relation_SecurityTaskEntryPoint2 SecurableObject

Indexes

Index Allow Duplicates Fields
RecIDIdx No
TaskEntryPointIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityTaskEntryPoint Table

SecurityTaskExplodedGraph

The SecurityTaskExplodedGraph table contains the duty to privilege mappings that have been specified on the security duty AOT nodes.

Fields

Field Type Extended Type Enumeration Type Description
RecId Int64 RecId
recVersion Integer RecVersion
RefCount Int
SecuritySubTask Int64 RecId Unique ID for the record in the database
SecurityTask Int64 RecId Unique ID for the record in the database

Relations

Relation Table
Relation_SecurityTaskExplodedGraph1 SecurityTask
Relation_SecurityTaskExplodedGraph2 SecurityTask

Indexes

Index Allow Duplicates Fields
RecIDIdx No
SubTaskIdx Yes
TaskSubTaskIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityTaskExplodedGraph Table

SecurityTaskPermission

The SecurityTaskPermission table is obsolete.

Fields

Field Type Extended Type Enumeration Type Description
Access Int
Level Int
RecId Int64 RecId
recVersion Integer RecVersion
SecurableObject Int64 RecId Unique ID for the record in the database
SecurityTask Int64 RecId Unique ID for the record in the database

Relations

Relation Table
Relation_SecurityTaskPermission1 SecurityTask
Relation_SecurityTaskPermission2 SecurableObject

Indexes

Index Allow Duplicates Fields
RecIDIdx No
TaskObjectIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityTaskPermission Table

SecurityTaskPermissionOverride

The SecurityTaskPermissionOverride table contains the list of permissions that have been specified on the security privilege AOT nodes.

Fields

Field Type Extended Type Enumeration Type Description
Access Enum AccessRight
RecId Int64 RecId
recVersion Integer RecVersion
SecurableObject Int64 RecId Unique ID for the record in the database
SecurityTask Int64 RecId Unique ID for the record in the database
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Relation_SecurityTaskPermissionOverride1 SecurityTask
Relation_SecurityTaskPermissionOverride2 SecurableObject

Indexes

Index Allow Duplicates Fields
RecIDIdx No
TaskObjectIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityTaskPermissionOverride Table

SecurityUserRole

The SecurityUserRole table contains the user to role mappings.

Fields

Field Type Extended Type Enumeration Type Description
AssignmentMode Enum RoleAssignmentMode
AssignmentStatus Enum RoleAssignmentStatus
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
SecurityRole Int64 RecId Unique ID for the record in the database
User String UserId ID for the user
ValidFrom UtcDateTime
ValidTo UtcDateTime

Relations

Relation Table
Partition Partitions
Relation_SecurityRole SecurityRole
Relation_SecurityUserRole3 UserInfo
SecurityRole SecurityRole
User UserInfo

Indexes

Index Allow Duplicates Fields
RecIDIdx No
UserRoleIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityUserRole Table

SecurityUserRoleCondition

The SecurityUserRoleCondition table contains the list of companies that constrain a user to role mappings.?If there are no entries for a particular user to role mapping then the user is granted the permissions of that role for all companies.

Fields

Field Type Extended Type Enumeration Type Description
ControllingKey int64
DataArea String DataAreaId ID for an area of data
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
SecurityUserRole Int64 RecId Unique ID for the record in the database

Relations

Relation Table
DataArea DataArea
Partition Partitions
Relation_SecurityUserRoleCondition1 SecurityUserRole
Relation_SecurityUserRoleCondition2 DataArea
SecurityUserRole SecurityUserRole

Indexes

Index Allow Duplicates Fields
RecIDIdx No
UserRoleDataAreaIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SecurityUserRoleCondition Table

SqlDescribe

The SqlDescribe table is used to store the table and field metadata. The SqlDataDictionary::tablemetadata method populates this table by using a back end database query.

Fields

Field Type Extended Type Enumeration Type Description
array Int
fieldId Integer FieldId ID for the field
fieldType Enum Types
flags Int
name String UtilElementName Name of the application element.
nullable Enum boolean
numericPrecision Int
numericScale Int
RecId Int64 RecId
recVersion Integer RecVersion
rightJustify Enum boolean
shadow Enum boolean
sqlName String UtilElementName Name of the application element.
strSize Int
tabId Integer TableId ID for the table

Field Groups

Field Group Fields
fieldIdRelation

Indexes

Index Allow Duplicates Fields
Field No
RecId No
SqlName Yes

Inheritance Hierarchy

xRecord Class
Common Table
SqlDescribe Table

SqlDictionary

The SqlDictionary table describes the current state of the database with respect to the table and field metadata. The table also contains view and table dependency information. The database synchronization engine uses the SqlDictionary table to determine the actions that are required to synchronize the AOT with the database.

Fields

Field Type Extended Type Enumeration Type Description
array Int
fieldId Integer FieldId ID for the field
fieldType Enum Types
flags Int
name String UtilElementName Name of the application element.
nullable Enum boolean
RecId Int64 RecId
recVersion Integer RecVersion
rightJustify Enum boolean
shadow Enum boolean
sqlName String UtilElementName Name of the application element.
strSize Int
tabId Integer TableId ID for the table

Field Groups

Field Group Fields
fieldIdRelation

Indexes

Index Allow Duplicates Fields
Field No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SqlDictionary Table

SqlParameters

The SqlParameters table stores database related information in the form of parameter and value pairs. This table is not used in Microsoft Dynamics Ax 2009.

Fields

Field Type Extended Type Enumeration Type Description
id Int
iParm Int
iValue Int
parm String
RecId Int64 RecId
recVersion Integer RecVersion
value String

Indexes

Index Allow Duplicates Fields
Parm No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SqlParameters Table

SqlStatistics

The SqlStatistics table stores related database statistics for the user. This table is not used in Microsoft Dynamics Ax 2009.

Fields

Field Type Extended Type Enumeration Type Description
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
indexId Integer IndexId ID for the index
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
objectType Enum SqlStatType
RecId Int64 RecId
recVersion Integer RecVersion
tabId Integer TableId ID for the table
userId String UserId ID for the user
value1 Int
value10 Int
value11 Int
value12 Int
value2 Int
value3 Int
value4 Int
value5 Int
value6 Int
value7 Int
value8 Int
value9 Int

Field Groups

Field Group Fields
indexIdRelation

Relations

Relation Table
Relation_SqlStats1 SqlStatistics
Relation_SqlStats2 UserInfo
tabId SqlStatistics
userId UserInfo

Indexes

Index Allow Duplicates Fields
Id No
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
SqlStatistics Table

SqlStorage

The SqlStorage table contains information about table space and its Oracle attributes.

Fields

Field Type Extended Type Enumeration Type Description
id Int
indexId Integer IndexId ID for the index
objectType Int
override Enum boolean
parm String
RecId Int64 RecId
recVersion Integer RecVersion
tabId Integer TableId ID for the table
value String

Field Groups

Field Group Fields
indexIdRelation

Indexes

Index Allow Duplicates Fields
Id No

Inheritance Hierarchy

xRecord Class
Common Table
SqlStorage Table

SqlSyncInfo

The SqlSyncInfo table captures messages and DDL statements during the database synchronization process. Once the synchronization process is complete the information in the table is deleted.

Fields

Field Type Extended Type Enumeration Type Description
ID Int
LogType Enum SqlSyncLogType
MessageType Enum SqlSyncMessageType
ParentID Int
RecId Int64 RecId
recVersion Integer RecVersion
Sequence Int
SyncTable Enum boolean
TableName String
Text String
WarningOk Enum boolean

Indexes

Index Allow Duplicates Fields
TableName Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateReadUpdateDelete. The Application Object Server authorizes each create, read, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SqlSyncInfo Table

Subquery

The Subquery table is used by position based paging functionality.

Fields

Field Type Extended Type Enumeration Type Description
dataAreaId String DataAreaId
RecId Int64 RecId
recVersion Integer RecVersion

Relations

Relation Table
dataAreaId DataArea

Indexes

Index Allow Duplicates Fields
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
Subquery Table

SysActiveTempTable

The SysActiveTempTable table provides data about the temporary database tables that are currently created. The table is used by the framework to manage the lifetime of these tables.

Fields

Field Type Extended Type Enumeration Type Description
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InstanceId String UtilElementName Name of the application element.
RecId Int64 RecId
recVersion Integer RecVersion
RelationTypeId Int64 RecId Unique ID for the record in the database
ServerId Int64 RecId Unique ID for the record in the database
SessionId Int64 RecId Unique ID for the record in the database

Indexes

Index Allow Duplicates Fields
InstanceIdIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysActiveTempTable Table

SysBCProxyUserAccount

The SysBCProxyUserAccount table stores the business connector proxy information that is entered through the SysBcAliasForm security form. This table always contains one record.

Fields

Field Type Extended Type Enumeration Type Description
networkAlias String NetworkAlias
networkDomain String NetworkDomain
RecId Int64 RecId
recVersion Integer RecVersion
sid String Sid

Indexes

Index Allow Duplicates Fields
RecID No
Sid No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysBCProxyUserAccount Table

SysBreakpointList

The SysBreakpointList table contains a list of developers that have breakpoints in MorphX.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
machineName String NetworkDomain
RecId Int64 RecId
recVersion Integer RecVersion
userId String UserId ID for the user
version Int

Relations

Relation Table
userId UserInfo

Indexes

Index Allow Duplicates Fields
RecId No
UserId Yes

Inheritance Hierarchy

xRecord Class
Common Table
SysBreakpointList Table

SysBreakpoints

The SysBreakpoints table contains a list of all the breakpoints in MorphX.

Fields

Field Type Extended Type Enumeration Type Description
codePath Container
lineNo Int
listRecId Int64 RecId Unique ID for the record in the database
RecId Int64 RecId
recVersion Integer RecVersion
status Int
version Int

Relations

Relation Table
listRecId SysBreakpointList
Relation_SysBreakpoints1 SysBreakpointList

Indexes

Index Allow Duplicates Fields
ListRecId No

Inheritance Hierarchy

xRecord Class
Common Table
SysBreakpoints Table

SysCacheFlush

The SysCacheFlush table contains data that is used for synchronization of caches across multiple AOS servers.

Fields

Field Type Extended Type Enumeration Type Description
ClearData Container
FlushData Container
FlushVersion Int
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
Scope String GlobalObjectCacheScope Name of an instance in the global object cache.

Indexes

Index Allow Duplicates Fields
CacheScopeIdx No
RecIDIdx No

Inheritance Hierarchy

xRecord Class
Common Table
SysCacheFlush Table

SysClientAccessLog

Fields

Field Type Extended Type Enumeration Type Description
ClientComputer String UserIdStr Name
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
EventsContainer Container
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
SessionId Int

Relations

Relation Table
Partition Partitions

Indexes

Index Allow Duplicates Fields
CreatedByIdx Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateDelete. The Application Object Server authorizes each create and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysClientAccessLog Table

SysClientSessions

The SysClientSessions contains the data for the client sessions that are currently active in the system.

Fields

Field Type Extended Type Enumeration Type Description
clientComputer String UserIdStr Name
clientType Int
DataPartition String PartitionKey Partition Key (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DEL_company String
DEL_Login_time Int
helpLanguage String InstalledLanguageId
LoginDateTime UtcDateTime
RecId Int64 RecId
recVersion Integer RecVersion
ServerId Int
SessionId Int
sessionType Int
sid String Sid
Status Int
userId String UserId ID for the user
userLanguage String InstalledLanguageId
Version Int

Relations

Relation Table
DataPartition Partitions
Relation_SysClientSessions1 SysServerSessions
Relation_SysClientSessions2 UserInfo
ServerId SysServerSessions
userId UserInfo

Indexes

Index Allow Duplicates Fields
ServerId Yes
SessionId No
Status Yes Status
Status_ClientType_UserId Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysClientSessions Table

SysConfig

The SysConfig table contains license and configuration information.

Fields

Field Type Extended Type Enumeration Type Description
configType Enum ConfigType
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
expiration String
id Int
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
shadowValue String (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
timestamp String (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
userCount Int
value String

Indexes

Index Allow Duplicates Fields
ConfigType No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysConfig Table

SysEncryptionKey

The SysEncryptionKey table stores the encryption key that is used to encrypt the EP query string and post the data parameters.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Key Container
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion

Indexes

Index Allow Duplicates Fields
RecID No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysEncryptionKey Table

SysGlobalConfiguration

The SysGlobalConfiguration table stores system level global setting that can be used to configure specific components.

Fields

Field Type Extended Type Enumeration Type Description
Name String
RecId Int64 RecId
recVersion Integer RecVersion
ServerId String
SettingLevel Int
Value String

Indexes

Index Allow Duplicates Fields
NameIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysGlobalConfiguration Table

SysInheritanceRelations

The SysInheritanceRelations framework helper table for table inheritance. The table stores table inheritance hierarchy related information.

Fields

Field Type Extended Type Enumeration Type Description
MainTableId Int
RecId Int64 RecId
recVersion Integer RecVersion
RelatedTableId Int

Indexes

Index Allow Duplicates Fields
Main No
RelatedMain No

Inheritance Hierarchy

xRecord Class
Common Table
SysInheritanceRelations Table

SysLastValue

The SysLastValue table is storage for the usage data that is recorded as users navigate the system.

Fields

Field Type Extended Type Enumeration Type Description
company String SelectableDataArea ID for the company you can select
designName String UtilElementName Name of the application element.
elementName String UtilElementName Name of the application element.
isKernel Enum boolean
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recordType Enum UtilElementType
recVersion Integer RecVersion
userId String UserId ID for the user
value Container

Relations

Relation Table
isVirtual_Extern DataArea
Partition Partitions
Relation_SysLastValue1 UserInfo
Relation_SysLastValue2 DataArea
userId UserInfo

Indexes

Index Allow Duplicates Fields
RecordType Yes
UserId No

Inheritance Hierarchy

xRecord Class
Common Table
SysLastValue Table

SysModel

The SysModel table contains information about installed models on the system.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
Layer Int64 LayerRecid The ID of the layer.
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
State String

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModel Table

SysModelElement

The SysModelElement table lists the ModelElements that the installation holds.

Fields

Field Type Extended Type Enumeration Type Description
AxId Integer UtilElementId Unique internal identification number of the application object.
ElementType Int64 ModelElementType The ID of an ElementType
Name String
Origin
ParentId Integer UtilElementParentId The unique internal identification number of a parent application object
ParentModelElement Int64 ParentModelElementRecid The ID of a parent model element
PartOfInheritance Int
RecId Int64 RecId
recVersion Integer RecVersion
RootModelElement Int64 RootModelElementRecid The ID of a root model element

Relations

Relation Table
ElementType SysModelElementType
Relation_SysModelElementType SysModelElementType

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElement Table

SysModelElementData

The SysModelElementData table provides the Layer specific data for any SysModelElement.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
Layer Int64 LayerRecid The ID of the layer.
LegacyId Int
ModelElement Int64 ModelElementRecid The ID of a ModelElement
ModelId Integer ModelId The ID of the model.
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
SaveCount Int

Relations

Relation Table
Layer SysModelLayer
ModelElement SysModelElement
ModelId SysModel
Relation_SysModel SysModel
Relation_SysModelElement SysModelElement
Relation_SysModelLayer SysModelLayer

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementData Table

SysModelElementDataOld

The SysModelElementDataOld table provides the Layer specific data for any SysModelElementOld.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
Layer Int64 LayerRecid The ID of the layer.
LegacyId Int
ModelElement Int64 ModelElementRecid The ID of a ModelElement
ModelId Integer ModelId The ID of the model.
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
SaveCount Int

Relations

Relation Table
Layer SysModelLayerOld
ModelElement SysModelElementOld
ModelId SysModelOld
Relation_SysModelElementOld SysModelElementOld
Relation_SysModelLayerOld SysModelLayerOld
Relation_SysModelOld SysModelOld

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementDataOld Table

SysModelElementLabel

The SysModelElementLabel table contains the label text for a given language.

Fields

Field Type Extended Type Enumeration Type Description
Comment String
Id Int
LabelId String
Language String
Module String
RecId Int64 RecId
recVersion Integer RecVersion
Text String

Indexes

Index Allow Duplicates Fields
ModuleLangIDIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementLabel Table

SysModelElementLabelOld

The SysModelElementLabelOld table contains the label text for a given language.

Fields

Field Type Extended Type Enumeration Type Description
Comment String
Id Int
LabelId String
Language String
Module String
RecId Int64 RecId
recVersion Integer RecVersion
Text String

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementLabelOld Table

SysModelElementOld

The SysModelElementOld table lists the ModelElements that the installation holds.

Fields

Field Type Extended Type Enumeration Type Description
AxId Integer UtilElementId Unique internal identification number of the application object.
ElementType Int64 ModelElementType The ID of an ElementType
Name String
Origin
ParentId Integer UtilElementParentId The unique internal identification number of a parent application object
ParentModelElement Int64 ParentModelElementRecid The ID of a parent model element
PartOfInheritance Int
RecId Int64 RecId
recVersion Integer RecVersion
RootModelElement Int64 RootModelElementRecid The ID of a root model element

Relations

Relation Table
ElementType SysModelElementTypeOld
Relation_SysModelElementTypeOld SysModelElementTypeOld

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementOld Table

SysModelElementSource

The SysModelElementSource table contains the Source Text for all SysModelElements that have source.

Fields

Field Type Extended Type Enumeration Type Description
Layer Int64 LayerRecid The ID of the layer.
ModelElement Int64 ModelElementRecid The ID of a ModelElement
RecId Int64 RecId
recVersion Integer RecVersion
Source Container

Relations

Relation Table
Layer SysModelElementData
Relation_SysModelElementData SysModelElementData

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementSource Table

SysModelElementSourceOld

The SysModelElementSourceOld table contains the Source Text for all SysModelElementsOld that have source.

Fields

Field Type Extended Type Enumeration Type Description
Layer Int64 LayerRecid The ID of the layer.
ModelElement Int64 ModelElementRecid The ID of a ModelElement
RecId Int64 RecId
recVersion Integer RecVersion
Source Container

Relations

Relation Table
Layer SysModelElementDataOld
Relation_SysModelElementDataOld SysModelElementDataOld

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementSourceOld Table

SysModelElementType

The SysModelElementType table specifies the possible SysModelElement types. Its Recid is backwards compatible with the UtilRecordType enum for the ‘old’ element types.

Fields

Field Type Extended Type Enumeration Type Description
Name String ModelElementTypeName The name of the element type.
ParentType Int64 ModelElementType The ID of an ElementType
RecId Int64 RecId
recVersion Integer RecVersion
TreeNodeName String

Relations

Relation Table
Name SysModelElementType

Indexes

Index Allow Duplicates Fields
RecIDIdx No
TypeNameIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementType Table

SysModelElementTypeOld

The SysModelElementTypeOld table specifies the possible SysModelElementOld types. Its Recid is backwards compatible with the UtilRecordType enum for the ‘old’ element types.

Fields

Field Type Extended Type Enumeration Type Description
Name String ModelElementTypeName The name of the element type.
ParentType Int64 ModelElementType The ID of an ElementType
RecId Int64 RecId
recVersion Integer RecVersion
TreeNodeName String

Relations

Relation Table
Name SysModelElementType

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelElementTypeOld Table

SysModelLayer

The SysModelLayer table lists the possible LayerId and Name. If Model data exists in a layer it reports the aggregated version number for that layer.

Fields

Field Type Extended Type Enumeration Type Description
IsDirty Int
Layer Enum UtilEntryLevel
RecId Int64 RecId
recVersion Integer RecVersion
VersionNumber Int

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelLayer Table

SysModelLayerOld

The SysModelLayerOld table lists the possible LayerId and Name. If Model data exists in a layer it reports the aggregated version number for that layer.

Fields

Field Type Extended Type Enumeration Type Description
Layer Enum UtilEntryLevel
RecId Int64 RecId
recVersion Integer RecVersion
VersionNumber Int

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelLayerOld Table

SysModelManifest

The SysModelManifest table contains the manifest information about deployed models, such as Description, Publisher and Version of a model

Fields

Field Type Extended Type Enumeration Type Description
Category Integer ModelManifestCategoryRecId The ID of the model category
Description String ModelDescription The description of the model.
DisplayName String ModelDisplayName The display name of the model.
Model Int64 ModelRecid The ID of the model.
Name String ModelName The name of the model in the model store.
Publisher String ModelPublisher The publisher of the model.
RecId Int64 RecId
recVersion Integer RecVersion
Signed Int
VersionBuildNo Int
VersionMajor Int
VersionMinor Int
VersionRevision Int

Field Groups

Field Group Fields
AutoIdentification

Relations

Relation Table
Category SysModelManifestCategory
Model SysModel
Relation_SysModel SysModel
Relation_SysModelManifestCategory SysModelManifestCategory

Indexes

Index Allow Duplicates Fields
ModelNameIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelManifest Table

SysModelManifestCategory

The SysModelManifestCategory table contains the category aspect of the manifest information for deployed models.

Fields

Field Type Extended Type Enumeration Type Description
Name String ModelManifestCategoryName The name of the model category.
RecId Int64 RecId
recVersion Integer RecVersion

Indexes

Index Allow Duplicates Fields
NameIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelManifestCategory Table

SysModelManifestCategoryOld

The SysModelManifestCategoryOld table contains the category aspect of the manifest information for deployed models.

Fields

Field Type Extended Type Enumeration Type Description
Name String ModelManifestCategoryName The name of the model category.
RecId Int64 RecId
recVersion Integer RecVersion

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelManifestCategoryOld Table

SysModelManifestOld

The SysModelManifestOld table contains the manifest information about deployed models, such as Description, Publisher and Version of a model.

Fields

Field Type Extended Type Enumeration Type Description
Category Integer ModelManifestCategoryRecId The ID of the model category
Description String ModelDescription The description of the model.
DisplayName String ModelDisplayName The display name of the model.
Model Int64 ModelRecidOld The ID of the model (old).
Name String ModelName The name of the model in the model store.
Publisher String ModelPublisher The publisher of the model.
RecId Int64 RecId
recVersion Integer RecVersion
Signed Int
VersionBuildNo Int
VersionMajor Int
VersionMinor Int
VersionRevision Int

Field Groups

Field Group Fields
AutoIdentification

Relations

Relation Table
Category SysModelManifestCategoryOld
Model SysModelOld
Relation_SysModelManifestCategoryOld SysModelManifestCategoryOld
Relation_SysModelOld SysModelOld

Indexes

Index Allow Duplicates Fields
ModelNameIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelManifestOld Table

SysModelOld

The SysModelOld table contains information about installed models on the system.

Fields

Field Type Extended Type Enumeration Type Description
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
Layer Int64 LayerRecid The ID of the layer.
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
RecId Int64 RecId
recVersion Integer RecVersion
State String

Indexes

Index Allow Duplicates Fields
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysModelOld Table

SysOccConfiguration

The SysOccConfiguration table stores the global concurrency model setting and updates the conflict exception login policy.

Fields

Field Type Extended Type Enumeration Type Description
AutoUpdateRecVersion Enum boolean
GlobalOccMode Enum GlobalOccMode
LogHandledUpdateConflicts Enum boolean
RecId Int64 RecId
recVersion Integer RecVersion
UniqueIndex Int
UseReadUncommitedForAll Enum boolean

Indexes

Index Allow Duplicates Fields
UniqueIndex No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysOccConfiguration Table

SysRecordLevelSecurity

The SysRecordLevelSecurity table contains all the record level security restrictions that are configured by the system administrator. The restrictions are persisted on a per company, per group basis.

Fields

Field Type Extended Type Enumeration Type Description
_unused Enum boolean
companyId String SelectableDataArea ID for the company you can select
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DEL_groupId String UserGroupId ID for the user group
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
restriction Container
SecurityRole Int64 RecId Name of the security role
tabId Integer TableId ID for the table

Relations

Relation Table
companyId DataArea
DEL_groupId UserGroupInfo
Partition Partitions
Relation_SecurityRole SecurityRole
SecurityRole SecurityRole

Indexes

Index Allow Duplicates Fields
RecId No
Role No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysRecordLevelSecurity Table

SysServerSessions

The SysServerSessions table is used to store information about the active AOS Servers in the system.

Fields

Field Type Extended Type Enumeration Type Description
AOSAccount String
AOSId String
DEL_LastUpdateTime Int
DEL_Login_time Int
Instance_Name String
LastUpdateDateTime UtcDateTime
LoadBalance Int
LoginDateTime UtcDateTime
RecId Int64 RecId
recVersion Integer RecVersion
ServerId Int
Status Int
Version Int
Workload Int

Indexes

Index Allow Duplicates Fields
LoadBalance Yes
ServerId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SysServerSessions Table

SysSetbasedHelper

The SysSetbasedHelper framework helper table for table inheritance set-based operations.

Fields

Field Type Extended Type Enumeration Type Description
CandidateRecId Int64 RecId Unique ID for the record in the database
RecId Int64 RecId
recVersion Integer RecVersion

Indexes

Index Allow Duplicates Fields
CandidateRecIDIdx No
RecIDIdx No

Inheritance Hierarchy

xRecord Class
Common Table
SysSetbasedHelper Table

SystemSequences

The SystemSequences table holds the next available record ID block for each table.

Fields

Field Type Extended Type Enumeration Type Description
cycle Enum boolean
dataAreaId String DataAreaId
id Int
maxVal Int64 RecId Unique ID for the record in the database
minVal Int64 RecId Unique ID for the record in the database
name String
nextVal Int64 RecId Unique ID for the record in the database
RecId Int64 RecId
recVersion Integer RecVersion
tabId Integer TableId ID for the table

Relations

Relation Table
dataAreaId DataArea

Indexes

Index Allow Duplicates Fields
Id No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
SystemSequences Table

TableCollectionList

The TableCollectionList table stores the mapping between table collections and virtual companies.

Fields

Field Type Extended Type Enumeration Type Description
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
tableCollection String UtilElementName Name of the application element.
virtualDataArea String VirtualDataArea ID for a virtual company

Relations

Relation Table
isVirtual_Extern DataArea
parentId_Extern UtilElements
Partition Partitions
Relation_CollectionList1 UtilElements
Relation_CollectionList2 DataArea

Indexes

Index Allow Duplicates Fields
VirtualDataArea No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
TableCollectionList Table

TimeZonesList

The TimeZonesList table contains the list of the time zones that are supported by Microsoft Dynamics Ax.

Fields

Field Type Extended Type Enumeration Type Description
EnumName String
EnumPosition Int
RecId Int64 RecId
recVersion Integer RecVersion
TimeZoneKeyName String
TzEnum Enum Timezone

Indexes

Index Allow Duplicates Fields
EnumPosition No
TzEnum No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
TimeZonesList Table

TimeZonesRulesData

The TimeZonesRulesData table contains the GMT offsets and daylight saving time information for all time zones that are supported by Microsoft Dynamics AX.

Fields

Field Type Extended Type Enumeration Type Description
Bias Int
DBias Int
DDay Int
DDayOfWeek Int
DHour Int
DMinute Int
DMonth Int
DSecond Int
DYear Int
RecId Int64 RecId
recVersion Integer RecVersion
RuleId Int
SBias Int
SDay Int
SDayOfWeek Int
SHour Int
SMinute Int
SMonth Int
SSecond Int
SYear Int
TzEnum Enum Timezone
Year Int

Relations

Relation Table
Relation_TimeZonesRulesData1 TimeZonesList
TzEnum TimeZonesList

Indexes

Index Allow Duplicates Fields
RuleId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
TimeZonesRulesData Table

UserDataAreaFilter

The UserDataAreaFilter table contains a list of selectable companies for a user. It is populated by invoking the populateSelectableCompanies method on the SecurityRights class.

Fields

Field Type Extended Type Enumeration Type Description
DataArea String DataAreaId ID for an area of data
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
User String UserId ID for the user

Relations

Relation Table
DataArea DataArea
Partition Partitions
Relation_DataArea DataArea
Relation_User UserInfo
User UserInfo

Indexes

Index Allow Duplicates Fields
DataAreaIdx No
RecIdIdx No

Inheritance Hierarchy

xRecord Class
Common Table
UserDataAreaFilter Table

UserInfo

The UserInfo table contains a list of users in Microsoft Dynamics Ax and their active directory and default information.

Fields

Field Type Extended Type Enumeration Type Description
accountType Enum UserAccountType
autoInfo Int
autoLogOff Int
autoUpdate Int
clientAccessLogLevel Int
company String SelectableDataArea ID for the company you can select
compilerWarningLevel Enum CompilerWarningLevel
confirmDelete Int
confirmUpdate Int
credentialRecId int64
debuggerPopup Int
debugInfo Int
defaultPartition Enum boolean (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DEL__unused1 String
DEL__unused2 String
DEL_defaultModelId Int
DEL_osAccountName String
DEL_password String
DEL_startupMenu String UtilElementName Name of the application element.
enable Enum boolean
enabledOnce Enum boolean
externalId String
externalIdType Enum ExternalIdType
externalUser Enum boolean
filterByGridOnByDefault Enum boolean
formFontName String
formFontSize Int
garbagecollectlimit Int
generalInfo Int
globalExcelExportFilePath String (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
globalExcelExportLocation Int
globalExcelExportMode Int
globalFormOpenMode Int
globalListPageLinkMode Int
helplanguage String InstalledLanguageId
historyLimit Int
homePageRefreshDuration Int
id String UserId ID for the user
IdentityProvider String NetworkDomain
infologLevel Int
issuerRecId int64
language String InstalledLanguageId
messageLimit Int
name String UserIdStr Name
networkAlias String NetworkAlias
networkDomain String NetworkDomain
notifyTimeZoneMismatch Enum boolean
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
preferredCalendar Enum PreferredCalendar
PreferredLocale String PreferredLocale
preferredTimeZone Enum Timezone
propertyFontName String
propertyFontSize Int
querytimeLimit Int
RecId Int64 RecId
recVersion Integer RecVersion
reportBottomMargin String
reportFontName String
reportFontSize Int
reportLeftMargin String
reportRightMargin String
reportTopMargin String
showAOTLayer Int
showModelNameInAOT Int
showStatusLine Int
showToolbar Int
sid String Sid
startupProject String UtilElementName Name of the application element.
statuslineInfo Int
toolbarInfo Int
traceInfo Int

Field Groups

Field Group Fields
AutoLookup id, accountType, name, networkAlias, networkDomain, enable
AutoReport

Relations

Relation Table
id UserInfo
isVirtual_Extern DataArea
Partition Partitions
Relation_UserInfo DataArea

Indexes

Index Allow Duplicates Fields
Id No
IdOnly Yes
Sid Yes
SidOnly Yes

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateDelete. The Application Object Server authorizes each create and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
UserInfo Table

UserInfoStartupModel

The UserInfoStartupModel table holds the preferred startup model for each layer for each user.

Fields

Field Type Extended Type Enumeration Type Description
Layer Enum UtilEntryLevel
ModelId Int64 ModelRecid The ID of the model.
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
UserId String UserGroupId ID for the user group

Relations

Relation Table
ModelId SysModelManifest
Partition Partitions
Relation_SysModelManifest SysModelManifest
Relation_UserInfo UserInfo
Relation_UserInfoStartupModel3 DEL_UserGroupInfo
UserId UserInfo

Indexes

Index Allow Duplicates Fields
RecIDIdx No
UserID_Layer_Idx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
UserInfoStartupModel Table

UtilElements

The UtilElements table contains the application that is shown in the AOT.

Fields

Field Type Extended Type Enumeration Type Description
baseVersion Int
code Container
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
name String UtilElementName Name of the application element.
parentId Int
RecId Int64 RecId
recordType Enum UtilElementType
recVersion Integer RecVersion
saveCount Int
source Container
utilLevel Enum UtilEntryLevel
version Int

Indexes

Index Allow Duplicates Fields
name No recordType, parentId, name, utilLevel
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
UtilElements Table

UtilElementsOld

The UtilElementsOld table contains the application model stored in the application folder. It is used during the upgrade process.

Fields

Field Type Extended Type Enumeration Type Description
baseVersion Int
code Container
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
name String UtilElementName Name of the application element.
parentId Int
RecId Int64 RecId
recordType Enum UtilElementType
recVersion Integer RecVersion
saveCount Int
source Container
utilLevel Enum UtilEntryLevel
version Int

Indexes

Index Allow Duplicates Fields
name No recordType, parentId, name, utilLevel
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
UtilElementsOld Table

UtilIdElements

The UtilIdElements table contains the application model shown in the AOT.

Fields

Field Type Extended Type Enumeration Type Description
baseVersion Int
code Container
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
id Int
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
name String UtilElementName Name of the application element.
parentId Int
RecId Int64 RecId
recordType Enum UtilElementType
recVersion Integer RecVersion
saveCount Int
utilLevel Enum UtilEntryLevel
version Int

Indexes

Index Allow Duplicates Fields
Id No
name No recordType, parentId, name, utilLevel
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
UtilIdElements Table

UtilIdElementsOld

The UtilIdElementsOld table contains the application model stored in the application folder. It is used during the upgrade process.

Fields

Field Type Extended Type Enumeration Type Description
baseVersion Int
code Container
createdBy String CreatedBy
createdDateTime UtcDateTime CreatedDateTime
dEL_CreatedTime Integer DEL_CreatedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Integer DEL_ModifiedTime (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
id Int
modifiedBy String ModifiedBy
modifiedDateTime UtcDateTime ModifiedDateTime
name String UtilElementName Name of the application element.
parentId Int
RecId Int64 RecId
recordType Enum UtilElementType
recVersion Integer RecVersion
saveCount Int
utilLevel Enum UtilEntryLevel
version Int

Indexes

Index Allow Duplicates Fields
Id No
name No recordType, parentId, name, utilLevel
RecId No

Inheritance Hierarchy

xRecord Class
Common Table
UtilIdElementsOld Table

UtilModels

The UtilModels table contains information about models that are installed on the system.

Fields

Field Type Extended Type Enumeration Type Description
CategoryId Int
Description String ModelDescription The description of the model.
DisplayName String ModelDisplayName The display name of the model.
Id Int
InstallMode Int
Layer Enum UtilEntryLevel
MarkedForRemoval Int
ModelGroupId Int
Name String ModelName The name of the model in the model store.
Publisher String ModelPublisher The publisher of the model.
RecId Int64 RecId
recVersion Integer RecVersion
Signed Int
State String
VersionBuildNo Int
VersionMajor Int
VersionMinor Int
VersionRevision Int

Indexes

Index Allow Duplicates Fields
ModelIDIdx No
ModelNameIdx No
RecIDIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
UtilModels Table

VirtualDataAreaList

The VirtualDataAreaList table stores the mapping between real companies and virtual companies.

Fields

Field Type Extended Type Enumeration Type Description
id String SelectableDataArea ID for the company you can select
Partition Int64 Partition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Int64 RecId
recVersion Integer RecVersion
virtualDataArea String VirtualDataArea ID for a virtual company

Field Groups

Field Group Fields
virtualDataAreaRelation

Relations

Relation Table
isVirtual_Extern DataArea
Partition Partitions
Relation_DataAreaList1 DataArea
Relation_DataAreaList2 DataArea

Indexes

Index Allow Duplicates Fields
Id No
RecId No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
VirtualDataAreaList Table

VSAssembly

The VSAssembly table contains synchronization information that describes the last time an assembly that is stored under the Visual Studio Projects node in the AOT was deployed..

Fields

Field Type Extended Type Enumeration Type Description
DeployTo Enum DeployTo
Name String AssemblyName
ProjectName String ProjectName
ProjectType String ProjectType
RecId Int64 RecId
recVersion Integer RecVersion
ServerId Int
UpdatedDate UtcDateTime

Indexes

Index Allow Duplicates Fields
NameIdx No

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Inheritance Hierarchy

xRecord Class
Common Table
VSAssembly Table

转载请注明:ww12345678 的部落格 | AX Helper » System Tables

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址