Class DBC.SaleHistFields

Fields for SaleHist, Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.

Inheritance
object
DBC.SaleHistFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.SaleHistFields

Fields

SaleHist.ActiveLinks: Number of active links to documents and such

Declaration
public const string ActiveLinks = "activeLinks"
Field Value
Type Description
string

Amount

SaleHist.Amount: Total sale amount

Declaration
public const string Amount = "amount"
Field Value
Type Description
string

AppointmentId

SaleHist.AppointmentId: For future use

Declaration
public const string AppointmentId = "appointment_id"
Field Value
Type Description
string

AssociateId

SaleHist.AssociateId: Owning associate

Declaration
public const string AssociateId = "associate_id"
Field Value
Type Description
string

ComptrId

SaleHist.ComptrId: Competitor

Declaration
public const string ComptrId = "comptr_id"
Field Value
Type Description
string

ContactId

SaleHist.ContactId: Optional contact reference

Declaration
public const string ContactId = "contact_id"
Field Value
Type Description
string

CreditedId

SaleHist.CreditedId: Who is to be credited for the sale

Declaration
public const string CreditedId = "credited_id"
Field Value
Type Description
string

CurrencyId

SaleHist.CurrencyId: Currency of sale

Declaration
public const string CurrencyId = "currency_id"
Field Value
Type Description
string

Done

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

Declaration
public const string Done = "done"
Field Value
Type Description
string

Earning

SaleHist.Earning: Earning on sale

Declaration
public const string Earning = "earning"
Field Value
Type Description
string

EarningPercent

SaleHist.EarningPercent: Earning as percent of total

Declaration
public const string EarningPercent = "earning_percent"
Field Value
Type Description
string

GroupIdx

SaleHist.GroupIdx: Owner's group whn sale was created

Declaration
public const string GroupIdx = "group_idx"
Field Value
Type Description
string

Heading

SaleHist.Heading: Sale heading (short description?)

Declaration
public const string Heading = "heading"
Field Value
Type Description
string

NddAppointmentId

SaleHist.NddAppointmentId: ID, can be 0, of the appointment that "caused" the nextDueDate

Declaration
public const string NddAppointmentId = "nddAppointment_id"
Field Value
Type Description
string

NextDueDate

SaleHist.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 const string NextDueDate = "nextDueDate"
Field Value
Type Description
string

Number1

SaleHist.Number1: Alphanumeric user field

Declaration
public const string Number1 = "number1"
Field Value
Type Description
string

PersonId

SaleHist.PersonId: Optional person reference

Declaration
public const string PersonId = "person_id"
Field Value
Type Description
string

PostitTextId

SaleHist.PostitTextId: Paperclip text

Declaration
public const string PostitTextId = "postitText_id"
Field Value
Type Description
string

Probability

SaleHist.Probability: Actual probability, may differ from the one in the list

Declaration
public const string Probability = "probability"
Field Value
Type Description
string

ProbabilityIdx

SaleHist.ProbabilityIdx: Pointer to probability list value

Declaration
public const string ProbabilityIdx = "probability_idx"
Field Value
Type Description
string

ProjectId

SaleHist.ProjectId: Optional project reference

Declaration
public const string ProjectId = "project_id"
Field Value
Type Description
string

ReasonId

SaleHist.ReasonId: Why we lost it

Declaration
public const string ReasonId = "reason_id"
Field Value
Type Description
string

ReasonSoldId

SaleHist.ReasonSoldId: Reason why we made the sale

Declaration
public const string ReasonSoldId = "reasonSold_id"
Field Value
Type Description
string

ReasonStalledId

SaleHist.ReasonStalledId: If the status is stalled, it should be commented here

Declaration
public const string ReasonStalledId = "reasonStalled_id"
Field Value
Type Description
string

Registered

SaleHist.Registered: Registered date

Declaration
public const string Registered = "registered"
Field Value
Type Description
string

RegisteredAssociateId

SaleHist.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
string

ReopenDate

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

Declaration
public const string ReopenDate = "reopenDate"
Field Value
Type Description
string

SaleId

SaleHist.SaleId: The sale

Declaration
public const string SaleId = "sale_id"
Field Value
Type Description
string

SaleTypeCatId

SaleHist.SaleTypeCatId: Category of sale type, slaved from saletype

Declaration
public const string SaleTypeCatId = "saleTypeCat_id"
Field Value
Type Description
string

SaleTypeId

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

Declaration
public const string SaleTypeId = "saleType_id"
Field Value
Type Description
string

Saledate

SaleHist.Saledate: (expected | lost | won) sales date

Declaration
public const string Saledate = "saledate"
Field Value
Type Description
string

SalehistId

SaleHist.SalehistId: Primary key

Declaration
public const string SalehistId = "salehist_id"
Field Value
Type Description
string

Source

SaleHist.Source: For future integration use; source of record

Declaration
public const string Source = "source"
Field Value
Type Description
string

SourceId

SaleHist.SourceId: Source of order

Declaration
public const string SourceId = "source_id"
Field Value
Type Description
string

Status

SaleHist.Status: Status (open, closed, lost)

Declaration
public const string Status = "status"
Field Value
Type Description
string

TextId

SaleHist.TextId: Optional long description

Declaration
public const string TextId = "text_id"
Field Value
Type Description
string

Updated

SaleHist.Updated: Last updated

Declaration
public const string Updated = "updated"
Field Value
Type Description
string

UpdatedAssociateId

SaleHist.UpdatedAssociateId: Last updated by whom

Declaration
public const string UpdatedAssociateId = "updated_associate_id"
Field Value
Type Description
string

UpdatedCount

SaleHist.UpdatedCount: Number of updates made to this record

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
string

Userdef2Id

SaleHist.Userdef2Id: User-defined fields reference

Declaration
public const string Userdef2Id = "userdef2_id"
Field Value
Type Description
string

UserdefId

SaleHist.UserdefId: User-defined fields reference

Declaration
public const string UserdefId = "userdef_id"
Field Value
Type Description
string

Visibility

SaleHist.Visibility: Obsolete, but still maintained denormalization of visiblefor

Declaration
public const string Visibility = "visibility"
Field Value
Type Description
string