• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

Product Table (129)

Some tooltip text!
• 7 minutes to read
 • 7 minutes to read

One Product, member of one price list

Fields

Name Description Type Null
product_id Primary key PK
ERPProductKey Reference/foreign key to the product in the given pricelist in the product supplier system, if it exists there. String(254) ●
PriceListId Foreign key to the price list that this product is a part of. FK PriceList ●
Name The name to use in the user interface. String(254) ●
Description The description to use, with potentially several lines. Will be used as tool-tip to use in the list user interface too. String(2047) ●
Code The product code / article number in the product supplier system. String(254) ●
QuantityUnit What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); Connector handles conversion relative to PriceUnit if they are different String(79) ●
PriceUnit What is the unit (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever); read-only for lines that originate in defined products String(79) ●
IsSubscription Is this a subscription product, sold in repeating intervals/amounts? Bool ●
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. String(254) ●
DefaultSubscriptionQuantity The default number of SubscriptionUnits to suggest when creating quote lines from this product Double ●
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. String(79) ●
Url URL to product information web page. String(1023) ●
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. String(254) ●
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. String(254) ●
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. String(254) ●
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. String(254) ●
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. Double ●
UnitCost The cost price. Might not be given, use Decimal.MinValue to signal this. Double ●
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. Double ●
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. Double ●
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. Clob ●
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. Bool ●
Supplier In SuperOffice, an id from the contact table, when saved as an ERP cache, the name of the supplier String(254) ●
SupplierCode Suppliers part code/number or other key-like field String(254) ●
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. String(2047) ●
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. String(254) ●
extraField1 This a simple field for adding information that the Connector can provide, and that the qoute document need to display. String(1023) ●
extraField2 This a simple field for adding information that the Connector can provide, and that the qoute document need to display. String(1023) ●
extraField3 This a simple field for adding information that the Connector can provide, and that the qoute document need to display. String(1023) ●
extraField4 This a simple field for adding information that the Connector can provide, and that the qoute document need to display. String(1023) ●
extraField5 This a simple field for adding information that the Connector can provide, and that the qoute document need to display. String(1023) ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

Product table relationship diagram

Indexes

Fields Types Description
product_id PK Clustered, Unique
ERPProductKey String(254) Index
PriceListId FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
PriceList List of prices, cached from an ERP system

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top