Class DBC.PersonInterestFields

Fields for PersonInterest, Note: If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note: The combination of person_id and pinterest_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest.

Inheritance

Object

DBC.PersonInterestFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class PersonInterestFields : Object

Fields

EndDate

PersonInterest.EndDate: End date for this interest - no GUI

Declaration

public const string EndDate = "endDate"

Field Value

Type	Description
String

Flags

PersonInterest.Flags: Spare flag field

Declaration

public const string Flags = "flags"

Field Value

Type	Description
String

PersonId

PersonInterest.PersonId: Owning person

Declaration

public const string PersonId = "person_id"

Field Value

Type	Description
String

PersoninterestId

PersonInterest.PersoninterestId: Primary key

Declaration

public const string PersoninterestId = "personinterest_id"

Field Value

Type	Description
String

PinterestIdx

PersonInterest.PinterestIdx: Person interest link

Declaration

public const string PinterestIdx = "pinterest_idx"

Field Value

Type	Description
String

Registered

PersonInterest.Registered: Registered when

Declaration

public const string Registered = "registered"

Field Value

Type	Description
String

RegisteredAssociateId

PersonInterest.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
String

StartDate

PersonInterest.StartDate: Start date for this interest - no GUI

Declaration

public const string StartDate = "startDate"

Field Value

Type	Description
String

Updated

PersonInterest.Updated: Last updated when

Declaration

public const string Updated = "updated"

Field Value

Type	Description
String

UpdatedAssociateId

PersonInterest.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
String

UpdatedCount

PersonInterest.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
String