List of DB Tables (in all books)
| Table Name | Description and Notes | Admin Privilege |
|---|---|---|
| hyp_Clients | 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 |
| hyp_Contact Persons | The contact persons in the Client / Supplier card. This table contains the additional contact persons of the organization or the client. | Edit & Rules |
| hyp_Suppliers | 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 |
| hyp_Users | The Employee Card in Hyper. | Edit & Rules |
| hyp_Accounts | 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 |
| hyp_Audio Recordings | 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 |
| hyp_Bad Client Leads | This table contains the duplicate / fictitious customer information in the system and the summary of the contact with them. | Edit & Rules |
| hyp_Cash in hand Management | Protected | |
| hyp_Cheques | Printed Cheques | Protected |
| hyp_Cheques Deposit Form | Edit & Rules | |
| hyp_Cheques Deposit Form Items | Edit & Rules | |
| hyp_Cheques_Breakdown | This table contains the details of printed cheques. | Protected |
| hyp_Client 3rd Party Billing for Services | The 3rd Party Billing for services which is defined from the Sales rules of the client card. | Edit Only |
| hyp_Client Contract | 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 |
| hyp_Client Monthly Billing for Services | Edit Only | |
| hyp_Client Open Billing or Supply | Tracking production, supply and customer billing according to orders. Delivered and charged records, will be archived. | Edit Only |
| hyp_Client Price List | 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 |
| hyp_Client X Statements | List of digitally signed statements & documents for customer or vendor. We always use PDF files. | Protected |
| hyp_Clients Record Extension | Edit & Rules | |
| hyp_Credit Invoice | Credit invoice table | Protected |
| hyp_Credit Invoice Items | This table contains the items for the credit invoice. | Protected |
| hyp_Delivery Channel Notes | The delivery channel notes. | Edit & Rules |
| hyp_Delivery Note | The Delivery note of goods in Hyper. | Protected |
| hyp_Delivery Note Items | The included items in the delivery note. | Protected |
| hyp_Entity Credit Line | Edit & Rules | |
| hyp_Entity Documents Tree | Edit & Rules | |
| hyp_Entity Tax Settings | The TDS definitions of Hyper entity. | Edit Only |
| hyp_Entity_Banking_and_Credit_Cards | Protected | |
| hyp_Foreign Exchange Trades | Edit & Rules | |
| hyp_Import Bank Statement Worksheet | Edit & Rules | |
| hyp_Inbox | The list of messages. | Edit Only |
| hyp_Journal | Book Keeping Modul | Protected |
| hyp_Journal Attachments | Edit & Rules | |
| hyp_Mail_Abstract for search | The Email messages abstracts table. This table is used for messages searching purpose. | Edit Only |
| hyp_Mail_Attachment | The field of the "Attechments" tab in Email message. | Edit Only |
| hyp_Mail_Recipients | The list of addressees of the Email message. | Edit Only |
| hyp_Meeting EMail Links | The linkage of Email correspondences to meetings. | Protected |
| hyp_Meetings | Edit & Rules | |
| hyp_Meetings Automation Processing | Sub-table with the list of invitees for the meeting. | Protected |
| hyp_Meetings Invitations | Sub-table with the list of invitees for the meeting. | Edit Only |
| hyp_Order Confirmation Chain | The confirmation chain proccess of an order. | Edit Only |
| hyp_Order Items | The Order Items and their details. | Edit & Rules |
| hyp_Order Items BOM | The assembly details of the orders items. | Edit & Rules |
| hyp_Order Payment POS UI | The payment details for the orders items | Edit & Rules |
| hyp_Orders | All of the orders details, that also include the clients details, payment methods, delivery details, etc. | Edit & Rules |
| hyp_Outbox | The list of sent messages from outbox. | Edit Only |
| hyp_Outbox Drafts | The drafts table of the Outbox. | Edit Only |
| hyp_Password_Storage | The table of passwords that have been defined in the Password Storage, in the Home Page of Hyper. | Protected |
| hyp_PPC Manufacture Instructions | The manufacture instructions of the products. These fields are defined in the Manufacture Instructions tab, of the Production Module. | Edit & Rules |
| hyp_PPC Manufacture Instructions Parts List | The parts list of the item. These fields are defined in the "Manufacture Instructions" of the Production Module. | Edit & Rules |
| hyp_PPC Manufacture Instructions Workflow | The manufacture instructions workflow. These fields can be defined in the Manufacture Instructions tab of the Production module. | Edit & Rules |
| hyp_Product Header | The product card in Hyper. | Edit & Rules |
| hyp_Product Inventory | 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 |
| hyp_Product Price Log | The product prices log, according to the prices validation. | Edit Only |
| hyp_Product Sale | The product sale campaigns table. | Edit Only |
| hyp_Product Script | Edit Only | |
| hyp_Product Valid Suppliers | The available suppliers table of the product | Edit Only |
| hyp_Projects | The projects table of Hyper | Edit & Rules |
| hyp_Purchase Order | The purchase order table, for the organizations suppliers. | Edit Only |
| hyp_Purchase Order Items | The purchase order items table. | Edit Only |
| hyp_Receipt Items | The recipt items table, which includes the payment method and its details. | Protected |
| hyp_Receipts | The receipts table of Hyper. | Protected |
| hyp_Refund Items | The refund items table, which includes the payment method and its details. | Protected |
| hyp_Refunds | The Refunds table in Hyper. | Protected |
| hyp_Relationship | The Relationship table which includes the Phone calls and Emails. | Edit & Rules |
| hyp_Return of Goods Note | The Return of Goods Note main table of Hyper. | Protected |
| hyp_Return of Goods Note Items | The list of items for the Return of Goods Note. | Protected |
| hyp_Sale Media Channel | The list of Marketing Media Channels. | Edit & Rules |
| hyp_Sale Media Channel Monthly Usage | The monthly usage details of the media channel. | Edit & Rules |
| hyp_Sale Opportunities | The sale opportunities table of Hyper. | Edit & Rules |
| hyp_Service Ticket | The service tickets primary table of Hyper. | Edit & Rules |
| hyp_Service Ticket Attachments | Edit & Rules | |
| hyp_Service Ticket Confirmation Chain | Edit Only | |
| hyp_Service Ticket Relationship | Edit & Rules | |
| hyp_Stock Journal | 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 |
| hyp_Supplier Commission List | The table of the approved commissions for a middleman. | Edit & Rules |
| hyp_Supplier Invoice Management | Edit & Rules | |
| hyp_Tasks | The task card of Hyper. | Edit & Rules |
| hyp_Tax Invoice | Tax Invoice - Document Title | Protected |
| hyp_Tax Invoice Items | The Tax Invoice items detalis. | Protected |
| hyp_TPM Account Deals | Edit & Rules | |
| hyp_TPM Account Status | Edit Only | |
| hyp_TPM Closed Positions | Journal of trades that the Clients has executed on the organization trading platforms | Edit Only |
| hyp_TPM Commands | Requests for modifications in external trading platforms through their API. The table can contain requests initiated by Hyper or by other systems. | Edit Only |
| hyp_TPM Equity History | This table includes the clients records for the beggining of each trading day and includes the Balance, Equity, Credit and Margin. | Edit Only |
| hyp_TPM Open Positions | Open trades that the Clients has executed on the organization trading platforms | Edit Only |
| hyp_TPM Positions PnL History | 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 |
| hyp_Trading System Feed History | Price Feed sampling table, used for Accounting and Risk management reports | Edit Only |
| hyp_Trading System Feed VaR | Daily Summary of Price Feed sampling table, used for Accounting and Risk management reports | Edit Only |
| hyp_Advanced Search Wizard | The Advanced Search Wizard of Hyper is used for creating and defining filters for customized searching, according to the users needs. | Protected |
| hyp_Agencies | The list of branches and Haifar adjustments for each of them. A branch can also represent a franchisee or telephone marketing team. | Protected |
| hyp_Alerts by Events | Edit Only | |
| hyp_Anti Spam White List | 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 |
| hyp_Attachments_File_Types_Handlers | 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 |
| hyp_Attachments_Templates | This table is used for defining documents of the organization to be available for the user in some of Hyper's modules. | Edit Only |
| hyp_Balance Sheet Classes | Edit Only | |
| hyp_Built-in Docs Printing Customization | Protected | |
| hyp_Clearing Brands | Edit Only | |
| hyp_Corporation Setup | Edit Only | |
| hyp_Currency Definition | 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 |
| hyp_Currency Rates | 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 |
| hyp_Custom_Zonation | The distribution areas definitions, according to the defined Region and City. | Edit Only |
| hyp_Customer Clubs Definition | Edit & Rules | |
| hyp_Default Document Folders | Edit Only | |
| hyp_Definitions by Country | 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 |
| hyp_Departments List | List of all departments in the organization. | Edit Only |
| hyp_EMail Accounts | 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 |
| hyp_Email Server | Edit Only | |
| hyp_Files_Sync_Content | Protected | |
| hyp_Files_Sync_Profile | Protected | |
| hyp_Global Definitions | Protected | |
| hyp_Illustration Image | Protected | |
| hyp_Import Bank Statement Main | 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 |
| hyp_Import Bank Statement Rules | 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 |
| hyp_Import Client From List Items | Edit & Rules | |
| hyp_Import Client From List Wizard | Edit & Rules | |
| hyp_Mail_Templates | Mail Templates table. | Edit Only |
| hyp_Order Confirmation Flow Chain Definition | Edit Only | |
| hyp_Order Default Memos | The definitions for Price Offers documents. This table fields can be defined in the Order Header & Footer tab of the System Fundamentals. | Edit Only |
| hyp_Order_Header_link_to_BOM_Fields | Edit Only | |
| hyp_PBX Directory | Table of telephone extensions in the organization. The table is only relevant if Haifer connects to the organization's PBX. | Edit Only |
| hyp_PPC Assembly Schedule | The assembly schedule table | Edit Only |
| hyp_PPC Workflow | The workflow table of the production. This table is defined in the Fundamentals tab of the Production Module. | Edit Only |
| hyp_PPC Workflow Items | The required workflow items. This table is defined from the Fundamentals tab of the Production module. | Edit Only |
| hyp_PPC_Global_Definition | The definitions table of the organizations delivery planning. This table is defined in the fundamentals tab of the Production Module. | Edit Only |
| hyp_PPC_Non_Working_Days | 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 |
| hyp_Price Index Linkage Definition | List of indices used by the company. | Edit & Rules |
| hyp_Price Index Linkage Rates | The index rates definitions. The rates can be defined from the "Price Linkage Index" tab in the Toolbox of the Bookkeeping module. | Edit Only |
| hyp_Price List Definition | Edit & Rules | |
| hyp_Print_Labels_Wizard | The definitions of products labels. | Edit Only |
| hyp_Print_Labels_Wizard_Fields_List | The design and content settings of the barcode label. | Edit Only |
| hyp_Report Customized List | Edit Only | |
| hyp_Report Layout | The report layout definition. | Edit & Rules |
| hyp_Report Layout Functions | Edit & Rules | |
| hyp_Report Layout Record Fields | Edit & Rules | |
| hyp_Report Title | The report definition and general information. | Edit & Rules |
| hyp_Report Uses Tables | The list of required table for the report. | Edit & Rules |
| hyp_Report Wheres Def | The filtering terms. | Edit & Rules |
| hyp_Sale Campaign | The Sale Campaign details. These fields can be defined in the Marketing Campaigns tab of Marketing & Web-Content module. | Edit Only |
| hyp_Sale Docs Notes Ext | Edit Only | |
| hyp_Sale Opportunity Flow Chain Definition | Edit Only | |
| hyp_Server Side Automations Settings | Server-side application settings table and the Heifer website | Edit Only |
| hyp_Service Customize Status List | Edit Only | |
| hyp_Service Flow Chain Definition | Edit Only | |
| hyp_Stockroom | 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 |
| hyp_Supplier Invoice Category Definition | Edit & Rules | |
| hyp_Trading System Symbols | One table for all financial instruments available to dealers (customers), in all trading platforms linked into the current database. | Edit & Rules |
| hyp_Trading Systems List | 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 |
| hyp_Unit of measure Definition | Edit Only | |
| hyp_User Ext Authorization Rules | The Employees extended authorization rules. The fields of this table are defined in the Authorization tab of the Employee Card. | Edit Only |
| hyp_User Personal Settings | Edit Only | |
| hyp_User Work Shifts | Edit Only | |
| hyp_User Work Shifts Changes | Edit Only | |
| hyp_VAT_GST Rates | Value Added Tax Table, according to the country in which the Company is registered. | Edit Only |
| hyp_Web_Data_Port_Fields | Sub-table, field specification for the profile table. | Edit Only |
| hyp_Web_Data_Port_Profile | Table of reception profiles and service calls from external systems. | Edit Only |
| hyp_Web_Service_Config | 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 |
| hyp_Automation Task Queue | Edit Only | |
| hyp_Construction Site Billing | The billing details for construction site. | Edit & Rules |
| hyp_Construction Site Billing Items | The list of items for the billing, in construction site. | Edit & Rules |
| hyp_Construction Site Header | The title of the project card in Hyper. | Edit & Rules |
| hyp_Construction Site Incomes | The incomes of the construction site. | Edit & Rules |
| hyp_Construction Site MAP | Edit & Rules | |
| hyp_Construction Site MAP1 | Edit & Rules | |
| hyp_Construction Site Types | Edit & Rules | |
| hyp_CryptoCurr Exchange Trades | Edit & Rules | |
| hyp_Custom Dev Settings NO UI | Edit Only | |
| hyp_Loan Attachments | List of attachments to a loan portfolio | Edit & Rules |
| hyp_Loan Client Terms | 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 |
| hyp_Loan Fin Props List | List of invoices or checks for financing for a single loan portfolio. | Edit & Rules |
| hyp_Loan Header | Loan title record. The loan / financing management module is licensed separately. | Edit & Rules |
| hyp_Loan Insurance Policies | Insurance policies for the property for which the loan was granted. Usually in the real estate and automotive fields. | Edit & Rules |
| hyp_Loan Payments Schedule | 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 |
| hyp_Money Laundering Conversion Extended List | Book Keeping Modul | Edit Only |
| hyp_TPM Contract Rollover | Edit & Rules | |
| hyp_TPM Daily Risk Assets | Protected | |
| hyp_TPM Daily Risk Instruments | Protected | |
| hyp_TPM Daily Risk Totals | Protected | |
| hyp_TPM Feed Storage Buffer | 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 |
| hyp_TPM Instrument Daily Events | Edit Only | |
| hyp_TPM Journal Buffer | Journal of trades that the Clients has executed on the organization trading platforms | Edit Only |
| hyp_TPM Live Feed Sampler Settings | Feed data archiving tracking table. The administrator may edit the data to affect the conduct of the applications. | Edit Only |
| hyp_TPM Live Risk Alerts | Alerts definitions for the trading risk management system. Only defined financial instruments will be available for the alerts system. |
Edit & Rules |
| hyp_TPM Policies | Protected | |
| hyp_TPM Positions Change Log | Capture of changes in client trading orders for regulation | Edit & Rules |
| hyp_TPM Settings Matrix Symbol vs Group | Edit Only | |
| hyp_TPM Slippage Report | Edit & Rules | |
| hyp_Trading System Exp Sym Reg Translation | Edit Only | |
| hyp_Trading System Symbols Translation | 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 |
| hyp_User Commissions | Edit & Rules | |
| hyp_User Personal Contacts | Edit Only | |
| hyp_User Presence Log | Edit Only | |
| hyp_User Sendees | Edit Only | |
| hyp_Website Client Fields Matrix | Edit Only | |
| hyp_Website Contact Person Divisions | Edit Only | |
| hyp_Website Contact Persons Fields Matrix | Edit Only | |
| hyp_Website Mail to Clients | Edit Only | |
| hyp_Website Text | Hyper Main Table of Contents: Website and document text memos, email templates, and even SMS templates. | Edit & Rules |
| SYE_Countries Industries Classification List | Edit Only | |
| SYE_Table Script | Edit Only | |
| hyp_EMail_Servers_Sync | Records of the downloaded messages from POP3 or IMAP server | Edit Only |
| hyp_ERP Automation Log | Protected | |
| hyp_Forms Modification Log | Protected | |
| hyp_Presence Log Backup | Presence log back up table of the employee. | Protected |
| hyp_Relationship Meetings Log | 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 |
| hyp_User Login Log | Edit Only |