Class DBC.ProductFields
Fields for Product, One Product, member of one price list
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class ProductFields : ObjectFields
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 |