List of DB Tables (in all books)

Table Name Description and Notes Admin Privilege
Customer table. This is the "head" of the customer portfolio in Hyper, from new lead status to "paused customer" .
Through the Hyper interface the client file can be archived and returned.
Edit & Rules
The contact persons in the Client / Supplier card. This table contains the additional contact persons of the organization or the client. Edit & Rules
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.
Edit & Rules
The Employee Card in Hyper. Edit & Rules
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. Protected
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. Edit Only
This table contains the duplicate / fictitious customer information in the system and the summary of the contact with them. Edit & Rules
Protected
Printed Cheques Protected
Edit & Rules
Edit & Rules
This table contains the details of printed cheques. Protected
The 3rd Party Billing for services which is defined from the Sales rules of the client card. Edit Only
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. Edit Only
Edit Only
Tracking production, supply and customer billing according to orders. Delivered and charged records, will be archived. Edit Only
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. Edit Only
List of digitally signed statements & documents for customer or vendor. We always use PDF files. Protected
Edit & Rules
Credit invoice table Protected
This table contains the items for the credit invoice. Protected
The delivery channel notes. Edit & Rules
The Delivery note of goods in Hyper. Protected
The included items in the delivery note. Protected
Edit & Rules
Edit & Rules
The TDS definitions of Hyper entity. Edit Only
Protected
Edit & Rules
Edit & Rules
The list of messages. Edit Only
Book Keeping Modul Protected
Edit & Rules
The Email messages abstracts table. This table is used for messages searching purpose. Edit Only
The field of the "Attechments" tab in Email message. Edit Only
The list of addressees of the Email message. Edit Only
The linkage of Email correspondences to meetings. Protected
Edit & Rules
Sub-table with the list of invitees for the meeting. Protected
Sub-table with the list of invitees for the meeting. Edit Only
The confirmation chain proccess of an order. Edit Only
The Order Items and their details. Edit & Rules
The assembly details of the orders items. Edit & Rules
The payment details for the orders items Edit & Rules
All of the orders details, that also include the clients details, payment methods, delivery details, etc. Edit & Rules
The list of sent messages from outbox. Edit Only
The drafts table of the Outbox. Edit Only
The table of passwords that have been defined in the Password Storage, in the Home Page of Hyper. Protected
The manufacture instructions of the products. These fields are defined in the Manufacture Instructions tab, of the Production Module. Edit & Rules
The parts list of the item. These fields are defined in the "Manufacture Instructions" of the Production Module. Edit & Rules
The manufacture instructions workflow. These fields can be defined in the Manufacture Instructions tab of the Production module. Edit & Rules
The product card in Hyper. Edit & Rules
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.
Edit Only
The product prices log, according to the prices validation. Edit Only
The product sale campaigns table. Edit Only
Edit Only
The available suppliers table of the product Edit Only
The projects table of Hyper Edit & Rules
The purchase order table, for the organizations suppliers. Edit Only
The purchase order items table. Edit Only
The recipt items table, which includes the payment method and its details. Protected
The receipts table of Hyper. Protected
The refund items table, which includes the payment method and its details. Protected
The Refunds table in Hyper. Protected
The Relationship table which includes the Phone calls and Emails. Edit & Rules
The Return of Goods Note main table of Hyper. Protected
The list of items for the Return of Goods Note. Protected
The list of Marketing Media Channels. Edit & Rules
The monthly usage details of the media channel. Edit & Rules
The sale opportunities table of Hyper. Edit & Rules
The service tickets primary table of Hyper. Edit & Rules
Edit & Rules
Edit Only
Edit & Rules
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.
Protected
The table of the approved commissions for a middleman. Edit & Rules
Edit & Rules
The task card of Hyper. Edit & Rules
Tax Invoice - Document Title Protected
The Tax Invoice items detalis. Protected
Edit & Rules
Edit Only
Journal of trades that the Clients has executed on the organization trading platforms Edit Only
Requests for modifications in external trading platforms through their API. The table can contain requests initiated by Hyper or by other systems. Edit Only
This table includes the clients records for the beggining of each trading day and includes the Balance, Equity, Credit and Margin. Edit Only
Open trades that the Clients has executed on the organization trading platforms Edit Only
This table includes the data of the end of the day and the beggining of the next day, for all of the open trades. Edit Only
Price Feed sampling table, used for Accounting and Risk management reports Edit Only
Daily Summary of Price Feed sampling table, used for Accounting and Risk management reports Edit Only
The Advanced Search Wizard of Hyper is used for creating and defining filters for customized searching, according to the users needs. Protected
The list of branches and Haifar adjustments for each of them. A branch can also represent a franchisee or telephone marketing team. Protected
Edit Only
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.
Edit Only
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. Edit Only
This table is used for defining documents of the organization to be available for the user in some of Hyper's modules. Edit Only
Edit Only
Protected
Edit Only
Edit Only
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). Edit Only
The list of the currencies rates. tThe exchange rate is defined according to the data source, as defined in the Currency Definition Table. Edit Only
The distribution areas definitions, according to the defined Region and City. Edit Only
Edit & Rules
Edit Only
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. Protected
List of all departments in the organization. Edit Only
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. Edit Only
Edit Only
Protected
Protected
Protected
Protected
The fields definitions for the import of bank statements. These fields are defined from the "Toolbox" tab of the Bookkeeping Module of Hyper. Edit Only
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. Edit Only
Edit & Rules
Edit & Rules
Mail Templates table. Edit Only
Edit Only
The definitions for Price Offers documents. This table fields can be defined in the Order Header & Footer tab of the System Fundamentals. Edit Only
Edit Only
Table of telephone extensions in the organization. The table is only relevant if Haifer connects to the organization's PBX. Edit Only
The assembly schedule table Edit Only
The workflow table of the production. This table is defined in the Fundamentals tab of the Production Module. Edit Only
The required workflow items. This table is defined from the Fundamentals tab of the Production module. Edit Only
The definitions table of the organizations delivery planning. This table is defined in the fundamentals tab of the Production Module. Edit Only
Definitions of non working days for the Production and the Delivery. These field are defined in the Fundamentals tab of the Production module. Edit Only
List of indices used by the company. Edit & Rules
The index rates definitions. The rates can be defined from the "Price Linkage Index" tab in the Toolbox of the Bookkeeping module. Edit Only
Edit & Rules
The definitions of products labels. Edit Only
The design and content settings of the barcode label. Edit Only
Edit Only
The report layout definition. Edit & Rules
Edit & Rules
Edit & Rules
The report definition and general information. Edit & Rules
The list of required table for the report. Edit & Rules
The filtering terms. Edit & Rules
The Sale Campaign details. These fields can be defined in the Marketing Campaigns tab of Marketing & Web-Content module. Edit Only
Edit Only
Edit Only
Server-side application settings table and the Heifer website Edit Only
Edit Only
Edit Only
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. Edit Only
Edit & Rules
One table for all financial instruments available to dealers (customers), in all trading platforms linked into the current database. Edit & Rules
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. Edit Only
Edit Only
The Employees extended authorization rules. The fields of this table are defined in the Authorization tab of the Employee Card. Edit Only
Edit Only
Edit Only
Edit Only
Value Added Tax Table, according to the country in which the Company is registered. Edit Only
Sub-table, field specification for the profile table. Edit Only
Table of reception profiles and service calls from external systems. Edit Only
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.
Edit Only
Edit Only
The billing details for construction site. Edit & Rules
The list of items for the billing, in construction site. Edit & Rules
The title of the project card in Hyper. Edit & Rules
The incomes of the construction site. Edit & Rules
Edit & Rules
Edit & Rules
Edit & Rules
Edit & Rules
Edit Only
List of attachments to a loan portfolio Edit & Rules
In this table we manage credit facilities with debtors (when financing an invoice or discounting checks).
For customers applying for a private loan, there is no need to use the table - unless the customer takes several loans then it is possible to enter his general terms and conditions in one line.
Edit & Rules
List of invoices or checks for financing for a single loan portfolio. Edit & Rules
Loan title record. The loan / financing management module is licensed separately. Edit & Rules
Insurance policies for the property for which the loan was granted. Usually in the real estate and automotive fields. Edit & Rules
Payment schedule and management throughout the life of the loan.
At first Hyper creates an expected repayment schedule and later the user can edit the table and change the refunds according to reality.
Hyper updates the interest rate according to actual repayments.
Edit & Rules
Book Keeping Modul Edit Only
Edit & Rules
Protected
Protected
Protected
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. Protected
Edit Only
Journal of trades that the Clients has executed on the organization trading platforms Edit Only
Feed data archiving tracking table. The administrator may edit the data to affect the conduct of the applications. Edit Only
Alerts definitions for the trading risk management system.
Only defined financial instruments will be available for the alerts system.
Edit & Rules
Protected
Capture of changes in client trading orders for regulation Edit & Rules
Edit Only
Edit & Rules
Edit Only
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.
Edit Only
Edit & Rules
Edit Only
Edit Only
Edit Only
Edit Only
Edit Only
Edit Only
Edit Only
Hyper Main Table of Contents: Website and document text memos, email templates, and even SMS templates. Edit & Rules
Edit Only
Edit Only
Records of the downloaded messages from POP3 or IMAP server Edit Only
Protected
Protected
Presence log back up table of the employee. Protected
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. Protected
Edit Only