Table 5331 "CRM Integration Record"

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

Properties

Property	Value
Caption	CRM Integration Record
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
2	CRM ID	Guid	—
3	Integration ID	Guid	—
4	Last Synch. Modified On	DateTime	—
5	Last Synch. CRM Modified On	DateTime	—
6	Table ID	Integer	—	not editable
7	Last Synch. Result Δ BC25	Option	—	OptionCaption: ,Success,Failure
8	Last Synch. CRM Result Δ BC25	Option	—	OptionCaption: ,Success,Failure
9	Last Synch. Job ID	Guid	—
10	Last Synch. CRM Job ID	Guid	—
11	Skipped	Boolean	—	not editable
13	Statistics Uploaded	Boolean	—
14	Archived Sales Order	Boolean	—	not editable
15	Archived Sales Order Updated	Boolean	—	not editable

Keys

Key1: CRM ID, Integration ID (clustered)
Key2: Integration ID
Key3: Last Synch. Modified On, Integration ID
Key4: Last Synch. CRM Modified On, CRM ID
Key5: Skipped, Table ID
Key6: Table ID
Key7: Statistics Uploaded, Skipped, Table ID
Key8: Integration ID, Statistics Uploaded, Skipped, Table ID

Events published

OnBeforeIsModifiedAfterLastSynchronizedCRMRecord(CRMID: Guid; DestinationTableID: Integer; CurrentModifiedOn: DateTime; var IsModified: Boolean; var Handled: Boolean) (integration)
OnBeforeIsModifiedAfterLastSynchronizedRecord(RecordID: RecordID; CurrentModifiedOn: DateTime; var IsModified: Boolean; var Handled: Boolean) (integration)

Procedures

