Bookable Resource Booking (BookableResourceBooking) table/entity reference (Microsoft Dynamics 365 Customer Service)

Represents the line details of a resource booking.

Note

The Microsoft Dynamics 365 Customer Service Bookable Resource Booking (BookableResourceBooking) table extends the Microsoft Dynamics 365 Bookable Resource Booking (BookableResourceBooking) table.

Writable columns/attributes

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

msdyn_AcceptCascadeCrewChanges
msdyn_ActualArrivalTime
msdyn_ActualTravelDuration
msdyn_AllowOverlapping
msdyn_AppointmentBookingId
msdyn_BaseTravelDuration
msdyn_BookingMethod
msdyn_BookingSetupMetadataId
msdyn_CascadeCrewChanges
msdyn_effort
msdyn_EstimatedArrivalTime
msdyn_EstimatedTravelDuration
msdyn_Latitude
msdyn_Longitude
msdyn_MilesTraveled
msdyn_requirementgroupid
msdyn_requirementgroupset
msdyn_ResourceGroup
msdyn_ResourceRequirement
msdyn_serviceappointment
msdyn_TimeGroupDetailSelected
msdyn_TravelTimeCalculationType
msdyn_TzaEndTime
msdyn_TzaStartTime
msdyn_URSInternalFlags
msdyn_WorkLocation

msdyn_AcceptCascadeCrewChanges

Property	Value
Description	Defines whether this booking accepts changes propagated as cascading changes
DisplayName	Accept Cascade Crew Changes
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_acceptcascadecrewchanges`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_bookableresourcebooking_msdyn_acceptcascadecrewchanges`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_ActualArrivalTime

Property	Value
Description	Shows the time that work started.
DisplayName	Actual Arrival Time
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_actualarrivaltime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_ActualTravelDuration

Property	Value
Description	Shows the total travel duration. Calculated based on the difference between the Bookable Resource Booking's start time and actual arrival time.
DisplayName	Actual Travel Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_actualtravelduration`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_AllowOverlapping

Property	Value
Description	Allow the time of this booking to be displayed on the schedule assistant as available.
DisplayName	Allow Overlapping
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_allowoverlapping`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_bookableresourcebooking_msdyn_allowoverlapping`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_AppointmentBookingId

Property	Value
Description	Unique identifier for Appointment associated with Bookable Resource Booking.
DisplayName	Appointment Booking
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_appointmentbookingid`
RequiredLevel	None
Type	Lookup
Targets	appointment

msdyn_BaseTravelDuration

Property	Value
Description	The Base travel duration indicates the travel time without traffic
DisplayName	Base Travel Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_basetravelduration`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_BookingMethod

Property	Value
Description	Shows the method used to create this booking.
DisplayName	Booking Method
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_bookingmethod`
RequiredLevel	None
Type	Picklist
DefaultFormValue	690970003
GlobalChoiceName	`msdyn_resourceschedulesource`

msdyn_BookingMethod Choices/Options

Value	Label
192350000	Optimization
690970001	Schedule Board
690970002	Mobile
690970003	Manual
690970004	Schedule Assistant

msdyn_BookingSetupMetadataId

Property	Value
Description	A unique identifier for the booking setup metadata that is associated with a bookable resource booking.
DisplayName	Booking Setup Metadata
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_bookingsetupmetadataid`
RequiredLevel	None
Type	Lookup
Targets	msdyn_bookingsetupmetadata

msdyn_CascadeCrewChanges

Property	Value
Description	Defines whether changing any of the following fields (Start Time, End Time, Status) should cascade the changes to other bookings on this requirement that have the same start and end time.
DisplayName	Cascade Crew Changes
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_cascadecrewchanges`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_bookableresourcebooking_msdyn_cascadecrewchanges`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_effort

Property	Value
Description	Capacity that needs to take from resource capacity
DisplayName	Capacity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_effort`
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0.0001
Precision	4
SourceTypeMask	0

msdyn_EstimatedArrivalTime

Property	Value
Description	Estimated Arrival Time
DisplayName	Estimated Arrival Time
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatedarrivaltime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

msdyn_EstimatedTravelDuration

