Class QuoteAlternativeTableInfo

Table 'QuoteAlternative': Quote Version is made up of one or more Alternatives. One of 1..n possible alternatives in a Quote Version. The reason we have alternatives is that a quote can say to a customer, “we can solve you problem in two (or more) different ways, with different technology and sideeffects (and price)”. An Alternative may have discounts on the total amount. The Alternative tracks whether the user on the order level entered the Discount , Earning amount or the TotalPrice fields so that the discount and earning and total can be re-calculated correctly when Quote Lines are added or changed.

Inheritance
object
TableInfo
QuoteAlternativeTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("QuoteAlternative")]
public class QuoteAlternativeTableInfo : 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.GetQuoteAlternativeInfo().

Fields

DictionaryTableName

Conceptual name of table QuoteAlternative in the database dictionary: QuoteAlternative

Declaration
public const string DictionaryTableName = "QuoteAlternative"
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.GetQuoteAlternativeInfo().

Properties

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.GetQuoteAlternativeInfo().

Description

Field 'Description' in table 'QuoteAlternative': Dictionary type String[2048], .NET type: string

The tool-tip to use in the user interface (on the tab, for instance).
Declaration
public StringFieldInfo Description { 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.GetQuoteAlternativeInfo().

DictionaryTableNumber

Table number for table QuoteAlternative 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.GetQuoteAlternativeInfo().

DiscountAmount

Field 'DiscountAmount' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

The discount the sales rep specifies, in whatever currency the sale is in. Both the two ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed. If this field is filled out by the user, it overrides the discount suggested by the connector. If the user has not filled any values, the system will copy the ERP discount amount value into this field.
Declaration
public DoubleFieldInfo DiscountAmount { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

DiscountPercent

Field 'DiscountPercent' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

The discount the sales rep specifies, in percent. Both the two ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed. If this field is filled out by the user, it overrides the discount suggested by the connector. If the user has not filled any values, the system will copy the ERP discount percent value into this field. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’.
Declaration
public DoubleFieldInfo DiscountPercent { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

ERPDiscountAmount

Field 'ERPDiscountAmount' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

The discount the system calculates based on customer /amount / whatever. Can be overridden by the user in the field ‘DiscountPercent’ or ‘DiscountAmount’. Both the two ‘ERPDiscountPercent’ and ‘ERPDiscountAmount’ shall be filled out. If UserValueOverride is 'None', then the ERPDiscountAmount shall be copied into DiscountAmount and ERPDiscountPercent into DiscountPercent.
Declaration
public DoubleFieldInfo ERPDiscountAmount { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

ERPDiscountPercent

Field 'ERPDiscountPercent' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

The discount the system calculates based on customer /amount / whatever. Can be overridden by the sales rep in the field ‘DiscountPercent’ or ‘DiscountAmount’. Both the two ‘ERPDiscountPercent’ and ‘ERPDiscountAmount’ shall be filled out. If UserValueOverride is 'None', then the ERPDiscountAmount shall be copied into DiscountAmount and ERPDiscountPercent into DiscountPercent. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’.
Declaration
public DoubleFieldInfo ERPDiscountPercent { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

ERPQuoteAlternativeKey

Field 'ERPQuoteAlternativeKey' in table 'QuoteAlternative': Dictionary type String[255], .NET type: string

Key that identifies this alternative in the ERP system, if it exists there.
Declaration
public StringFieldInfo ERPQuoteAlternativeKey { 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.GetQuoteAlternativeInfo().

EarningAmount

Field 'EarningAmount' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

Earning on this alternative, as an absolute amount
Declaration
public DoubleFieldInfo EarningAmount { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

EarningPercent

Field 'EarningPercent' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

The earning on this alternative, in percent of total. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’.
Declaration
public DoubleFieldInfo EarningPercent { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

ExtraField1

Field 'extraField1' in table 'QuoteAlternative': Dictionary type String[1024], .NET type: string

Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public StringFieldInfo ExtraField1 { 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.GetQuoteAlternativeInfo().

ExtraField2

Field 'extraField2' in table 'QuoteAlternative': Dictionary type String[1024], .NET type: string

Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public StringFieldInfo ExtraField2 { 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.GetQuoteAlternativeInfo().

ExtraField3

Field 'extraField3' in table 'QuoteAlternative': Dictionary type String[1024], .NET type: string

Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public StringFieldInfo ExtraField3 { 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.GetQuoteAlternativeInfo().

ExtraField4

Field 'extraField4' in table 'QuoteAlternative': Dictionary type String[1024], .NET type: string

Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public StringFieldInfo ExtraField4 { 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.GetQuoteAlternativeInfo().

ExtraField5

Field 'extraField5' in table 'QuoteAlternative': Dictionary type String[1024], .NET type: string

Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public StringFieldInfo ExtraField5 { 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.GetQuoteAlternativeInfo().

LeftOuterJoin_QuoteLine_QuoteAlternativeId

Generated left outer join from the primary key QuoteAlternativeId on this table, to QuoteLine.QuoteAlternativeId.

Declaration
public TargetedLeftOuterJoin<QuoteLineTableInfo> LeftOuterJoin_QuoteLine_QuoteAlternativeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteLineTableInfo>
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.GetQuoteAlternativeInfo().

LeftOuterJoin_QuoteVersion_LikelyQuoteAlternativeId

Generated left outer join from the primary key QuoteAlternativeId on this table, to QuoteVersion.LikelyQuoteAlternativeId.

Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_LikelyQuoteAlternativeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteVersionTableInfo>
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.GetQuoteAlternativeInfo().

LeftOuterJoin_Quote_AcceptedQuoteAlternativeId

Generated left outer join from the primary key QuoteAlternativeId on this table, to Quote.AcceptedQuoteAlternativeId.

Declaration
public TargetedLeftOuterJoin<QuoteTableInfo> LeftOuterJoin_Quote_AcceptedQuoteAlternativeId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteTableInfo>
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.GetQuoteAlternativeInfo().

Name

Field 'Name' in table 'QuoteAlternative': Dictionary type String[60], .NET type: string

Name of Alternative. Shown in tab in user interface, intentionally kept short
Declaration
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.GetQuoteAlternativeInfo().

QuoteAlternativeId

Field 'quotealternative_id' in table 'QuoteAlternative': Dictionary type PK, .NET type: int

Primary key
Declaration
public Int32FieldInfo QuoteAlternativeId { 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.GetQuoteAlternativeInfo().

QuoteVersionId

Field 'QuoteVersionId' in table 'QuoteAlternative': Dictionary type FK, target: QuoteVersion, .NET type: int

The version that owns this alternative (the chain is Sale 1->1 Quote 1->+ QuoteVersion 1->+ QuoteAlternative.
Declaration
public Int32FieldInfo QuoteVersionId { 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.GetQuoteAlternativeInfo().

QuoteVersionId_InnerJoin_QuoteVersion

Generated join from the foreign key QuoteVersionId in this table, to its target table QuoteVersionTableInfo.

Declaration
public TargetedInnerJoin<QuoteVersionTableInfo> QuoteVersionId_InnerJoin_QuoteVersion { get; }
Property Value
Type Description
TargetedInnerJoin<QuoteVersionTableInfo>
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.GetQuoteAlternativeInfo().

Reason

Field 'Reason' in table 'QuoteAlternative': Dictionary type String[2048], .NET type: string

If there was a problem, this field contains a localized explanation of the problem and possible steps to fix it that the user can be shown.
Declaration
public StringFieldInfo Reason { 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.GetQuoteAlternativeInfo().

Registered

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

Registered when
Declaration
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.GetQuoteAlternativeInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'QuoteAlternative': Dictionary type FK, target: Associate, .NET type: int

Registered by whom
Declaration
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.GetQuoteAlternativeInfo().

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.GetQuoteAlternativeInfo().

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.GetQuoteAlternativeInfo().

Status

Field 'Status' in table 'QuoteAlternative': Dictionary type Enum, .NET type: QuoteStatus

If there was a problem with for instance calculation, this field is set to warning or error.
Declaration
public QuoteStatusFieldInfo Status { get; }
Property Value
Type Description
QuoteStatusFieldInfo
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.GetQuoteAlternativeInfo().

TotalPrice

Field 'TotalPrice' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

Sum of the QuoteLines.TotalPrice - AlternativeDiscount or QuoteLines.TotalCost + Earning based on what, if anything, the user has entered last. Shall be calculated by the connector.
Declaration
public DoubleFieldInfo TotalPrice { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

Updated

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

Last updated when
Declaration
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.GetQuoteAlternativeInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'QuoteAlternative': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom
Declaration
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.GetQuoteAlternativeInfo().

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.GetQuoteAlternativeInfo().

UpdatedCount

Field 'updatedCount' in table 'QuoteAlternative': Dictionary type UShort, .NET type: short

Number of updates made to this record
Declaration
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.GetQuoteAlternativeInfo().

UserValueOverride

Field 'UserValueOverride' in table 'QuoteAlternative': Dictionary type Enum, .NET type: ValueOverride

Has the pre-calculated (from ERP) price information been overridden, and how. If the user has filled out the discountpercentage field, then the UserValueOverride field is set to OverridePercent. (The DiscountAmount, EarningPercent, EarningAmount and TotalPrice fields are calculated based on the discountPercent.)
Declaration
public ValueOverrideFieldInfo UserValueOverride { get; }
Property Value
Type Description
ValueOverrideFieldInfo
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.GetQuoteAlternativeInfo().

VAT

Field 'VAT' in table 'QuoteAlternative': Dictionary type Double, .NET type: double

Tax/VAT - THIS IS AN AMOUNT, available as a merge field in the quote document. The SuperOffice quote connector will calculate this field based on the vat PERCENTAGES on the individual lines; other connectors may implement other algorithms at will.
Declaration
public DoubleFieldInfo VAT { get; }
Property Value
Type Description
DoubleFieldInfo
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.GetQuoteAlternativeInfo().

VATInfo

Field 'VATInfo' in table 'QuoteAlternative': Dictionary type String[255], .NET type: string

Extra info about VAT that the connector might insert. This field has no business logic in the CRM code, but is available as a merge field in the quote documents.
Declaration
public StringFieldInfo VATInfo { 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.GetQuoteAlternativeInfo().

Implements

Extension Methods