SQL statement trace log in Framework(SysTraceTableSQL)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeSysTraceTableSQL/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enSQL statement trace log
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Framework/SysTraceTableSQL
callStack Framework/SysTraceTableSQL
Category Framework/SysTraceTableSQL
Code Framework/SysTraceTableSQL
ConnectionId Framework/SysTraceTableSQL
ConnectionSPID Framework/SysTraceTableSQL
ConnectionType Framework/SysTraceTableSQL
DetailType Framework/SysTraceTableSQL
IsLobsIncluded Framework/SysTraceTableSQL
IsMoreDataPending Framework/SysTraceTableSQL
IsSelectedForUpdate Framework/SysTraceTableSQL
IsStartedWithinTransaction Framework/SysTraceTableSQL
RowsAffected Framework/SysTraceTableSQL
RowSize Framework/SysTraceTableSQL
RowsPerFetch Framework/SysTraceTableSQL
Statement Framework/SysTraceTableSQL
StatementId Framework/SysTraceTableSQL
StatementReuseCount Framework/SysTraceTableSQL
StatementType Framework/SysTraceTableSQL
Text Framework/SysTraceTableSQL
TextDetails Framework/SysTraceTableSQL
traceContainer Framework/SysTraceTableSQL
traceTime Framework/SysTraceTableSQL
DataAreaId Framework/SysTraceTableSQL
Relationship_CompanyRelationshipId Framework/SysTraceTableSQL

RecId

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeSysTraceTableSQL/(resolvedAttributes)/RecIdattribute

is.readOnly
is.dataFormat.integer
is.dataFormat.big

callStack

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the callStack attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

Category

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
displayNameTrace type
dataFormatint32
isNullabletrue

Traits

List of traits for the Category attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTrace type
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Code

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Code attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

ConnectionId

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ConnectionId attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

ConnectionSPID

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ConnectionSPID attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

ConnectionType

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the ConnectionType attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

DetailType

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
displayNameTrace detail type
dataFormatint32
isNullabletrue

Traits

List of traits for the DetailType attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTrace detail type
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

IsLobsIncluded

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsLobsIncluded attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

IsMoreDataPending

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsMoreDataPending attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

IsSelectedForUpdate

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsSelectedForUpdate attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

IsStartedWithinTransaction

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsStartedWithinTransaction attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

RowsAffected

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RowsAffected attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

RowSize

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RowSize attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

RowsPerFetch

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RowsPerFetch attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

Statement

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the Statement attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

StatementId

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StatementId attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

StatementReuseCount

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StatementReuseCount attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

StatementType

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StatementType attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

Text

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the Text attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

TextDetails

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the TextDetails attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

traceContainer

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

List of traits for the traceContainer attribute are listed below.

is.dataFormat.byte
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.byte
is.dataFormat.array

traceTime

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the traceTime attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

DataAreaId

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the DataAreaId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.dataFormat.character
is.dataFormat.array

Relationship_CompanyRelationshipId

First included in: Framework/SysTraceTableSQL (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array