Database Table "hyp_Accounts"

Table Description

Accounts. This modul is used for the inner accounts of the company. the accounts will be presented in the trial balance on the right side.

Normal Storage

Normal

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes json
Account ID Integer 0 Edit Read Only
Key Field
AccountID
Account Name String 50 Edit Mandatory AccountName
Account Purpose
Values List:
General (LC static rate)
Revenue (LC static rate)
Expense (LC static rate)
Continuous Bank Account
Cash Income
Cheque Income
Electronic Income
Cash Payments
Cheque Payments
Electronic Payments
Settling of GST / VAT (LC)
Institution
Hired Worker
General (Multiple Currency)
Status 0 Select AccountPurpose
Notes String 250 Memo Notes
VAT Account ID Integer 0 Edit Read Only VATAccountID
VAT Account Name String 50 PopupList VATAccountName
VAT % to Derive Real 0 Edit VATToDerive
Enabled Bool 0 Select Enabled
Created On FixDT 0 Edit Read Only CreatedOn
Created By String 40 Edit Read Only CreatedBy
Account Name in English String 50 Edit AccountNameInEnglish
Positive Balance Class ID Integer 0 Edit PositiveBalanceClassID
Negative Balance Class ID Integer 0 Edit NegativeBalanceClassID
Balance Sheet Category
Values List:
None (off balance)
Revenues (P&L)
Expenses (P&L)
Assets
Liabilities
Equity
Status 0 Select Read Only BalanceSheetCategory
Bank Account ID for Cash Flow Forecast Integer 0 PopupList BankAccountIDForCashFlowForecast
Export Account to 3rd party Integer 0 Edit ExportAccountTo3rdParty
Old Software Account Integer 0 Edit Read Only OldSoftwareAccount
Old Software Name String 10 Edit Read Only OldSoftwareName
Reg. Bank or Property on Country String 40 Select RegBankOrPropertyOnCountry
Bank ID Serial 10 PopupEdit BankID
Branch / Routing / Swift Serial 15 PopupEdit BranchRoutingSwift
Account (Local or IBAN) Serial 30 Edit AccountLocalOrIBAN
Reg. Bank Name String 40 Edit RegBankName
Reg. Bank Address String 100 Edit RegBankAddress
Hyper Integrations String 200 GroupSelect HyperIntegrations
Letter Addressee Block String 400 Memo LetterAddresseeBlock
Jump to tables index

Database Table "hyp_Journal"

Table Description

Book Keeping Modul

Normal Storage

Archive Storage

All entries of Debits and credits made after the balance

Deleted Storage(Recycle)

Delete Entries is prohibited.
Field Name English Title Data Type Text Length Editor Attributes json
Entry ID Entry ID Integer 0 Edit Read Only
Key Field
EntryID
Description Description String 80 Edit Mandatory Description
BK Entry Date BK Entry Date Date 0 SelectEdit Mandatory BKEntryDate
Reference Document Type Reference Document Type
Values List:
Unknown
Tax Invoice
Receipt
Credit Invoice
Refund
Importation Log
Supplier Invoice
Payment to Supplier
Employees Salary
Balance Sheet
Exportation Log
Dividend Payment
Internal Currency Conversion
Exchange Differentials
Status 0 Select ReferenceDocumentType
Reference Document Reference Document Integer 0 Edit ReferenceDocument
Cash Flow Date Cash Flow Date Date 0 SelectEdit CashFlowDate
Creation Time Creation Time FixDT 0 SelectEdit Read Only CreationTime
Created By Created By String 40 Edit Read Only CreatedBy
Cancellation Time Cancellation Time FixDT 0 SelectEdit Read Only CancellationTime
Cancelled By Cancelled By String 40 Edit Read Only CancelledBy
Batch From ID Batch From ID Integer 0 Edit Hidden
Read Only
BatchFromID
Batch Until ID Batch Until ID Integer 0 Edit Hidden
Read Only
BatchUntilID
1st Debit Account Number Account Number Integer 0 Edit Read Only 1stDebitAccountNumber
1st Debit Account Name Account Name String 50 PopupList 1stDebitAccountName
1st Debit Transferred Amount Transferred Amount Money 0 Edit 1stDebitTransferredAmount
1st Debit Currency Currency String 4 Select 1stDebitCurrency
1st Debit Exchange Rate Exchange Rate Real 0 Edit 1stDebitExchangeRate
1st Debit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
1stDebitBundleNumber
2nd Debit Account Number Account Number Integer 0 Edit Read Only 2ndDebitAccountNumber
2nd Debit Account Name Account Name String 50 PopupList 2ndDebitAccountName
2nd Debit Transferred Amount Transferred Amount Money 0 Edit 2ndDebitTransferredAmount
2nd Debit Currency Currency String 4 Select 2ndDebitCurrency
2nd Debit Exchange Rate Exchange Rate Real 0 Edit 2ndDebitExchangeRate
2nd Debit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
2ndDebitBundleNumber
3rd Debit Account Number Account Number Integer 0 Edit Read Only 3rdDebitAccountNumber
3rd Debit Account Name Account Name String 50 PopupList 3rdDebitAccountName
3rd Debit Transferred Amount Transferred Amount Money 0 Edit 3rdDebitTransferredAmount
3rd Debit Currency Currency String 4 Select 3rdDebitCurrency
3rd Debit Exchange Rate Exchange Rate Real 0 Edit 3rdDebitExchangeRate
3rd Debit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
3rdDebitBundleNumber
1st Credit Account Number Account Number Integer 0 Edit Read Only 1stCreditAccountNumber
1st Credit Account Name Account Name String 50 PopupList 1stCreditAccountName
1st Credit Transferred Amount Transferred Amount Money 0 Edit 1stCreditTransferredAmount
1st Credit Currency Currency String 4 Select 1stCreditCurrency
1st Credit Exchange Rate Exchange Rate Real 0 Edit 1stCreditExchangeRate
1st Credit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
1stCreditBundleNumber
2nd Credit Account Number Account Number Integer 0 Edit Read Only 2ndCreditAccountNumber
2nd Credit Account Name Account Name String 50 PopupList 2ndCreditAccountName
2nd Credit Transferred Amount Transferred Amount Money 0 Edit 2ndCreditTransferredAmount
2nd Credit Currency Currency String 4 Select 2ndCreditCurrency
2nd Credit Exchange Rate Exchange Rate Real 0 Edit 2ndCreditExchangeRate
2nd Credit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
2ndCreditBundleNumber
3rd Credit Account Number Account Number Integer 0 Edit Read Only 3rdCreditAccountNumber
3rd Credit Account Name Account Name String 50 PopupList 3rdCreditAccountName
3rd Credit Transferred Amount Transferred Amount Money 0 Edit 3rdCreditTransferredAmount
3rd Credit Currency Currency String 4 Select 3rdCreditCurrency
3rd Credit Exchange Rate Exchange Rate Real 0 Edit 3rdCreditExchangeRate
3rd Credit Bundle Number Bundle Number Real 0 Edit Hidden
Read Only
3rdCreditBundleNumber
Government Report Date Government Report Date Month 0 SelectEdit GovernmentReportDate
1st Debit Private Description Private Description String 35 Edit 1stDebitPrivateDescription
2nd Debit Private Description Private Description String 35 Edit 2ndDebitPrivateDescription
3rd Debit Private Description Private Description String 35 Edit 3rdDebitPrivateDescription
1st Credit Private Description Private Description String 35 Edit 1stCreditPrivateDescription
2nd Credit Private Description Private Description String 35 Edit 2ndCreditPrivateDescription
3rd Credit Private Description Private Description String 35 Edit 3rdCreditPrivateDescription
Internal Notes Internal Notes String 100 Edit InternalNotes
Total Amount LC Money 0 Edit Read Only TotalAmountLC
Standard / Philosophy Standard / Philosophy
Values List:
Standard
GAAP
IFRS
Theory
Status 0 Select StandardPhilosophy
TDS Rate % TDS Rate % Real 0 Edit TDSRate
Internal Entry Type Internal Entry Type String 1 Edit Hidden
Read Only
InternalEntryType
Money Laundering Bundle Real 0 Edit MoneyLaunderingBundle
Currency Exchange ID Verification Made by Currency Exchange ID Verification Made by String 40 PopupList CurrencyExchangeIDVerificationMadeBy
Attached File Ext String 10 Edit Hidden
Read Only
AttachedFileExt
Jump to tables index