Class DBC.QuoteAlternativeFields

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

Inheritance
Object
DBC.QuoteAlternativeFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class QuoteAlternativeFields

Fields

Description

QuoteAlternative.Description: The tool-tip to use in the user interface (on the tab, for instance).

Declaration
public const string Description = "Description"
Field Value
Type Description
String

DiscountAmount

QuoteAlternative.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 const string DiscountAmount = "DiscountAmount"
Field Value
Type Description
String

DiscountPercent

QuoteAlternative.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 const string DiscountPercent = "DiscountPercent"
Field Value
Type Description
String

EarningAmount

QuoteAlternative.EarningAmount: Earning on this alternative, as an absolute amount

Declaration
public const string EarningAmount = "EarningAmount"
Field Value
Type Description
String

EarningPercent

QuoteAlternative.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 const string EarningPercent = "EarningPercent"
Field Value
Type Description
String

ERPDiscountAmount

QuoteAlternative.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 const string ERPDiscountAmount = "ERPDiscountAmount"
Field Value
Type Description
String

ERPDiscountPercent

QuoteAlternative.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 const string ERPDiscountPercent = "ERPDiscountPercent"
Field Value
Type Description
String

ERPQuoteAlternativeKey

QuoteAlternative.ERPQuoteAlternativeKey: Key that identifies this alternative in the ERP system, if it exists there.

Declaration
public const string ERPQuoteAlternativeKey = "ERPQuoteAlternativeKey"
Field Value
Type Description
String

ExtraField1

QuoteAlternative.ExtraField1: Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public const string ExtraField1 = "extraField1"
Field Value
Type Description
String

ExtraField2

QuoteAlternative.ExtraField2: Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public const string ExtraField2 = "extraField2"
Field Value
Type Description
String

ExtraField3

QuoteAlternative.ExtraField3: Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public const string ExtraField3 = "extraField3"
Field Value
Type Description
String

ExtraField4

QuoteAlternative.ExtraField4: Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public const string ExtraField4 = "extraField4"
Field Value
Type Description
String

ExtraField5

QuoteAlternative.ExtraField5: Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public const string ExtraField5 = "extraField5"
Field Value
Type Description
String

Name

QuoteAlternative.Name: Name of Alternative. Shown in tab in user interface, intentionally kept short

Declaration
public const string Name = "Name"
Field Value
Type Description
String

QuoteAlternativeId

QuoteAlternative.QuoteAlternativeId: Primary key

Declaration
public const string QuoteAlternativeId = "quotealternative_id"
Field Value
Type Description
String

QuoteVersionId

QuoteAlternative.QuoteVersionId: The version that owns this alternative (the chain is Sale 1->1 Quote 1->+ QuoteVersion 1->+ QuoteAlternative.

Declaration
public const string QuoteVersionId = "QuoteVersionId"
Field Value
Type Description
String

Reason

QuoteAlternative.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 const string Reason = "Reason"
Field Value
Type Description
String

Registered

QuoteAlternative.Registered: Registered when

Declaration
public const string Registered = "registered"
Field Value
Type Description
String

RegisteredAssociateId

QuoteAlternative.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
String

Status

QuoteAlternative.Status: If there was a problem with for instance calculation, this field is set to warning or error.

Declaration
public const string Status = "Status"
Field Value
Type Description
String

TotalPrice

QuoteAlternative.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 const string TotalPrice = "TotalPrice"
Field Value
Type Description
String

Updated

QuoteAlternative.Updated: Last updated when

Declaration
public const string Updated = "updated"
Field Value
Type Description
String

UpdatedAssociateId

QuoteAlternative.UpdatedAssociateId: Last updated by whom

Declaration
public const string UpdatedAssociateId = "updated_associate_id"
Field Value
Type Description
String

UpdatedCount

QuoteAlternative.UpdatedCount: Number of updates made to this record

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
String

UserValueOverride

QuoteAlternative.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 const string UserValueOverride = "UserValueOverride"
Field Value
Type Description
String

VAT

QuoteAlternative.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 const string VAT = "VAT"
Field Value
Type Description
String

VATInfo

QuoteAlternative.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 const string VATInfo = "VATInfo"
Field Value
Type Description
String