Database Table "hyp_Orders"

Table Description

All of the orders details, that also include the clients details, payment methods, delivery details, etc.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Order Number Real 0 Edit Read Only
Key Field
OrderNumber
Agency Status 0 Select Agency
Drawer / Station ID Integer 0 Edit Read Only DrawerStationID
Order Application String 3 Edit Read Only OrderApplication
Client Number Integer 0 Edit Read Only ClientNumber
Client Full Name String 135 PopupList Read Only ClientFullName
Contact Person String 135 PopupList ContactPerson
Directed to
Values List:
Contact Person
Company
Status 0 Select DirectedTo
Sales Agent String 40 PopupList SalesAgent
Subject String 60 SelectEdit Subject
Type
Values List:
New Sale
Service Order
MRP Order
Status 0 Select Type
Status
Values List:
Price Quotation
Approved Quotation
Cancelled while Negotiating
Cancelled after Approval
Sent to Production
Cancelled - Alternative Offer Approved
Status 0 Select Read Only Status
Order Approved On FixDT 0 SelectEdit Read Only OrderApprovedOn
Offer/Order Cancelled On FixDT 0 SelectEdit Read Only OfferOrderCancelledOn
Order Sent to Production On FixDT 0 SelectEdit Read Only OrderSentToProductionOn
International Document Bool 0 Select InternationalDocument
Delivery Address String 100 PopupEdit DeliveryAddress
City String 40 PopupEdit City
Region String 40 PopupEdit Region
Country String 40 Select Country
Distribution Area String 40 Edit Read Only DistributionArea
Requested Delivery Date FixDT 0 SelectEdit RequestedDeliveryDate
Final Delivery Date FixDT 0 SelectEdit Read Only FinalDeliveryDate
Project Number Integer 0 Edit Read Only ProjectNumber
Project Title String 100 Edit Read Only ProjectTitle
Project Entrepreneur String 100 Edit Read Only ProjectEntrepreneur
Location in Project Map String 100 Edit Read Only LocationInProjectMap
Credit Client due to Project Money 0 Edit Read Only CreditClientDueToProject
PriceList Date of Value Date 0 SelectEdit PriceListDateOfValue
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 Money 0 Edit Read Only TotalChargeLC
Purchaser Currency String 4 Select PurchaserCurrency
Total Charge on P.C. Total Charge in Purchaser currency Money 0 Edit Read Only TotalChargeOnPC
Created On FixDT 0 Edit Read Only CreatedOn
Created By String 40 Edit Read Only CreatedBy
Last Update FixDT 0 Edit Read Only LastUpdate
Updated By String 40 Edit Read Only UpdatedBy
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
This offer is Valid for # Days Integer 0 Edit Mandatory ThisOfferIsValidForDays
Order Header String 800 Memo OrderHeader
Order Footer String 1500 Memo OrderFooter
Inhouse Operational Notes String 1500 Memo InhouseOperationalNotes
Middleman Account Integer 0 Edit Read Only MiddlemanAccount
Middleman Name String 135 PopupList MiddlemanName
Middleman Commission % Rate Real 0 Edit MiddlemanCommissionRate
Gross Profit LC Money 0 Edit Read Only GrossProfitLC
Winning Order Number Real 0 Edit Read Only WinningOrderNumber
Last Confirmation Step String 30 Edit Read Only LastConfirmationStep
Next Confirmation Step String 30 Edit Read Only NextConfirmationStep
Next Confirmation Step Deadline Date 0 SelectEdit Read Only NextConfirmationStepDeadline
Old Doc Reference String 20 Edit Read Only OldDocReference
Old Software Name String 10 Edit Read Only OldSoftwareName
Against Purchase Order String 20 Edit AgainstPurchaseOrder
Don't Print SubTotal Bool 0 Select DonTPrintSubTotal
Print Order Contract String 30 Select PrintOrderContract
Rounding Off Bool 0 Select RoundingOff
Need Crane to Floor Number Integer 0 Edit NeedCraneToFloorNumber
CAD File Extention String 5 Edit Hidden
Read Only
CADFileExtention
CAD File Name String 20 Edit Hidden
Read Only
CADFileName
Spare Agent 1 String 40 PopupList SpareAgent1
Spare Agent 2 String 40 PopupList SpareAgent2
Delivery Channel String 20 Edit Read Only DeliveryChannel
Delivery Channel Attrib String 1 Edit Hidden
Read Only
DeliveryChannelAttrib
Unloading Order Integer 0 Edit Read Only UnloadingOrder
Language Status 0 Select Language
Jump to tables index