Table 6623 "FS Connection Setup"

FieldServiceIntegration · Microsoft.Integration.DynamicsFieldService · captioned “Dynamics 365 Field Service Integration Setup” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Dynamics 365 Field Service Integration Setup
DataClassification	CustomerContent
Permissions	tabledata “FS Connection Setup” = r

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	Primary Key	Code[20]	—	DataClassification SystemMetadata
2	Server Address	Text[250]	Specifies the URL of the environment that hosts the Dynamics 365 Field Service solution that you want to connect to. via Page 6612 “FS Connection Setup”	DataClassification OrganizationIdentifiableInformation
3	User Name	Text[250]	Specifies the user name of a Dynamics 365 Field Service account. via Page 6613 “FS Connection Setup Wizard”	DataClassification EndUserIdentifiableInformation
4	User Password Key	Guid	—	DataClassification EndUserPseudonymousIdentifiers
59	Restore Connection	Boolean	—	DataClassification SystemMetadata
60	Is Enabled	Boolean	Specifies if the connection to Dynamics 365 Field Service is enabled. When you check this checkbox, you will be prompted to sign-in to Dataverse with an administrator user account. The account will be used one time to give consent to, install and configure applications and components that the integr… via Page 6612 “FS Connection Setup”	DataClassification SystemMetadata
63	FS Version	Text[30]	Field Service Version caption	DataClassification SystemMetadata
67	Is FS Solution Installed	Boolean	Specifies if the Integration Solution is installed and configured in Dynamics 365 Field Service. You cannot change this setting. via Page 6612 “FS Connection Setup”	DataClassification SystemMetadata
69	Enable Invt. Availability	Boolean	Specifies if the Field Service users will be able to pull information about inventory availability by location from Business Central. This is available only if Virtual Table app is installed. via Page 6612 “FS Connection Setup”	DataClassification SystemMetadata
76	Proxy Version	Integer	Specifies the Microsoft Dynamics 365 (CRM) software development kit version that is used to connect to Dynamics 365 Field Service. via Page 6613 “FS Connection Setup Wizard”	DataClassification SystemMetadata
118	CurrencyDecimalPrecision	Integer	Currency Decimal Precision caption	DataClassification SystemMetadata
124	BaseCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId); DataClassification SystemMetadata
133	BaseCurrencyPrecision	Integer	Base Currency Precision caption	DataClassification SystemMetadata
134	BaseCurrencySymbol	Text[5]	Base Currency Symbol caption	DataClassification SystemMetadata
135	Authentication Type	Option	—	OptionCaption: OAuth 2.0,AD,IFD,OAuth; DataClassification SystemMetadata
136	Connection String	Text[250]	—	DataClassification OrganizationIdentifiableInformation
137	Domain	Text[250]	—	not editable; DataClassification OrganizationIdentifiableInformation
138	Server Connection String	BLOB	—	DataClassification OrganizationIdentifiableInformation
139	Disable Reason	Text[250]	—	DataClassification SystemMetadata
200	Job Journal Template	Code[10]	Specifies the project journal template in which project journal lines will be created and coupled to work order products and work order services. via Page 6612 “FS Connection Setup”	TableRelation Table 209 “Job Journal Template” (Job Journal Template); DataClassification SystemMetadata
201	Job Journal Batch	Code[10]	Specifies the project journal batch in which project journal lines will be created and coupled to work order products and work order services. via Page 6612 “FS Connection Setup”	TableRelation Table 237 “Job Journal Batch” (“Job Journal Batch”.Name where(“Journal Template Name” = field(“Job Journal Template”))); DataClassification SystemMetadata
202	Hour Unit of Measure	Code[10]	Specifies the unit of measure that corresponds to the ‘hour’ unit that is used on Dynamics 365 Field Service bookable resources. via Page 6612 “FS Connection Setup”	TableRelation Table 204 “Unit of Measure” (Unit of Measure); DataClassification SystemMetadata
203	Line Synch. Rule	Enum “FS Work Order Line Synch. Rule”	Specifies when to synchronize work order products and work order services. via Page 6612 “FS Connection Setup”	enum Enum 6611 “FS Work Order Line Synch. Rule”; DataClassification SystemMetadata
204	Line Post Rule	Enum “FS Work Order Line Post Rule”	Specifies when to post project journal lines that are coupled to work order products and work order services. via Page 6612 “FS Connection Setup”	enum Enum 6610 “FS Work Order Line Post Rule”; DataClassification SystemMetadata
300	Integration Type	Enum “FS Integration Type”	Specifies the type of integration between Business Central and Dynamics 365 Field Service. via Page 6612 “FS Connection Setup”	enum Enum 6612 “FS Integration Type”; DataClassification SystemMetadata
301	Default Work Order Incident ID	Guid	—	DataClassification SystemMetadata

