ErpSyncLog table - SuperOffice

ErpSyncLog Table (426)

Record all field changes done by the Erp Sync

Fields

Name	Description	Type	Nullable
erpsynclog_id	Primary key	PK	No
ErpExternalKeyId	Link to the external key, indirectly also to the connection and internal key	FK ErpExternalKey	Yes
ErpFieldKey	ERP field name/key	String(254)	Yes
CrmFieldKey	CRM field name/key	String(254)	Yes
TargetIsCrm	Was the CRM field the target of the change? If false, then it was the ERP field that was changed by this sync operation	Bool	Yes
OldValue	The old value of the target field	String(254)	Yes
NewValue	The new value of the target field	String(254)	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ErpExternalKey	The external (ERP-facing) key related to a synchronized record / connection

Replication Flags

None

Security Flags

No access control via user’s Role.