Class DBC.RelationsFields

Fields for Relations, Instance of a relation, in principle between any two records, as long as they are defined in RelationDefinition. All instances of relations are held in this table; their definitions are in the RelDef table (RelDef + RelTarg define which relations you can have, this table contains the relations the user has actually entered). From 6.1 all links between appointments, sales and documents are also stored in this tabel.

Inheritance

Object

DBC.RelationsFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class RelationsFields : Object

Fields

AssociateId

Relations.AssociateId: Owner of this relation record

Declaration

public const string AssociateId = "associateId"

Field Value

Type	Description
String

DestinationRecord

Relations.DestinationRecord: Actual target record

Declaration

public const string DestinationRecord = "destination_record"

Field Value

Type	Description
String

DestinationTable

Relations.DestinationTable: Actual target table

Declaration

public const string DestinationTable = "destination_table"

Field Value

Type	Description
String

EndDate

Relations.EndDate: End date of validity

Declaration

public const string EndDate = "endDate"

Field Value

Type	Description
String

GroupIdx

Relations.GroupIdx: User group owning this relation

Declaration

public const string GroupIdx = "group_idx"

Field Value

Type	Description
String

Registered

Relations.Registered: Registered when

Declaration

public const string Registered = "registered"

Field Value

Type	Description
String

RegisteredAssociateId

Relations.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
String

RelationId

Relations.RelationId: Primary key

Declaration

public const string RelationId = "relation_id"

Field Value

Type	Description
String

Relcomment

Relations.Relcomment: Comment for relation

Declaration

public const string Relcomment = "relcomment"

Field Value

Type	Description
String

ReldefId

Relations.ReldefId: Reference to definition

Declaration

public const string ReldefId = "reldef_id"

Field Value

Type	Description
String

RelFlags

Relations.RelFlags: Relation flags, meaning as yet unspecified

Declaration

public const string RelFlags = "relFlags"

Field Value

Type	Description
String

Reversed

Relations.Reversed: Is direction reversed relative to definition

Declaration

public const string Reversed = "reversed"

Field Value

Type	Description
String

SourceRecord

Relations.SourceRecord: Actual source record

Declaration

public const string SourceRecord = "source_record"

Field Value

Type	Description
String

SourceTable

Relations.SourceTable: Actual source table

Declaration

public const string SourceTable = "source_table"

Field Value

Type	Description
String

StartDate

Relations.StartDate: Start date of validity

Declaration

public const string StartDate = "startDate"

Field Value

Type	Description
String

Updated

Relations.Updated: Last updated when

Declaration

public const string Updated = "updated"

Field Value

Type	Description
String

UpdatedAssociateId

Relations.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
String

UpdatedCount

Relations.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
String