Database Table "hyp_Tax Invoice"

Table Description

Tax Invoice - Document Title

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name Description and Notes Data Type Text Length
Invoice Number The invoice number Integer 0
Agency Assign an invoice to a branch, is used to produce reports. Status 0
Drawer / Station ID POS code / station / safe, according to local computer settings. Used to count cash and produce reports. Integer 0
Sales Agent Sales Agent Association is used to generate reports only. String 40
Client Number Customer number in Hyper. Integer 0
Client Full Name The customer name, can be manually edited like other personal information in an invoice. String 135
Contact Person Select the contact with the customer if the invoice is delivered. The contact will appear on the invoice in the "Please hand over" line. String 135
Address Address on the invoice. The client address will be copied here by default but the field is editable. String 300
Phone Phone on invoice. Customer's phone 1 will be copied here by default but the field is editable. Phone 20
Fax Fax on the invoice. The customer's fax number will be copied here by default but the field is editable. Phone 20
Email String 80
ID Number ID on the invoice. Will be copied from the customer record by default but the field is editable. Serial 20
Directed to Choose between forwarding the invoice to the company itself or the contact. Status 0
Language
Status 0
International Document International Document:
Printed in customer currency, in customer's language! And the journal order will also be in the currency in which the customer pays.
Only an individual or legal entity registered in a country other than that of the organization managed by the software can receive an international invoice.
Bool 0
Purchaser Currency String 4
Rounding Off Bool 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
Total Charge on P.C. Total Charge in Purchaser currency Money 0
Payment Terms
Cash
Standard Credit
Extra Credit
Monthly Payments
Consignation
None
Status 0
Monthly Payments Integer 0
Credit Months Integer 0
Credit Days Integer 0
Due Date Date 0
Origin Production Time FixDT 0
Produced By String 40
Electronic Signed PDF
No
Produced & Sent
Waiting in queue
Status 0
Bundled with Receipt Number Integer 0
Assign Journal Entries to Parent Integer 0
Authorities Invoice Mode
Standard Tax Invoice
Reverse Charge - Mode 1
Reverse Charge - Mode 2
Status 0
Notes String 600
Internal Notes String 100
Responsible Manager String 40
Old Doc Reference String 20
Old Software Name String 10
Cancellation Time FixDT 0
Cancelled By String 40
Cancellation Reason String 50
Jump to tables index

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

Database Table "hyp_Client Contract"

Table Description

This table contains the prepaid products of the client as well as their details and the amount of supplied units. The fields of this table are displayed in the "Committed Prepaid Products" in the Clients sales rules, and according to the definitions of the pre-paid Tax Invoice.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
Commitment ID The unique number of the commitment, given by the system. Integer 0
Catalogic Number The catalogic number of the committed / prepaid product. String 30
Product Name String 120
Units Supplied The total amount of units that have been supplied. Real 0
Prepaid This field describes whether the product was prepaid or not. This is an automatic field, updated by the system according to tax invoice. Bool 0
Committed Until Date The system allows to use this contract until the defined date in this field. Date 0
Committed Units The amount of units in the contract. Real 0
Selling Method
Net Price
VAT included
Status 0
Tax-Free Selling Price Real 0
Taxable Selling Price Real 0
Selling Price inc Tax Money 0
Selling Currency String 4
Last Update FixDT 0
Updated By String 40
Jump to tables index

Database Table "hyp_Return of Goods Note"

Table Description

The Return of Goods Note main table of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Return Note Number The unique number of the Return Note in Hyper. Integer 0
Agency
Status 0
Drawer / Station ID Integer 0
Client Number Integer 0
Client Full Name String 135
Contact Person String 135
Address String 300
Phone Phone 20
Fax Phone 20
Email String 80
ID Number Serial 20
Directed to
Contact Person
Company
Status 0
Language
Status 0
International Document Bool 0
Purchaser Currency String 4
Rounding Off Bool 0
Tax Rate Percent Money 0
Total Tax Free LC Money 0
Total Tax Liable LC Money 0
Total Tax LC Money 0
Total Credit LC Total Goods Value Money 0
Total Credit on P.C. Total Credit in Purchaser currency Money 0
Origin Production Time FixDT 0
Produced By String 40
Notes String 600
Responsible Manager String 40
Old Doc Reference String 20
Old Software Name String 10
Cancellation Time FixDT 0
Cancelled By String 40
Cancellation Reason String 50
Jump to tables index