Table 6611 "FS Bookable Resource Booking"

FieldServiceIntegration · Microsoft.Integration.DynamicsFieldService · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	BookableResourceBookingId	GUID	Bookable Resource Booking caption
2	CreatedOn	Datetime	Created On caption
3	CreatedBy	GUID	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ModifiedOn	Datetime	Modified On caption
5	ModifiedBy	GUID	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	CreatedOnBehalfBy	GUID	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ModifiedOnBehalfBy	GUID	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
15	OwnerId	GUID	Owner caption
20	OwningBusinessUnit	GUID	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
21	OwningUser	GUID	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
22	OwningTeam	GUID	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
24	VersionNumber	BigInteger	Version Number caption
25	ImportSequenceNumber	Integer	Import Sequence Number caption
26	OverriddenCreatedOn	Date	Record Created On caption
27	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
28	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
29	Name	Text[100]	—
30	ProcessId	GUID	Process Id caption
31	StageId	GUID	(Deprecated) Stage Id caption
32	TraversedPath	Text[1250]	(Deprecated) Traversed Path caption
34	BookingType	Option	Booking Type caption
36	Duration	Integer	—
37	EndTime	Datetime	End Time caption
38	Header	GUID	—	TableRelation Table 6612 “FS BookableResourceBookingHdr” (“FS BookableResourceBookingHdr”.BookableResourceBookingHeaderId)
39	Resource	GUID	—	TableRelation Table 6610 “FS Bookable Resource” (“FS Bookable Resource”.BookableResourceId)
40	StartTime	Datetime	Start Time caption
41	StateCode	Option	Status caption
43	StatusCode	Option	Status Reason caption
45	ExchangeRate	Decimal	—
46	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
47	ResourceName	Text[100]	—	FlowField: lookup(“FS Bookable Resource”.Name where(BookableResourceId = field(Resource)))
48	HeaderName	Text[100]	—	FlowField: lookup(“FS BookableResourceBookingHdr”.Name where(BookableResourceBookingHeaderId = field(Header)))
51	ActualArrivalTime	Datetime	Actual Arrival Time caption
52	ActualTravelDuration	Integer	Actual Travel Duration caption
53	AllowOverlapping	Boolean	Allow Overlapping caption
56	BookingMethod	Option	Booking Method caption
59	CascadeCrewChanges	Boolean	Cascade Crew Changes caption
61	AcceptCascadeCrewChanges	Boolean	Accept Cascade Crew Changes caption
63	effort	Decimal	Capacity caption
64	EstimatedArrivalTime	Datetime	Estimated Arrival Time caption
65	EstimatedTravelDuration	Integer	Estimated Travel Duration caption
66	URSInternalFlags	BLOB	Internal Flags caption
67	Latitude	Decimal	—
68	Longitude	Decimal	—
69	MilesTraveled	Decimal	Miles Traveled caption
71	ResourceGroup	GUID	Resource Group caption	TableRelation Table 6610 “FS Bookable Resource” (“FS Bookable Resource”.BookableResourceId)
74	WorkLocation	Option	Work Location caption
78	ResourceGroupName	Text[100]	—	FlowField: lookup(“FS Bookable Resource”.Name where(BookableResourceId = field(ResourceGroup)))
82	BaseTravelDuration	Integer	Base Travel Duration caption
83	requirementgroupset	Text[40]	Requirement Group Set caption
84	TravelTimeCalculationType	Option	Travel Time Calculation caption
87	InternalFlags	BLOB	Internal Flags caption
88	OfflineTimestamp	Datetime	Offline Timestamp caption
89	PreventTimestampCreation	Boolean	Prevent Timestamp Creation caption
91	Signature	BLOB	—
92	SlotText	BLOB	Slot Text caption
93	TotalBillableDuration	Integer	Total Billable Duration caption
94	TotalBreakDuration	Integer	Total Break Duration caption
95	TotalCost	Decimal	Total Cost caption
96	totalcost_Base	Decimal	Total Cost (Base) caption
97	TotalDurationInProgress	Integer	Total Duration In Progress caption
98	TravelTimeRescheduling	Boolean	Travel Time Rescheduling (Deprecated) caption
100	WorkOrder	GUID	Work Order caption	TableRelation Table 6617 “FS Work Order” (“FS Work Order”.WorkOrderId)
102	WorkOrderName	Text[100]	—	FlowField: lookup(“FS Work Order”.Name where(WorkOrderId = field(WorkOrder)))
103	Crew	GUID	—	TableRelation Table 6610 “FS Bookable Resource” (“FS Bookable Resource”.BookableResourceId)
104	CrewMemberType	Option	Crew Member Type caption
106	QuickNoteAction	Option	Quick note actions caption
108	CrewName	Text[100]	—	FlowField: lookup(“FS Bookable Resource”.Name where(BookableResourceId = field(Crew)))
110	BookingStatus	Guid	Booking Status caption	TableRelation Table 6627 “FS Booking Status” (“FS Booking Status”.BookingStatusId)
120	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
121	IntegrateToService	Boolean	Integrate to Service caption

Keys

PK: BookableResourceBookingId (clustered)
Name: Name

Procedures

2 local procedures, no public ones.

Relations

CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwningUser: TableRelation Table 5340 “CRM Systemuser”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”
CrewName: CalcFormula Table 6610 “FS Bookable Resource”
ResourceGroupName: CalcFormula Table 6610 “FS Bookable Resource”
ResourceName: CalcFormula Table 6610 “FS Bookable Resource”
Crew: TableRelation Table 6610 “FS Bookable Resource”
Resource: TableRelation Table 6610 “FS Bookable Resource”
ResourceGroup: TableRelation Table 6610 “FS Bookable Resource”
HeaderName: CalcFormula Table 6612 “FS BookableResourceBookingHdr”
Header: TableRelation Table 6612 “FS BookableResourceBookingHdr”
WorkOrderName: CalcFormula Table 6617 “FS Work Order”
WorkOrder: TableRelation Table 6617 “FS Work Order”
BookingStatus: TableRelation Table 6627 “FS Booking Status”

Referenced by

4 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 6619 “FS Work Order Product”: BookingName, Booking
Table 6620 “FS Work Order Service”: BookingName, Booking

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 5342 “CRM Synch. Helper” (2 calls: GetBaseCurrencyCode → GetNavCurrencyCode, GetCurrencyCode → GetNavCurrencyCode)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "FS Bookable Resource Booking"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.