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.
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class PersonInterestFields
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 |