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 English Title Data Type Text Length Editor Attributes json
From Date Date 0 SelectEdit Mandatory
Key Field
FromDate
Class String 3 Edit Key Field Class
Tax Rate Real 0 Edit TaxRate
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 English Title Data Type Text Length Editor Attributes json
Index ID Integer 0 Edit Read Only
Key Field
IndexId
Country String 40 SelectEdit Mandatory Country
Index Title String 50 Edit Mandatory IndexTitle
Manual Bool 0 Select Manual
Type
Values List:
0 = Statistical
1 = Interest
Status 0 Select Type
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 English Title Data Type Text Length Editor Attributes json
Code String 5 Edit Mandatory
Key Field
Code
Full Name in English String 30 Edit Mandatory FullNameInEnglish
Minimal Cash Coin Amount Money 0 Edit MinimalCashCoinAmount
Safe Minimal Rate Real 0 Edit SafeMinimalRate
Safe Maximal Rate Real 0 Edit SafeMaximalRate
Data Source String 3 Edit Read Only DataSource
Jump to tables index

Database Table "hyp_Global Definitions"

Table Description

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Main Key String 2 Edit Hidden
Read Only
Key Field
MainKey
Company ID Number Serial 20 Edit Mandatory CompanyIdNumber
Company Name in English String 100 Edit Mandatory CompanyNameInEnglish
Company Authority in English String 40 Edit CompanyAuthorityInEnglish
Company Registered in Country String 40 Select Mandatory CompanyRegisteredInCountry
Bookkeeping Currency String 5 Select Mandatory BookkeepingCurrency
Client Name Stringing
Values List:
0 = Last Name + First Name
1 = First Name + Last Name
2 = Title + Last Name + First Name
3 = Title + First Name + Last Name
Status 0 Select ClientNameStringing
Employee Name Stringing
Values List:
0 = Last Name + First Name
1 = First Name + Last Name
2 = Title + Last Name + First Name
3 = Title + First Name + Last Name
Status 0 Select EmployeeNameStringing
Main Phone Country Code (prefix) Integer 0 Edit MainPhoneCountryCodePrefix
Main Country Code on Phone Fields
Values List:
0 = Keep as Input
1 = Remove Main Prefix
2 = Add Main Prefix if no Code Exist
Status 0 Select MainCountryCodeOnPhoneFields
Acceptable Input Languages String 100 GroupSelect AcceptableInputLanguages
Access Authorization Groups String 1000 TextMemo Hidden AccessAuthorizationGroups
Force users to change password
Values List:
0 = No
1 = Every 1 Month
2 = Every 2 Months
3 = Every 3 Months
4 = Every 6 Months
Status 0 Select ForceUsersToChangePassword
Allow to Login only from WAN IP Addresses String 150 TextMemo AllowToLoginOnlyFromWanIpAddresses
Pro. License Details String 70 Edit ProLicenseDetails
International Details for A4 Header String 250 Memo InternationalDetailsForA4Header
Use Address Wizard
Values List:
0 = No. Just simple Edit box
1 = Yes, Combine Edit and Dialog Popup
2 = Yes, Address input only by Wizard !
Status 0 Select UseAddressWizard
Official Clients Activity Starting from Date Date 0 SelectEdit OfficialClientsActivityStartingFromDate
Allow Dial Out through PBX Automation Bool 0 Select AllowDialOutThroughPbxAutomation
Windows Active Directory Basic Group String 50 Edit WindowsActiveDirectoryBasicGroup
How to Init "Starting At" for a New Task
Values List:
0 = Keep it Empty
1 = Set Current Date
2 = Set Current Date & Time
Status 0 Select HowToInitStartingAtForANewTask
Calendar Graphic View From Hour Integer 0 Edit CalendarGraphicViewFromHour
Calendar Graphic View Until Hour Integer 0 Edit CalendarGraphicViewUntilHour
Fields for "Calendar Meeting Window" String 250 PopupList FieldsForCalendarMeetingWindow
Send Calendar Updates via Email by Default Bool 0 Select SendCalendarUpdatesViaEmailByDefault
Send Calendar Updates via SMS by Default Bool 0 Select SendCalendarUpdatesViaSmsByDefault
Required fields when the client is not interested String 400 PopupList RequiredFieldsWhenTheClientIsNotInterested
Invoices Total Rounding Off Bool 0 Select InvoicesTotalRoundingOff
Require Client ID beyond Total Amount LC Integer 0 Edit RequireClientIdBeyondTotalAmountLc
Allow Manual Amount Field in Cash UI Bool 0 Select AllowManualAmountFieldInCashUi
Financial Institution Bool 0 Select FinancialInstitution
Money Laundering
Values List:
0 = Not Regulated
1 = Banking Services Provider
2 = E-Loans (credit provider)
3 = CFD Broker
Status 0 Select MoneyLaundering
Enable Securities Check in Retail Bool 0 Select EnableSecuritiesCheckInRetail
Set Sale Docs Agency According to
Values List:
0 = The oducing User
1 = The Client's Agency
Status 0 Select SetSaleDocsAgencyAccordingTo
Copy Sale Docs Agent from Client record field
Values List:
0 = null, Empty
1 = Default Sales Agent
2 = Default Relationship Manager
3 = Spare Agent 1
4 = Spare Agent 2
5 = Spare Agent 3
Status 0 Select CopySaleDocsAgentFromClientRecordField
Delete Standing Orders after # months of NO Use Integer 0 Select DeleteStandingOrdersAfterMonthsOfNoUse
Default Sales Analysis by Document
Values List:
0 = Tax Invoice vs Credit Invoice
1 = Delivery Note vs Return of Goods
2 = Order vs Return of Goods
Status 0 Select DefaultSalesAnalysisByDocument
Number Price Offer From Integer 0 Edit NumberPriceOfferFrom
Number Transaction Invoice From Integer 0 Edit NumberTransactionInvoiceFrom
Number Delivery Notes From Integer 0 Edit NumberDeliveryNotesFrom
Number Return Goods From Integer 0 Edit NumberReturnGoodsFrom
Number Tax Invoices From Integer 0 Edit NumberTaxInvoicesFrom
Number Credit Invoices From Integer 0 Edit NumberCreditInvoicesFrom
Number Receipts From Integer 0 Edit NumberReceiptsFrom
Number Refunds From Integer 0 Edit NumberRefundsFrom
Number Purchase Order From Integer 0 Edit NumberPurchaseOrderFrom
Print # copies for every Original Delivery Note Integer 0 Edit PrintCopiesForEveryOriginalDeliveryNote
Print # copies for every Original Return Goods Integer 0 Edit PrintCopiesForEveryOriginalReturnGoods
Print # copies for every Original Tax Invoice Integer 0 Edit PrintCopiesForEveryOriginalTaxInvoice
Print # copies for every Original Credit Invoice Integer 0 Edit PrintCopiesForEveryOriginalCreditInvoice
Print "Account Balance at Production Time" Bool 0 Select PrintAccountBalanceAtProductionTime
Encrypt Any Sales Doc PDF Bool 0 Select EncryptAnySalesDocPdf
Allow Edit of Identified Entity in Sales Doc Bool 0 Select AllowEditOfIdentifiedEntityInSalesDoc
High Precision Accounting Bool 0 Select HighPrecisionAccounting
Editing Journal Entries after Creation
Values List:
0 = Entry will be ReadOnly after 30 minutes
1 = Allow Delete / Recovery, Fields Readonly
2 = Allow Editing except Amount & Currency
3 = All fields editable
Status 0 Select EditingJournalEntriesAfterCreation
Minimal BK Entry Date Date 0 SelectEdit Read Only MinimalBkEntryDate
Tax Authorities Reports Submitted up to date Date 0 SelectEdit Read Only TaxAuthoritiesReportsSubmittedUpToDate
Minimal Inventory Entry Date Date 0 SelectEdit Read Only MinimalInventoryEntryDate
Trading Data in Archive until date Date 0 Edit Read Only TradingDataInArchiveUntilDate
Company TDS ID Serial 20 Edit CompanyTdsId
Cheque Default A4 Format String 40 Select ChequeDefaultA4Format
Cheque "Payable to Payee only" Bool 0 Select ChequePayableToPayeeOnly
Make Receipt/Refund Contrary Account Mandatory Bool 0 Select MakeReceiptRefundContraryAccountMandatory
Journal Report Calc Opening Balance Default Value
Values List:
0 = No
1 = Yes, by BK Entry Date
2 = Yes, by Cash Flow Date
Status 0 Select JournalReportCalcOpeningBalanceDefaultValue
Domestic Market Revenue Account (VAT Liable) Default P&L Account Integer 0 PopupList DomesticMarketRevenueAccountVatLiable
Export Revenue Account (VAT Free) Default Fees Account Integer 0 PopupList ExportRevenueAccountVatFree
TPM Profit & Loss Account Integer 0 PopupList TpmProfitLossAccount
TPM Dividend / Loans PIL Account Integer 0 PopupList TpmDividendLoansPilAccount
TPM Rollover / Loans Interest Account Integer 0 PopupList TpmRolloverLoansInterestAccount
TPM / Loans Commission Account Integer 0 PopupList TpmLoansCommissionAccount
Receipt Cash Default Account Integer 0 PopupList ReceiptCashDefaultAccount
Receipt Cheque Default Account Integer 0 PopupList ReceiptChequeDefaultAccount
Receipt C.C. Default Account Integer 0 PopupList ReceiptCCDefaultAccount
Bank Transfer Default Account Integer 0 PopupList BankTransferDefaultAccount
Receipt Bill of Exchange Default Account Integer 0 PopupList ReceiptBillOfExchangeDefaultAccount
Payment Cheque Default Account Integer 0 PopupList PaymentChequeDefaultAccount
Clients Deduction At Source Default Account Integer 0 PopupList ClientsDeductionAtSourceDefaultAccount
Clients Deduction At Source 2 Default Account Integer 0 PopupList ClientsDeductionAtSource2DefaultAccount
Suppliers Deduction At Source Default Account Integer 0 PopupList SuppliersDeductionAtSourceDefaultAccount
Currency Swaps Default Account Integer 0 PopupList CurrencySwapsDefaultAccount
Spare Modules Default Account Integer 0 PopupList SpareModulesDefaultAccount
TDS Run Automatically on modules Bool 0 Select TdsRunAutomaticallyOnModules
TDS Refund Client after Loss Bool 0 Select TdsRefundClientAfterLoss
TDS TPM Default Person Rate Integer 0 Edit TdsTpmDefaultPersonRate
TDS TPM Default Company Rate Integer 0 Edit TdsTpmDefaultCompanyRate
TDS Deposit Default Person Rate Integer 0 Edit TdsDepositDefaultPersonRate
TDS Include TPM P&L Balance Commands Bool 0 Select TdsIncludeTpmPLBalanceCommands
TDS Payments from TPM Balance Commands Bool 0 Select TdsPaymentsFromTpmBalanceCommands
Activate "CRM Spare Table 1" Module
Values List:
0 = No, Hide this tab
1 = Yes, with Manual Key
2 = Yes, with Automatic Key Generator
Status 0 Select ActivateCrmSpareTable1Module
Activate "CRM Spare Table 3" Module
Values List:
0 = No, Hide this tab
1 = Yes, with Manual Key
2 = Yes, with Automatic Key Generator
Status 0 Select ActivateCrmSpareTable3Module
Activate "CRM Spare Table 5" Module
Values List:
0 = No, Hide this tab
1 = Yes, with Manual Key
2 = Yes, with Automatic Key Generator
Status 0 Select ActivateCrmSpareTable5Module
Activate "CRM Spare Table 6" Module
Values List:
0 = No, Hide this tab
1 = Yes, with Manual Key
2 = Yes, with Automatic Key Generator
Status 0 Select ActivateCrmSpareTable6Module
Activate "Client Extra Properties 1"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateClientExtraProperties1
Activate "Client Extra Properties 2"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateClientExtraProperties2
Activate "Client Extra Properties 3"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
4 = Yes, Mass Data mode with Ext sub table
5 = Yes, Mass Data & READ ONLY mode
Status 0 Select ActivateClientExtraProperties3
Activate "Client Extra Properties 4"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateClientExtraProperties4
Activate "Client Extra Properties 5"
Values List:
0 = No, Hide this tab
1 = Yes, Update each sub record separately
2 = Yes, as READ ONLY data source
Status 0 Select ActivateClientExtraProperties5
Activate "Client Extra Properties 6"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateClientExtraProperties6
Client Extra Properties Turn him to Active Bool 0 Select ClientExtraPropertiesTurnHimToActive
Activate "Supplier Extra Properties 1"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateSupplierExtraProperties1
Activate "Supplier Extra Properties 2"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateSupplierExtraProperties2
Activate "Supplier Extra Properties 3"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
4 = Yes, Mass Data mode with Ext sub table
5 = Yes, Mass Data & READ ONLY mode
Status 0 Select ActivateSupplierExtraProperties3
Activate "Supplier Extra Properties 4"
Values List:
0 = No, Hide this tab
1 = Yes, Override whole table on save
2 = Yes, Update each sub record separately
3 = Yes, as READ ONLY data source
Status 0 Select ActivateSupplierExtraProperties4
Supplier Extra Properties Turn him to Active Bool 0 Select SupplierExtraPropertiesTurnHimToActive
Activate Point of Sale Module Bool 0 Select ActivatePointOfSaleModule
Activate Construction Site Module Bool 0 Select ActivateConstructionSiteModule
Activate 3rd Party Billing Module Bool 0 Select Activate3rdPartyBillingModule
Activate Trading Platforms Module Bool 0 Select ActivateTradingPlatformsModule
Number Primary Accounts in High Range Bool 0 Select Hidden
Read Only
NumberPrimaryAccountsInHighRange
Number Clients in High Range Bool 0 Select Hidden
Read Only
NumberClientsInHighRange
Number Suppliers in High Range Bool 0 Select Hidden
Read Only
NumberSuppliersInHighRange
Offers are Valid for # Days Integer 0 Edit OffersAreValidForDays
Fields for "ERP New Order" popup window String 400 PopupList FieldsForErpNewOrderPopupWindow
Order Prototype Virtual Menu Node ID Integer 0 Edit OrderPrototypeVirtualMenuNodeId
Order Prototype Display Node Fields String 5 Edit OrderPrototypeDisplayNodeFields
Order Items Display Node Fields String 5 Edit OrderItemsDisplayNodeFields
Order Items Display Node Fields for PP&C String 5 Edit OrderItemsDisplayNodeFieldsForPpC
Order Default CAD File String 30 Select OrderDefaultCadFile
Enable "Order Content Import" Interface
Values List:
0 = None
1 = Import from .csv file
2 = Import from Excel Clipboard Format
3 = Import from .csv file & Render BOM
4 = Import from Excel Clipboard Format & Render BOM
Status 0 Select EnableOrderContentImportInterface
Default Notes for International Delivery Note String 400 Memo Hidden
Read Only
DefaultNotesForInternationalDeliveryNote
Default Notes for International Return Goods String 400 Memo Hidden
Read Only
DefaultNotesForInternationalReturnGoods
Default Notes for International Tax Invoice String 400 Memo Hidden
Read Only
DefaultNotesForInternationalTaxInvoice
Default Notes for International Credit Invoice String 400 Memo Hidden
Read Only
DefaultNotesForInternationalCreditInvoice
Default Notes for International Receipt Form String 400 Memo Hidden
Read Only
DefaultNotesForInternationalReceiptForm
Default Notes for International Refund Form String 400 Memo Hidden
Read Only
DefaultNotesForInternationalRefundForm
Default International Product Return Policy String 500 Memo Hidden
Read Only
DefaultInternationalProductReturnPolicy
Jump to tables index