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 TablesInfo.GetSaleTypeInfo().
Fields
DictionaryTableName
Conceptual name of table SaleType in the database dictionary: SaleType
Declaration
public const string DictionaryTableName = "SaleType"
Field Value
Type | Description |
---|---|
string |
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 TablesInfo.GetSaleTypeInfo().
Properties
AllowQuoteAlternatives
Field 'allowQuoteAlternatives' in table 'SaleType': Dictionary type Bool, .NET type: short
Can quotes linked to sales of this type, have multiple AlternativesDeclaration
public UInt16FieldInfo AllowQuoteAlternatives { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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 archiveDeclaration
public StringFieldInfo ArchiveGroupingFields { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
ConfirmationLinesTemplate
Field 'confirmationLinesTemplate' in table 'SaleType': Dictionary type FK, target: DocTmpl, .NET type: int
The template that this sale type should use when producing the order confirmation lines document; the template must have DocTmplQuoteType=ConfirmationLinesDeclaration
public Int32FieldInfo ConfirmationLinesTemplate { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
DefaultQuoteValidity
Field 'defaultQuoteValidity' in table 'SaleType': Dictionary type Int, .NET type: int
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 |
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 TablesInfo.GetSaleTypeInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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 TablesInfo.GetSaleTypeInfo().
Deleted
Field 'deleted' in table 'SaleType': Dictionary type UShort, .NET type: short
0 -> record is active 1 -> record is 'deleted' and should not be shown in listsDeclaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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 |
---|---|
int |
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 TablesInfo.GetSaleTypeInfo().
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 documentsDeclaration
public StringFieldInfo DocumentGroupingFields { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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 |
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 TablesInfo.GetSaleTypeInfo().
HasGuide
Field 'hasGuide' in table 'SaleType': Dictionary type Bool, .NET type: short
Does this sale type have a guide attachedDeclaration
public UInt16FieldInfo HasGuide { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
HasStakeholders
Field 'hasStakeholders' in table 'SaleType': Dictionary type UShort, .NET type: short
Does this sale type have stakeholdersDeclaration
public UInt16FieldInfo HasStakeholders { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
IsAutoAdvance
Field 'isAutoAdvance' in table 'SaleType': Dictionary type Bool, .NET type: short
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 |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
MaxDiscountPercent
Field 'maxDiscountPercent' in table 'SaleType': Dictionary type Int, .NET type: int
The maximum discount in percent of total, if set, on quotes linked to sales of this typeDeclaration
public Int32FieldInfo MaxDiscountPercent { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
MaxDiscountPercentSet
Field 'maxDiscountPercentSet' in table 'SaleType': Dictionary type Bool, .NET type: short
Is there a limit, in percent, to the total discount on quotes linked to sales of this typeDeclaration
public UInt16FieldInfo MaxDiscountPercentSet { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
MinEarningPercent
Field 'minEarningPercent' in table 'SaleType': Dictionary type Int, .NET type: int
The minimum earning in percent of total, if set, on quotes linked to sales of this typeDeclaration
public Int32FieldInfo MinEarningPercent { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
MinEarningPercentSet
Field 'minEarningPercentSet' in table 'SaleType': Dictionary type Bool, .NET type: short
Is there a limit, in earning as percent of total, on quotes linked to sales of this typeDeclaration
public UInt16FieldInfo MinEarningPercentSet { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
Name
Field 'name' in table 'SaleType': Dictionary type String[240], .NET type: string
The list itemDeclaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
QuoteLinesTemplate
Field 'quoteLinesTemplate' in table 'SaleType': Dictionary type FK, target: DocTmpl, .NET type: int
The template that this sale type should use when producing the product lines offer document; the template must have DocTmplQuoteType=QuoteLinesDeclaration
public Int32FieldInfo QuoteLinesTemplate { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
Rank
Field 'rank' in table 'SaleType': Dictionary type UShort, .NET type: short
Rank orderDeclaration
public UInt16FieldInfo Rank { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
Registered
Field 'registered' in table 'SaleType': Dictionary type UtcDateTime, .NET type: DateTime
Registered whenDeclaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
RegisteredAssociateId
Field 'registered_associate_id' in table 'SaleType': Dictionary type FK, target: Associate, .NET type: int
Registered by whomDeclaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
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 |
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 TablesInfo.GetSaleTypeInfo().
SaleDuration
Field 'saleDuration' in table 'SaleType': Dictionary type Int, .NET type: int
Expected number of dales from initiation to close of saleDeclaration
public Int32FieldInfo SaleDuration { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
SaleTypeCatId
Field 'saleTypeCat_id' in table 'SaleType': Dictionary type FK, target: SaleTypeCat, .NET type: int
Category of sale type, copied to saleDeclaration
public Int32FieldInfo SaleTypeCatId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
SaleTypeId
Field 'SaleType_Id' in table 'SaleType': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo SaleTypeId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
Tooltip
Field 'tooltip' in table 'SaleType': Dictionary type String[255], .NET type: string
Tooltip or other descriptionDeclaration
public StringFieldInfo Tooltip { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
Updated
Field 'updated' in table 'SaleType': Dictionary type UtcDateTime, .NET type: DateTime
Last updated whenDeclaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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 TablesInfo.GetSaleTypeInfo().
UpdatedAssociateId
Field 'updated_associate_id' in table 'SaleType': Dictionary type FK, target: Associate, .NET type: int
Last updated by whomDeclaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetSaleTypeInfo().
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> |
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 TablesInfo.GetSaleTypeInfo().
UpdatedCount
Field 'updatedCount' in table 'SaleType': Dictionary type UShort, .NET type: short
Number of updates made to this recordDeclaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetSaleTypeInfo().