Diagrams


Table

CRM Integration Record

Fields

# Name Type
2 CRM ID (CRM ID) GUID
3 Integration ID (Integration ID) GUID
4 Last Synch. Modified On (Last Synch. Modified On) DateTime
5 Last Synch. CRM Modified On (Last Synch. CRM Modified On) DateTime
6 Table ID (Table ID) Integer Editable: No
Normal
7 Last Synch. Result (Last Synch. Result) Option
8 Last Synch. CRM Result (Last Synch. CRM Result) Option
9 Last Synch. Job ID (Last Synch. Job ID) GUID
10 Last Synch. CRM Job ID (Last Synch. CRM Job ID) GUID
11 Skipped (Skipped) Boolean Editable: No

Keys

# Fields
0 CRM ID,Integration ID (CRM ID,Integration ID) Clustered: Yes
1 Integration ID (Integration ID)
2 Last Synch. Modified On,Integration ID (Last Synch. Modified On,Integration ID)
3 Last Synch. CRM Modified On,CRM ID (Last Synch. CRM Modified On,CRM ID)
4 Skipped,Table ID (Skipped,Table ID)

Table Relations To Other Tables

Field Related Table Related Field
Integration ID (Integration ID) Integration Record Integration ID (Integration ID) 1..n

Table Relations From Other Tables

From Table From Field