Class SaleRecordData

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

Inheritance
object
SaleRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class SaleRecordData
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

SaleRecordData()

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

Declaration
public SaleRecordData()
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

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

Declaration
public int ActiveErpLinks
Field Value
Type Description
int

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Number of active links to documents and such

Declaration
public uint ActiveLinks
Field Value
Type Description
uint

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Amount

Total sale amount

Declaration
public double Amount
Field Value
Type Description
double
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

AppointmentId

For future use

Declaration
public int AppointmentId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

AssociateId

Owning associate

Declaration
public int AssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ComptrId

Competitor

Declaration
public int ComptrId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ContactId

Optional contact reference

Declaration
public int ContactId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CreatedByWorkflowId

The workflow this sale was created by

Declaration
public int CreatedByWorkflowId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CreditedId

Who is to be credited for the sale

Declaration
public int CreditedId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CurrencyId

Currency of sale

Declaration
public int CurrencyId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Done

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

Declaration
public SaleDone Done
Field Value
Type Description
SaleDone
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Earning

Earning on sale

Declaration
public double Earning
Field Value
Type Description
double
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

EarningPercent

Earning as percent of total

Declaration
public double EarningPercent
Field Value
Type Description
double
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

GroupIdx

Owner's group whn sale was created

Declaration
public int GroupIdx
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Heading

Sale heading (short description?)

Declaration
public string Heading
Field Value
Type Description
string
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

NddAppointmentId

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

Declaration
public int NddAppointmentId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Number1

Alphanumeric user field

Declaration
public string Number1
Field Value
Type Description
string
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

PersonId

Optional person reference

Declaration
public int PersonId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

PostitTextId

Paperclip text

Declaration
public int PostitTextId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Probability

Actual probability, may differ from the one in the list

Declaration
public short Probability
Field Value
Type Description
short
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProbabilityIdx

Pointer to probability list value

Declaration
public int ProbabilityIdx
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProjectId

Optional project reference

Declaration
public int ProjectId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ReasonId

Why we lost it

Declaration
public int ReasonId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ReasonSoldId

Reason why we made the sale

Declaration
public int ReasonSoldId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ReasonStalledId

If the status is stalled, it should be commented here

Declaration
public int ReasonStalledId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Registered

Registered date in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

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
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SaleId

Primary key

Declaration
public int SaleId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SaleTypeCatId

Category of sale type, slaved from saletype

Declaration
public int SaleTypeCatId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SaleTypeId

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

Declaration
public int SaleTypeId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Saledate

(expected / lost / won) sales date

Declaration
public DateTime Saledate
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Source

For future integration use; source of record

Declaration
public short Source
Field Value
Type Description
short
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SourceId

Source of order

Declaration
public int SourceId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Status

Status: 1 = open, 2 = sold, 3 = lost, 4 = stalled

Declaration
public SaleStatus Status
Field Value
Type Description
SaleStatus
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TextId

Optional long description

Declaration
public int TextId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Updated

Last updated in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Userdef2Id

User-defined fields reference

Declaration
public int Userdef2Id
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UserdefId

User-defined fields reference

Declaration
public int UserdefId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Visibility

Obsolete, but still maintained denormalization of visiblefor

Declaration
public short Visibility
Field Value
Type Description
short
Remarks

Please use this class instead of a full SaleRow 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 SaleTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods