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 |