Class DBC.ProductFields

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

Inheritance
Object
DBC.ProductFields
Inherited Members
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
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
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
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
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
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
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
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
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
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
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
String

IsSubscription

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

Declaration
public const string IsSubscription = "IsSubscription"
Field Value
Type Description
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
String

Name

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

Declaration
public const string Name = "Name"
Field Value
Type Description
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
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
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
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
String

ProductId

Product.ProductId: Primary key

Declaration
public const string ProductId = "product_id"
Field Value
Type Description
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
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
String

Registered

Product.Registered: Registered when

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

RegisteredAssociateId

Product.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
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
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
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
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
String

SupplierCode

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

Declaration
public const string SupplierCode = "SupplierCode"
Field Value
Type Description
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
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
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
String

Updated

Product.Updated: Last updated when

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

UpdatedAssociateId

Product.UpdatedAssociateId: Last updated by whom

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

UpdatedCount

Product.UpdatedCount: Number of updates made to this record

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

Url

Product.Url: URL to product information web page.

Declaration
public const string Url = "Url"
Field Value
Type Description
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
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
String