ErpExternalKey table - SuperOffice

ErpExternalKey Table (423)

The external (ERP-facing) key related to a synchronized record / connection

Fields

Name	Description	Type	Nullable
erpexternalkey_id	Primary key	PK	No
ErpInternalKeyId	Link to the internal key and thus the original table/record in SuperOffice that is being synchronized	FK ErpInternalKey	No
ErpConnectionId	Link to the Erp connection the key relates to	FK ErpConnection	No
ErpKey	The primary key from the ERP system	String(254)	No
ActorType	The actor type within the ERP system of this synchronized record	Enum ErpActorType	No
MostRecentTimestamp	Datetime, transaction number or other identification of the point in time of the most-recently seen actor in the ERP system	String(254)	No
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

ErpExternalKey table relationship diagram

Indexes

Fields	Types	Description
ErpConnectionId, ErpInternalKeyId	FK, FK	Unique
ErpConnectionId, ActorType, ErpKey	FK, Enum, String(254)	Unique
ErpInternalKeyId	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ErpConnection	One connection to an ERP connector, specifying Client and other required information
ErpInternalKey	The internal (superoffice-facing) key related to a synchronized record
ErpSyncLog	Record all field changes done by the Erp Sync

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ErpInternalKey table ErpSyncLog table ErpConnection table Enum values for ErpActorType contact table project table

⌘I