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
Drawer / Station ID Integer 0 Edit Read Only DrawerStationID
Client Number Integer 0 Edit Hidden
Read Only
Mandatory
ClientNumber
Client Full Name String 135 SelectEdit Mandatory ClientFullName
Contact Person String 135 SelectEdit ContactPerson
Address String 300 Memo Address
Phone Phone 20 SelectEdit Mandatory Phone
Fax Phone 20 Edit Fax
Email String 80 Edit Email
ID Number Serial 20 Edit IDNumber
Directed to
Values List:
Contact Person
Company
Status 0 Select DirectedTo
Language Status 0 Select Language
Reason For Export Status 0 Select ReasonForExport
Purchaser Currency String 4 Select Mandatory PurchaserCurrency
Rounding Off Bool 0 Select RoundingOff
Tax Rate Percent Money 0 Edit Read Only TaxRatePercent
Total Tax Free LC Money 0 Edit Read Only TotalTaxFreeLC
Total Tax Liable LC Money 0 Edit Read Only TotalTaxLiableLC
Total Tax LC Money 0 Edit Read Only TotalTaxLC
Total Charge LC Total Goods Value Money 0 Edit Read Only TotalChargeLC
Total Charge on P.C. Total Goods Value in P.C. Money 0 Edit Read Only TotalChargeOnPC
Payment Terms
Values List:
Cash
Standard Credit
Extra Credit
Monthly Payments
Consignation
None
Status 0 Select PaymentTerms
Monthly Payments Integer 0 Edit MonthlyPayments
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
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
Jump to tables index

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
ItemID
Order Number Real 0 Edit Read Only OrderNumber
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
Tax-Free Selling Price Real 0 Edit Tax-FreeSellingPrice
Taxable Selling Price Real 0 Edit TaxableSellingPrice
Selling Currency String 4 Select Mandatory SellingCurrency
Discount % Real 0 Edit Discount
Warranty Period in months Real 0 Edit WarrantyPeriodInMonths
Total Tax Free LC Money 0 Edit Read Only TotalTaxFreeLC
Total Tax Liable LC Money 0 Edit Read Only TotalTaxLiableLC
Total Tax LC Money 0 Edit Read Only TotalTaxLC
Total Charge LC Total Goods Value Money 0 Edit Read Only TotalChargeLC
Total Charge on P.C. Total Goods Value in P.C. Money 0 Edit Read Only TotalChargeOnPC
Exchange Rate Real 0 Edit Read Only ExchangeRate
Package Conversion Ratio Real 0 Edit Read Only PackageConversionRatio
Package Conversion Unit Status 0 Select Read Only PackageConversionUnit
Package Conversion Quantity Real 0 Edit Read Only PackageConversionQuantity
Sale Source Status 0 Select Read Only SaleSource
Trace SubRecord ID Real 0 Edit Hidden
Read Only
TraceSubRecordID
Against Purchase Order String 20 Edit AgainstPurchaseOrder
Tax Invoice Number Integer 0 Edit Read Only TaxInvoiceNumber
Commitment ID Integer 0 Edit Read Only CommitmentID
Jump to tables index