Keys

Key1: Primary Key (clustered)

Events published

OnGetDefaultFSConnection(var ConnectionName: Text) (integration)

Procedures

EnsureCDSConnectionIsEnabled() (internal)
EnsureCRMConnectionIsEnabled() (internal)
LoadConnectionStringElementsFromCDSConnectionSetup() (internal)
DeployFSSolution(ForceRedeploy: Boolean) (internal)
CountCRMJobQueueEntries(var ActiveJobs: Integer; var TotalJobs: Integer) (internal)
SetPassword(PasswordText: SecretText) (internal)
DeletePassword() (internal)
RegisterConnection() (internal)
RegisterConnectionWithName(ConnectionName: Text) (internal)
UnregisterConnection(): Boolean (internal)
UnregisterConnectionWithName(ConnectionName: Text) (internal)
GetConnectionStringWithCredentials(): SecretText (internal)
GetPassword(): SecretText (internal)
GetJobQueueEntriesObjectIDToRunFilter(): Text (internal)
PerformTestConnection() (internal)
VerifyTestConnection(): Boolean (internal)
TestConnection(): Boolean (internal)
TestIntegrationUserRequirements() (internal)
TryReadSystemUsers() (internal)
UpdateFromWizard(var SourceFSConnectionSetup: Record "FS Connection Setup"; PasswordText: SecretText) (internal)
EnableFSConnectionFromWizard() (internal)
RefreshDataFromFS() (internal)
RefreshDataFromFS(ResetSalesOrderMappingConfiguration: Boolean) (internal)
PromptForCredentials(var AdminEmail: Text; var AdminPassword: SecretText): Boolean (internal)
PromptForCredentials(var AdminEmail: Text; var AdminPassword: SecretText; var AdminADDomain: Text): Boolean (internal)
UpdateConnectionString(): Text (internal)
GetConnectionStringAsStoredInSetup(): Text (internal)
SetConnectionString(ConnectionString: Text) (internal)
IsEnabled(): Boolean (internal)
IsIntegrationTypeServiceEnabled(): Boolean (internal)
IsIntegrationTypeProjectEnabled(): Boolean (internal)
GetProxyVersion(): Integer (internal)
IsVirtualTablesAppInstalled(): Boolean (internal)
GetEntityLogicalName(): Text (internal)
SetupVirtualTables(VirtualTableAppInstalled: Boolean) (internal)
InitializeDefaultTemplateAndBatch()

Plus 16 local procedures.

Triggers

OnModify, OnDelete

Relations

Hour Unit of Measure: TableRelation Table 204 “Unit of Measure”
Job Journal Template: TableRelation Table 209 “Job Journal Template”
Job Journal Batch: TableRelation Table 237 “Job Journal Batch”
BaseCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”

Pages and codeunits on this table

Page 6612 “FS Connection Setup” (source table)
Page 6613 “FS Connection Setup Wizard” (source table)

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 7201 “CDS Integration Impl.” (13 calls: DeployFSSolution → GetAccessToken, GetConnectionStringWithCredentials → GetCDSConnectionClientId, GetConnectionStringWithCredentials → GetCDSConnectionClientSecret, …)
Codeunit 6615 “FS Integration Mgt.” (4 calls: DeployFSSolution → ImportFSSolution, DeployFSSolution → IsFSSolutionInstalled, InstallIntegrationSolution → ImportFSSolution, …)
Codeunit 1293 “Isolated Storage Management” (3 calls: DeletePassword → Delete, GetPassword → Get, SetPassword → Set)
Codeunit 5344 “CRM Product Name” (3 calls: CDSConnectionNotEnabledError → FSServiceName, CRMConnectionNotEnabledError → FSServiceName, VerifyTestConnection → FSServiceName)
Codeunit 5330 “CRM Integration Management” (2 calls: VerifyTestConnection → ClearState, VerifyTestConnection → GetLastErrorMessage)
Codeunit 457 “Environment Information” (1 call: GetProxyVersion → IsSaaS)
Codeunit 6611 “FS Setup Defaults” (1 call: EnableIntegrationTables → ResetConfiguration)
Page 1313 “Dynamics CRM Admin Credentials” (1 call: PromptForCredentials → (object))

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