Class SaleTypeTableInfo
Table 'SaleType': Type of sale - large solution, incremental, whatever fits the organization
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> |
LeftOuterJoin_SaleTypeGroupLink_SaleTypeId
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> |
LeftOuterJoin_SaleTypeHeadingLink_SaleTypeId
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> |
LeftOuterJoin_SaleTypeStageLink_SaleTypeId
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 |