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

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

See also

Dataverse table/entity reference
Dataverse Web API Reference