Database Table "hyp_Product Header"
Table Description
The product card in Hyper.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Catalogic Number | String | 30 | Edit | Mandatory Key Field |
CatalogicNumber | |
Group | String | 30 | Select | Group | ||
Product Name | String | 120 | Edit | Mandatory /G:1 | ProductName | |
Product Name in English | String | 120 | Edit | Mandatory /G:1 | ProductNameInEnglish | |
Unit of measure | Status | 0 | Select | UnitOfMeasure | ||
Sale Quantity Method | Values List: 0 = Real Units1 = Integer Units 2 = Whole Packages (Integer) |
Status | 0 | Select | SaleQuantityMethod | |
Sale Price Method | Values List: 0 = Net Price1 = VAT included |
Status | 0 | Select | Read Only | SalePriceMethod |
Net Sale Price | Real | 0 | Edit | NetSalePrice | ||
Gross Sale Price | Money | 0 | Edit | GrossSalePrice | ||
Sale Currency | String | 5 | Select | SaleCurrency | ||
International Barcode | String | 30 | Edit | InternationalBarcode | ||
Package Unit | Status | 0 | Select | PackageUnit | ||
Package Conversion Ratio | Real | 0 | Edit | PackageConversionRatio | ||
Warranty Period in months for the Client | Real | 0 | Edit | WarrantyPeriodInMonthsForTheClient | ||
Warranty Period in months from the Supplier | Real | 0 | Edit | WarrantyPeriodInMonthsFromTheSupplier | ||
Must fill in a Batch number | Values List: 0 = No1 = Per Single Unit 2 = Per Package |
Status | 0 | Select | MustFillInABatchNumber | |
Point of Sale Extra Feature | Values List: 0 = No Need1 = The product obligates weighing 2 = The product is priced manually 3 = Only Receipt 4 = Only Receipt + Priced Manually |
Status | 0 | Select | PointOfSaleExtraFeature | |
Block Sales | Bool | 0 | Select | BlockSales | ||
Revenue Account Number | Integer | 0 | PopupList | RevenueAccountNumber | ||
Unit Width mm | Real | 0 | Edit | UnitWidthMm | ||
Unit Height mm | Real | 0 | Edit | UnitHeightMm | ||
Unit Depth mm | Real | 0 | Edit | UnitDepthMm | ||
Unit Weight kg | Real | 0 | Edit | UnitWeightKg | ||
Allow to change Width | String | 80 | Edit | AllowToChangeWidth | ||
Allow to change Height | String | 80 | Edit | AllowToChangeHeight | ||
Allow to change Depth | String | 80 | Edit | AllowToChangeDepth | ||
Calculate quantity by dimensions | Values List: W*HW*D H*D W*D*H |
String | 5 | Select | CalculateQuantityByDimensions | |
Fragile | Bool | 0 | Select | Fragile | ||
Regulation | Values List: 0 = None1 = Food 2 = Electrical 3 = Plant 4 = Animal 5 = Chemical (Hazard) 6 = Drug / Medication |
Status | 0 | Select | Regulation | |
Charge for child nodes Additions | Bool | 0 | Select | ChargeForChildNodesAdditions | ||
PP&C Handling Type | Values List: 0 = NONE (Just Obligate the Client)1 = Stock Buffered Product (Reorder) 2 = Back to Back Purchase 3 = Manufactured by Demand (Dynamic/Configured) 4 = Manufactured End Component (MRP) 5 = Preliminary Raw Material |
Status | 0 | Select | PpCHandlingType | |
Material Wastage Percent | Integer | 0 | Edit | MaterialWastagePercent | ||
Safety Stock Level | Real | 0 | Edit | SafetyStockLevel | ||
Reorder Default Amount | Real | 0 | Edit | ReorderDefaultAmount | ||
Global Sales Quota | Real | 0 | Edit | GlobalSalesQuota | ||
Overbooking Quota | Real | 0 | Edit | OverbookingQuota | ||
Count Sales Quota Since | Date | 0 | SelectEdit | CountSalesQuotaSince | ||
Default Supplier Number | Integer | 0 | Edit | Read Only | DefaultSupplierNumber | |
Default Supplier | String | 105 | PopupList | DefaultSupplier | ||
Net Cost Price | Real | 0 | Edit | NetCostPrice | ||
Cost Currency | String | 5 | Select | CostCurrency | ||
Cost Price Multiplier | Real | 0 | Edit | CostPriceMultiplier | ||
Purchase Unit | Status | 0 | Select | PurchaseUnit | ||
Purchase Conversion Ratio | Real | 0 | Edit | PurchaseConversionRatio | ||
Extended Media | Integer | 0 | Select | Hidden Read Only |
ExtendedMedia | |
Tax Class | String | 3 | Select | TaxClass |