Class SaleTypeTableInfo

Table 'SaleType': Type of sale - large solution, incremental, whatever fits the organization

Inheritance
Object
TableInfo
SaleTypeTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("SaleType")]
public class SaleTypeTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table SaleType in the database dictionary: SaleType

Declaration
public const string DictionaryTableName = "SaleType"
Field Value
Type Description
String

Properties

AllowQuoteAlternatives

Field 'allowQuoteAlternatives' in table 'SaleType': Dictionary type Bool, .NET type: Int16

Can quotes linked to sales of this type, have multiple Alternatives

Declaration
public UInt16FieldInfo AllowQuoteAlternatives { get; }
Property Value
Type Description
UInt16FieldInfo

ArchiveGroupingFields

Field 'archiveGroupingFields' in table 'SaleType': Dictionary type String[60], .NET type: String

Comma-separated names of grouping fields for quote lines, in the quote lines archive

Declaration
public StringFieldInfo ArchiveGroupingFields { get; }
Property Value
Type Description
StringFieldInfo

ConfirmationLinesTemplate

Field 'confirmationLinesTemplate' in table 'SaleType': Dictionary type FK, .NET type: Int32

The template that this sale type should use when producing the order confirmation lines document; the template must have DocTmplQuoteType=ConfirmationLines

Declaration
public Int32FieldInfo ConfirmationLinesTemplate { get; }
Property Value
Type Description
Int32FieldInfo

ConfirmationLinesTemplate_InnerJoin_DocTmpl

Generated join from the foreign key ConfirmationLinesTemplate in this table, to its target table DocTmplTableInfo.

Declaration
public TargetedInnerJoin<DocTmplTableInfo> ConfirmationLinesTemplate_InnerJoin_DocTmpl { get; }
Property Value
Type Description
TargetedInnerJoin<DocTmplTableInfo>

DefaultQuoteValidity

Field 'defaultQuoteValidity' in table 'SaleType': Dictionary type Int, .NET type: Int32

Default valid days for quotes linked to sales of this type (valid from quote transmission)

Declaration
public Int32FieldInfo DefaultQuoteValidity { get; }
Property Value
Type Description
Int32FieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

Deleted

Field 'deleted' in table 'SaleType': Dictionary type UShort, .NET type: Int16

0 -> record is active 1 -> record is 'deleted' and should not be shown in lists

Declaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type Description
UInt16FieldInfo

DictionaryTableNumber

Table number for table SaleType in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
Int32

DocumentGroupingFields

Field 'documentGroupingFields' in table 'SaleType': Dictionary type String[60], .NET type: String

Comma-separated names of grouping fields for quote lines, when generating the documents

Declaration
public StringFieldInfo DocumentGroupingFields { get; }
Property Value
Type Description
StringFieldInfo

DurationUnit

Field 'durationUnit' in table 'SaleType': Dictionary type Enum, .NET type: DurationUnit

Units for the duration (day, week, whatever)

Declaration
public DurationUnitFieldInfo DurationUnit { get; }
Property Value
Type Description
DurationUnitFieldInfo

HasGuide

Field 'hasGuide' in table 'SaleType': Dictionary type Bool, .NET type: Int16

Does this sale type have a guide attached

Declaration
public UInt16FieldInfo HasGuide { get; }
Property Value
Type Description
UInt16FieldInfo

HasStakeholders

Field 'hasStakeholders' in table 'SaleType': Dictionary type UShort, .NET type: Int16

Does this sale type have stakeholders

Declaration
public UInt16FieldInfo HasStakeholders { get; }
Property Value
Type Description
UInt16FieldInfo

IsAutoAdvance

Field 'isAutoAdvance' in table 'SaleType': Dictionary type Bool, .NET type: Int16

Does the sale stage advance automatically, when the last guided activity in a stage is completed?

Declaration
public UInt16FieldInfo IsAutoAdvance { get; }
Property Value
Type Description
UInt16FieldInfo

LeftOuterJoin_Sale_SaleTypeId

Generated left outer join from the primary key SaleTypeId on this table, to Sale.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTableInfo>

LeftOuterJoin_SaleHist_SaleTypeId

Generated left outer join from the primary key SaleTypeId on this table, to SaleHist.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleHistTableInfo>

Generated left outer join from the primary key SaleTypeId on this table, to SaleTypeGroupLink.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleTypeGroupLinkTableInfo> LeftOuterJoin_SaleTypeGroupLink_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTypeGroupLinkTableInfo>

Generated left outer join from the primary key SaleTypeId on this table, to SaleTypeHeadingLink.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleTypeHeadingLinkTableInfo> LeftOuterJoin_SaleTypeHeadingLink_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTypeHeadingLinkTableInfo>

