List of DB Tables (in all books)

Table Name Description and Notes
Client Card. Available for statuses of "New Leed" to "Held Client". Due to system optimization consideration, inactive clients can be transferred to the archive. Clients retrieval from archive is a manual operation for each client card.
The contact persons in the Client / Supplier card. This table contains the additional contact persons of the organization or the client.
The supplier card in Hyper.
Due to optimization considerations, inactive or unnecessary suppliers cards, can be removed to the archive. These cards can be manually moved back to the normal table of suppliers.
The Employee Card in Hyper.
Accounts. This modul is used for the inner accounts of the company. the accounts will be presented in the trial balance on the right side.
This table contains the details of the recorded phone calls. This table also includes received data from the PBX as well as the details of the details of the user that executed the call.
This table contains the duplicate / fictitious customer information in the system and the summary of the contact with them.
Printed Cheques
This table contains the details of printed cheques.
The 3rd Party Billing for services which is defined from the Sales rules of the client card.
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.
Tracking production, supply and customer billing according to orders. Delivered and charged records, will be archived.
The private price list of the client which includes products details and the special offered price for the client. This table is defined in the Sales Rules of the clients cards.
List of digitally signed statements & documents for customer or vendor. We always use PDF files.
Credit invoice table
This table contains the items for the credit invoice.
The delivery channel notes.
The Delivery note of goods in Hyper.
The included items in the delivery note.
The TDS definitions of Hyper entity.
The list of messages.
Book Keeping Modul
The Email messages abstracts table. This table is used for messages searching purpose.
The field of the "Attechments" tab in Email message.
The list of addressees of the Email message.
The linkage of Email correspondences to meetings.
Sub-table with the list of invitees for the meeting.
Sub-table with the list of invitees for the meeting.
The confirmation chain proccess of an order.
The Order Items and their details.
The assembly details of the orders items.
The payment details for the orders items
All of the orders details, that also include the clients details, payment methods, delivery details, etc.
The list of sent messages from outbox.
The drafts table of the Outbox.
The table of passwords that have been defined in the Password Storage, in the Home Page of Hyper.
The manufacture instructions of the products. These fields are defined in the Manufacture Instructions tab, of the Production Module.
The parts list of the item. These fields are defined in the "Manufacture Instructions" of the Production Module.
The manufacture instructions workflow. These fields can be defined in the Manufacture Instructions tab of the Production module.
The product card in Hyper.
Opening balances of Inventory followed by summarized records from "hyp_Stock Journal" Table inNormal storage. This is an Optimization Mechanism.
In every night process the server transfers the Inventory changes and updates that are older than 30 days. Records with quantity of 0, are automatically deleted.
The product prices log, according to the prices validation.
The product sale campaigns table.
The available suppliers table of the product
The projects table of Hyper
The purchase order table, for the organizations suppliers.
The purchase order items table.
The recipt items table, which includes the payment method and its details.
The receipts table of Hyper.
The refund items table, which includes the payment method and its details.
The Refunds table in Hyper.
The Relationship table which includes the Phone calls and Emails.
The Return of Goods Note main table of Hyper.
The list of items for the Return of Goods Note.
The list of Marketing Media Channels.
The monthly usage details of the media channel.
The sale opportunities table of Hyper.
The service tickets primary table of Hyper.
Product Inventory - accurate records of every update and change of the inventory.
In every night process the server tranferes any record older than 30 days to archive. The opening balance will be calculated in "hyp_Product Inventory" table.
The table of the approved commissions for a middleman.
The task card of Hyper.
Tax Invoice - Document Title
The Tax Invoice items detalis.
Journal of trades that the Clients has executed on the organization trading platforms
Requests for modifications in external trading platforms through their API. The table can contain requests initiated by Hyper or by other systems.
This table includes the clients records for the beggining of each trading day and includes the Balance, Equity, Credit and Margin.
Open trades that the Clients has executed on the organization trading platforms
This table includes the data of the end of the day and the beggining of the next day, for all of the open trades.
Price Feed sampling table, used for Accounting and Risk management reports
Daily Summary of Price Feed sampling table, used for Accounting and Risk management reports
The Advanced Search Wizard of Hyper is used for creating and defining filters for customized searching, according to the users needs.
The list of branches and Haifar adjustments for each of them. A branch can also represent a franchisee or telephone marketing team.
This table includes the "White List", which is the approved list of Domain Names and Email Addresses that were marked as "spam" by Hyper.
After added to this list, messages from these domain names and Email addresses will be received as regular messages in Hyper.
This table is defined in the Attachments & Templates tab of the System Fundamentals. This table is used for defining the approved file extension of the organization for Hyper, as well as the way of handling these files.
This table is used for defining documents of the organization to be available for the user in some of Hyper's modules.
The currency table used by the organization, sales in the purchase and in the NAHS, the source of the rates will usually be central banks (representative rate).
The list of the currencies rates. tThe exchange rate is defined according to the data source, as defined in the Currency Definition Table.
The distribution areas definitions, according to the defined Region and City.
The list of countries in which the organization holds a representative office (branches or franchisees) or in terms of translation and definitions, adjustment is required for certain countries.
List of all departments in the organization.
Definition table for public mailboxes in Hyper, which can be shared between users. This is the table from which you can select boxes for automatic applications.
The fields definitions for the import of bank statements. These fields are defined from the "Toolbox" tab of the Bookkeeping Module of Hyper.
The logical rules for auto identifying target accounts. The fields of this table are defined during the import of bank statements as entries, after defining the imported columns.
Mail Templates table.
The definitions for Price Offers documents. This table fields can be defined in the Order Header & Footer tab of the System Fundamentals.
Table of telephone extensions in the organization. The table is only relevant if Haifer connects to the organization's PBX.
The assembly schedule table
The workflow table of the production. This table is defined in the Fundamentals tab of the Production Module.
The required workflow items. This table is defined from the Fundamentals tab of the Production module.
The definitions table of the organizations delivery planning. This table is defined in the fundamentals tab of the Production Module.
Definitions of non working days for the Production and the Delivery. These field are defined in the Fundamentals tab of the Production module.
List of indices used by the company.
The index rates definitions. The rates can be defined from the "Price Linkage Index" tab in the Toolbox of the Bookkeeping module.
The definitions of products labels.
The design and content settings of the barcode label.
The report layout definition.
The report definition and general information.
The list of required table for the report.
The filtering terms.
The Sale Campaign details. These fields can be defined in the Marketing Campaigns tab of Marketing & Web-Content module.
Server-side application settings table and the Heifer website
setting list of stockrooms (actual or Simulated) in organization. (For accounting or production management). Every stockroom can be associated to sub sections and the inventory will be calculated separately for any sub section.
One table for all financial instruments available to dealers (customers), in all trading platforms linked into the current database.
The trading platform definitions table (exposure and coverage) connected to Hyper. After changing definition in this table, it is recommended to reset the relevant automation (via Hyper Client), in order to verify that the definitions were fully implemented.
The Employees extended authorization rules. The fields of this table are defined in the Authorization tab of the Employee Card.
Value Added Tax Table, according to the country in which the Company is registered.
Sub-table, field specification for the profile table.
Table of reception profiles and service calls from external systems.
Used to setup external interfaces, accessed by the network. e.g. SMS gateway, Credit Card clearing and Trading platforms.
All fields beside the first, are "Optional" and need to be filled according to the service provider. These definition dields can be define from the "Automation Log & Web Services tab, of the System Fundamentals.
The billing details for construction site.
The list of items for the billing, in construction site.
The title of the project card in Hyper.
The incomes of the construction site.
Book Keeping Modul
Whole Price Feed (Tick by Tick). After 12 hours, the data is archived in ZIP in the same database in a folder with the same name.
Journal of trades that the Clients has executed on the organization trading platforms
Feed data archiving tracking table. The administrator may edit the data to affect the conduct of the applications.
Alerts definitions for the trading risk management system.
Only defined financial instruments will be available for the alerts system.
Capture of changes in client trading orders for regulation
One table to all financial instruments in which the organization trade on outward Brokers (or Banks).
The goal is to adjust the settings of the broker financial instruments in terms of the organization, to perform calculations.
Hyper Main Table of Contents: Website and document text memos, email templates, and even SMS templates.
Records of the downloaded messages from POP3 or IMAP server
Presence log back up table of the employee.
Documentation of appointment coordination with an entity (customer / vendor / project). Each change, in front of each user, will be recorded in a separate line in this table.