Property	Value
Description	Estimated Travel Duration
DisplayName	Estimated Travel Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatedtravelduration`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_Latitude

Property	Value
Description
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
DisplayName	Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_longitude`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	180
MinValue	-180
Precision	5

msdyn_MilesTraveled

Property	Value
Description	In this field you can enter the total miles the resource drove to the job site
DisplayName	Miles Traveled
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_milestraveled`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	1000000000
MinValue	0
Precision	2

msdyn_requirementgroupid

Property	Value
Description	Requirement Group
DisplayName	Requirement Group
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_requirementgroupid`
RequiredLevel	None
Type	Lookup
Targets	msdyn_requirementgroup

msdyn_requirementgroupset

Property	Value
Description	Requirement Group Set
DisplayName	Requirement Group Set
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_requirementgroupset`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	40

msdyn_ResourceGroup

Property	Value
Description	Unique identifier for Resource associated with Resource Booking
DisplayName	Resource Group
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_resourcegroup`
RequiredLevel	None
Type	Lookup
Targets	bookableresource

msdyn_ResourceRequirement

Property	Value
Description	Resource Requirement
DisplayName	Resource Requirement
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_resourcerequirement`
RequiredLevel	None
Type	Lookup
Targets	msdyn_resourcerequirement

msdyn_serviceappointment

Property	Value
Description	Unique identifier for Service Appointment associated with Resource Booking.
DisplayName	Service Activity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_serviceappointment`
RequiredLevel	None
Type	Lookup
Targets	serviceappointment

msdyn_TimeGroupDetailSelected

Property	Value
Description
DisplayName	Time Group Detail Selected
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_timegroupdetailselected`
RequiredLevel	None
Type	Lookup
Targets	msdyn_timegroupdetail

msdyn_TravelTimeCalculationType

Property	Value
Description	Travel Time Calculation
DisplayName	Travel Time Calculation
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_traveltimecalculationtype`
RequiredLevel	None
Type	Picklist
DefaultFormValue	192350000
GlobalChoiceName	`msdyn_traveltimetype`

msdyn_TravelTimeCalculationType Choices/Options

Value	Label
192350000	Bing Maps without historical traffic
192350001	Bing Maps with historical traffic
192350002	Custom Map Provider
192350003	Approximate

msdyn_TzaEndTime

Property	Value
Description	End date and time of the booking in time zone independent format
DisplayName	End Date Time Zone Independent
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_tzaendtime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	TimeZoneIndependent
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

msdyn_TzaStartTime

Property	Value
Description	Start date and time of the booking in time zone independent format
DisplayName	Start Date Time Zone Independent
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_tzastarttime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	TimeZoneIndependent
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

msdyn_URSInternalFlags

