Table 6412 "FS Bookable Resource Booking"

Base Application · Microsoft.Integration.FieldService · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata
ObsoleteState	Removed
ObsoleteTag	28.0
ObsoleteReason	Field Service is moved to Field Service Integration app.

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 6413 “FS BookableResourceBookingHdr” (“FS BookableResourceBookingHdr”.BookableResourceBookingHeaderId)
39	Resource	GUID	—	TableRelation Table 6410 “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 Δ BC28	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 Δ BC28	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 Δ BC28	Decimal	—
68	Longitude Δ BC28	Decimal	—
69	MilesTraveled Δ BC28	Decimal	Miles Traveled caption
71	ResourceGroup	GUID	Resource Group caption	TableRelation Table 6410 “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 Δ BC28	Decimal	Total Cost caption
96	totalcost_Base Δ BC28	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 6400 “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 6410 “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)))

Keys

PK: BookableResourceBookingId (clustered)
Name: Name

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”
WorkOrderName: CalcFormula Table 6400 “FS Work Order”
WorkOrder: TableRelation Table 6400 “FS Work Order”
CrewName: CalcFormula Table 6410 “FS Bookable Resource”
ResourceGroupName: CalcFormula Table 6410 “FS Bookable Resource”
ResourceName: CalcFormula Table 6410 “FS Bookable Resource”
Crew: TableRelation Table 6410 “FS Bookable Resource”
Resource: TableRelation Table 6410 “FS Bookable Resource”
ResourceGroup: TableRelation Table 6410 “FS Bookable Resource”
HeaderName: CalcFormula Table 6413 “FS BookableResourceBookingHdr”
Header: TableRelation Table 6413 “FS BookableResourceBookingHdr”

Referenced by

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

Table 6402 “FS Work Order Product”: BookingName, Booking
Table 6406 “FS Work Order Service”: BookingName, Booking

Deprecations

object: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). 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.