Database Table "hyp_VAT_GST Rates"
Table Description
Value Added Tax Table, according to the country in which the Company is registered.Normal StorageAll Data Stored Here |
Archive StorageNot 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 |
Database Table "hyp_Price Index Linkage Definition"
Table Description
List of indices used by the company.Normal StorageAll Data Stored Here |
Archive StorageNot 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 = Statistical1 = Interest |
Status | 0 | Select | Type |
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 StorageAll Data Stored Here |
Archive StorageNot 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 |
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 Name1 = 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 Name1 = 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 Input1 = 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 = No1 = 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 box1 = 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 Empty1 = 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 Regulated1 = 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 User1 = The Client's Agency |
Status | 0 | Select | SetSaleDocsAgencyAccordingTo | |
Copy Sale Docs Agent from Client record field | Values List: 0 = null, Empty1 = 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 Invoice1 = 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 minutes1 = 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 = No1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 tab1 = 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 = None1 = 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 |