Table 5368 "CRM NAV Connection"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM NAV Connection
TableType	CRM
DataClassification	CustomerContent

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	NAVConnectionId	Guid	Business Central Connection 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)
8	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
9	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
10	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
11	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
12	OrganizationId	Guid	Organization Id caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
13	OrganizationIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId)))
14	statecode	Option	Status caption	OptionCaption: ,Active,Inactive
15	statuscode	Option	Status Reason caption	OptionCaption: ,Active,Inactive
16	VersionNumber	BigInteger	—
17	ImportSequenceNumber	Integer	Import Sequence Number caption
18	OverriddenCreatedOn	Date	Record Created On caption
19	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
20	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
21	Name	Text[100]	—
22	Dynamics NAV URL	Text[250]	Business Central URL caption
23	Dynamics NAV OData URL	Text[250]	Business Central OData URL caption
24	Dynamics NAV OData Username	Text[250]	—
25	Dynamics NAV OData Accesskey	Text[250]	—

Keys

Key1: NAVConnectionId (clustered)
Key2: Name

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
OrganizationId: TableRelation Table 5363 “CRM Organization”

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