Class DBC.ProductFields

Fields for Product, One Product, member of one price list

Inheritance

System.Object

DBC.ProductFields

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class ProductFields

Fields

Code

Product.Code: The product code / article number in the product supplier system.

Declaration

public const string Code = "Code"

Field Value

Type	Description
System.String

DefaultSubscriptionQuantity

Product.DefaultSubscriptionQuantity: The default number of SubscriptionUnits to suggest when creating quote lines from this product

Declaration

public const string DefaultSubscriptionQuantity = "DefaultSubscriptionQuantity"

Field Value

Type	Description
System.String

Description

Product.Description: The description to use, with potentially several lines. Will be used as tool-tip to use in the list user interface too.

Declaration

public const string Description = "Description"

Field Value

Type	Description
System.String

ERPProductKey

Product.ERPProductKey: Reference/foreign key to the product in the given pricelist in the product supplier system, if it exists there.

Declaration

public const string ERPProductKey = "ERPProductKey"

Field Value

Type	Description
System.String

ExtraField1

Product.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
System.String

ExtraField2

Product.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
System.String

ExtraField3

Product.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
System.String

ExtraField4

Product.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
System.String

ExtraField5

Product.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
System.String

ExtraInfo

Product.ExtraInfo: Extra data (fields with labels). Shall be shown in the quoteline dialog. Additional info that the ERP system would like to store and show in the user interface. Information placed here is shown in the GUI if the “provide-extra-data” capability is true. Different products can have different fields. It will not be possible to directly put info here into the quote document.

Declaration

public const string ExtraInfo = "ExtraInfo"

Field Value

Type	Description
System.String

InAssortment

Product.InAssortment: True for products that should currently be offered, false when the product is discontinued and should not ordinarily be offered. When false the product no longer appears in search results.

Declaration

public const string InAssortment = "InAssortment"

Field Value

Type	Description
System.String

IsSubscription

Product.IsSubscription: Is this a subscription product, sold in repeating intervals/amounts?

Declaration

public const string IsSubscription = "IsSubscription"

Field Value

Type	Description
System.String

ItemNumber

Product.ItemNumber: Line item number, NOR: «Postnummer». Specific numbers from some hierarchy, for instance “1.4.3.2P”. Typically used to sort the items in the quote by some standard way.

Declaration

public const string ItemNumber = "ItemNumber"

Field Value

Type	Description
System.String

Name

Product.Name: The name to use in the user interface.

Declaration

public const string Name = "Name"

Field Value

Type	Description
System.String

PriceListId

Product.PriceListId: Foreign key to the price list that this product is a part of.

Declaration

public const string PriceListId = "PriceListId"

Field Value

Type	Description
System.String

PriceUnit

Product.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
System.String

ProductCategoryKey

Product.ProductCategoryKey: 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 product category.

Declaration

public const string ProductCategoryKey = "ProductCategoryKey"

Field Value

Type	Description
System.String

ProductFamilyKey

Product.ProductFamilyKey: 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 product family.

Declaration

public const string ProductFamilyKey = "ProductFamilyKey"

Field Value

Type	Description
System.String

ProductId

Product.ProductId: Primary key

Declaration

public const string ProductId = "product_id"

Field Value

Type	Description
System.String

ProductTypeKey

Product.ProductTypeKey: 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 product type.

Declaration

public const string ProductTypeKey = "ProductTypeKey"

Field Value

Type	Description
System.String

QuantityUnit

Product.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
System.String

Registered

Product.Registered: Registered when

Declaration

public const string Registered = "registered"

Field Value

Type	Description
System.String

RegisteredAssociateId

Product.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
System.String

Rights

Product.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
System.String

Rule

Product.Rule: The names of one or more calculation rules that are in effect for this line, comma-separated case-insensitive. Will NOT be used by SuperOffice.

Declaration

public const string Rule = "Rule"

Field Value

Type	Description
System.String

SubscriptionUnit

Product.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
System.String

Supplier

Product.Supplier: In SuperOffice, an id from the contact table, when saved as an ERP cache, the name of the supplier

Declaration

public const string Supplier = "Supplier"

Field Value

Type	Description
System.String

SupplierCode

Product.SupplierCode: Suppliers part code/number or other key-like field

Declaration

public const string SupplierCode = "SupplierCode"

Field Value

Type	Description
System.String

UnitCost

Product.UnitCost: The cost price. Might not be given, use Decimal.MinValue to signal this.

Declaration

public const string UnitCost = "UnitCost"

Field Value

Type	Description
System.String

UnitListPrice

Product.UnitListPrice: (Basic Price, normal price, standard price.) This is the basic price from which the discount is computed from. The ListPrice will stay the same even when a larger amount is ordered.

Declaration

public const string UnitListPrice = "UnitListPrice"

Field Value

Type	Description
System.String

UnitMinimumPrice

Product.UnitMinimumPrice: The minimum price this salesman can offer to his customer. This might be cost price if there is no policy. Might not be given, use Decimal.MinValue to signal this.

Declaration

public const string UnitMinimumPrice = "UnitMinimumPrice"

Field Value

Type	Description
System.String

Updated

Product.Updated: Last updated when

Declaration

public const string Updated = "updated"

Field Value

Type	Description
System.String

UpdatedAssociateId

Product.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
System.String

UpdatedCount

Product.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
System.String

Url

Product.Url: URL to product information web page.

Declaration

public const string Url = "Url"

Field Value

Type	Description
System.String

VAT

Product.VAT: Tax/VAT if available from ERP system. THIS IS A PERCENTAGE. In the Superoffice product register, this field is available in the product admin GUI.

Declaration

public const string VAT = "VAT"

Field Value

Type	Description
System.String

VATInfo

Product.VATInfo: A field for putting VATInfo you need to show in the final quoteDocument, like the VAT type that is used. Not used in any business logic in SuperOffice; available to document templates.

Declaration

public const string VATInfo = "VATInfo"

Field Value

Type	Description
System.String