Class QuoteAlternativeRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the QuoteAlternative table.
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class QuoteAlternativeRecordData : ObjectRemarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Constructors
QuoteAlternativeRecordData()
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the QuoteAlternative table.
Declaration
public QuoteAlternativeRecordData()Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Fields
Description
The tool-tip to use in the user interface (on the tab, for instance).
Declaration
public string DescriptionField Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
DiscountAmount
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 double DiscountAmountField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
DiscountPercent
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 double DiscountPercentField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
EarningAmount
Earning on this alternative, as an absolute amount
Declaration
public double EarningAmountField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
EarningPercent
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 double EarningPercentField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 /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 double ERPDiscountAmountField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 /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 double ERPDiscountPercentField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ERPQuoteAlternativeKey
Key that identifies this alternative in the ERP system, if it exists there.
Declaration
public string ERPQuoteAlternativeKeyField Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ExtraField1
Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public string ExtraField1Field Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ExtraField2
Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public string ExtraField2Field Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ExtraField3
Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public string ExtraField3Field Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ExtraField4
Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public string ExtraField4Field Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ExtraField5
Optional information added by Quote Connector; usable in the quote document merge process
Declaration
public string ExtraField5Field Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Name
Name of Alternative. Shown in tab in user interface, intentionally kept short
Declaration
public string NameField Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
QuoteAlternativeId
Primary key
Declaration
public int QuoteAlternativeIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
QuoteVersionId
The version that owns this alternative (the chain is Sale 1->1 Quote 1->+ QuoteVersion 1->+ QuoteAlternative.
Declaration
public int QuoteVersionIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Reason
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 string ReasonField Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 RegisteredField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 RegisteredAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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.
Declaration
public QuoteStatus StatusField Value
| Type | Description |
|---|---|
| QuoteStatus |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
TotalPrice
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 double TotalPriceField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 UpdatedField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 UpdatedAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 UpdatedCountField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 UserValueOverrideField Value
| Type | Description |
|---|---|
| ValueOverride |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo 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 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 double VATField Value
| Type | Description |
|---|---|
| Double |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
VATInfo
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 string VATInfoField Value
| Type | Description |
|---|---|
| String |
Remarks
Please use this class instead of a full QuoteAlternativeRow 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 QuoteAlternativeTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.