Products - codbex/codbex-olympus GitHub Wiki
Product can be an item or service that could be sold or purchased.
Product
Entity Definition
- Entity Type:
Primary Entity - Layout Type:
Manage Entities - Module: https://github.com/codbex/codbex-products
| Field | Type | Length | Null? | Calc? | Ref? | Description |
|---|---|---|---|---|---|---|
| Id | INTEGER | no | - | - | ||
| Name | VARCHAR | 500 | no | - | - | Name of the product |
| Type | INTEGER | no | - | yes | Reference to Product Type | |
| Category | INTEGER | no | - | yes | Which category is the product in Products | |
| BaseUnit | INTEGER | - | - | - | Reference to the UoM | |
| Model | VARCHAR | 200 | no | - | - | Model of the product |
| Company | INTEGER | no | - | yes | Reference to the Companies | |
| SKU | VARCHAR | 64 | - | - | - | Stock Keeping Units |
| UPC | VARCHAR | 20 | - | - | - | Universal Product Code |
| EAN | VARCHAR | 20 | - | - | - | European Article Number |
| JAN | VARCHAR | 20 | - | - | - | Japanese Article Numbering (EAN-13) |
| ISBN | VARCHAR | 20 | - | - | - | International Standard Book Number |
| MPN | VARCHAR | 40 | - | - | - | Manufacturer Part Number |
| Manufacturer | INTEGER | - | - | - | Reference to the Manufacturer | |
| Weight | DOUBLE | 20 | no | - | - | |
| Height | DOUBLE | 20 | no | - | - | |
| Length | DOUBLE | 20 | no | - | - | |
| Location | VARCHAR | 20 | - | - | - | |
| Quantity | DECIMAL | - | - | - | ||
| Image | VARCHAR | 225 | - | - | - | |
| Shipping | TINYINT | 1 | - | - | - | |
| Price | DECIMAL | 4 | no | - | - | |
| Points | INTEGER | 8 | - | - | - | |
| DateAvailable | DATE | 20 | - | - | - | |
| Subtract | TINYINT | 1 | no | - | - | |
| Minimum | INTEGER | 10 | no | - | - | |
| DateAdded | TIMESTAMP | 20 | no | - | - | |
| DateModified | TIMESTAMP | 20 | - | - | - | |
| StockStatus | IINTEGER | no | yes | - |