Facility/Equipment (Equipment) table/entity reference (Microsoft Dynamics 365)

Resource that can be scheduled.

Messages

The following table lists the messages for the Facility/Equipment (Equipment) 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 /equipments See Create	Create records
CreateMultiple Event: True	CreateMultiple	CreateMultipleRequest
Delete Event: True	DELETE /equipments(equipmentid) See Delete	Delete records
Disassociate Event: True	Disassociate records	Disassociate records
Retrieve Event: True	GET /equipments(equipmentid) See Retrieve	Retrieve records
RetrieveMultiple Event: True	GET /equipments See Query data	Query data
SetBusinessSystemUser Event: False	SetBusinessSystemUser	SetBusinessSystemUserRequest
Update Event: True	PATCH /equipments(equipmentid) See Update	Update records
UpdateMultiple Event: True	UpdateMultiple	UpdateMultipleRequest
Upsert Event: False	PATCH /equipments(equipmentid) See Upsert a table row	UpsertRequest
UpsertMultiple Event: False	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Facility/Equipment (Equipment) table.

Property	Value
DisplayName	Facility/Equipment
DisplayCollectionName	Facilities/Equipment
SchemaName	Equipment
CollectionSchemaName	Equipments
EntitySetName	equipments
LogicalName	equipment
LogicalCollectionName	equipments
PrimaryIdAttribute	equipmentid
PrimaryNameAttribute	name
TableType	Standard
OwnershipType	BusinessOwned

Writable columns/attributes

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

• BusinessUnitId
• CalendarId
• Description
• DisplayInServiceViews
• EMailAddress
• EquipmentId
• ImportSequenceNumber
• IsDisabled
• Name
• OverriddenCreatedOn
• SiteId
• Skills
• TimeZoneCode
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• UTCConversionTimeZoneCode

BusinessUnitId

Property	Value
Description	Shows the business unit that the Equipment belongs to.
DisplayName	Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	businessunitid
RequiredLevel	SystemRequired
Type	Lookup
Targets	businessunit

CalendarId

Property	Value
Description	Fiscal calendar associated with the facility/equipment.
DisplayName	Calendar
IsValidForForm	False
IsValidForRead	True
LogicalName	calendarid
RequiredLevel	SystemRequired
Type	Lookup
Targets	calendar

Description

Property	Value
Description	Description of the facility/equipment.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	description
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

DisplayInServiceViews

Property	Value
Description	For internal use only.
DisplayName	Display in Service Views
IsValidForForm	True
IsValidForRead	True
LogicalName	displayinserviceviews
RequiredLevel	None
Type	Boolean
GlobalChoiceName	equipment_displayinserviceviews
DefaultValue	False
True Label	Yes
False Label	No

EMailAddress

Property	Value
Description	Email address of person to contact about the use of the facility/equipment.
DisplayName	Primary Email
IsValidForForm	True
IsValidForRead	True
LogicalName	emailaddress
RequiredLevel	None
Type	String
Format	Email
FormatName	Email
ImeMode	Auto
IsLocalizable	False
MaxLength	100

EquipmentId

Property	Value
Description	Unique identifier of the facility/equipment.
DisplayName	Facility/Equipment
IsValidForForm	False
IsValidForRead	True
LogicalName	equipmentid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	importsequencenumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

IsDisabled

Property	Value
Description	Whether the facility/equipment is disabled or operational.
DisplayName	Is Disabled
IsValidForForm	False
IsValidForRead	True
LogicalName	isdisabled
RequiredLevel	None
Type	Boolean
GlobalChoiceName	equipment_isdisabled
DefaultValue	False
True Label	Yes
False Label	No

Name

Property	Value
Description	Name of the facility/equipment.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	name
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

SiteId

Property	Value
Description	Site where the facility/equipment is located.
DisplayName	Site
IsValidForForm	True
IsValidForRead	True
LogicalName	siteid
RequiredLevel	None
Type	Lookup
Targets	site

Skills

Property	Value
Description	Skills needed to operate the facility/equipment.
DisplayName	Skills
IsValidForForm	True
IsValidForRead	True
LogicalName	skills
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

TimeZoneCode

Property	Value
Description	Local time zone where the facility/equipment is located.
DisplayName	Time Zone
IsValidForForm	True
IsValidForRead	True
LogicalName	timezonecode
RequiredLevel	SystemRequired
Type	Integer
MaxValue	1500
MinValue	-1500

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

TransactionCurrencyId

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

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

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

• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• ExchangeRate
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OrganizationId
• VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the facility/equipment entry.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the record was created.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the equipment.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Exchange rate for the currency associated with the equipment with respect to 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

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the facility/equipment.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the equipment.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier of the parent business unit.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Lookup
Targets	organization

VersionNumber

