Class QuoteLineTableInfo

Table 'QuoteLine': One line in a QuoteAlternative. QuoteLines are mainly information copied from the Products provider. Products information is sometimes edited by the user before being included in the quote, so most information is duplicated from Product rather than referenced directly.

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

Fields

DictionaryTableName

Conceptual name of table QuoteLine in the database dictionary: QuoteLine

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

Properties

Code

Field 'Code' in table 'QuoteLine': Dictionary type String[255], .NET type: string

A value the salesmen use to quickly find the correct product. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo Code { 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.GetQuoteLineInfo().

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

DeliveredQuantity

Field 'DeliveredQuantity' in table 'QuoteLine': Dictionary type Double, .NET type: double

How many units have been delivered - updated by ERP system.
Declaration
public DoubleFieldInfo DeliveredQuantity { 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.GetQuoteLineInfo().

Description

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

A longer description for the product. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
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.GetQuoteLineInfo().

DictionaryTableNumber

Table number for table QuoteLine 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.GetQuoteLineInfo().

DiscountAmount

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

The discount for the line, in whatever currency the sale is in. Both ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed last. If this field is filled out by the user, it overrides any discount suggested by the connector. If the user has not filled this in, the system will copy the ERP discount amount to 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.GetQuoteLineInfo().

DiscountPercent

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

The discount for the line, in percent. Both ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed last. If this field is filled out by the user, it overrides any discount suggested by the connector. If the user has not filled this in, the system will copy the ERP discount amount to 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.GetQuoteLineInfo().

ERPDiscountAmount

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

The discount the system calculates based on customer / quantity / whatever. Can be overrided by the salesman in the field 'DiscountPercent' or 'DiscountAmount'. If UserValueOverride is set to ‘None’ then the value is copied to DiscountAmount. Both fields ERPDiscountPercent and ERPDiscountAmount will be filled out.
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.GetQuoteLineInfo().

ERPDiscountPercent

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

The discount the system calculates based on customer / quantity / whatever. Can be overrided by the salesman in the field 'DiscountPercent' or 'DiscountAmount'. Both fields ERPDiscountPercent and ERPDiscountAmount will be filled out. If UserValueOverride is set to ‘None’ then the value is copied to 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.GetQuoteLineInfo().

ERPProductKey

Field 'ERPProductKey' in table 'QuoteLine': Dictionary type String[255], .NET type: string

Foreign key of product+pricelist this line is based on. Can be blank since the QuoteLine doesn’t have to be connected to a product.
Declaration
public StringFieldInfo ERPProductKey { 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.GetQuoteLineInfo().

ERPQuoteLineKey

Field 'ERPQuoteLineKey' in table 'QuoteLine': Dictionary type String[255], .NET type: string

The foreign key to the quoteline in ERP system (if it has such a representation).
Declaration
public StringFieldInfo ERPQuoteLineKey { 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.GetQuoteLineInfo().

EarningAmount

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

The earning, in whatever currency the sale is in. Both ‘EarningAmount and ‘EarningPercent shall be filled out, but the UserValueOverride field must be set to the field the user actually changed last.
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.GetQuoteLineInfo().

EarningPercent

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

The earning, in percent. Both ‘EarningAmount and ‘EarningPercent shall be filled out, but the UserValueOverride field must be set to the field the user actually changed last. 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.GetQuoteLineInfo().

ExtraField1

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

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
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.GetQuoteLineInfo().

ExtraField2

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

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
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.GetQuoteLineInfo().

ExtraField3

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

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
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.GetQuoteLineInfo().

ExtraField4

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

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
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.GetQuoteLineInfo().

ExtraField5

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

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
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.GetQuoteLineInfo().

ExtraInfo

Field 'ExtraInfo' in table 'QuoteLine': Dictionary type Clob, .NET type: string

Extra information, supplied by QuoteConnector, used by a future dynamic GUI extension
Declaration
public StringFieldInfo ExtraInfo { 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.GetQuoteLineInfo().

IsSubscription

Field 'IsSubscription' in table 'QuoteLine': Dictionary type Bool, .NET type: short

Is this a subscription product, sold in repeating intervals/amounts?
Declaration
public UInt16FieldInfo IsSubscription { 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.GetQuoteLineInfo().

ItemNumber

Field 'ItemNumber' in table 'QuoteLine': Dictionary type String[80], .NET type: string

Norwegian: «Postnummer». Specific numbers from some hierarchy, for instance '1.4.3.2'. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo ItemNumber { 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.GetQuoteLineInfo().

Name

Field 'Name' in table 'QuoteLine': Dictionary type String[255], .NET type: string

The name of the product. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
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.GetQuoteLineInfo().

PriceUnit

Field 'PriceUnit' in table 'QuoteLine': Dictionary type String[80], .NET type: string

What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); read-only for lines that originate in defined products.
Declaration
public StringFieldInfo PriceUnit { 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.GetQuoteLineInfo().

ProductCategoryKey

Field 'ProductCategoryKey' in table 'QuoteLine': Dictionary type String[255], .NET type: string

Either a List id to an id from a connector provided list, or, if the connection doesn't support lists, a text. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo ProductCategoryKey { 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.GetQuoteLineInfo().

ProductFamilyKey

Field 'ProductFamilyKey' in table 'QuoteLine': Dictionary type String[255], .NET type: string

Either a List id to an id from a connector provided list, or, if the connection doesn't support lists, a text. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo ProductFamilyKey { 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.GetQuoteLineInfo().

ProductTypeKey

Field 'ProductTypeKey' in table 'QuoteLine': Dictionary type String[255], .NET type: string

Either a List id to an id from a connector provided list, or, if the connection doesn't support lists, a text. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo ProductTypeKey { 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.GetQuoteLineInfo().

Quantity

Field 'Quantity' in table 'QuoteLine': Dictionary type Double, .NET type: double

How many units; this is a decimal field since you might want to offer fractional units (2.5kg, or 0.5PC).
Declaration
public DoubleFieldInfo Quantity { 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.GetQuoteLineInfo().

QuantityUnit

Field 'QuantityUnit' in table 'QuoteLine': Dictionary type String[80], .NET type: string

What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); Connector handles conversion relative to PriceUnit if they are different.
Declaration
public StringFieldInfo QuantityUnit { 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.GetQuoteLineInfo().

QuoteAlternativeId

Field 'QuoteAlternativeId' in table 'QuoteLine': Dictionary type FK, target: QuoteAlternative, .NET type: int

The alternative this line is part of, the conceptual Parent in CRM database.
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.GetQuoteLineInfo().

QuoteAlternativeId_InnerJoin_QuoteAlternative

Generated join from the foreign key QuoteAlternativeId in this table, to its target table QuoteAlternativeTableInfo.

Declaration
public TargetedInnerJoin<QuoteAlternativeTableInfo> QuoteAlternativeId_InnerJoin_QuoteAlternative { get; }
Property Value
Type Description
TargetedInnerJoin<QuoteAlternativeTableInfo>
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.GetQuoteLineInfo().

QuoteLineId

Field 'quoteline_id' in table 'QuoteLine': Dictionary type PK, .NET type: int

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

Rank

Field 'Rank' in table 'QuoteLine': Dictionary type Int, .NET type: int

QuoteLines can be re-ordered, so we must track the ordering.
Declaration
public Int32FieldInfo Rank { 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.GetQuoteLineInfo().

Reason

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

If QuoteStatus is not OK, then this field contains a localized explanation 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.GetQuoteLineInfo().

Registered

Field 'registered' in table 'QuoteLine': 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.GetQuoteLineInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'QuoteLine': 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.GetQuoteLineInfo().

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

Rights

Field 'Rights' in table 'QuoteLine': Dictionary type String[2048], .NET type: string

Field1=right&Field2=right, etc. of any fields that have non-standard field access rights. Rights can be one of: N (=None or Hidden), R (=Read-only), W (=Writeable), M (=Mandatory). The fields will mostly be from the Quoteline table, but some added fields that are conceptually part of the quoteline, like Image will also be possibly to set rights on. Will be used by SuperOffice to control the user interface when showing the record.
Declaration
public StringFieldInfo Rights { 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.GetQuoteLineInfo().

Rule

Field 'Rule' in table 'QuoteLine': Dictionary type String[255], .NET type: string

The names of one or more calculation rules that are in effect for this line, comma-separated case-insensitive
Declaration
public StringFieldInfo Rule { 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.GetQuoteLineInfo().

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

Status

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

If there was a problem with for instance calculation, this field is set to warning or error. Typically shown as an icon. QuoteStatus is an enum with statuses: OK, OKWithInfo, Warning, 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.GetQuoteLineInfo().

SubscriptionQuantity

Field 'SubscriptionQuantity' in table 'QuoteLine': Dictionary type Double, .NET type: double

The default number of SubscriptionUnits to suggest when creating quote lines from this product
Declaration
public DoubleFieldInfo SubscriptionQuantity { 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.GetQuoteLineInfo().

SubscriptionStart

Field 'SubscriptionStart' in table 'QuoteLine': Dictionary type DateTime, .NET type: DateTime

Start date for subscription, as offered
Declaration
public DateTimeFieldInfo SubscriptionStart { 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.GetQuoteLineInfo().

SubscriptionUnit

Field 'SubscriptionUnit' in table 'QuoteLine': Dictionary type String[255], .NET type: string

Either a List id to an id from a connector provided list, or, if the connection doesn’t support lists, a text with the actual subscription unit.
Declaration
public StringFieldInfo SubscriptionUnit { 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.GetQuoteLineInfo().

Supplier

Field 'Supplier' in table 'QuoteLine': Dictionary type String[255], .NET type: string

The name of the supplier. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo Supplier { 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.GetQuoteLineInfo().

SupplierCode

Field 'SupplierCode' in table 'QuoteLine': Dictionary type String[255], .NET type: string

The suppliers' code or part number for this product. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo SupplierCode { 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.GetQuoteLineInfo().

TotalPrice

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

TotalPrice = SubTotal - DiscountAmount or TotalPrice = (UnitCost * Quantity) + EarningAmount, according to what the user changed last.
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.GetQuoteLineInfo().

UnitCost

Field 'UnitCost' in table 'QuoteLine': Dictionary type Double, .NET type: double

The cost price per unit for this product. May be filled in by connector if it has the Provide-Cost capability.
Declaration
public DoubleFieldInfo UnitCost { 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.GetQuoteLineInfo().

UnitListPrice

Field 'UnitListPrice' in table 'QuoteLine': Dictionary type Double, .NET type: double

The standard list price; as given by ERP Connector, OR overridden by user
Declaration
public DoubleFieldInfo UnitListPrice { 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.GetQuoteLineInfo().

UnitMinimumPrice

Field 'UnitMinimumPrice' in table 'QuoteLine': Dictionary type Double, .NET type: double

The minimum price this line can be sold for (to limit discounting). Will come from the connector. List price per unit must exceed the minimum price per unit.
Declaration
public DoubleFieldInfo UnitMinimumPrice { 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.GetQuoteLineInfo().

Updated

Field 'updated' in table 'QuoteLine': 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.GetQuoteLineInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'QuoteLine': 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.GetQuoteLineInfo().

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

UpdatedCount

Field 'updatedCount' in table 'QuoteLine': 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.GetQuoteLineInfo().

Url

Field 'Url' in table 'QuoteLine': Dictionary type String[1024], .NET type: string

A url to the product info. Can be empty. Is stored here if the user changes the value from the product in the pricelist, or just enters a QuoteLine without a product link.
Declaration
public StringFieldInfo Url { 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.GetQuoteLineInfo().

UserValueOverride

Field 'UserValueOverride' in table 'QuoteLine': 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.GetQuoteLineInfo().

VAT

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

Tax/VAT - THIS IS A PERCENTAGE. The connector is responsible for populating this field; the percentage will be used to calculate VAT amounts available as merge fields in the document templates (but amounts are never stored in the database).
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.GetQuoteLineInfo().

VATInfo

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

Tax/VAT information, Extra info about VAT that the connector might insert, and the users might want to specify on the quote. The core CRM product has no business logic for this field, it is wholly up to connectors to use it.
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.GetQuoteLineInfo().

Implements

Extension Methods