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

ErpConnectionActorType Table (419)

Some tooltip text!
• 2 minutes to read
 • 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

Indexes

Fields Types Description
erpconnectionactortype_id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top