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_Projects | The projects table of Hyper | 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_Bank Transfer Interface | Edit Only | |
| hyp_Cash in hand Management | Protected | |
| hyp_Cheques Deposit Form | Edit & Rules | |
| hyp_Cheques Deposit Form Items | Edit & Rules | |
| hyp_Clearing Credit Cards | Protected | |
| hyp_Client Contacts | In this table, the contacts linked to or working for the client are updated | Edit & Rules |
| 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 X Statements | List of digitally signed statements & documents for customer or vendor. We always use PDF files. | Edit & Rules |
| hyp_Clients Record Extension | Edit & Rules | |
| hyp_Clients Website Ext. Record | Edit Only | |
| 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_Email Attachment | Edit Only | |
| hyp_Email Inbox | Edit Only | |
| hyp_Email Outbox | Edit Only | |
| hyp_Email Outbox Drafts | Edit Only | |
| hyp_Email Recipients | Edit Only | |
| 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 | Edit & Rules | |
| hyp_Import Bank Statement Worksheet | Edit & Rules | |
| hyp_Inventory Log | Protected | |
| hyp_Journal | Book Keeping Modul | Protected |
| hyp_Journal Attachments | 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 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_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_Opening 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_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_Orders | All of the orders details, that also include the clients details, payment methods, delivery details, etc. | Edit & Rules |
| hyp_Password_Storage | The table of passwords that have been defined in the Password Storage, in the Home Page of Hyper. | Protected |
| hyp_Payment Cheque | Protected | |
| hyp_Payment Cheque Breakdown | 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 Media | Edit & Rules | |
| hyp_Product Script | Edit Only | |
| hyp_Product Valid Suppliers | The available suppliers table of the product | Edit Only |
| hyp_Project Contacts | 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 Opportunity | Edit & Rules | |
| hyp_Sale Opportunity Attachments | Edit & Rules | |
| hyp_Sale Opportunity Wall | Edit & Rules | |
| hyp_Sale Opportunity Web Input | Edit Only | |
| hyp_Sales Promotions | Edit Only | |
| hyp_Sales Promotions Items | 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_SMS_Out | Edit Only | |
| hyp_Supplier Commission List | The table of the approved commissions for a middleman. | Edit & Rules |
| hyp_Supplier Contacts | 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 Feed VaR | 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_Transaction Invoice | Edit & Rules | |
| hyp_Transaction Invoice Items | Edit & Rules | |
| hyp_AML Conversion List | Edit Only | |
| hyp_Automation Task Queue | Edit Only | |
| 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_CryptoCurr Exchange Trades | Edit & Rules | |
| hyp_Email Accounts Health Status | Edit & Rules | |
| hyp_Entity Website Quiz | Edit & Rules | |
| hyp_Entity Website Quiz Data | Edit Only | |
| hyp_Foreign Exchange Trades | Edit & Rules | |
| hyp_Interest Bearing Deposit | Edit & Rules | |
| hyp_Interest Bearing Deposit Daily Value | Edit Only | |
| hyp_Loan Attachments | List of attachments to a loan portfolio | Edit & Rules |
| hyp_Loan Client Payments to Income | 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 Distribution of Funds | 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 Original Payments Schedule Backup | Edit & Rules | |
| hyp_Loan Payments Draft | Edit & Rules | |
| hyp_Money Laundering Conversion Extended List | Edit Only | |
| hyp_Project Real Estate Map | Edit & Rules | |
| hyp_Project Real Estate Types for Map | Edit & Rules | |
| hyp_Report Money Laundring Intelligence | Edit Only | |
| hyp_TPM Abnormal Feed Price | Edit Only | |
| hyp_TPM Attachments | Edit & Rules | |
| hyp_TPM Contract Rollover | Edit & Rules | |
| hyp_TPM Daily Risk Assets | Edit & Rules | |
| hyp_TPM Daily Risk Instruments | Edit & Rules | |
| 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 Journal Buffer | Journal of trades that the Clients has executed on the organization trading platforms | Edit Only |
| hyp_TPM Positions Change Log | Capture of changes in client trading orders for regulation | Edit & Rules |
| hyp_TPM Symbol Quantity Split | 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 Mail to Clients | Edit Only | |
| SYE_Monitor KeepAlive v2 Push | Edit Only | |
| htp_Process Management Chain Definition | 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. | Edit Only |
| hyp_Agencies | The list of branches and Haifar adjustments for each of them. A branch can also represent a franchisee or telephone marketing team. | Edit Only |
| hyp_Alerts by Events | 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_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. | Edit Only |
| hyp_Departments List | List of all departments in the organization. | Edit Only |
| hyp_Document File Types Handlers | 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_Email White List | Edit Only | |
| hyp_Ext App Config | Edit Only | |
| hyp_Global Definitions | Protected | |
| hyp_Hardware Payment Terminals EMV | Edit Only | |
| 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_Import Price List Sheet Preset | Edit & Rules | |
| hyp_Inventory Stockrooms | 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_Mail_Templates | Mail Templates table. | Edit Only |
| hyp_New Documents Templates | 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 Only |
| 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_Product Price List Definition | Edit Only | |
| hyp_Product Price List Items | 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_Server Side Automations Settings | Server-side application settings table and the Heifer website | Edit Only |
| hyp_Service Customize Status List | Edit Only | |
| hyp_Supplier Invoice Category Definition | Edit & Rules | |
| hyp_Tree Menu Customization | 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 Menu Favorites | 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 API Tokens | 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_Website Contact Person Divisions | Edit Only | |
| hyp_Website Form Fields List | Edit Only | |
| hyp_Website Text | Hyper Main Table of Contents: Website and document text memos, email templates, and even SMS templates. | Edit & Rules |
| hyp_TPM Exp Sym Reg Translation | Edit Only | |
| hyp_TPM Groups | 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 Servers List | Table of settings for trading platforms (exposure and coverage) connected to Hyper. After changing a setting in this table, it is recommended to restart the relevant interface application (via the Hyper client) to ensure that the settings have been fully implemented. |
Edit Only |
| hyp_TPM Symbol by Group Ext Config | Edit Only | |
| hyp_TPM Symbols | Edit & Rules | |
| hyp_TPM Symbols in Data Source | Edit Only | |
| hyp_TPM Symbols Translation | Edit Only | |
| hyp_Website Quiz | Edit & Rules | |
| hyp_Website Quiz Adv Rules | Edit & Rules | |
| hyp_Website Quiz Questions | Edit & Rules | |
| SYE Price Index Linkage API | Table of indexes stored on SYE server and can be imported automatically | Edit Only |
| SYE Price Index Linkage Rates | List of rates of each index | Edit Only |
| SYE_Central FX Rates | Edit Only | |
| SYE_Countries Black List | Edit Only | |
| SYE_Countries Industries Classification List | Edit Only | |
| SYE_Currencies List | Edit Only | |
| SYE_Currencies Rates by Source | Edit Only | |
| hyp_Application DB Upgrade | Protected | |
| 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_SMS Provider Status | Edit Only | |
| hyp_TPM Feed History | Edit Only | |
| hyp_TPM Instrument Daily Events | Edit Only | |
| hyp_User Login Log | Edit Only | |
| hyp_Website Usage Log | Edit Only | |
| SQL Tables Sync | Edit Only |