Class DBC.QuoteLineFields
Fields for 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.
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class QuoteLineFields : ObjectFields
Code
QuoteLine.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 const string Code = "Code"Field Value
| Type | Description |
|---|---|
| String |
DeliveredQuantity
QuoteLine.DeliveredQuantity: How many units have been delivered - updated by ERP system.
Declaration
public const string DeliveredQuantity = "DeliveredQuantity"Field Value
| Type | Description |
|---|---|
| String |
Description
QuoteLine.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 const string Description = "Description"Field Value
| Type | Description |
|---|---|
| String |
DiscountAmount
QuoteLine.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 const string DiscountAmount = "DiscountAmount"Field Value
| Type | Description |
|---|---|
| String |
DiscountPercent
QuoteLine.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 const string DiscountPercent = "DiscountPercent"Field Value
| Type | Description |
|---|---|
| String |
EarningAmount
QuoteLine.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 const string EarningAmount = "EarningAmount"Field Value
| Type | Description |
|---|---|
| String |
EarningPercent
QuoteLine.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 const string EarningPercent = "EarningPercent"Field Value
| Type | Description |
|---|---|
| String |
ERPDiscountAmount
QuoteLine.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 const string ERPDiscountAmount = "ERPDiscountAmount"Field Value
| Type | Description |
|---|---|
| String |
ERPDiscountPercent
QuoteLine.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 const string ERPDiscountPercent = "ERPDiscountPercent"Field Value
| Type | Description |
|---|---|
| String |
ERPProductKey
QuoteLine.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 const string ERPProductKey = "ERPProductKey"Field Value
| Type | Description |
|---|---|
| String |
ERPQuoteLineKey
QuoteLine.ERPQuoteLineKey: The foreign key to the quoteline in ERP system (if it has such a representation).
Declaration
public const string ERPQuoteLineKey = "ERPQuoteLineKey"Field Value
| Type | Description |
|---|---|
| String |
ExtraField1
QuoteLine.ExtraField1: This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
Declaration
public const string ExtraField1 = "extraField1"Field Value
| Type | Description |
|---|---|
| String |
ExtraField2
QuoteLine.ExtraField2: This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
Declaration
public const string ExtraField2 = "extraField2"Field Value
| Type | Description |
|---|---|
| String |
ExtraField3
QuoteLine.ExtraField3: This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
Declaration
public const string ExtraField3 = "extraField3"Field Value
| Type | Description |
|---|---|
| String |
ExtraField4
QuoteLine.ExtraField4: This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
Declaration
public const string ExtraField4 = "extraField4"Field Value
| Type | Description |
|---|---|
| String |
ExtraField5
QuoteLine.ExtraField5: This a simple field for adding information that the Connector can provide, and that the qoute document need to display.
Declaration
public const string ExtraField5 = "extraField5"Field Value
| Type | Description |
|---|---|
| String |
ExtraInfo
QuoteLine.ExtraInfo: Extra information, supplied by QuoteConnector, used by a future dynamic GUI extension
Declaration
public const string ExtraInfo = "ExtraInfo"Field Value
| Type | Description |
|---|---|
| String |
IsSubscription
QuoteLine.IsSubscription: Is this a subscription product, sold in repeating intervals/amounts?
Declaration
public const string IsSubscription = "IsSubscription"Field Value
| Type | Description |
|---|---|
| String |
ItemNumber
QuoteLine.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 const string ItemNumber = "ItemNumber"Field Value
| Type | Description |
|---|---|
| String |
Name
QuoteLine.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 const string Name = "Name"Field Value
| Type | Description |
|---|---|
| String |
PriceUnit
QuoteLine.PriceUnit: What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); read-only for lines that originate in defined products.
Declaration
public const string PriceUnit = "PriceUnit"Field Value
| Type | Description |
|---|---|
| String |
ProductCategoryKey
QuoteLine.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 const string ProductCategoryKey = "ProductCategoryKey"Field Value
| Type | Description |
|---|---|
| String |
ProductFamilyKey
QuoteLine.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 const string ProductFamilyKey = "ProductFamilyKey"Field Value
| Type | Description |
|---|---|
| String |
ProductTypeKey
QuoteLine.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 const string ProductTypeKey = "ProductTypeKey"Field Value
| Type | Description |
|---|---|
| String |
Quantity
QuoteLine.Quantity: How many units; this is a decimal field since you might want to offer fractional units (2.5kg, or 0.5PC).
Declaration
public const string Quantity = "Quantity"Field Value
| Type | Description |
|---|---|
| String |
QuantityUnit
QuoteLine.QuantityUnit: What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); Connector handles conversion relative to PriceUnit if they are different.
Declaration
public const string QuantityUnit = "QuantityUnit"Field Value
| Type | Description |
|---|---|
| String |
QuoteAlternativeId
QuoteLine.QuoteAlternativeId: The alternative this line is part of, the conceptual Parent in CRM database.
Declaration
public const string QuoteAlternativeId = "QuoteAlternativeId"Field Value
| Type | Description |
|---|---|
| String |
QuoteLineId
QuoteLine.QuoteLineId: Primary key
Declaration
public const string QuoteLineId = "quoteline_id"Field Value
| Type | Description |
|---|---|
| String |
Rank
QuoteLine.Rank: QuoteLines can be re-ordered, so we must track the ordering.
Declaration
public const string Rank = "Rank"Field Value
| Type | Description |
|---|---|
| String |
Reason
QuoteLine.Reason: If QuoteStatus is not OK, then this field contains a localized explanation that the user can be shown.
Declaration
public const string Reason = "Reason"Field Value
| Type | Description |
|---|---|
| String |
Registered
QuoteLine.Registered: Registered when
Declaration
public const string Registered = "registered"Field Value
| Type | Description |
|---|---|
| String |
RegisteredAssociateId
QuoteLine.RegisteredAssociateId: Registered by whom
Declaration
public const string RegisteredAssociateId = "registered_associate_id"Field Value
| Type | Description |
|---|---|
| String |
Rights
QuoteLine.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 const string Rights = "Rights"Field Value
| Type | Description |
|---|---|
| String |
Rule
QuoteLine.Rule: The names of one or more calculation rules that are in effect for this line, comma-separated case-insensitive
Declaration
public const string Rule = "Rule"Field Value
| Type | Description |
|---|---|
| String |
Status
QuoteLine.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 const string Status = "Status"Field Value
| Type | Description |
|---|---|
| String |
SubscriptionQuantity
QuoteLine.SubscriptionQuantity: The default number of SubscriptionUnits to suggest when creating quote lines from this product
Declaration
public const string SubscriptionQuantity = "SubscriptionQuantity"Field Value
| Type | Description |
|---|---|
| String |
SubscriptionStart
QuoteLine.SubscriptionStart: Start date for subscription, as offered
Declaration
public const string SubscriptionStart = "SubscriptionStart"Field Value
| Type | Description |
|---|---|
| String |
SubscriptionUnit
QuoteLine.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 const string SubscriptionUnit = "SubscriptionUnit"Field Value
| Type | Description |
|---|---|
| String |
Supplier
QuoteLine.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 const string Supplier = "Supplier"Field Value
| Type | Description |
|---|---|
| String |
SupplierCode
QuoteLine.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 const string SupplierCode = "SupplierCode"Field Value
| Type | Description |
|---|---|
| String |
TotalPrice
QuoteLine.TotalPrice: TotalPrice = SubTotal - DiscountAmount or TotalPrice = (UnitCost * Quantity) + EarningAmount, according to what the user changed last.
Declaration
public const string TotalPrice = "TotalPrice"Field Value
| Type | Description |
|---|---|
| String |
UnitCost
QuoteLine.UnitCost: The cost price per unit for this product. May be filled in by connector if it has the Provide-Cost capability.
Declaration
public const string UnitCost = "UnitCost"Field Value
| Type | Description |
|---|---|
| String |
UnitListPrice
QuoteLine.UnitListPrice: The standard list price; as given by ERP Connector, OR overridden by user
Declaration
public const string UnitListPrice = "UnitListPrice"Field Value
| Type | Description |
|---|---|
| String |
UnitMinimumPrice
QuoteLine.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 const string UnitMinimumPrice = "UnitMinimumPrice"Field Value
| Type | Description |
|---|---|
| String |
Updated
QuoteLine.Updated: Last updated when
Declaration
public const string Updated = "updated"Field Value
| Type | Description |
|---|---|
| String |
UpdatedAssociateId
QuoteLine.UpdatedAssociateId: Last updated by whom
Declaration
public const string UpdatedAssociateId = "updated_associate_id"Field Value
| Type | Description |
|---|---|
| String |
UpdatedCount
QuoteLine.UpdatedCount: Number of updates made to this record
Declaration
public const string UpdatedCount = "updatedCount"Field Value
| Type | Description |
|---|---|
| String |
Url
QuoteLine.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 const string Url = "Url"Field Value
| Type | Description |
|---|---|
| String |
UserValueOverride
QuoteLine.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
QuoteLine.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 const string VAT = "VAT"Field Value
| Type | Description |
|---|---|
| String |
VATInfo
QuoteLine.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 const string VATInfo = "VATInfo"Field Value
| Type | Description |
|---|---|
| String |