Database Table "hyp_VAT_GST Rates"

Table Description

Value Added Tax Table, according to the country in which the Company is registered.

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name Description and Notes Data Type Text Length
From Date The date the new VAT rate comes into effect. Date 0
Tax Rate Percent of value added tax. Money 0
Jump to tables index

Database Table "hyp_Price Index Linkage Definition"

Table Description

List of indices used by the company.

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name Description and Notes Data Type Text Length
Main Key Internal key. String 2
Code Code / name representing the index. Heifer supports all the characters but it is recommended to quote the source. String 15
Full Name in Local Language The name of the index in the local language / according to the country in which it was conducted. String 30
Jump to tables index

Database Table "hyp_Currency Definition"

Table Description

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).

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name Description and Notes Data Type Text Length
Code Currency code, usually according to the ISO standard. String 4
Full Name in English The currency name is always in English. The system will automatically fill this field for currencies from both the ECB and the BOI. String 30
Minimal Cash Coin Amount The smallest currency value. The smallest measure of currency issued to the public. Money 0
Safe Minimal Rate Minimum security rate. Is not required.
The field allows a minimum exchange rate restriction in accordance with the Company's policy.		 Real 0
Safe Maximal Rate Maximum security rate. Is not required.
The field allows a maximum exchange rate restriction in accordance with the Company's policy.		 Real 0
Data Source The source of the data is the central bank symbol from which the representative rates are taken (eg ECB or BOI).
As the Haier software develops and according to the country in which the company is registered, this data may change automatically!		 String 3
Jump to tables index

Database Table "hyp_Global Definitions"

Table Description

Normal Storage

Archive Storage

Deleted Storage(Recycle)
Field Name Description and Notes Data Type Text Length
Main Key String 2
Company ID Number Serial 20
Company Name in English String 100
Company Authority in English String 40
Company Registered in Country String 40
Bookkeeping Currency String 4
Client Name Stringing
Last Name + First Name
First Name + Last Name
Title + Last Name + First Name
Title + First Name + Last Name
Last Name + First Name + 3rd Optional Name
Title + Last Name + First Name + 3rd Optional Name		 Status 0
Employee Name Stringing
Last Name + First Name
First Name + Last Name
Title + Last Name + First Name
Title + First Name + Last Name		 Status 0
Main Phone Country Code (prefix) Integer 0
Main Country Code on Phone Fields
Keep as Input
Remove Main Prefix
Add Main Prefix if no Code Exist		 Status 0
Acceptable Input Languages String 100
Access Authorization Groups String 1000
Force users to change password
No
Every 1 Month
Every 2 Months
Every 3 Months
Every 6 Months		 Status 0
Allow to Login only from WAN IP Addresses String 150
License title instead of company number String 80
International Details for A4 Header String 200
Use Address Wizard
No. Just simple Edit box
Yes, Combine Edit and Dialog Popup
Yes, Address input only by Wizard !		 Status 0
Official Clients Activity Starting from Date Date 0
Allow Dial Out through PBX Automation Bool 0
How to Init "Starting At" for a New Task
Keep it Empty
Set Current Date
Set Current Date & Time		 Status 0
Calendar Graphic View From Hour Integer 0
Calendar Graphic View Until Hour Integer 0
Fields for "Calendar Meeting Window" String 250
Send Calendar Updates via Email by Default Bool 0
Send Calendar Updates via SMS by Default Bool 0
Calendar Limit Total Number of Participants to Integer 0
Required fields when the client is not interested String 400
Required client fields before first transaction String 400
Invoices Total Rounding Off Bool 0
Download Currency Rates At Hour 0
Currency Convert Wizards Feed Source
Representative Rate
Live TP Feed
Live Feed from SYE		 Status 0
Receipt / Refund Cash UI
Bills Table
Bills Table and Free Field
Bills Skin		 Status 0
Require Client ID beyond Total Amount LC Integer 0
Set Sale Docs Agency According to
The Producing User
The Client's Agency		 Status 0
Copy Sale Docs Agent from Client record field
--NO--
Default Sales Agent
Default Relationship Manager
Spare Agent 1
Spare Agent 2
Spare Agent 3		 Status 0
Delete Standing Orders after # months of NO Use Integer 0
Default Sales Analysis by Document
Tax Invoice vs Credit Invoice
Delivery Note vs Return of Goods
Order vs Return of Goods		 Status 0
Number Delivery Notes From Integer 0
Number Return Goods From Integer 0
Number Tax Invoices From Integer 0
Number Receipts From Integer 0
Number Credit Invoices From Integer 0
Number Refunds From Integer 0
Print # copies for every Original Delivery Note Integer 0
Print # copies for every Original Return Goods Integer 0
Print # copies for every Original Tax Invoice Integer 0
Print # copies for every Original Receipt Integer 0
Print # copies for every Original Credit Invoice Integer 0
Print # copies for every Original Refund Integer 0
Default Notes for International Delivery Note String 400
Default Notes for International Return Goods String 400
Default Notes for International Tax Invoice String 400
Default Notes for International Credit Invoice String 400
Default Notes for International Receipt Form String 400
Default Notes for International Refund Form String 400
Default International Product Return Policy String 500
Financial Institution Bool 0
Money Laundering
Not Regulated
Banking Services Provider
E-Loans (credit provider)
CFD Broker
Loans Broker (middleman)		 Status 0
Default Refund Form Purpose
User must select
Refund Retail Client
Withdrawal from Account
Vehicle Financing
Real Estate Financing
Invoice Financing
Private Loan		 Status 0
Editing Journal Entries after Creation
Entry will be ReadOnly after 30 minutes
Allow Delete / Recovery, Fields Readonly
Allow Editing except Amount & Currency
All fields editable		 Status 0
Minimal BK Entry Date Date 0
Minimal Government Report Date Date 0
Company TDS ID Integer 0
Tax Invoice "Tax Free" Default Account Default Fees Account Integer 0
Tax Invoice "Tax Liable" Default Account Default P&L Account Integer 0
Receipt Cash Default Account Integer 0
Receipt Cheque Default Account Integer 0
Receipt C.C. Default Account Integer 0
Bank Transfer Default Account Integer 0
Receipt Assignment of Rights Default Account Integer 0
Payment Cheque Default Account Integer 0
Clients Payment Interface Settling Account Integer 0
Suppliers Payment Interface Settling Account Integer 0
Clients Deduction At Source Default Account Integer 0
Suppliers Deduction At Source Default Account Integer 0
Currency Swaps Default Account Integer 0
Currency Swap for Clients Account Integer 0
Currency Swap for Suppliers Account Integer 0
Currency Swap for Projects Account Integer 0
TPM Profit & Loss Account Integer 0
TPM Dividend Account Integer 0
TPM Rollover Account Integer 0
TPM Other Commission Account Integer 0
Cheque "Payable to Payee only" Bool 0
Cheque Default A4 Format String 20
Include "Admin Fee" in Clients TDS calc Bool 0
Price Index Linkage Definition String 200
Activate "CRM Spare Table 1" Module (at Homepage)
No, Hide this tab
Yes, with Manual Key
Yes, with Automatic Key Generator		 Status 0
Activate "CRM Spare Table 3" Module (at Homepage)
No, Hide this tab
Yes, with Manual Key
Yes, with Automatic Key Generator		 Status 0
Activate "CRM Spare Table 5" Module (at Homepage)
No, Hide this tab
Yes, with Manual Key
Yes, with Automatic Key Generator		 Status 0
Activate "CRM Spare Table 6" Module (at Homepage)
No, Hide this tab
Yes, with Manual Key
Yes, with Automatic Key Generator		 Status 0
Activate "Client Extra Properties 1"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Client Extra Properties 2"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Client Extra Properties 3"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source
Yes, Mass Data mode with Ext sub table
Yes, Mass Data & READ ONLY mode		 Status 0
Activate "Client Extra Properties 4"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Client Extra Properties 5"
No, Hide this tab
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Client Extra Properties 6"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Client Extra Properties Turn him to Active Bool 0
Activate "Supplier Extra Properties 1"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Supplier Extra Properties 2"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Activate "Supplier Extra Properties 3"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source
Yes, Mass Data mode with Ext sub table
Yes, Mass Data & READ ONLY mode		 Status 0
Activate "Supplier Extra Properties 4"
No, Hide this tab
Yes, Override whole table on save
Yes, Update each sub record separately
Yes, as READ ONLY data source		 Status 0
Supplier Extra Properties Turn him to Active Bool 0
Activate Point of Sale Module Bool 0
Activate Construction Site Module Bool 0
Activate 3rd Party Billing Module Bool 0
Activate Trading Platforms Module Bool 0
Number Primary Accounts in High Range Bool 0
Number Clients in High Range Bool 0
Number Suppliers in High Range Bool 0
Trading Data in Archive until date Date 0
Product Image #1 Title String 20
Product Image #2 Title String 20
Product Image #3 Title String 20
Product Image #2 Resolution (WxH) String 9
Product Image #3 Resolution (WxH) String 9
Enable Product Price History Bool 0
Enable Product Valid Suppliers List Bool 0
Offers are Valid for # Days Integer 0
Fields for "ERP New Order" popup window String 400
Order Prototype Virtual Menu Node ID Integer 0
Order Prototype Display Node Fields String 5
Order Items Display Node Fields String 5
Order Items Display Node Fields for PP&C String 5
Order Default CAD File String 30
How to use Order Subject in Tax Invoice
None
Copy the Subject before the Order Items
Put the Subject instead of all Order Items		 Status 0
Enable "Order Content Import" Interface
None
Import from .csv file
Import from Excel Clipboard Format
Import from .csv file & Render BOM
Import from Excel Clipboard Format & Render BOM		 Status 0
Jump to tables index