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 |
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.