Database Table "hyp_Clients"

Table Description

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.

Normal Storage

Normal

Archive Storage

Due to system admin decision only. valid for update in archive

Deleted Storage(Recycle)

Users with CRM Managers authotization or higher, can delete cards and sub-tables with no meetings or reservations
Field Name Description and Notes Data Type Text Length
Client Number Client number. Unique number. Integer 0
Agency The name of the agency, according to the Agencies table of Hyper. Status 0
Title Select the required title for the client. String 15
Last Name Surname / Company. The Last name of the client or the name of the company. Name 50
First Name Name 40
3rd Optional Name middle name of the client or the nickname/brand of the company. Name 40
Client Full Name The clients full name. This auto field is created from the "First Name" and the "Last Name" fields. String 135
Email The primary Email address String 100
Web Page The company Web page URL. String 60
1st Phone phone number / Cell Number. 1st option Phone 20
2nd Phone phone number / Cell Number. 2nd option Phone 20
3rd Phone phone number / Cell Number. 3rd option Phone 20
Fax Fax number Phone 20
VoIP Phone Voip Phone number. (Skype etc.) String 40
Street Address Default Company address: Street name and number. String 80
City Default Company address: City Name String 40
Region Default Company address: Region String 40
Country Default Company Country: Select from list String 40
Zip Code Default Company address: Zip Code String 15
Building / Apartment / Office Instructions String 80
Use a Different Mailing Address String 160
Gender Gender of client. Select from list. Status 0
Birthday The Birthday date of the client. Select from the calendar or fill in the date Date 0
ID Number ID Number of Client or company. The system verifies that the ID number is legal and displays a message when it does not match the defined rules. Serial 20
ID Doc Type ID Doc Type. Select from list. Status 0
ID Doc Valid Until Month 0
Country Issuing ID String 40
Docs & Forms Language
by Connected User
Status 0
Handling Status Handling status. Auto / Manually field. This field is updated according to the recent activity of the client. Status 0
Locked Name & ID Locked Name & ID. Hidden field, Boolean field marked as "TRUE" for clients handling status of "Real Client" or "Real Client + Club / Contract". Bool 0
Created On Created on. An auto field. FixDT 0
Created By Created by. Auto field - modified at the moment of creation. String 40
Parent Client Account Parent client account Auto filled according to the chosen client card in the "Parent client account name" field. Integer 0
Parent Client Account Name Parent client account name. Choose from list of existing customers, to create a linkage between the clients cards for accounting usage. String 135
Assign Journal Entries to Parent Redirect the journal entries to the parent card. The formal documents will still be produced with the Child client name. Bool 0
Middleman Account Middleman Account number of this client (Supplier number). Auto filled by the system after choosing "Middleman Name". Integer 0
Middleman Name Middleman Name. Select from list of existing suppliers (suppliers table).
When defined as middleman, the supplier card can be linked to a client card, and receive commissions accordingly.
String 135
Use Currency by Default Default currency for documents printing. Select from the list of currencies. As default, the system takes the defined bookkeeping currency from the sales tab of the System Fundamentals. String 4
Committed to pay VAT Bool 0
Produce International Documents by Default Produce International documents by default. Boolean field. Choose yes to produce the formal documents of this client in English. Bool 0
Send Official Documents to Primary Email Send official Documents to Primary Email. Select from list. choose the type of documents to send. Bool 0
Print prices on delivery notes Define whether to print the prices on delivery notes. Printing delivery notes without prices is available only for local documents. Bool 0
Default Payment Terms Default Payment Terms. Define the approved payment terms for the client. When choosing a credit payment, fill in the "Credit Months" and "Credit Days" fields accordingly. Status 0
Credit Months Credit months. Choose how many months. Active only when "Default Payment Terms" is "Standard Credit" / "Extra Credit" / "Consignation". Integer 0
Credit Days Credit days. Choose how many days. Active only when "Default Payment Terms" is "Standard Credit" / "Extra Credit" / "Consignation". Integer 0
Export Account to 3rd party Export account to 3rd party. Fill in account number. Integer 0
Gov Tax Authorities ID String 20
Money Laundering
--select--
Remote Detection
Face-to-face Identification
Not Regulated
Status 0
SEC Regulation
Normal
Not Regulated
Status 0
Industry Classification Code Integer 0
Industry Classification String 100
Contract CID Counter Hidden field, Automatically filled by the system. Integer 0
GIS Latitude GIS Latitude. Real 0
GIS Longitude GIS Longitude. Real 0
Data Source String 2
Website Password String 50
Website EMail Verification Status
Not Asked
Waiting
Verified
Status 0
Website Phone Verification Status
Not Asked
Waiting
Verified
Status 0
Website Last Token String 10
Website Hidden Script Monetary Trans Auth String 1
Website Shop / TP Activity
Closed
Readonly
Active
Status 0
Website Registration Flags String 5
Role for Loan Module None
Borrower
Debtor
Investor
Status 0
Default Sales Agent Default agent. Select from the list of users. The client card may be available and visible for the authorized sales agent only, String 40
Default Relationship Manager Default relationship Manager. Select from list of users. The client card may be available and visible for the authorized relationship managers only, according to the authorizations definitions. String 40
Spare Agent 1 spare agent 1. to choose from list of users/employees. String 40
Spare Agent 2 spare agent 2. to choose from list of users/employees. String 40
Spare Agent 3 spare agent 3. to choose from list of users/employees. String 40
Price List String 50
Accept Commercial Info by these channles Define whether the client accepts receiving commercial info and select the allowed channels . Status 0
Popup Serious Note Define a message for pop-up to be displayed when opening the clients card. String 160
Relationship Abstract Recent events summery. Auto field which displays the recent relationship log with the client. String 1000
Last Phone call On Auto filled according to last updated phone call time. FixDT 0
Last Phone call By String 40
Last Phone call / Try to call Result The updated status of the last phone call to the client. Status 0
Next Phone call On Select from calendar the timing for the next phone call. FixDT 0
Next Phone call By Select the required employee to make the next phone call. String 40
Last Contact On Automatically filled according to the last reported contact with the client. FixDT 0
Last Meeting On Automatically filled according to the last reported meeting with client. FixDT 0
First Meeting On Automatically filled according to the first reported contact with the client. FixDT 0
First Price Quotation On
Status 0
Became a Real Client On Date Automatically filled after approving the client as active. Date 0
Not Interested Reason The reason of the client for not becoming a real client. Select from the list. Status 0
Assigned by Wizard On Assigned by wizard on. Automatically filled by the system. FixDT 0
Lead Supplier Lead supplier. Choose from a list of sources. String 60
Lead Status
Normal
Newly Created
HOT Lead
Interested Again
Status 0
Go to tables index

Database Table "hyp_Client Price List"

Table Description

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.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
Catalogic Number String 30
Product Name The product name, as defined in the product card. String 120
Selling Method
Net Price
VAT included
Status 0
Tax-Free Selling Price The special Tax-Free Selling Price for the Client. Real 0
Taxable Selling Price The special Taxable Selling Price for the client. Real 0
Selling Price inc Tax Money 0
Selling Currency The selling currency of the private price. String 4
Warranty Period in months The warranty period in months for the client. Real 0
Last Update This automatic field displayes the time of the last modification in the client price list. FixDT 0
Updated By This automatic field displayes the name of the user who has made the last modification in the client price list. String 40
Go to tables index

Database Table "hyp_Client Contract"

Table Description

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.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
Commitment ID The unique number of the commitment, given by the system. Integer 0
Catalogic Number The catalogic number of the committed / prepaid product. String 30
Product Name String 120
Units Supplied The total amount of units that have been supplied. Real 0
Prepaid This field describes whether the product was prepaid or not. This is an automatic field, updated by the system according to tax invoice. Bool 0
Committed Until Date The system allows to use this contract until the defined date in this field. Date 0
Committed Units The amount of units in the contract. Real 0
Selling Method
Net Price
VAT included
Status 0
Tax-Free Selling Price Real 0
Taxable Selling Price Real 0
Selling Price inc Tax Money 0
Selling Currency String 4
Last Update FixDT 0
Updated By String 40
Go to tables index

Database Table "hyp_Client Monthly Billing for Services"

Table Description

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
Commitment ID Integer 0
Service Started From This is a mandatory field Which should be defined in the "Monthly Billing for Services" tab of the client card Sales Rules. The system automatically calculates the monthly rate from this date on, and will charge the client on a monthly basis. Date 0
Service Ends At Fill in this field if there is any specific date for the end of the service. As lonk as the service in continuous, do not update this field. Date 0
Catalogic Number The catalogic number of the product / swervice. String 30
Description A short description of the service. As default, the defined description of the service will be displayed. String 120
Quantity Real 0
Unit of measure
Status 0
Selling Method
Net Price
VAT included
Status 0
Tax-Free Selling Price Real 0
Taxable Selling Price Real 0
Selling Price inc Tax Money 0
Selling Currency String 4
Logic The required billing method from the suggested list: Monthly Repeating / Fix Price Repeating / One Time Event. Status 0
Last Billing Date Date 0
Notes Inner notes for the organization. String 300
Last Update The date of the recent update. FixDT 0
Updated By An automaitic field. The user name that have made the last update. String 40
Go to tables index

Database Table "hyp_Client 3rd Party Billing for Services"

Table Description

The 3rd Party Billing for services which is defined from the Sales rules of the client card.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
Created on UTC FixDT 0
Time FixDT 0
Catalogic Number String 30
Description String 120
Quantity Real 0
Unit of measure
Status 0
Tax-Free Selling Price Real 0
Taxable Selling Price Real 0
Selling Currency String 4
Billing Doc Type
Pending (not served yet)
Order Document
Pro-forma Invoice
Tax Invoice
Status 0
Invoice Doc Ref Real 0
IO String 60
Campaign String 100
Impressions Integer 0
Clicks Integer 0
Conversions Integer 0
Cost Money 0
Revenue Money 0
Profit Money 0
Country String 3
Advertiser String 60
Publisher String 60
Platform / Server String 10
Supplier Number Integer 0
Fraud
No
Self Detected
Client Detected
Client Complain
Status 0
Sys Ref.1 Real 0
Sys Ref.2 Real 0
Sys Ref.3 Real 0
Go to tables index