Show / Hide Table of Contents

Class SaleTableInfo

Table 'sale': Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.

Inheritance
object
TableInfo
SaleTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(params 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.this[string]
TableInfo.PrimaryKeyField
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("sale")]
public class SaleTableInfo : 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 TablesInfo.GetSaleInfo().

Fields

DictionaryTableName

Conceptual name of table Sale in the database dictionary: sale

Declaration
public const string DictionaryTableName = "sale"
Field Value
Type Description
string
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 TablesInfo.GetSaleInfo().

Properties

ActiveErpLinks

Field 'activeErpLinks' in table 'sale': Dictionary type Int, .NET type: int

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
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 TablesInfo.GetSaleInfo().

ActiveLinks

Field 'activeLinks' in table 'sale': Dictionary type UInt, .NET type: uint

Number of active links to documents and such
Declaration
public FieldInfo ActiveLinks { get; }
Property Value
Type Description
FieldInfo
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 TablesInfo.GetSaleInfo().

Amount

Field 'amount' in table 'sale': Dictionary type Double, .NET type: double

Total sale amount
Declaration
public DoubleFieldInfo Amount { get; }
Property Value
Type Description
DoubleFieldInfo
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 TablesInfo.GetSaleInfo().

AppointmentId

Field 'appointment_id' in table 'sale': Dictionary type FK, target: Appointment, .NET type: int

For future use
Declaration
public Int32FieldInfo AppointmentId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

AppointmentId_InnerJoin_Appointment

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

Declaration
public TargetedInnerJoin<AppointmentTableInfo> AppointmentId_InnerJoin_Appointment { get; }
Property Value
Type Description
TargetedInnerJoin<AppointmentTableInfo>
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 TablesInfo.GetSaleInfo().

AssociateId

Field 'associate_id' in table 'sale': Dictionary type FK, target: Associate, .NET type: int

Owning associate
Declaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

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>
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 TablesInfo.GetSaleInfo().

ComptrId

Field 'comptr_id' in table 'sale': Dictionary type FK, target: Comptr, .NET type: int

Competitor
Declaration
public Int32FieldInfo ComptrId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ComptrId_InnerJoin_Comptr

Generated join from the foreign key ComptrId in this table, to its target table ComptrTableInfo.

Declaration
public TargetedInnerJoin<ComptrTableInfo> ComptrId_InnerJoin_Comptr { get; }
Property Value
Type Description
TargetedInnerJoin<ComptrTableInfo>
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 TablesInfo.GetSaleInfo().

ContactId

Field 'contact_id' in table 'sale': Dictionary type FK, target: Contact, .NET type: int

Optional contact reference
Declaration
public Int32FieldInfo ContactId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ContactId_InnerJoin_Contact

Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.

Declaration
public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }
Property Value
Type Description
TargetedInnerJoin<ContactTableInfo>
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 TablesInfo.GetSaleInfo().

CreatedByWorkflowId

Field 'created_by_workflow_id' in table 'sale': Dictionary type FK, target: Workflow, .NET type: int

The workflow this sale was created by
Declaration
public Int32FieldInfo CreatedByWorkflowId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

CreatedByWorkflowId_InnerJoin_Workflow

Generated join from the foreign key CreatedByWorkflowId in this table, to its target table WorkflowTableInfo.

Declaration
public TargetedInnerJoin<WorkflowTableInfo> CreatedByWorkflowId_InnerJoin_Workflow { get; }
Property Value
Type Description
TargetedInnerJoin<WorkflowTableInfo>
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 TablesInfo.GetSaleInfo().

CreditedId

Field 'credited_id' in table 'sale': Dictionary type FK, target: Credited, .NET type: int

Who is to be credited for the sale
Declaration
public Int32FieldInfo CreditedId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

CreditedId_InnerJoin_Credited

Generated join from the foreign key CreditedId in this table, to its target table CreditedTableInfo.

Declaration
public TargetedInnerJoin<CreditedTableInfo> CreditedId_InnerJoin_Credited { get; }
Property Value
Type Description
TargetedInnerJoin<CreditedTableInfo>
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 TablesInfo.GetSaleInfo().

CurrencyId

