> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # ErpConnection table > One connection to an ERP connector, specifying Client and other required information ## ErpConnection Table (418) One connection to an ERP connector, specifying Client and other required information ## Fields | Name | Description | Type | Nullable | | ------------------------- | --------------------------------------------------------------------------------------------------------------------------- | ------------------------------------- | :------: | | erpconnection\_id | Primary key | PK | No | | ErpConnectorId | The connector that this connection should call | FK [ErpConnector](./erpconnector.mdx) | Yes | | DisplayName | Connection name shown to user; multi-language support | String(254) | Yes | | DisplayDescription | Tooltip/description shown to user; multi-language support | String(254) | Yes | | Active | Is this connection currently active | Bool | Yes | | ConnectionId | The GUID that uniquely identifies this connection; passed to the Connector in every call | String(127) | Yes | | MostRecentTimestamp | Datetime, transaction number or other identification of the point in time of the most-recently seen actor in the ERP system | String(254) | Yes | | AllAccess | Is this connection accessible to everyone? If not, then the ErpConnectionAccess table tells us who can access it | Bool | Yes | | Deleted | If set, then this is a row that has been 'deleted'; we do not physically delete rows to avoid disaster | Bool | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | ErpConnection table relationship diagram ## Indexes | Fields | Types | Description | | -------------- | ----------- | ----------- | | ErpConnectorId | FK | Index | | ConnectionId | String(127) | Unique | ## Relationships | Table | Description | | -------------------------------------------------- | -------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [ConnectionConfigField](./connectionconfigfield) | Configuration data for Erp and Quote Connections | | [ErpConnectionAccess](./erpconnectionaccess) | Access control for Erp Connections | | [ErpConnectionActorType](./erpconnectionactortype) | Data about the configuration of one Erp Actor on one ErpConnection | | [ErpConnector](./erpconnector) | One ERP Connector, known by its URL | | [ErpExternalKey](./erpexternalkey) | The external (ERP-facing) key related to a synchronized record / connection | | [QuoteConnection](./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. ## Related topics - [ErpConnection](/en/api/archive-providers/reference/erpconnection.md) - [ErpConnectionAccess table](/en/database/tables/erpconnectionaccess.md) - [ErpConnectionActorType table](/en/database/tables/erpconnectionactortype.md) - [SuperOffice.WebApi.Data.ErpConnection](/en/api/reference/webapi/SuperOffice.WebApi.Data.ErpConnection.md) - [erpconnections](/en/api/mdo-providers/reference/erpconnections.md) - [ErpConnector table](/en/database/tables/erpconnector.md)