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

ErpConnection Table (418)

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

One connection to an ERP connector, specifying Client and other required information

Fields

Name Description Type Null
erpconnection_id Primary key PK
ErpConnectorId The connector that this connection should call FK ErpConnector ●
DisplayName Connection name shown to user; multi-language support String(254) ●
DisplayDescription Tooltip/description shown to user; multi-language support String(254) ●
Active Is this connection currently active Bool ●
ConnectionId The GUID that uniquely identifies this connection; passed to the Connector in every call String(127) ●
MostRecentTimestamp Datetime, transaction number or other identification of the point in time of the most-recently seen actor in the ERP system String(254) ●
AllAccess Is this connection accessible to everyone? If not, then the ErpConnectionAccess table tells us who can access it Bool ●
Deleted If set, then this is a row that has been 'deleted'; we do not physically delete rows to avoid disaster Bool ●
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

ErpConnection table relationship diagram

Indexes

Fields Types Description
erpconnection_id PK Clustered, Unique
ErpConnectorId FK Index
ConnectionId String(127) Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
ConnectionConfigField Configuration data for Erp and Quote Connections
ErpConnectionAccess Access control for Erp Connections
ErpConnectionActorType Data about the configuration of one Erp Actor on one ErpConnection
ErpConnector One ERP Connector, known by its URL
ErpExternalKey The external (ERP-facing) key related to a synchronized record / connection
QuoteConnection Primary key in the CRM database. Definition of a connection to an external system, for the Quote system.

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