Class DBC.AssociateHistoryFields

Fields for AssociateHistory, Historical information about associates that have been deleted. Most references are NOT declared as foreign keys; this is a historical table that should not be updated when further changes occur in the database

Inheritance
Object
DBC.AssociateHistoryFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class AssociateHistoryFields

Fields

AssociateHistoryId

AssociateHistory.AssociateHistoryId: Primary key

Declaration
public const string AssociateHistoryId = "associatehistory_id"
Field Value
Type Description
String

AssociateId

AssociateHistory.AssociateId: The original primary key of the deleted associate

Declaration
public const string AssociateId = "associateId"
Field Value
Type Description
String

ContactId

AssociateHistory.ContactId: The original contact_id

Declaration
public const string ContactId = "contactId"
Field Value
Type Description
String

EjUserId

AssociateHistory.EjUserId: The ejuser reference, if any

Declaration
public const string EjUserId = "ejUserId"
Field Value
Type Description
String

Firstname

AssociateHistory.Firstname: First name

Declaration
public const string Firstname = "firstname"
Field Value
Type Description
String

GroupId

AssociateHistory.GroupId: The group id

Declaration
public const string GroupId = "groupId"
Field Value
Type Description
String

Lastname

AssociateHistory.Lastname: Last name

Declaration
public const string Lastname = "lastname"
Field Value
Type Description
String

LocationAddress

AssociateHistory.LocationAddress: Address of location, if this is a resource that is a location

Declaration
public const string LocationAddress = "locationAddress"
Field Value
Type Description
String

MiddleName

AssociateHistory.MiddleName: Middle name or 'van' etc.

Declaration
public const string MiddleName = "middleName"
Field Value
Type Description
String

Name

AssociateHistory.Name: The associate name/initials

Declaration
public const string Name = "name"
Field Value
Type Description
String

OriginalRegistered

AssociateHistory.OriginalRegistered: Registered when

Declaration
public const string OriginalRegistered = "originalRegistered"
Field Value
Type Description
String

PersonId

AssociateHistory.PersonId: The person id

Declaration
public const string PersonId = "personId"
Field Value
Type Description
String

Registered

AssociateHistory.Registered: Registered when

Declaration
public const string Registered = "registered"
Field Value
Type Description
String

RegisteredAssociateId

AssociateHistory.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
String

Type

AssociateHistory.Type: Associate type

Declaration
public const string Type = "type"
Field Value
Type Description
String