ConnectionConfigField table - SuperOffice

ConnectionConfigField Table (421)

Configuration data for Erp and Quote Connections

Fields

Name	Description	Type	Nullable
connectionconfigfield_id	Primary key	PK	No
ErpConnectionId	Erp connection, if this row belongs to an ERP Connector	FK ErpConnection	Yes
QuoteConnectionId	Quote connection, if this row belongs to a Quote Connector	FK QuoteConnection	Yes
FieldKey	The key that identifies the field, taken from the connector’s metadata	String(254)	Yes
FieldValue	The field value, formatted for transport as a string using CultureDataFormatter	String(1023)	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

ConnectionConfigField table relationship diagram

Indexes

Fields	Types	Description
ErpConnectionId	FK	Index
QuoteConnectionId	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
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

Save Connection Config Fields IQuoteConnector Get Connection Config Fields Get Erp Connection Config Fields QuoteConnection table ErpConnection table

⌘I