LeftOuterJoin_SaleTypeQuoteAttachment_SaleTypeId

Generated left outer join from the primary key SaleTypeId on this table, to SaleTypeQuoteAttachment.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleTypeQuoteAttachmentTableInfo> LeftOuterJoin_SaleTypeQuoteAttachment_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTypeQuoteAttachmentTableInfo>

Generated left outer join from the primary key SaleTypeId on this table, to SaleTypeStageLink.SaleTypeId.

Declaration
public TargetedLeftOuterJoin<SaleTypeStageLinkTableInfo> LeftOuterJoin_SaleTypeStageLink_SaleTypeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTypeStageLinkTableInfo>

MaxDiscountPercent

Field 'maxDiscountPercent' in table 'SaleType': Dictionary type Int, .NET type: Int32

The maximum discount in percent of total, if set, on quotes linked to sales of this type

Declaration
public Int32FieldInfo MaxDiscountPercent { get; }
Property Value
Type Description
Int32FieldInfo

MaxDiscountPercentSet

Field 'maxDiscountPercentSet' in table 'SaleType': Dictionary type Bool, .NET type: Int16

Is there a limit, in percent, to the total discount on quotes linked to sales of this type

Declaration
public UInt16FieldInfo MaxDiscountPercentSet { get; }
Property Value
Type Description
UInt16FieldInfo

MinEarningPercent

Field 'minEarningPercent' in table 'SaleType': Dictionary type Int, .NET type: Int32

The minimum earning in percent of total, if set, on quotes linked to sales of this type

Declaration
public Int32FieldInfo MinEarningPercent { get; }
Property Value
Type Description
Int32FieldInfo

MinEarningPercentSet

Field 'minEarningPercentSet' in table 'SaleType': Dictionary type Bool, .NET type: Int16

Is there a limit, in earning as percent of total, on quotes linked to sales of this type

Declaration
public UInt16FieldInfo MinEarningPercentSet { get; }
Property Value
Type Description
UInt16FieldInfo

Name

Field 'name' in table 'SaleType': Dictionary type String[240], .NET type: String

The list item

Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo

QuoteLinesTemplate

Field 'quoteLinesTemplate' in table 'SaleType': Dictionary type FK, .NET type: Int32

The template that this sale type should use when producing the product lines offer document; the template must have DocTmplQuoteType=QuoteLines

Declaration
public Int32FieldInfo QuoteLinesTemplate { get; }
Property Value
Type Description
Int32FieldInfo

QuoteLinesTemplate_InnerJoin_DocTmpl

Generated join from the foreign key QuoteLinesTemplate in this table, to its target table DocTmplTableInfo.

Declaration
public TargetedInnerJoin<DocTmplTableInfo> QuoteLinesTemplate_InnerJoin_DocTmpl { get; }
Property Value
Type Description
TargetedInnerJoin<DocTmplTableInfo>

Rank

Field 'rank' in table 'SaleType': Dictionary type UShort, .NET type: Int16

Rank order

Declaration
public UInt16FieldInfo Rank { get; }
Property Value
Type Description
UInt16FieldInfo

Registered

Field 'registered' in table 'SaleType': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'SaleType': Dictionary type FK, .NET type: Int32

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

SaleDuration

Field 'saleDuration' in table 'SaleType': Dictionary type Int, .NET type: Int32

Expected number of dales from initiation to close of sale

Declaration
public Int32FieldInfo SaleDuration { get; }
Property Value
Type Description
Int32FieldInfo

SaleTypeCatId

Field 'saleTypeCat_id' in table 'SaleType': Dictionary type FK, .NET type: Int32

Category of sale type, copied to sale

Declaration
public Int32FieldInfo SaleTypeCatId { get; }
Property Value
Type Description
Int32FieldInfo

SaleTypeCatId_InnerJoin_SaleTypeCat

Generated join from the foreign key SaleTypeCatId in this table, to its target table SaleTypeCatTableInfo.

Declaration
public TargetedInnerJoin<SaleTypeCatTableInfo> SaleTypeCatId_InnerJoin_SaleTypeCat { get; }
Property Value
Type Description
TargetedInnerJoin<SaleTypeCatTableInfo>

SaleTypeId

Field 'SaleType_Id' in table 'SaleType': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo SaleTypeId { get; }
Property Value
Type Description
Int32FieldInfo

Tooltip

Field 'tooltip' in table 'SaleType': Dictionary type String[255], .NET type: String

Tooltip or other description

Declaration
public StringFieldInfo Tooltip { get; }
Property Value
Type Description
StringFieldInfo

Updated

Field 'updated' in table 'SaleType': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'SaleType': Dictionary type FK, .NET type: Int32

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'SaleType': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)