Property	Value
Description	Version Number
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.

• business_unit_equipment
• calendar_equipment
• equipment_systemuser
• lk_equipment_createdby
• lk_equipment_createdonbehalfby
• lk_equipment_modifiedby
• lk_equipment_modifiedonbehalfby
• organization_equipment
• site_equipment
• TransactionCurrency_Equipment

business_unit_equipment

One-To-Many Relationship: businessunit business_unit_equipment

Property	Value
ReferencedEntity	businessunit
ReferencedAttribute	businessunitid
ReferencingAttribute	businessunitid
ReferencingEntityNavigationPropertyName	businessunitid_businessunit
IsHierarchical
CascadeConfiguration	Archive: Restrict Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

calendar_equipment

One-To-Many Relationship: calendar calendar_equipment

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

equipment_systemuser

One-To-Many Relationship: systemuser equipment_systemuser

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

lk_equipment_createdby

One-To-Many Relationship: systemuser lk_equipment_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_equipment_createdonbehalfby

One-To-Many Relationship: systemuser lk_equipment_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_equipment_modifiedby

One-To-Many Relationship: systemuser lk_equipment_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_equipment_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_equipment_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

organization_equipment

One-To-Many Relationship: organization organization_equipment

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

site_equipment

One-To-Many Relationship: site site_equipment

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

TransactionCurrency_Equipment

One-To-Many Relationship: transactioncurrency TransactionCurrency_Equipment

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.

• equipment_accounts
• equipment_activity_parties
• Equipment_Annotation
• Equipment_AsyncOperations
• Equipment_BulkDeleteFailures
• equipment_connections1
• equipment_connections2
• equipment_contacts
• Equipment_DuplicateBaseRecord
• Equipment_DuplicateMatchingRecord
• Equipment_Email_EmailSender
• equipment_MailboxTrackingFolders
• equipment_principalobjectattributeaccess
• Equipment_ProcessSessions
• equipment_resources
• Equipment_SyncErrors

equipment_accounts

Many-To-One Relationship: account equipment_accounts

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

equipment_activity_parties

Many-To-One Relationship: activityparty equipment_activity_parties

Property	Value
ReferencingEntity	activityparty
ReferencingAttribute	partyid
ReferencedEntityNavigationPropertyName	equipment_activity_parties
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Equipment_Annotation

Many-To-One Relationship: annotation Equipment_Annotation

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

Equipment_AsyncOperations

Many-To-One Relationship: asyncoperation Equipment_AsyncOperations

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

Equipment_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Equipment_BulkDeleteFailures

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

equipment_connections1

Many-To-One Relationship: connection equipment_connections1

Property	Value
ReferencingEntity	connection
ReferencingAttribute	record1id
ReferencedEntityNavigationPropertyName	equipment_connections1
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

equipment_connections2

Many-To-One Relationship: connection equipment_connections2

Property	Value
ReferencingEntity	connection
ReferencingAttribute	record2id
ReferencedEntityNavigationPropertyName	equipment_connections2
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

equipment_contacts

Many-To-One Relationship: contact equipment_contacts

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

Equipment_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Equipment_DuplicateBaseRecord

Property	Value
ReferencingEntity	duplicaterecord
ReferencingAttribute	baserecordid
ReferencedEntityNavigationPropertyName	Equipment_DuplicateBaseRecord
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Equipment_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Equipment_DuplicateMatchingRecord

Property	Value
ReferencingEntity	duplicaterecord
ReferencingAttribute	duplicaterecordid
ReferencedEntityNavigationPropertyName	Equipment_DuplicateMatchingRecord
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Equipment_Email_EmailSender

Many-To-One Relationship: email Equipment_Email_EmailSender

Property	Value
ReferencingEntity	email
ReferencingAttribute	emailsender
ReferencedEntityNavigationPropertyName	Equipment_Email_EmailSender
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

equipment_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder equipment_MailboxTrackingFolders

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

equipment_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess equipment_principalobjectattributeaccess

Property	Value
ReferencingEntity	principalobjectattributeaccess
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	equipment_principalobjectattributeaccess
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Equipment_ProcessSessions

Many-To-One Relationship: processsession Equipment_ProcessSessions

Property	Value
ReferencingEntity	processsession
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Equipment_ProcessSessions
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

equipment_resources

Many-To-One Relationship: resource equipment_resources

Property	Value
ReferencingEntity	resource
ReferencingAttribute	resourceid
ReferencedEntityNavigationPropertyName	equipment_resources
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

Equipment_SyncErrors

Many-To-One Relationship: syncerror Equipment_SyncErrors

Property	Value
ReferencingEntity	syncerror
ReferencingAttribute	regardingobjectid
ReferencedEntityNavigationPropertyName	Equipment_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