GetTableID(): Integer
RepairTableIdByLocalRecord(): Boolean (internal)
RepairTableIdByCRMRecord(): Boolean (internal)
GetCRMRecordID(IntegrationTableID: Integer; var CRMRecID: RecordID): Boolean
GetCRMRecordRef(IntegrationTableID: Integer; var RecRef: RecordRef): Boolean
GetLatestJobIDFilter(): Text
GetLatestError(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"): Boolean
InsertRecord(CRMID: Guid; SysId: Guid; TableId: Integer)
IsCRMRecordRefCoupled(CRMRecordRef: RecordRef): Boolean
IsIntegrationIdCoupled(IntegrationID: Guid; TableId: Integer): Boolean − BC25
IsRecordCoupled(DestinationRecordID: RecordID): Boolean
FindByCRMID(CRMID: Guid): Boolean
FindValidByCRMID(CRMID: Guid): Boolean
FindRecordId(var RecId: RecordId): Boolean
FindSystemIdByRecordId(var SysId: Guid; RecId: RecordId): Boolean
FindSystemIdByRecordRef(var SysId: Guid; RecordRef: RecordRef): Boolean
FindByRecordID(RecID: RecordID): Boolean
FindValidByRecordID(RecID: RecordID; IntegrationTableID: Integer): Boolean
FindRecordIDFromID(SourceCRMID: Guid; DestinationTableID: Integer; var DestinationRecordId: RecordID): Boolean
FindIDFromRecordID(SourceRecordID: RecordID; var DestinationCRMID: Guid): Boolean
FindIDFromRecordRef(SourceRecordRef: RecordRef; var DestinationCRMID: Guid): Boolean
CoupleCRMIDToRecordID(CRMID: Guid; RecordID: RecordID)
CoupleCRMIDToRecordRef(CRMID: Guid; RecordRef: RecordRef)
CoupleRecordIdToCRMID(RecordID: RecordID; CRMID: Guid)
RemoveCouplingToRecord(RecordID: RecordID): Boolean
RemoveCouplingToRecord(RecordRef: RecordRef): Boolean
RemoveCouplingToCRMID(CRMID: Guid; DestinationTableID: Integer): Boolean
SetNewCRMId(CRMId: Guid)
SetNewIntegrationId(IntegrationId: Guid)
AssertRecordIDCanBeCoupled(RecordID: RecordID; CRMID: Guid)
SetLastSynchResultFailed(SourceRecRef: RecordRef; DirectionToIntTable: Boolean; JobId: Guid)
SetLastSynchResultFailed(SourceRecRef: RecordRef; DirectionToIntTable: Boolean; JobId: Guid; var MarkedAsSkipped: Boolean)
IsSkipped(SourceRecordRef: RecordRef; DirectionToIntTable: Boolean): Boolean
SetLastSynchModifiedOns(SourceCRMID: Guid; DestinationTableID: Integer; CRMLastModifiedOn: DateTime; LastModifiedOn: DateTime; JobId: Guid; Direction: Option)
SetLastSynchCRMModifiedOn(CRMID: Guid; DestinationTableID: Integer; CRMLastModifiedOn: DateTime)
IsSameFailureRepeatedTwice(RecRef: RecordRef; LastJobID: Guid; NewJobID: Guid): Boolean
IsModifiedAfterLastSynchonizedCRMRecord(CRMID: Guid; DestinationTableID: Integer; CurrentModifiedOn: DateTime): Boolean
IsModifiedAfterLastSynchronizedRecord(RecordID: RecordID; CurrentModifiedOn: DateTime): Boolean
IsModifiedAfterLastSynchronizedRecord(RecordRef: RecordRef; CurrentModifiedOn: DateTime): Boolean
DeleteIfRecordDeleted(CRMID: Guid; DestinationTableID: Integer): Boolean

Plus 11 local procedures.

Triggers

OnInsert, OnDelete

Referenced by

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

Table 1001 “Job Task”: Coupled to Dataverse
Table 112 “Sales Invoice Header”: Coupled to Dataverse
Table 13 “Salesperson/Purchaser”: Coupled to Dataverse
Table 1313 “Activities Cue”: Coupled Data Synch Errors
Table 156 “Resource”: Coupled to Dataverse
Table 18 “Customer”: Coupled to Dataverse
Table 204 “Unit of Measure”: Coupled to Dataverse
Table 205 “Resource Unit of Measure”: Coupled to Dataverse
Table 23 “Vendor”: Coupled to Dataverse
Table 27 “Item”: Coupled to Dataverse
Table 36 “Sales Header”: Coupled to Dataverse
Table 4 “Currency”: Coupled to Dataverse
Table 5050 “Contact”: Coupled to Dataverse
Table 5092 “Opportunity”: Coupled to Dataverse
Table 5335 “Integration Table Mapping”: No. of Skipped
Table 5358 “CDS Failed Option Mapping”: CRM Integration Record Id
Table 5400 “Unit Group”: Coupled to Dataverse
Table 5404 “Item Unit of Measure”: Coupled to Dataverse
Table 5940 “Service Item”: Coupled to Dataverse
Table 6 “Customer Price Group”: Coupled to Dataverse
Table 6229 “Sust. ESG Reporting Name”: Coupled to Dataverse
Table 6230 “Sust. ESG Reporting Line”: Coupled to Dataverse
Table 6232 “Sust. Posted ESG Report Line”: Coupled to Dataverse
Table 6252 “Sust. ESG Reporting Unit”: Coupled to Dataverse
Table 6253 “Sust. ESG Standard”: Coupled to Dataverse
Table 6255 “Sust. ESG Range Period”: Coupled to Dataverse
Table 6256 “Sust. ESG Standard Requirement”: Coupled to Dataverse
Table 6257 “Sust. ESG Concept”: Coupled to Dataverse
Table 6258 “Sust. ESG Requirement Concept”: Coupled to Dataverse
Table 7002 “Sales Price”: Coupled to Dataverse
Table 9057 “Job Cue”: Coupled Data Synch Errors
Table 9059 “Administration Cue”: Coupled Data Synch Errors
Table 9062 “User Security Status”: Coupled Data Synch Errors
Table 9063 “Relationship Mgmt. Cue”: Coupled Data Synch Errors
Table extension 6611 “FS Job Task”: Coupled to FS
Table extension 6612 “FS Service Item”: Coupled to FS
Table extension 6613 “FS Job Cue”: Coupled Data Sync Errors
Table extension 6614 “FS Location”: Coupled to FS
Table extension 6615 “FS Service Header”: Coupled to FS
Table extension 6616 “FS Service Line”: Coupled to FS
Table extension 6619 “FS Service Order Type”: Coupled to FS
Table extension 6620 “FS Service Item Line”: Coupled to FS

Extended by

Table extension 6618 “FS Integration Record”

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 10 “Type Helper” (2 calls: IsModifiedAfterLastSynchonizedCRMRecord → CompareDateTime, IsModifiedAfterLastSynchronizedRecord → CompareDateTime)
Codeunit 5344 “CRM Product Name” (1 call: AssertRecordIDCanBeCoupled → CDSServiceName)

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