Class ProjectTableInfo

Table 'project': Projects

Inheritance

System.Object

TableInfo

ProjectTableInfo

Implements

System.ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("project")]
public class ProjectTableInfo : TableInfo, ICloneable

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table Project in the database dictionary: project

Declaration

public const string DictionaryTableName = "project"

Field Value

Type	Description
System.String

Properties

ActiveErpLinks

Field 'activeErpLinks' in table 'project': Dictionary type Int, .NET type: System.Int32

The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations

Declaration

public Int32FieldInfo ActiveErpLinks { get; }

Property Value

Type	Description
Int32FieldInfo

ActiveLinks

Field 'activeLinks' in table 'project': Dictionary type UInt, .NET type: System.UInt32

Number of active links to documents, other appointments, and such

Declaration

public FieldInfo ActiveLinks { get; }

Property Value

Type	Description
FieldInfo

AssociateId

Field 'associate_id' in table 'project': Dictionary type FK, target: Associate, .NET type: System.Int32

Project manager/owner

Declaration

public Int32FieldInfo AssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

AssociateId_InnerJoin_Associate

Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

DictionaryTableNumber

Table number for table Project in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration

public int DictionaryTableNumber { get; }

Property Value

Type	Description
System.Int32

Done

Field 'done' in table 'project': Dictionary type Bool, .NET type: System.Int16

Done (0=false, 1=true). Status implies changes in which fields are shown in GUI, as well as which fields can be updated

Declaration

public UInt16FieldInfo Done { get; }

Property Value

Type	Description
UInt16FieldInfo

EndDate

Field 'endDate' in table 'project': Dictionary type DateTime, .NET type: System.DateTime

Planned end date for project, inhertied from type and later editable

Declaration

public DateTimeFieldInfo EndDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

GroupId

Field 'group_id' in table 'project': Dictionary type FK, target: UserGroup, .NET type: System.Int32

Group id of original owning associate, semantics like appnt.grp_id

Declaration

public Int32FieldInfo GroupId { get; }

Property Value

Type	Description
Int32FieldInfo

GroupId_InnerJoin_UserGroup

Generated join from the foreign key GroupId in this table, to its target table UserGroupTableInfo.

Declaration

public TargetedInnerJoin<UserGroupTableInfo> GroupId_InnerJoin_UserGroup { get; }

Property Value

Type	Description
TargetedInnerJoin<UserGroupTableInfo>

LeftOuterJoin_Appointment_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Appointment.ProjectId.

Declaration

public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

LeftOuterJoin_ChatSession_ProjectId

Generated left outer join from the primary key ProjectId on this table, to ChatSession.ProjectId.

Declaration

public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ChatSessionTableInfo>

LeftOuterJoin_CounterValue_ProjectId

Generated left outer join from the primary key ProjectId on this table, to CounterValue.ProjectId.

Declaration

public TargetedLeftOuterJoin<CounterValueTableInfo> LeftOuterJoin_CounterValue_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CounterValueTableInfo>

LeftOuterJoin_Email_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Email.ProjectId.

Declaration

public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EmailTableInfo>

LeftOuterJoin_ProjectMember_ProjectId

Generated left outer join from the primary key ProjectId on this table, to ProjectMember.ProjectId.

Declaration

public TargetedLeftOuterJoin<ProjectMemberTableInfo> LeftOuterJoin_ProjectMember_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ProjectMemberTableInfo>

LeftOuterJoin_Sale_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Sale.ProjectId.

Declaration

public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleTableInfo>

LeftOuterJoin_SaleHist_ProjectId

Generated left outer join from the primary key ProjectId on this table, to SaleHist.ProjectId.

Declaration

public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleHistTableInfo>

LeftOuterJoin_SLink_AddProject

