Table 6410 "FS Bookable Resource"

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	BookableResourceId	GUID	Bookable Resource 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
33	AccountId	GUID	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
35	ContactId	GUID	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
36	ResourceType	Option	Resource Type caption
38	StateCode	Option	Status caption
40	StatusCode	Option	Status Reason caption
42	TimeZone	Integer	Time Zone caption
43	UserId	GUID	User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
44	ExchangeRate Δ BC28	Decimal	—
45	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
56	DeriveCapacity	Boolean	Derive Capacity From Group Members caption
58	DisplayOnScheduleAssistant	Boolean	Enable for Availability Search caption
60	DisplayOnScheduleBoard	Boolean	Display On Schedule Board caption
62	EndLocation	Option	End Location caption
64	GenericType	Option	Generic Type (Deprecated) caption
67	PrimaryEMail	Text[100]	Primary Email caption
68	StartLocation	Option	Start Location caption
70	TargetUtilization	Integer	Target Utilization caption
72	EnableAppointments	Option	Include Appointments caption
74	EnableOutlookSchedules	Option	Include Outlook Free/Busy in Search Resource Availability API caption
76	BookingsToDrip	Integer	Bookings To Drip caption
77	EnabledForFieldServiceMobile	Boolean	Enable for Field Service Mobile (legacy Xamarin app) caption
79	EnableDripScheduling	Boolean	Enable Drip Scheduling caption
81	HourlyRate Δ BC28	Decimal	Hourly Rate caption
82	HourlyRate_Base Δ BC28	Decimal	Hourly Rate (Base) caption
83	TimeOffApprovalRequired	Boolean	Time Off Approval Required caption
87	CrewStrategy	Option	Crew Strategy caption
89	InternalFlags	BLOB	Internal Flags caption
90	Latitude Δ BC28	Decimal	—
91	Longitude Δ BC28	Decimal	—
92	LocationTimestamp	Datetime	Location Timestamp caption
93	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

PK: BookableResourceId (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”
UserId: TableRelation Table 5340 “CRM Systemuser”
AccountId: TableRelation Table 5341 “CRM Account”
ContactId: TableRelation Table 5342 “CRM Contact”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

12 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 6412 “FS Bookable Resource Booking”: CrewName, ResourceGroupName, ResourceName, Crew, Resource, ResourceGroup
Table 6400 “FS Work Order”: PreferredResourceName, SupportContactName, PreferredResource, SupportContact
Table 6413 “FS BookableResourceBookingHdr”: BookableResourceIdName, BookableResourceId

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"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.