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 Description and Notes Data Type Text Length
Order Number The order number. This is a unique automatic number, givrn by the system. Real 0
Agency The agency of the organization where the order was made. Status 0
Drawer / Station ID Integer 0
Order Application The application that the order was created by. String 3
Client Number The client number that the order is related to. Integer 0
Client Full Name String 135
Contact Person The contact person of the client / organization that has made the order. String 135
Directed to Choose whether to direct the order to the company or the contact person. Status 0
Sales Agent The sales agent that the order is related to. String 40
Subject String 60
Type The order tpye: New Sale / Service Order / MRP Order. Status 0
Status The order status, as updated in the sales tab of the client card. Status 0
Order Approved On The date and time of updating the order status as approved (Pro-forma invoice). FixDT 0
Offer/Order Cancelled On FixDT 0
Order Sent to Production On The date and time of updating the order status as "Sent to Production". FixDT 0
International Document Choose YES to produce the documents in english. Bool 0
Delivery Address As default, the client address will be displayed in this field. String 100
City String 40
Region String 40
Country String 40
Distribution Area String 40
Requested Delivery Date FixDT 0
Final Delivery Date FixDT 0
Project Number Integer 0
Project Title String 100
Project Entrepreneur String 100
Location in Project Map String 100
Credit Client due to Project Money 0
PriceList Date of Value Date 0
Tax Rate Percent Money 0
Total Tax Free LC Money 0
Total Tax Liable LC Money 0
Total Tax LC Money 0
Total Charge LC Money 0
Purchaser Currency The required currency for the price offer. String 4
Total Charge on P.C. Total Charge in Purchaser currency Money 0
Created On FixDT 0
Created By The user name that has created the order. String 40
Last Update The date and time of the last modification. FixDT 0
Updated By The user name that has made the last modification. String 40
Payment Terms Define the payment terms for this order. As default, the payment terms are taken from the "Rules" definitions of the client. This field can be modified and the required payment terms can be selected from the list:
Cash - Cash payment for the received goods. When choosing a credit payment, fill in the "Credit Months" and "Credit Days" fields. When choosing "Monthly Payment", fill in the "Monthly Payment" field.
Status 0
Monthly Payments This field is available according to the selected payment terms. Integer 0
Credit Months This field is available according to the selected payment terms. Integer 0
Credit Days This field is available according to the selected payment terms. Integer 0
Due Date Date 0
This offer is Valid for # Days The validation for the price offer. After the defined dead-line, thestatus of the offer will be automatically changed to cancelled. Integer 0
Order Header A default comment to be displayed on the header of the order document . This content can also be taken from the defined contents of the "Orders Header & Footer" tab of the System Fundamentals. String 800
Order Footer A default comment to be displayed at the bottom of the order document. This content can also be taken from the defined contents of the "Orders Header & Footer" tab of the System Fundamentals. String 1500
Inhouse Operational Notes An internal note which will not be displayed on the order focument. String 1500
Middleman Account If any middleman was selected in the fieldMiddleman Name", its number will be displayed in this field. Integer 0
Middleman Name If the order was created by any of the defined middlmen in Hyper, select this middlename card in this field. String 135
Middleman Commission % Rate The middleman commission & Rate, which is calculated from the Total Charge LC. Real 0
Gross Profit LC Money 0
Winning Order Number If any other order was approved and updated as alternative to this order, its number will be displayed in this field. Real 0
Last Confirmation Step The last confirmed step in the confirmation chain. String 30
Next Confirmation Step The next confirmation step to approve in the confirmation chain. String 30
Next Confirmation Step Deadline Date 0
Old Doc Reference String 20
Old Software Name String 10
Against Purchase Order Purchase order reference. String 20
Don't Print SubTotal Bool 0
Print Order Contract Print the contract along with the Price Offer / Order. Choose the required Order Header and Order Footer, that have been defined in the "Order Header & Footer" tab of the System Fundamentals. String 30
Rounding Off Bool 0
Need Crane to Floor Number Integer 0
CAD File Extention String 5
CAD File Name String 20
Spare Agent 1 String 40
Spare Agent 2 String 40
Delivery Channel String 20
Delivery Channel Attrib String 1
Unloading Order Integer 0
Language
Status 0
Jump to tables index