Field 'currency_id' in table 'sale': Dictionary type FK, target: Currency, .NET type: int

Currency of sale
Declaration
public Int32FieldInfo CurrencyId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

CurrencyId_InnerJoin_Currency

Generated join from the foreign key CurrencyId in this table, to its target table CurrencyTableInfo.

Declaration
public TargetedInnerJoin<CurrencyTableInfo> CurrencyId_InnerJoin_Currency { get; }
Property Value
Type Description
TargetedInnerJoin<CurrencyTableInfo>
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 TablesInfo.GetSaleInfo().

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
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 TablesInfo.GetSaleInfo().

DictionaryTableNumber

Table number for table Sale 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
int
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 TablesInfo.GetSaleInfo().

Done

Field 'done' in table 'sale': Dictionary type Enum, .NET type: SaleDone

Done (0=don't know, 1 = No, 2=Yes)
Declaration
public SaleDoneFieldInfo Done { get; }
Property Value
Type Description
SaleDoneFieldInfo
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 TablesInfo.GetSaleInfo().

Earning

Field 'earning' in table 'sale': Dictionary type Double, .NET type: double

Earning on sale
Declaration
public DoubleFieldInfo Earning { get; }
Property Value
Type Description
DoubleFieldInfo
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 TablesInfo.GetSaleInfo().

EarningPercent

Field 'earning_percent' in table 'sale': Dictionary type Double, .NET type: double

Earning as percent of total
Declaration
public DoubleFieldInfo EarningPercent { get; }
Property Value
Type Description
DoubleFieldInfo
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 TablesInfo.GetSaleInfo().

GroupIdx

Field 'group_idx' in table 'sale': Dictionary type FK, target: UserGroup, .NET type: int

Owner's group whn sale was created
Declaration
public Int32FieldInfo GroupIdx { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

GroupIdx_InnerJoin_UserGroup

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

Declaration
public TargetedInnerJoin<UserGroupTableInfo> GroupIdx_InnerJoin_UserGroup { get; }
Property Value
Type Description
TargetedInnerJoin<UserGroupTableInfo>
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 TablesInfo.GetSaleInfo().

Heading

Field 'heading' in table 'sale': Dictionary type String[220], .NET type: string

Sale heading (short description?)
Declaration
public StringFieldInfo Heading { get; }
Property Value
Type Description
StringFieldInfo
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_Appointment_SaleId

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

Declaration
public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<AppointmentTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_ChatSession_SaleId

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

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_EmailItem_SaleId

Generated left outer join from the primary key SaleId on this table, to EmailItem.SaleId.

Declaration
public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EmailItemTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_Quote_SaleId

Generated left outer join from the primary key SaleId on this table, to Quote.SaleId.

Declaration
public TargetedLeftOuterJoin<QuoteTableInfo> LeftOuterJoin_Quote_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_SaleHist_SaleId

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

Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleHistTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_SaleStakeholder_SaleId

Generated left outer join from the primary key SaleId on this table, to SaleStakeholder.SaleId.

Declaration
public TargetedLeftOuterJoin<SaleStakeholderTableInfo> LeftOuterJoin_SaleStakeholder_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleStakeholderTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_Ticket_SaleId

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

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>
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 TablesInfo.GetSaleInfo().

LeftOuterJoin_VisibleFor_SaleId

Generated left outer join from the primary key SaleId on this table, to VisibleFor.SaleId.

Declaration
public TargetedLeftOuterJoin<VisibleForTableInfo> LeftOuterJoin_VisibleFor_SaleId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<VisibleForTableInfo>
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 TablesInfo.GetSaleInfo().

NddAppointmentId

Field 'nddAppointment_id' in table 'sale': Dictionary type FK, target: Appointment, .NET type: int

ID, can be 0, of the appointment that "caused" the nextDueDate
Declaration
public Int32FieldInfo NddAppointmentId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

NddAppointmentId_InnerJoin_Appointment

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

Declaration
public TargetedInnerJoin<AppointmentTableInfo> NddAppointmentId_InnerJoin_Appointment { get; }
Property Value
Type Description
TargetedInnerJoin<AppointmentTableInfo>
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 TablesInfo.GetSaleInfo().

NextDueDate

Field 'nextDueDate' in table 'sale': Dictionary type DateTime, .NET type: DateTime

Next due date, this is a denormalization of 'closest future activity date, or most recent if no future activities'. Maintained by the system, but very convenient for searching.
Declaration
public DateTimeFieldInfo NextDueDate { get; }
Property Value
Type Description
DateTimeFieldInfo
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 TablesInfo.GetSaleInfo().

Number1

Field 'number1' in table 'sale': Dictionary type String[50], .NET type: string

Alphanumeric user field
Declaration
public StringFieldInfo Number1 { get; }
Property Value
Type Description
StringFieldInfo
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 TablesInfo.GetSaleInfo().

PersonId

Field 'person_id' in table 'sale': Dictionary type FK, target: Person, .NET type: int

Optional person reference
Declaration
public Int32FieldInfo PersonId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

PersonId_InnerJoin_Person

Generated join from the foreign key PersonId in this table, to its target table PersonTableInfo.

Declaration
public TargetedInnerJoin<PersonTableInfo> PersonId_InnerJoin_Person { get; }
Property Value
Type Description
TargetedInnerJoin<PersonTableInfo>
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 TablesInfo.GetSaleInfo().

PostitTextId

Field 'postitText_id' in table 'sale': Dictionary type FK, target: Text, .NET type: int

Paperclip text
Declaration
public Int32FieldInfo PostitTextId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

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>
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 TablesInfo.GetSaleInfo().

Probability

Field 'probability' in table 'sale': Dictionary type UShort, .NET type: short

Actual probability, may differ from the one in the list
Declaration
public UInt16FieldInfo Probability { get; }
Property Value
Type Description
UInt16FieldInfo
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 TablesInfo.GetSaleInfo().

ProbabilityIdx

Field 'probability_idx' in table 'sale': Dictionary type FK, target: Prob, .NET type: int

Pointer to probability list value
Declaration
public Int32FieldInfo ProbabilityIdx { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ProbabilityIdx_InnerJoin_Prob

Generated join from the foreign key ProbabilityIdx in this table, to its target table ProbTableInfo.

Declaration
public TargetedInnerJoin<ProbTableInfo> ProbabilityIdx_InnerJoin_Prob { get; }
Property Value
Type Description
TargetedInnerJoin<ProbTableInfo>
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 TablesInfo.GetSaleInfo().

ProjectId

Field 'project_id' in table 'sale': Dictionary type FK, target: Project, .NET type: int

Optional project reference
Declaration
public Int32FieldInfo ProjectId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ProjectId_InnerJoin_Project

Generated join from the foreign key ProjectId in this table, to its target table ProjectTableInfo.

Declaration
public TargetedInnerJoin<ProjectTableInfo> ProjectId_InnerJoin_Project { get; }
Property Value
Type Description
TargetedInnerJoin<ProjectTableInfo>
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 TablesInfo.GetSaleInfo().

ReasonId

Field 'reason_id' in table 'sale': Dictionary type FK, target: Reason, .NET type: int

Why we lost it
Declaration
public Int32FieldInfo ReasonId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ReasonId_InnerJoin_Reason

Generated join from the foreign key ReasonId in this table, to its target table ReasonTableInfo.

Declaration
public TargetedInnerJoin<ReasonTableInfo> ReasonId_InnerJoin_Reason { get; }
Property Value
Type Description
TargetedInnerJoin<ReasonTableInfo>
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 TablesInfo.GetSaleInfo().

ReasonSoldId

Field 'reasonSold_id' in table 'sale': Dictionary type FK, target: ReasonSold, .NET type: int

Reason why we made the sale
Declaration
public Int32FieldInfo ReasonSoldId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ReasonSoldId_InnerJoin_ReasonSold

Generated join from the foreign key ReasonSoldId in this table, to its target table ReasonSoldTableInfo.

Declaration
public TargetedInnerJoin<ReasonSoldTableInfo> ReasonSoldId_InnerJoin_ReasonSold { get; }
Property Value
Type Description
TargetedInnerJoin<ReasonSoldTableInfo>
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 TablesInfo.GetSaleInfo().

ReasonStalledId

Field 'reasonStalled_id' in table 'sale': Dictionary type FK, target: ReasonStalled, .NET type: int

If the status is stalled, it should be commented here
Declaration
public Int32FieldInfo ReasonStalledId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

ReasonStalledId_InnerJoin_ReasonStalled

Generated join from the foreign key ReasonStalledId in this table, to its target table ReasonStalledTableInfo.

Declaration
public TargetedInnerJoin<ReasonStalledTableInfo> ReasonStalledId_InnerJoin_ReasonStalled { get; }
Property Value
Type Description
TargetedInnerJoin<ReasonStalledTableInfo>
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 TablesInfo.GetSaleInfo().

Registered

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

Registered date
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo
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 TablesInfo.GetSaleInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'sale': Dictionary type FK, target: Associate, .NET type: int

Registered by whom
Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

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>
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 TablesInfo.GetSaleInfo().

ReopenDate

Field 'reopenDate' in table 'sale': Dictionary type DateTime, .NET type: DateTime

Date the sale is to be reopened; valid only for status=stalled. Not necessarily the same as the nextDueDate.
Declaration
public DateTimeFieldInfo ReopenDate { get; }
Property Value
Type Description
DateTimeFieldInfo
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 TablesInfo.GetSaleInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable
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 TablesInfo.GetSaleInfo().

SaleId

Field 'sale_id' in table 'sale': Dictionary type PK, .NET type: int

Primary key
Declaration
public Int32FieldInfo SaleId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

SaleTypeCatId

Field 'saleTypeCat_id' in table 'sale': Dictionary type FK, target: SaleTypeCat, .NET type: int

Category of sale type, slaved from saletype
Declaration
public Int32FieldInfo SaleTypeCatId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

SaleTypeCatId_InnerJoin_SaleTypeCat

Generated join from the foreign key SaleTypeCatId in this table, to its target table SaleTypeCatTableInfo.

Declaration
public TargetedInnerJoin<SaleTypeCatTableInfo> SaleTypeCatId_InnerJoin_SaleTypeCat { get; }
Property Value
Type Description
TargetedInnerJoin<SaleTypeCatTableInfo>
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 TablesInfo.GetSaleInfo().

SaleTypeId

Field 'saleType_id' in table 'sale': Dictionary type FK, target: SaleType, .NET type: int

Link to list, sale type (big sale, small sale, no-process sale, ...)
Declaration
public Int32FieldInfo SaleTypeId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

SaleTypeId_InnerJoin_SaleType

Generated join from the foreign key SaleTypeId in this table, to its target table SaleTypeTableInfo.

Declaration
public TargetedInnerJoin<SaleTypeTableInfo> SaleTypeId_InnerJoin_SaleType { get; }
Property Value
Type Description
TargetedInnerJoin<SaleTypeTableInfo>
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 TablesInfo.GetSaleInfo().

Saledate

Field 'saledate' in table 'sale': Dictionary type DateTime, .NET type: DateTime

(expected / lost / won) sales date
Declaration
public DateTimeFieldInfo Saledate { get; }
Property Value
Type Description
DateTimeFieldInfo
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 TablesInfo.GetSaleInfo().

Source

Field 'source' in table 'sale': Dictionary type UShort, .NET type: short

For future integration use; source of record
Declaration
public UInt16FieldInfo Source { get; }
Property Value
Type Description
UInt16FieldInfo
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 TablesInfo.GetSaleInfo().

SourceId

Field 'source_id' in table 'sale': Dictionary type FK, target: Source, .NET type: int

Source of order
Declaration
public Int32FieldInfo SourceId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

SourceId_InnerJoin_Source

Generated join from the foreign key SourceId in this table, to its target table SourceTableInfo.

Declaration
public TargetedInnerJoin<SourceTableInfo> SourceId_InnerJoin_Source { get; }
Property Value
Type Description
TargetedInnerJoin<SourceTableInfo>
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 TablesInfo.GetSaleInfo().

Status

Field 'status' in table 'sale': Dictionary type Enum, .NET type: SaleStatus

Status: 1 = open, 2 = sold, 3 = lost, 4 = stalled
Declaration
public SaleStatusFieldInfo Status { get; }
Property Value
Type Description
SaleStatusFieldInfo
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 TablesInfo.GetSaleInfo().

TextId

Field 'text_id' in table 'sale': Dictionary type FK, target: Text, .NET type: int

Optional long description
Declaration
public Int32FieldInfo TextId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

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>
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 TablesInfo.GetSaleInfo().

Updated

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

Last updated
Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo
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 TablesInfo.GetSaleInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'sale': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom
Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

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>
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 TablesInfo.GetSaleInfo().

UpdatedCount

Field 'updatedCount' in table 'sale': Dictionary type UShort, .NET type: short

Number of updates made to this record
Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo
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 TablesInfo.GetSaleInfo().

Userdef2Id

Field 'userdef2_id' in table 'sale': Dictionary type FK, target: UDSaleLarge, .NET type: int

User-defined fields reference
Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

Userdef2Id_InnerJoin_UDSaleLarge

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

Declaration
public TargetedInnerJoin<UDSaleLargeTableInfo> Userdef2Id_InnerJoin_UDSaleLarge { get; }
Property Value
Type Description
TargetedInnerJoin<UDSaleLargeTableInfo>
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 TablesInfo.GetSaleInfo().

UserdefId

Field 'userdef_id' in table 'sale': Dictionary type FK, target: UDSaleSmall, .NET type: int

User-defined fields reference
Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
Type Description
Int32FieldInfo
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 TablesInfo.GetSaleInfo().

UserdefId_InnerJoin_UDSaleSmall

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

Declaration
public TargetedInnerJoin<UDSaleSmallTableInfo> UserdefId_InnerJoin_UDSaleSmall { get; }
Property Value
Type Description
TargetedInnerJoin<UDSaleSmallTableInfo>
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 TablesInfo.GetSaleInfo().

Visibility

Field 'visibility' in table 'sale': Dictionary type UShort, .NET type: short

Obsolete, but still maintained denormalization of visiblefor
Declaration
public UInt16FieldInfo Visibility { get; }
Property Value
Type Description
UInt16FieldInfo
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 TablesInfo.GetSaleInfo().

Methods

IdxAssociateId(int)

Shortcut method for looking up using the database index AssociateId, which spans the following fields:

FieldDescription
AssociateIdOwning associate
Declaration
public Restriction IdxAssociateId(int associateId)
Parameters
Type Name Description
int associateId
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

IdxAssociateIdDone(int, SaleDone)

Shortcut method for looking up using the database index AssociateIdDone, which spans the following fields:

FieldDescription
AssociateIdOwning associate
DoneDone (0=don't know, 1 = No, 2=Yes)
Declaration
public Restriction IdxAssociateIdDone(int associateId, SaleDone done)
Parameters
Type Name Description
int associateId
SaleDone done
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

IdxContactId(int)

Shortcut method for looking up using the database index ContactId, which spans the following fields:

FieldDescription
ContactIdOptional contact reference
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type Name Description
int contactId
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

IdxContactIdSaledate(int, DateTime)

Shortcut method for looking up using the database index ContactIdSaledate, which spans the following fields:

FieldDescription
ContactIdOptional contact reference
Saledate(expected / lost / won) sales date
Declaration
public Restriction IdxContactIdSaledate(int contactId, DateTime saledate)
Parameters
Type Name Description
int contactId
DateTime saledate
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

IdxProjectId(int)

Shortcut method for looking up using the database index ProjectId, which spans the following fields:

FieldDescription
ProjectIdOptional project reference
Declaration
public Restriction IdxProjectId(int projectId)
Parameters
Type Name Description
int projectId
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

IdxProjectIdSaledate(int, DateTime)

Shortcut method for looking up using the database index ProjectIdSaledate, which spans the following fields:

FieldDescription
ProjectIdOptional project reference
Saledate(expected / lost / won) sales date
Declaration
public Restriction IdxProjectIdSaledate(int projectId, DateTime saledate)
Parameters
Type Name Description
int projectId
DateTime saledate
Returns
Type Description
Restriction
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 TablesInfo.GetSaleInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top