Generated left outer join from the primary key ProjectId on this table, to SLink.AddProject.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_AddProject { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_SLink_RemoveProject

Generated left outer join from the primary key ProjectId on this table, to SLink.RemoveProject.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_RemoveProject { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_SLink_TaskProject

Generated left outer join from the primary key ProjectId on this table, to SLink.TaskProject.

Declaration

public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TaskProject { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_SShipment_ProjectId

Generated left outer join from the primary key ProjectId on this table, to SShipment.ProjectId.

Declaration

public TargetedLeftOuterJoin<SShipmentTableInfo> LeftOuterJoin_SShipment_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SShipmentTableInfo>

LeftOuterJoin_StatusValue_ProjectId

Generated left outer join from the primary key ProjectId on this table, to StatusValue.ProjectId.

Declaration

public TargetedLeftOuterJoin<StatusValueTableInfo> LeftOuterJoin_StatusValue_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<StatusValueTableInfo>

LeftOuterJoin_Ticket_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Ticket.ProjectId.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

LeftOuterJoin_URL_ProjectId

Generated left outer join from the primary key ProjectId on this table, to URL.ProjectId.

Declaration

public TargetedLeftOuterJoin<URLTableInfo> LeftOuterJoin_URL_ProjectId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<URLTableInfo>

Name

Field 'name' in table 'project': Dictionary type String[220], .NET type: System.String

Project name

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

NextMilestoneDate

Field 'nextMilestoneDate' in table 'project': Dictionary type DateTime, .NET type: System.DateTime

Calculated date, reflects date of closest non-complete future milestone activity

Declaration

public DateTimeFieldInfo NextMilestoneDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

NmdAppointmentId

Field 'nmdAppointment_id' in table 'project': Dictionary type FK, target: Appointment, .NET type: System.Int32

ID of appointment that "caused" the nextMilestoneDate, can be 0

Declaration

public Int32FieldInfo NmdAppointmentId { get; }

Property Value

Type	Description
Int32FieldInfo

NmdAppointmentId_InnerJoin_Appointment

Generated join from the foreign key NmdAppointmentId in this table, to its target table AppointmentTableInfo.

Declaration

public TargetedInnerJoin<AppointmentTableInfo> NmdAppointmentId_InnerJoin_Appointment { get; }

Property Value

Type	Description
TargetedInnerJoin<AppointmentTableInfo>

PostitTextId

Field 'postitText_id' in table 'project': Dictionary type FK, target: Text, .NET type: System.Int32

Paperclip text

Declaration

public Int32FieldInfo PostitTextId { get; }

Property Value

Type	Description
Int32FieldInfo

PostitTextId_InnerJoin_Text

Generated join from the foreign key PostitTextId in this table, to its target table TextTableInfo.

Declaration

public TargetedInnerJoin<TextTableInfo> PostitTextId_InnerJoin_Text { get; }

Property Value

Type	Description
TargetedInnerJoin<TextTableInfo>

ProjectId

Field 'project_id' in table 'project': Dictionary type PK, .NET type: System.Int32

Primary key

Declaration

public Int32FieldInfo ProjectId { get; }

Property Value

Type	Description
Int32FieldInfo

ProjectNumber

Field 'project_number' in table 'project': Dictionary type String[50], .NET type: System.String

Automatically generated number

Declaration

public StringFieldInfo ProjectNumber { get; }

Property Value

Type	Description
StringFieldInfo

Registered

Field 'registered' in table 'project': Dictionary type UtcDateTime, .NET type: System.DateTime

Registered date

Declaration

public DateTimeFieldInfo Registered { get; }

Property Value

Type	Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'project': Dictionary type FK, target: Associate, .NET type: System.Int32

Registered by whom

Declaration

public Int32FieldInfo RegisteredAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

SoundEx

Field 'soundEx' in table 'project': Dictionary type String[10], .NET type: System.String

What the name sounds like, for duplicate detection

Declaration

public StringFieldInfo SoundEx { get; }

Property Value

Type	Description
StringFieldInfo

Source

Field 'source' in table 'project': Dictionary type UShort, .NET type: System.Int16

How did we get this project? For future integration needs

Declaration

public UInt16FieldInfo Source { get; }

Property Value

Type	Description
UInt16FieldInfo

StatusIdx

Field 'status_idx' in table 'project': Dictionary type FK, target: ProjStatus, .NET type: System.Int32

Link to ProjStatus list

Declaration

public Int32FieldInfo StatusIdx { get; }

Property Value

Type	Description
Int32FieldInfo

StatusIdx_InnerJoin_ProjStatus

Generated join from the foreign key StatusIdx in this table, to its target table ProjStatusTableInfo.

Declaration

public TargetedInnerJoin<ProjStatusTableInfo> StatusIdx_InnerJoin_ProjStatus { get; }

Property Value

Type	Description
TargetedInnerJoin<ProjStatusTableInfo>

TextId

Field 'text_id' in table 'project': Dictionary type FK, target: Text, .NET type: System.Int32

Description field

Declaration

public Int32FieldInfo TextId { get; }

Property Value

Type	Description
Int32FieldInfo

TextId_InnerJoin_Text

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

Declaration

public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }

Property Value

Type	Description
TargetedInnerJoin<TextTableInfo>

TypeIdx

Field 'type_idx' in table 'project': Dictionary type FK, target: ProjType, .NET type: System.Int32

Link to ProjType list

Declaration

public Int32FieldInfo TypeIdx { get; }

Property Value

Type	Description
Int32FieldInfo

TypeIdx_InnerJoin_ProjType

Generated join from the foreign key TypeIdx in this table, to its target table ProjTypeTableInfo.

Declaration

public TargetedInnerJoin<ProjTypeTableInfo> TypeIdx_InnerJoin_ProjType { get; }

Property Value

Type	Description
TargetedInnerJoin<ProjTypeTableInfo>

TzLocationId

Field 'tzLocationId' in table 'project': Dictionary type FK, target: TZLocation, .NET type: System.Int32

Default timezone location for this project

Declaration

public Int32FieldInfo TzLocationId { get; }

Property Value

Type	Description
Int32FieldInfo

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration

public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }

Property Value

Type	Description
TargetedInnerJoin<TZLocationTableInfo>

Updated

Field 'updated' in table 'project': Dictionary type UtcDateTime, .NET type: System.DateTime

Last updated date

Declaration

public DateTimeFieldInfo Updated { get; }

Property Value

Type	Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'project': Dictionary type FK, target: Associate, .NET type: System.Int32

Last updated by whom

Declaration

public Int32FieldInfo UpdatedAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'project': Dictionary type UShort, .NET type: System.Int16

Number of updates made to this record

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

Userdef2Id

Field 'userdef2_id' in table 'project': Dictionary type FK, target: UDProjectLarge, .NET type: System.Int32

User defined table record 2

Declaration

public Int32FieldInfo Userdef2Id { get; }

Property Value

Type	Description
Int32FieldInfo

Userdef2Id_InnerJoin_UDProjectLarge

Generated join from the foreign key Userdef2Id in this table, to its target table UDProjectLargeTableInfo.

Declaration

public TargetedInnerJoin<UDProjectLargeTableInfo> Userdef2Id_InnerJoin_UDProjectLarge { get; }

Property Value

Type	Description
TargetedInnerJoin<UDProjectLargeTableInfo>

UserdefId

Field 'userdef_id' in table 'project': Dictionary type FK, target: UDProjectSmall, .NET type: System.Int32

Pointer to userdef small table

Declaration

public Int32FieldInfo UserdefId { get; }

Property Value

Type	Description
Int32FieldInfo

UserdefId_InnerJoin_UDProjectSmall

Generated join from the foreign key UserdefId in this table, to its target table UDProjectSmallTableInfo.

Declaration

public TargetedInnerJoin<UDProjectSmallTableInfo> UserdefId_InnerJoin_UDProjectSmall { get; }

Property Value

Type	Description
TargetedInnerJoin<UDProjectSmallTableInfo>

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)