Functional Location (msdyn_FunctionalLocation) table/entity reference (Microsoft Dynamics 365 Field Service)

Article
2025-02-08

Note

The Microsoft Dynamics 365 Field Service Functional Location (msdyn_FunctionalLocation) table extends the Microsoft Dynamics 365 Functional Location (msdyn_FunctionalLocation) table.

Writable columns/attributes

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

msdyn_Address1
msdyn_Address2
msdyn_Address3
msdyn_AddressName
msdyn_City
msdyn_Country
msdyn_Latitude
msdyn_Longitude
msdyn_PostalCode
msdyn_StateOrProvince

msdyn_Address1

Property	Value
Description
DisplayName	Street 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_Address2

Property	Value
Description	Street 2
DisplayName	Street 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_Address3

Property	Value
Description	Street 3
DisplayName	Street 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_AddressName

Property	Value
Description	Address Name
DisplayName	Address Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_addressname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_City

Property	Value
Description	City
DisplayName	City
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_city`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

msdyn_Country

Property	Value
Description	Country/Region
DisplayName	Country/Region
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_country`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

msdyn_Latitude

Property	Value
Description	Latitude
DisplayName	Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_latitude`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	90
MinValue	-90
Precision	5

msdyn_Longitude

Property	Value
Description	Longitude
DisplayName	Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_longitude`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	180
MinValue	-180
Precision	5

msdyn_PostalCode

Property	Value
Description	Postal Code
DisplayName	Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_postalcode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	20

msdyn_StateOrProvince

Property	Value
Description	State Or Province
DisplayName	State Or Province
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_stateorprovince`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Customized columns/attributes

Microsoft Dynamics 365 Field Service modifies the definition of columns/attributes defined in other solutions. Listed by SchemaName.

msdyn_Name

Changes from msdyn_Name (Microsoft Dynamics 365)

Property	Value
RequiredLevel	ApplicationRequired

One-to-Many relationships

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

msdyn_functionallocation_msdyn_nottoexceed_location
msdyn_msdyn_functionallocation_incident_FunctionalLocation
msdyn_msdyn_functionallocation_msdyn_agreementbookingincident_FunctionalLocation
msdyn_msdyn_functionallocation_msdyn_tradecoverage_FunctionalLocation
msdyn_msdyn_functionallocation_msdyn_workorder_FunctionalLocation
msdyn_msdyn_functionallocation_msdyn_workorderincident_FunctionalLocation

msdyn_functionallocation_msdyn_nottoexceed_location

Many-To-One Relationship: msdyn_nottoexceed msdyn_functionallocation_msdyn_nottoexceed_location

Property	Value
ReferencingEntity	`msdyn_nottoexceed`
ReferencingAttribute	`msdyn_location`
ReferencedEntityNavigationPropertyName	`msdyn_functionallocation_msdyn_nottoexceed_location`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_functionallocation_incident_FunctionalLocation

Many-To-One Relationship: incident msdyn_msdyn_functionallocation_incident_FunctionalLocation

Property	Value
ReferencingEntity	`incident`
ReferencingAttribute	`msdyn_functionallocation`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_functionallocation_incident_FunctionalLocation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_functionallocation_msdyn_agreementbookingincident_FunctionalLocation

Many-To-One Relationship: msdyn_agreementbookingincident msdyn_msdyn_functionallocation_msdyn_agreementbookingincident_FunctionalLocation

Property	Value
ReferencingEntity	`msdyn_agreementbookingincident`
ReferencingAttribute	`msdyn_functionallocation`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_functionallocation_msdyn_agreementbookingincident_FunctionalLocation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_functionallocation_msdyn_tradecoverage_FunctionalLocation

Many-To-One Relationship: msdyn_tradecoverage msdyn_msdyn_functionallocation_msdyn_tradecoverage_FunctionalLocation

Property	Value
ReferencingEntity	`msdyn_tradecoverage`
ReferencingAttribute	`msdyn_functionallocation`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_functionallocation_msdyn_tradecoverage_FunctionalLocation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_functionallocation_msdyn_workorder_FunctionalLocation

Many-To-One Relationship: msdyn_workorder msdyn_msdyn_functionallocation_msdyn_workorder_FunctionalLocation

Property	Value
ReferencingEntity	`msdyn_workorder`
ReferencingAttribute	`msdyn_functionallocation`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_functionallocation_msdyn_workorder_FunctionalLocation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_functionallocation_msdyn_workorderincident_FunctionalLocation

Many-To-One Relationship: msdyn_workorderincident msdyn_msdyn_functionallocation_msdyn_workorderincident_FunctionalLocation

Property	Value
ReferencingEntity	`msdyn_workorderincident`
ReferencingAttribute	`msdyn_functionallocation`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_functionallocation_msdyn_workorderincident_FunctionalLocation`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Customized relationships

Customized Many-to-One relationships

msdyn_FunctionalLocation_FunctionalLocationTyp

Changes from msdyn_FunctionalLocation_FunctionalLocationTyp (Microsoft Dynamics 365)

Property	Value
CascadeConfiguration	Delete: `Restrict`

Share via