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.

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

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.

Relations

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.

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

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.

Indexes

Inheritance Hierarchy

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

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.

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.

Indexes

Inheritance Hierarchy

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

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

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.

Indexes

Inheritance Hierarchy

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.

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.

Indexes

Inheritance Hierarchy

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

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.

Indexes

Inheritance Hierarchy

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

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.

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

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

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

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

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

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

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.

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

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.

Relations

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

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.

Relations

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.

Field Groups

Indexes

Inheritance Hierarchy

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

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.

Field Groups

Indexes

Inheritance Hierarchy

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.

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

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.

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.

Relations

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.

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.

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

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.

Indexes

Inheritance Hierarchy

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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.

Indexes

Inheritance Hierarchy

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.

Relations

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

TimeZonesList

The TimeZonesList table contains the list of the time zones that are supported.

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

TimeZonesRulesData

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

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.

Field Groups

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.

Relations

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.

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.

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.

Indexes

Inheritance Hierarchy

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.

Field Groups

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

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.