Class DBC.SaleFields
Fields for Sale, Sales For every Sale record edited through the SuperOffice GUI, a copy of the previous 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.
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class SaleFields
Fields
ActiveErpLinks
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 |
ActiveLinks
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 |
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 |
Saledate
Sale.Saledate: (expected / lost / won) sales date
Declaration
public const string Saledate = "saledate"
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 |
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 |