SLAItem table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

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

Messages

Message Web API Operation SDK class or method
Create POST /slaitems
See Create
CreateRequest or
Create
Delete DELETE /slaitems(slaitemid)
See Delete
DeleteRequest or
Delete
Retrieve GET /slaitems(slaitemid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /slaitems
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
Update PATCH /slaitems(slaitemid)
See Update
UpdateRequest or
Update

Properties

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

Writable columns/attributes

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

actionflowuniquename

Added by: Service Level Agreement (SLA) Solution

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

ActionURL

Added by: Service Level Agreement (SLA) Solution

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

AllowPauseResume

Added by: Service Level Agreement (SLA) Solution

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
IsValidForUpdate False
LogicalName allowpauseresume
RequiredLevel None
Type Boolean

AllowPauseResume Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 1

ApplicableEntity

Added by: Service Level Agreement (SLA) Solution

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

ApplicableWhenXml

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

BusinessHoursId

Added by: Service Level Agreement (SLA) Solution

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

ChangedAttributeList

Added by: Service Level Agreement (SLA) Solution

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

Description

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

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
Format Duration
IsValidForForm True
IsValidForRead True
LogicalName failureafter
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

msdyn_AdvancedPauseConfiguration

Added by: Service Level Agreement (SLA) Extension Solution

Property Value
Description
DisplayName Advanced Pause Configuration
IsValidForForm True
IsValidForRead True
LogicalName msdyn_advancedpauseconfiguration
RequiredLevel None
Type Boolean

msdyn_AdvancedPauseConfiguration Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_CustomTimeCalculation

Added by: Service Level Agreement (SLA) Extension Solution

Property Value
Description
DisplayName Custom Time Calculation Flag
IsValidForForm True
IsValidForRead True
LogicalName msdyn_customtimecalculation
RequiredLevel None
Type Boolean

msdyn_CustomTimeCalculation Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_CustomTimeCalculationWorkflowId

Added by: Service Level Agreement (SLA) Extension Solution

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
Targets workflow
Type Lookup

msdyn_PauseConfigurationXml

Added by: Service Level Agreement (SLA) Extension Solution

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

msdyn_slakpiid

Added by: Service Level Agreement (SLA) Extension Solution

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

Name

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

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
IsValidForUpdate False
LogicalName ownerid
RequiredLevel ApplicationRequired
Targets systemuser,team
Type Owner

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
IsValidForUpdate False
LogicalName owninguser
RequiredLevel None
Targets
Type Lookup

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
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName relatedfield
MaxLength 100
RequiredLevel None
Type String

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
Format None
IsValidForForm True
IsValidForRead True
LogicalName sequencenumber
MaxValue 1500
MinValue 0
RequiredLevel None
Type Integer

SLAId

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

SLAItemId

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

SuccessConditionsXml

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

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
Format Duration
IsValidForForm True
IsValidForRead True
LogicalName warnafter
MaxValue 2147483647
MinValue 0
RequiredLevel None
Type Integer

WorkflowId

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

WorkflowIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName workflowidname
MaxLength 100
RequiredLevel None
Type String

Read-only columns/attributes

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

businesshoursidName

Added by: Service Level Agreement (SLA) Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName businesshoursidname
MaxLength 160
RequiredLevel None
Type String

ComponentState

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

ComponentState Choices/Options

Value Label Description
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
Targets systemuser
Type Lookup

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

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
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

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
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

IsManaged

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

IsManaged Choices/Options

Value Label Description
1 Managed
0 Unmanaged

DefaultValue: 0

ModifiedBy

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

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

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
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

msdyn_customtimecalculationworkflowidName

Added by: Service Level Agreement (SLA) Extension Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_customtimecalculationworkflowidname
MaxLength 100
RequiredLevel None
Type String

msdyn_slakpiidName

Added by: Service Level Agreement (SLA) Extension Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_slakpiidname
MaxLength 100
RequiredLevel None
Type String

OverwriteTime

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

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
Targets businessunit
Type Lookup

SLAIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName slaidname
MaxLength 100
RequiredLevel None
Type String

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
Targets transactioncurrency
Type Lookup

TransactionCurrencyIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

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

One-To-Many Relationships

Listed by SchemaName.

SLAItem_SyncErrors

Same as the SLAItem_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName SLAItem_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

msdyn_slaitem_slakpiinstance

Added by: Service Level Agreement (SLA) Extension Solution

Same as the msdyn_slaitem_slakpiinstance many-to-one relationship for the slakpiinstance table/entity.

Property Value
ReferencingEntity slakpiinstance
ReferencingAttribute msdyn_slaitemid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_slaitem_slakpiinstance
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

lk_slaitembase_createdby

See the lk_slaitembase_createdby one-to-many relationship for the systemuser table/entity.

lk_slaitembase_modifiedonbehalfby

See the lk_slaitembase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

lk_slaitembase_createdonbehalfby

See the lk_slaitembase_createdonbehalfby one-to-many relationship for the systemuser table/entity.

TransactionCurrency_SLAItem

See the TransactionCurrency_SLAItem one-to-many relationship for the transactioncurrency table/entity.

sla_slaitem_slaId

See the sla_slaitem_slaId one-to-many relationship for the sla table/entity.

lk_slaitembase_modifiedby

See the lk_slaitembase_modifiedby one-to-many relationship for the systemuser table/entity.

slaitembase_workflowid

See the slaitembase_workflowid one-to-many relationship for the workflow table/entity.

calendar_slaitem

See the calendar_slaitem one-to-many relationship for the calendar table/entity.

msdyn_msdyn_slakpi_slaitem

Added by: Service Level Agreement (SLA) Extension Solution

See the msdyn_msdyn_slakpi_slaitem one-to-many relationship for the msdyn_slakpi table/entity.

msdyn_workflow_slaitem_customtimecalculationworkflowid

See the msdyn_workflow_slaitem_customtimecalculationworkflowid one-to-many relationship for the workflow table/entity.

See also

Dataverse table/entity reference
Web API Reference
slaitem EntityType