Class SaleHistRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the SaleHist table.

Inheritance

object

SaleHistRecordData

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOfficeCRMRows

Assembly: SoDataBase.dll

Syntax

public class SaleHistRecordData

Remarks

Please use this class instead of a full SaleHistRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SaleHistTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

SaleHistRecordData()

Declaration

public SaleHistRecordData()

Fields

ActiveLinks

Number of active links to documents and such

Declaration

public uint ActiveLinks

Field Value

Type	Description
uint

Amount

Total sale amount

Declaration

public double Amount

Field Value

Type	Description
double

AppointmentId

For future use

Declaration

public int AppointmentId

Field Value

Type	Description
int

AssociateId

Owning associate

Declaration

public int AssociateId

Field Value

Type	Description
int

ComptrId

Competitor

Declaration

public int ComptrId

Field Value

Type	Description
int

ContactId

Optional contact reference

Declaration

public int ContactId

Field Value

Type	Description
int

CreditedId

Who is to be credited for the sale

Declaration

public int CreditedId

Field Value

Type	Description
int

CurrencyId

Currency of sale

Declaration

public int CurrencyId

Field Value

Type	Description
int

Done

Done (0=don't know, 1 = No, 2=Yes)

Declaration

public SaleDone Done

Field Value

Type	Description
SaleDone

Earning

Earning on sale

Declaration

public double Earning

Field Value

Type	Description
double

EarningPercent

Earning as percent of total

Declaration

public double EarningPercent

Field Value

Type	Description
double

GroupIdx

Owner's group whn sale was created

Declaration

public int GroupIdx

Field Value

Type	Description
int

Heading

Sale heading (short description?)

Declaration

public string Heading

Field Value

Type	Description
string

NddAppointmentId

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

Declaration

public int NddAppointmentId

Field Value

Type	Description
int

NextDueDate

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 DateTime NextDueDate

Field Value

Type	Description
DateTime

Number1

Alphanumeric user field

Declaration

public string Number1

Field Value

Type	Description
string

PersonId

Optional person reference

Declaration

public int PersonId

Field Value

Type	Description
int

PostitTextId

Paperclip text

Declaration

public int PostitTextId

Field Value

Type	Description
int

Probability

Actual probability, may differ from the one in the list

Declaration

public short Probability

Field Value

Type	Description
short

ProbabilityIdx

Pointer to probability list value

Declaration

public int ProbabilityIdx

Field Value

Type	Description
int

ProjectId

Optional project reference

Declaration

public int ProjectId

Field Value

Type	Description
int

ReasonId

Why we lost it

Declaration

public int ReasonId

Field Value

Type	Description
int

ReasonSoldId

Reason why we made the sale

Declaration

public int ReasonSoldId

Field Value

Type	Description
int

ReasonStalledId

If the status is stalled, it should be commented here

Declaration

public int ReasonStalledId

Field Value

Type	Description
int

Registered

Registered date in UTC.

Declaration

public DateTime Registered

Field Value

Type	Description
DateTime

RegisteredAssociateId

Registered by whom

Declaration

public int RegisteredAssociateId

Field Value

Type	Description
int

ReopenDate

Date the sale is to be reopened; valid only for status=stalled. Not necessarily the same as the nextDueDate.

Declaration

public DateTime ReopenDate

Field Value

Type	Description
DateTime

SaleId

The sale

Declaration

public int SaleId

Field Value

Type	Description
int

SaleTypeCatId

Category of sale type, slaved from saletype

Declaration

public int SaleTypeCatId

Field Value

Type	Description
int

SaleTypeId

Link to list, sale type (big sale, small sale, no-process sale, ...)

Declaration

public int SaleTypeId

Field Value

Type	Description
int

Saledate

(expected | lost | won) sales date

Declaration

public DateTime Saledate

Field Value

Type	Description
DateTime

SalehistId

Primary key

Declaration

public int SalehistId

Field Value

Type	Description
int

Source

For future integration use; source of record

Declaration

public short Source

Field Value

Type	Description
short

SourceId

Source of order

Declaration

public int SourceId

Field Value

Type	Description
int

StageWhenClosedId

The stage the sale was in when it was closed (sold or lost)

Declaration

public int StageWhenClosedId

Field Value

Type	Description
int

Status

Status (open, closed, lost)

Declaration

public SaleStatus Status

Field Value

Type	Description
SaleStatus

TextId

Optional long description

Declaration

public int TextId

Field Value

Type	Description
int

Updated

Last updated in UTC.

Declaration

public DateTime Updated

Field Value

Type	Description
DateTime

UpdatedAssociateId

Last updated by whom

Declaration

public int UpdatedAssociateId

Field Value

Type	Description
int

UpdatedCount

Number of updates made to this record

Declaration

public short UpdatedCount

Field Value

Type	Description
short

Userdef2Id

User-defined fields reference

Declaration

public int Userdef2Id

Field Value

Type	Description
int

UserdefId

User-defined fields reference

Declaration

public int UserdefId

Field Value

Type	Description
int

Visibility

Obsolete, but still maintained denormalization of visiblefor

Declaration

public short Visibility

Field Value

Type	Description
short

Extension Methods

EnumUtil.MapEnums<From, To>(From)

SaleHistRecordDataExtensions.ToInsertAsync(SaleHistRecordData, CancellationToken)

Converters.MapEnums<From, To>(From)

ObjectExtensions.AssignByReflection<T>(T, T)

ObjectExtensions.GraphCopy<T>(T)