Database Table "hyp_Delivery Note"
Table Description
The Delivery note of goods in Hyper.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Delivery Note Number | Integer | 0 | Edit | Read Only Key Field |
DeliveryNoteNumber | |
| Agency | Status | 0 | Select | Read Only | Agency | |
| Sales Agent | String | 40 | PopupList | SalesAgent | ||
| Client Number | Integer | 0 | Edit | Hidden Read Only Mandatory |
ClientNumber | |
| Client Full Name | String | 105 | SelectEdit | Mandatory | ClientFullName | |
| Contact Person | String | 105 | PopupList | ContactPerson | ||
| Address | String | 300 | Memo | Address | ||
| Phone | Phone | 20 | SelectEdit | Mandatory | Phone | |
| String | 80 | Edit | ||||
| ID Number | Serial | 20 | Edit | IdNumber | ||
| Language | Status | 0 | Select | Language | ||
| Reason For Export | Values List: 0 = None1 = For Sale 2 = Samples of No Commercial Value 3 = Temporary Export |
Status | 0 | Select | ReasonForExport | |
| Rounding Off | Bool | 0 | Select | RoundingOff | ||
| Total Net LC | Money | 0 | Edit | Read Only | TotalNetLc | |
| Tax Class | String | 3 | Select | TaxClass | ||
| Tax Rate Percent | Real | 0 | Edit | Read Only | TaxRatePercent | |
| Total Tax LC | Money | 0 | Edit | Read Only | TotalTaxLc | |
| Total Gross LC | Money | 0 | Edit | Read Only | TotalGrossLc | |
| Purchaser Currency | String | 5 | Select | Mandatory | PurchaserCurrency | |
| Total Gross in PC | Total Goods Value in P.C. | Money | 0 | Edit | Read Only | TotalGrossInPc |
| Round off Amount | Money | 0 | Edit | Read Only | RoundOffAmount | |
| Payment Terms | Values List: 0 = Cash1 = Standard Credit 2 = Extra Credit 3 = Monthly Payments 4 = Consignation 5 = None |
Status | 0 | Select | PaymentTerms | |
| Credit Months | Integer | 0 | Edit | CreditMonths | ||
| Credit Days | Integer | 0 | Edit | CreditDays | ||
| Due Date | Date | 0 | Edit | Read Only | DueDate | |
| Origin Production Time | FixDT | 0 | SelectEdit | Read Only | OriginProductionTime | |
| Produced By | String | 40 | Edit | Read Only | ProducedBy | |
| Notes | String | 600 | Memo | Notes | ||
| Internal Notes | String | 100 | Edit | InternalNotes | ||
| Responsible Manager | String | 40 | PopupList | Read Only | ResponsibleManager | |
| Old Doc Reference | String | 20 | Edit | Read Only | OldDocReference | |
| Old Software Name | String | 10 | Edit | Read Only | OldSoftwareName | |
| Cancellation Time | FixDT | 0 | SelectEdit | Read Only | CancellationTime | |
| Cancelled By | String | 40 | Edit | Read Only | CancelledBy | |
| Cancellation Reason | String | 50 | Edit | Read Only | CancellationReason | |
| Sale Opportunity | Integer | 0 | PopupList | SaleOpportunity | ||
| Account Country Code | String | 2 | Edit | Read Only | AccountCountryCode | |
| Account Balance at Production Time | Money | 0 | Edit | Read Only | AccountBalanceAtProductionTime | |
| Credit Line Usage (Risk) LC | Integer | 0 | Edit | Read Only | CreditLineUsageRiskLc |
Database Table "hyp_Delivery Note Items"
Table Description
The included items in the delivery note.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Delivery Note Number | Integer | 0 | Edit | Hidden Read Only Key Field |
DeliveryNoteNumber | |
| Item ID | Real | 0 | Edit | Hidden Read Only Key Field |
ItemId | |
| Catalogic Number | String | 30 | Edit | Read Only | CatalogicNumber | |
| Description | String | 120 | Edit | Description | ||
| 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 | ||
| 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 Goods Value in P.C. | 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 | 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 | |
| Client P.O. | String | 20 | Edit | ClientPO | ||
| Sale Source | Values List: 0 = None1 = Started Here 2 = Order 3 = Tax Invoice 4 = Transaction Invoice |
Status | 0 | Select | Read Only | SaleSource |
| Order Number | Real | 0 | Edit | Read Only | OrderNumber | |
| Trace SubRecord ID | Real | 0 | Edit | Hidden Read Only |
TraceSubrecordId | |
| Manufacture / Delivery Date | Date | 0 | Edit | Read Only | ManufactureDeliveryDate | |
| Commitment ID | Integer | 0 | Edit | Read Only | CommitmentId | |
| Tax Class | String | 3 | Select | TaxClass | ||
| Tax Rate Percent | Real | 0 | Edit | Read Only | TaxRatePercent | |
| Sale Price Method | Values List: 0 = Net Price1 = VAT included |
Status | 0 | Select | Hidden Read Only |
SalePriceMethod |
| Sale Quantity Method | Values List: 0 = Real Units1 = Integer Units 2 = Whole Packages (Integer) |
Status | 0 | Select | Hidden Read Only |
SaleQuantityMethod |