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 Units
1 = Integer Units
2 = Whole Packages (Integer)
Status 0 Select SaleQuantityMethod
Sale Price Method
Values List:
0 = Net Price
1 = 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 = No
1 = Per Single Unit
2 = Per Package
Status 0 Select MustFillInABatchNumber
Point of Sale Extra Feature
Values List:
0 = No Need
1 = 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*H
W*D
H*D
W*D*H
String 5 Select CalculateQuantityByDimensions
Fragile Bool 0 Select Fragile
Regulation
Values List:
0 = None
1 = 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
Jump to tables index