Class QuoteLineRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the QuoteLine table.

Inheritance
object
QuoteLineRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class QuoteLineRecordData
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

QuoteLineRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the QuoteLine table.

Declaration
public QuoteLineRecordData()
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

Code

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 string Code
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

DeliveredQuantity

How many units have been delivered - updated by ERP system.

Declaration
public double DeliveredQuantity
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Description

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 string Description
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

DiscountAmount

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 double DiscountAmount
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

DiscountPercent

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 double DiscountPercent
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ERPDiscountAmount

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 double ERPDiscountAmount
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ERPDiscountPercent

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 double ERPDiscountPercent
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ERPProductKey

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 string ERPProductKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ERPQuoteLineKey

The foreign key to the quoteline in ERP system (if it has such a representation).

Declaration
public string ERPQuoteLineKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

EarningAmount

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 double EarningAmount
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

EarningPercent

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 double EarningPercent
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraField1

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.

Declaration
public string ExtraField1
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraField2

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.

Declaration
public string ExtraField2
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraField3

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.

Declaration
public string ExtraField3
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraField4

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.

Declaration
public string ExtraField4
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraField5

This a simple field for adding information that the Connector can provide, and that the qoute document need to display.

Declaration
public string ExtraField5
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraInfo

Extra information, supplied by QuoteConnector, used by a future dynamic GUI extension

Declaration
public string ExtraInfo
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

IsSubscription

Is this a subscription product, sold in repeating intervals/amounts?

Declaration
public short IsSubscription
Field Value
Type Description
short
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ItemNumber

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 string ItemNumber
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Name

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 string Name
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

PriceUnit

What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); read-only for lines that originate in defined products.

Declaration
public string PriceUnit
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProductCategoryKey

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 string ProductCategoryKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProductFamilyKey

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 string ProductFamilyKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProductTypeKey

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 string ProductTypeKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Quantity

How many units; this is a decimal field since you might want to offer fractional units (2.5kg, or 0.5PC).

Declaration
public double Quantity
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

QuantityUnit

What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); Connector handles conversion relative to PriceUnit if they are different.

Declaration
public string QuantityUnit
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

QuoteAlternativeId

The alternative this line is part of, the conceptual Parent in CRM database.

Declaration
public int QuoteAlternativeId
Field Value
Type Description
int
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

QuoteLineId

Primary key

Declaration
public int QuoteLineId
Field Value
Type Description
int
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rank

QuoteLines can be re-ordered, so we must track the ordering.

Declaration
public int Rank
Field Value
Type Description
int
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Reason

If QuoteStatus is not OK, then this field contains a localized explanation that the user can be shown.

Declaration
public string Reason
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Registered

Registered when in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rights

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 string Rights
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rule

The names of one or more calculation rules that are in effect for this line, comma-separated case-insensitive

Declaration
public string Rule
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Status

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 QuoteStatus Status
Field Value
Type Description
QuoteStatus
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SubscriptionQuantity

The default number of SubscriptionUnits to suggest when creating quote lines from this product

Declaration
public double SubscriptionQuantity
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SubscriptionStart

Start date for subscription, as offered

Declaration
public DateTime SubscriptionStart
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SubscriptionUnit

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 string SubscriptionUnit
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Supplier

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 string Supplier
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SupplierCode

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 string SupplierCode
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TotalPrice

TotalPrice = SubTotal - DiscountAmount or TotalPrice = (UnitCost * Quantity) + EarningAmount, according to what the user changed last.

Declaration
public double TotalPrice
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UnitCost

The cost price per unit for this product. May be filled in by connector if it has the Provide-Cost capability.

Declaration
public double UnitCost
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UnitListPrice

The standard list price; as given by ERP Connector, OR overridden by user

Declaration
public double UnitListPrice
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UnitMinimumPrice

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 double UnitMinimumPrice
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Updated

Last updated when in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Url

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 string Url
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UserValueOverride

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 ValueOverride UserValueOverride
Field Value
Type Description
ValueOverride
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

VAT

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 double VAT
Field Value
Type Description
double
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

VATInfo

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 string VATInfo
Field Value
Type Description
string
Remarks

Please use this class instead of a full QuoteLineRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding QuoteLineTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods