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