Edit

Share via

SLA Item (SLAItem) table/entity reference (Microsoft Dataverse)

  • Article

Contains information about a tracked support KPI for a specific customer.

Messages

The following table lists the messages for the SLA Item (SLAItem) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Associate
Event: True		 Associate records Associate records
Create
Event: True		 POST /slaitems
See Create		 Create records
Delete
Event: False		 DELETE /slaitems(slaitemid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /slaitems(slaitemid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /slaitems
See Query data		 Query data
Update
Event: True		 PATCH /slaitems(slaitemid)
See Update		 Update records
Upsert
Event: False		 PATCH /slaitems(slaitemid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the SLA Item (SLAItem) table.

Property Value
DisplayName SLA Item
DisplayCollectionName SLA Items
SchemaName SLAItem
CollectionSchemaName SLAItems
EntitySetName slaitems
LogicalName slaitem
LogicalCollectionName slaitems
PrimaryIdAttribute slaitemid
PrimaryNameAttribute name
TableType Standard
OwnershipType None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

actionflowuniquename

Property Value
Description
DisplayName Action Flow Unique Name
IsValidForForm True
IsValidForRead True
LogicalName actionflowuniquename
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 4000

ActionURL

Property Value
Description Action URL
DisplayName Action URL
IsValidForForm True
IsValidForRead True
LogicalName actionurl
RequiredLevel None
Type String
Format Url
FormatName Url
ImeMode Auto
IsLocalizable False
MaxLength 1024

AllowPauseResume

Property Value
Description Select whether this SLA will allow pausing and resuming during the time calculation.
DisplayName Allow Pause and Resume
IsValidForForm True
IsValidForRead True
LogicalName allowpauseresume
RequiredLevel None
Type Boolean
GlobalChoiceName slaitem_allowpauseresume
DefaultValue True
True Label Yes
False Label No

ApplicableEntity

Property Value
Description
DisplayName Applicable Entity
IsValidForForm True
IsValidForRead True
LogicalName applicableentity
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

ApplicableWhenXml

Property Value
Description Condition for SLA item
DisplayName ApplicableWhenXml
IsValidForForm False
IsValidForRead True
LogicalName applicablewhenxml
RequiredLevel ApplicationRequired
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

BusinessHoursId

Property Value
Description Choose the business hours for calculating SLA item timelines.
DisplayName Business Hours
IsValidForForm True
IsValidForRead True
LogicalName businesshoursid
RequiredLevel None
Type Lookup
Targets calendar

ChangedAttributeList

Property Value
Description
DisplayName Changed Attribute List
IsValidForForm True
IsValidForRead True
LogicalName changedattributelist
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 4000

Description

Property Value
Description Type additional information to describe the SLA Item
DisplayName Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type String
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 100

FailureAfter

Property Value
Description Select how soon the success criteria must be met until the SLA item is considered failed and failure actions are initiated. The actual duration is based on the business hours as specified in the associated SLA record.
DisplayName Failure After
IsValidForForm True
IsValidForRead True
LogicalName failureafter
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

msdyn_AdvancedPauseConfiguration

Property Value
Description
DisplayName Advanced Pause Configuration
IsValidForForm True
IsValidForRead True
LogicalName msdyn_advancedpauseconfiguration
RequiredLevel None
Type Boolean
GlobalChoiceName slaitem_msdyn_advancedpauseconfiguration
DefaultValue False
True Label Yes
False Label No

msdyn_CustomTimeCalculation

Property Value
Description
DisplayName Custom Time Calculation Flag
IsValidForForm True
IsValidForRead True
LogicalName msdyn_customtimecalculation
RequiredLevel None
Type Boolean
GlobalChoiceName slaitem_msdyn_customtimecalculation
DefaultValue False
True Label Yes
False Label No

msdyn_CustomTimeCalculationWorkflowId

Property Value
Description Unique identifier for Custom Time Calculation Workflow associated with SLA Item.
DisplayName Custom Time Calculation Workflow
IsValidForForm True
IsValidForRead True
LogicalName msdyn_customtimecalculationworkflowid
RequiredLevel None
Type Lookup
Targets workflow

msdyn_PauseConfigurationXml

Property Value
Description
DisplayName PauseConfigurationXml
IsValidForForm True
IsValidForRead True
LogicalName msdyn_pauseconfigurationxml
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1048576

msdyn_slakpiid

Property Value
Description Unique identifier for SLAKPI associated with SLA Item.
DisplayName SLA KPI
IsValidForForm True
IsValidForRead True
LogicalName msdyn_slakpiid
RequiredLevel None
Type Lookup
Targets msdyn_slakpi

Name

Property Value
Description Type a descriptive name of the service level agreement (SLA) item.
DisplayName Name
IsValidForForm True
IsValidForRead True
LogicalName name
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwnerId

Property Value
Description Enter the user or team who owns the SLA. This field is updated every time the item is assigned to a different user.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel ApplicationRequired
Type Owner
Targets systemuser, team

OwnerIdType

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

OwningUser

Property Value
Description Unique identifier of the user who owns the SLA Item record.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets

RelatedField

Property Value
Description Select the service level agreement (SLA) key performance indicator (KPI) that this SLA Item is created for.
DisplayName Related Case Field
IsValidForForm True
IsValidForRead True
LogicalName relatedfield
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Inactive
IsLocalizable False
MaxLength 100

SequenceNumber

Property Value
Description Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName Sequence
IsValidForForm True
IsValidForRead True
LogicalName sequencenumber
RequiredLevel None
Type Integer
MaxValue 1500
MinValue 0

SLAId

Property Value
Description Unique identifier for SLA associated with SLA Item.
DisplayName SLA
IsValidForForm True
IsValidForRead True
LogicalName slaid
RequiredLevel SystemRequired
Type Lookup
Targets sla

SLAItemId

Property Value
Description Unique identifier of the SLA Item.
DisplayName SLA Item
IsValidForForm False
IsValidForRead True
LogicalName slaitemid
RequiredLevel SystemRequired
Type Uniqueidentifier

SuccessConditionsXml

Property Value
Description Condition for SLA item
DisplayName SuccessConditionsXml
IsValidForForm False
IsValidForRead True
LogicalName successconditionsxml
RequiredLevel ApplicationRequired
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

WarnAfter

Property Value
Description Select how soon the success criteria must be met before warning actions are initiated. The actual duration is based on the business hours as specified in the associated SLA record.
DisplayName Warn After
IsValidForForm True
IsValidForRead True
LogicalName warnafter
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

WorkflowId

Property Value
Description Workflow associated with the SLA Item.
DisplayName Workflow ID
IsValidForForm False
IsValidForRead True
LogicalName workflowid
RequiredLevel None
Type Lookup
Targets workflow

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ComponentState

Property Value
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName componentstate

ComponentState Choices/Options

Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

ExchangeRate

Property Value
Description Exchange rate between the currency associated with the SLA Item record and the base currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

IsManaged

Property Value
Description For internal use only.
DisplayName Is Managed
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

ModifiedBy

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OverwriteTime

Property Value
Description For internal use only.
DisplayName Record Overwrite Time
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

OwningBusinessUnit

Property Value
Description Unique identifier for the business unit that owns the record
DisplayName Owning Business Unit
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

SLAItemIdUnique

Property Value
Description For internal use only.
DisplayName Unique Id
IsValidForForm False
IsValidForRead True
LogicalName slaitemidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

SolutionId

Property Value
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

SupportingSolutionId

Property Value
Description For internal use only.
DisplayName Solution
IsValidForForm False
IsValidForRead False
LogicalName supportingsolutionid
RequiredLevel None
Type Uniqueidentifier

TransactionCurrencyId

Property Value
Description Unique identifier of the currency associated with the SLA Item record.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Type Lookup
Targets transactioncurrency

VersionNumber

Property Value
Description Version number of the SLA Item.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

calendar_slaitem

One-To-Many Relationship: calendar calendar_slaitem

Property Value
ReferencedEntity calendar
ReferencedAttribute calendarid
ReferencingAttribute businesshoursid
ReferencingEntityNavigationPropertyName businesshoursid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slaitembase_createdby

One-To-Many Relationship: systemuser lk_slaitembase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slaitembase_createdonbehalfby

One-To-Many Relationship: systemuser lk_slaitembase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slaitembase_modifiedby

One-To-Many Relationship: systemuser lk_slaitembase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slaitembase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_slaitembase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_msdyn_slakpi_slaitem

One-To-Many Relationship: msdyn_slakpi msdyn_msdyn_slakpi_slaitem

Property Value
ReferencedEntity msdyn_slakpi
ReferencedAttribute msdyn_slakpiid
ReferencingAttribute msdyn_slakpiid
ReferencingEntityNavigationPropertyName msdyn_SLAKPIID
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_workflow_slaitem_customtimecalculationworkflowid

One-To-Many Relationship: workflow msdyn_workflow_slaitem_customtimecalculationworkflowid

Property Value
ReferencedEntity workflow
ReferencedAttribute workflowid
ReferencingAttribute msdyn_customtimecalculationworkflowid
ReferencingEntityNavigationPropertyName msdyn_customtimecalculationworkflowid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

sla_slaitem_slaId

One-To-Many Relationship: sla sla_slaitem_slaId

Property Value
ReferencedEntity sla
ReferencedAttribute slaid
ReferencingAttribute slaid
ReferencingEntityNavigationPropertyName slaid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slaitembase_workflowid

One-To-Many Relationship: workflow slaitembase_workflowid

Property Value
ReferencedEntity workflow
ReferencedAttribute workflowid
ReferencingAttribute workflowid
ReferencingEntityNavigationPropertyName workflowid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

TransactionCurrency_SLAItem

One-To-Many Relationship: transactioncurrency TransactionCurrency_SLAItem

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

msdyn_slaitem_slakpiinstance

Many-To-One Relationship: slakpiinstance msdyn_slaitem_slakpiinstance

Property Value
ReferencingEntity slakpiinstance
ReferencingAttribute msdyn_slaitemid
ReferencedEntityNavigationPropertyName msdyn_slaitem_slakpiinstance
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SLAItem_SyncErrors

Many-To-One Relationship: syncerror SLAItem_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SLAItem_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
slaitem