Class DBC.SaleFields

Fields for 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
DBC.SaleFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.SaleFields

Fields

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

Declaration
public const string ActiveErpLinks = "activeErpLinks"
Field Value
Type Description
string

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

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

Amount

Sale.Amount: Total sale amount

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

AppointmentId

Sale.AppointmentId: For future use

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

AssociateId

Sale.AssociateId: Owning associate

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

ComptrId

Sale.ComptrId: Competitor

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

ContactId

Sale.ContactId: Optional contact reference

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

CreatedByWorkflowId

Sale.CreatedByWorkflowId: The workflow this sale was created by

Declaration
public const string CreatedByWorkflowId = "created_by_workflow_id"
Field Value
Type Description
string

CreditedId

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

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

CurrencyId

Sale.CurrencyId: Currency of sale

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

Done

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

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

Earning

Sale.Earning: Earning on sale

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

EarningPercent

Sale.EarningPercent: Earning as percent of total

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

GroupIdx

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

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

Heading

Sale.Heading: Sale heading (short description?)

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

NddAppointmentId

Sale.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

Sale.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

Sale.Number1: Alphanumeric user field

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

PersonId

Sale.PersonId: Optional person reference

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

PostitTextId

Sale.PostitTextId: Paperclip text

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

Probability

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

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

ProbabilityIdx

Sale.ProbabilityIdx: Pointer to probability list value

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

ProjectId

Sale.ProjectId: Optional project reference

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

ReasonId

Sale.ReasonId: Why we lost it

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

ReasonSoldId

Sale.ReasonSoldId: Reason why we made the sale

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

ReasonStalledId

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

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

Registered

Sale.Registered: Registered date

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

RegisteredAssociateId

Sale.RegisteredAssociateId: Registered by whom

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

ReopenDate

Sale.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

Sale.SaleId: Primary key

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

SaleTypeCatId

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

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

SaleTypeId

Sale.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

Sale.Saledate: (expected / lost / won) sales date

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

Source

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

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

SourceId

Sale.SourceId: Source of order

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

Status

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

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

TextId

Sale.TextId: Optional long description

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

Updated

Sale.Updated: Last updated

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

UpdatedAssociateId

Sale.UpdatedAssociateId: Last updated by whom

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

UpdatedCount

Sale.UpdatedCount: Number of updates made to this record

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

Userdef2Id

Sale.Userdef2Id: User-defined fields reference

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

UserdefId

Sale.UserdefId: User-defined fields reference

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

Visibility

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

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