• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ErpExternalKey Table (423)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

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

Fields

Name Description Type Null
erpexternalkey_id Primary key PK
ErpInternalKeyId Link to the internal key and thus the original table/record in SuperOffice that is being synchronized FK ErpInternalKey
ErpConnectionId Link to the Erp connection the key relates to FK ErpConnection
ErpKey The primary key from the ERP system String(254)
ActorType The actor type within the ERP system of this synchronized record Enum ErpActorType
MostRecentTimestamp Datetime, transaction number or other identification of the point in time of the most-recently seen actor in the ERP system String(254)
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

ErpExternalKey table relationship diagram

Indexes

Fields Types Description
erpexternalkey_id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top