Property	Value
Description	For internal use only.
DisplayName	Internal Flags
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_ursinternalflags`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1048576

msdyn_WorkLocation

Property	Value
Description
DisplayName	Work Location
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_worklocation`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_worklocation`

msdyn_WorkLocation Choices/Options

Value	Label
690970000	Onsite
690970001	Facility
690970002	Location Agnostic

Many-to-One relationships

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

msdyn_appointment_bookableresourcebooking
msdyn_bookableresource_bookableresourcebooking_ResourceGroup
msdyn_msdyn_bookingsetupmetadata_bookableresourcebooking
msdyn_msdyn_timegroupdetail_bookableresourcebooking_TimeGroupDetailSelected
msdyn_requirementgroup_bookableresourcebooking_requirementgroupid
msdyn_resourcerequirement_bookableresourcebooking_ResourceRequirement
msdyn_serviceappointment_bookableresourcebooking_serviceappointment

msdyn_appointment_bookableresourcebooking

One-To-Many Relationship: appointment msdyn_appointment_bookableresourcebooking

Property	Value
ReferencedEntity	`appointment`
ReferencedAttribute	`activityid`
ReferencingAttribute	`msdyn_appointmentbookingid`
ReferencingEntityNavigationPropertyName	`msdyn_AppointmentBookingId`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_bookableresource_bookableresourcebooking_ResourceGroup

One-To-Many Relationship: bookableresource msdyn_bookableresource_bookableresourcebooking_ResourceGroup

Property	Value
ReferencedEntity	`bookableresource`
ReferencedAttribute	`bookableresourceid`
ReferencingAttribute	`msdyn_resourcegroup`
ReferencingEntityNavigationPropertyName	`msdyn_resourcegroup`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_bookingsetupmetadata_bookableresourcebooking

One-To-Many Relationship: msdyn_bookingsetupmetadata msdyn_msdyn_bookingsetupmetadata_bookableresourcebooking

Property	Value
ReferencedEntity	`msdyn_bookingsetupmetadata`
ReferencedAttribute	`msdyn_bookingsetupmetadataid`
ReferencingAttribute	`msdyn_bookingsetupmetadataid`
ReferencingEntityNavigationPropertyName	`msdyn_BookingSetupMetadataId`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_timegroupdetail_bookableresourcebooking_TimeGroupDetailSelected

One-To-Many Relationship: msdyn_timegroupdetail msdyn_msdyn_timegroupdetail_bookableresourcebooking_TimeGroupDetailSelected

Property	Value
ReferencedEntity	`msdyn_timegroupdetail`
ReferencedAttribute	`msdyn_timegroupdetailid`
ReferencingAttribute	`msdyn_timegroupdetailselected`
ReferencingEntityNavigationPropertyName	`msdyn_timegroupdetailselected`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_requirementgroup_bookableresourcebooking_requirementgroupid

One-To-Many Relationship: msdyn_requirementgroup msdyn_requirementgroup_bookableresourcebooking_requirementgroupid

Property	Value
ReferencedEntity	`msdyn_requirementgroup`
ReferencedAttribute	`msdyn_requirementgroupid`
ReferencingAttribute	`msdyn_requirementgroupid`
ReferencingEntityNavigationPropertyName	`msdyn_requirementgroupid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_resourcerequirement_bookableresourcebooking_ResourceRequirement

One-To-Many Relationship: msdyn_resourcerequirement msdyn_resourcerequirement_bookableresourcebooking_ResourceRequirement

Property	Value
ReferencedEntity	`msdyn_resourcerequirement`
ReferencedAttribute	`msdyn_resourcerequirementid`
ReferencingAttribute	`msdyn_resourcerequirement`
ReferencingEntityNavigationPropertyName	`msdyn_ResourceRequirement`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_serviceappointment_bookableresourcebooking_serviceappointment

One-To-Many Relationship: serviceappointment msdyn_serviceappointment_bookableresourcebooking_serviceappointment

Property	Value
ReferencedEntity	`serviceappointment`
ReferencedAttribute	`activityid`
ReferencingAttribute	`msdyn_serviceappointment`
ReferencingEntityNavigationPropertyName	`msdyn_serviceappointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

bookableresourcebooking_msdyn_bookingalerts
bookableresourcebooking_msdyn_ocoutboundmessages
bookableresourcebooking_msdyn_ocvoicemails

bookableresourcebooking_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert bookableresourcebooking_msdyn_bookingalerts

Property	Value
ReferencingEntity	`msdyn_bookingalert`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`bookableresourcebooking_msdyn_bookingalerts`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `7f15e2bb-305a-468f-9af7-be865755a984`

bookableresourcebooking_msdyn_ocoutboundmessages

Many-To-One Relationship: msdyn_ocoutboundmessage bookableresourcebooking_msdyn_ocoutboundmessages

Property	Value
ReferencingEntity	`msdyn_ocoutboundmessage`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`bookableresourcebooking_msdyn_ocoutboundmessages`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `7f15e2bb-305a-468f-9af7-be865755a984`

bookableresourcebooking_msdyn_ocvoicemails

Many-To-One Relationship: msdyn_ocvoicemail bookableresourcebooking_msdyn_ocvoicemails

Property	Value
ReferencingEntity	`msdyn_ocvoicemail`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`bookableresourcebooking_msdyn_ocvoicemails`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `7f15e2bb-305a-468f-9af7-be865755a984`

Feedback

Was this page helpful?

Last updated on 2025-08-29