ErpConnectionActorType Table (419)

• 2 minutes to read

Data about the configuration of one Erp Actor on one ErpConnection

Fields

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

ErpConnectionActorType table relationship diagram

Actor type within the ERP system, related but not identitcal to SuperOffice Entity type

This enumeration is used in: ErpConnectionActorType.ActorTypeErp; ErpExternalKey.ActorType

ActorTypeErp or ActorType	Description
0	Unknown - used when initializing
1	Erp Customer
2	Supplier or Vendor
3	Both customer and supplier
4	Contact person
5	Project
6	Employee, often mapped to associate
7	Sale

Actor type within the CRM, system, a subset of the SuperOffice Entity types

ActorTypeCrm	Description
0	Unknown - used when initializing
1	Crm Customer
2	Person
3	Project
4	Sale

Fields	Types	Description
erpconnectionactortype_id	PK	Clustered, Unique
ErpConnectionId, ActorTypeErp	FK, Enum	Unique
ErpConnectionId, ActorTypeCrm	FK, Enum	Index

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