ErpConnectionActorType table - SuperOffice

ErpConnectionActorType Table (419)

Data about the configuration of one Erp Actor on one ErpConnection

Fields

Name	Description	Type	Nullable
erpconnectionactortype_id	Primary key	PK	No
ErpConnectionId	The connection this actor is configured for	FK ErpConnection	No
ActorTypeErp	The actor type (ERP side)	Enum ErpActorType	No
ActorTypeCrm	The actor type (CRM side)	Enum CrmActorType	Yes
IsActive	Is this mapping/synchronization configuration currently active	Bool	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

ErpConnectionActorType table relationship diagram

Indexes

Fields	Types	Description
ErpConnectionId, ActorTypeErp	FK, Enum	Unique
ErpConnectionId, ActorTypeCrm	FK, Enum	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
ErpField	Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector

Replication Flags

None

Security Flags

No access control via user’s Role.