Database Table "hyp_Order Items"
Table Description
The Order Items and their details.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Order Number | Real | 0 | Edit | Hidden Read Only Key Field |
OrderNumber | |
| Item ID | Real | 0 | Edit | Hidden Read Only Key Field |
ItemId | |
| Catalogic Number | String | 30 | Edit | Read Only | CatalogicNumber | |
| Product Name | String | 120 | Edit | ProductName | ||
| Quantity | Real | 0 | Edit | Quantity | ||
| Unit of measure | Status | 0 | Select | UnitOfMeasure | ||
| Net Sale Price | Real | 0 | Edit | NetSalePrice | ||
| Gross Sale Price | Money | 0 | Edit | GrossSalePrice | ||
| Sale Currency | String | 5 | Select | SaleCurrency | ||
| Sale Price Method | Values List: 0 = Net Price1 = VAT included |
Status | 0 | Select | Hidden Read Only |
SalePriceMethod |
| Exchange Rate | Real | 0 | Edit | Read Only | ExchangeRate | |
| Discount % | Real | 0 | Edit | Discount_Percent | ||
| Total Net LC | Money | 0 | Edit | Read Only | TotalNetLc | |
| Total Tax LC | Money | 0 | Edit | Read Only | TotalTaxLc | |
| Total Gross LC | Money | 0 | Edit | Read Only | TotalGrossLc | |
| Total Gross in PC | Total Charge in Purchaser currency | Money | 0 | Edit | Read Only | TotalGrossInPc |
| Warranty Period in months | Real | 0 | Edit | WarrantyPeriodInMonths | ||
| Package Conversion Ratio | Real | 0 | Edit | Read Only | PackageConversionRatio | |
| Package Quantity | Real | 0 | Edit | Read Only | PackageQuantity | |
| Package Unit | Status | 0 | Select | Read Only | PackageUnit | |
| Unit Weight kg | Real | 0 | Edit | UnitWeightKg | ||
| Package Weight kg | Real | 0 | Edit | Read Only | PackageWeightKg | |
| Commitment ID | Integer | 0 | Edit | Read Only | CommitmentId | |
| Discount Note | String | 50 | Edit | DiscountNote | ||
| Discount Type | String | 1 | Edit | Hidden Read Only |
DiscountType | |
| Unit Width mm | Real | 0 | Edit | UnitWidthMm | ||
| Unit Height mm | Real | 0 | Edit | UnitHeightMm | ||
| Unit Depth mm | Real | 0 | Edit | UnitDepthMm | ||
| Net Cost Price | Real | 0 | Edit | NetCostPrice | ||
| Cost Currency | String | 5 | Select | CostCurrency | ||
| Manual Product Name | String | 1 | Edit | Hidden Read Only |
ManualProductName |