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 StorageNormal |
Archive StorageNot 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: 00 = General (LC static rate)01 = Revenue (LC static rate) 02 = Expense (LC static rate) 03 = Continuous Bank Account 04 = Cash Income 05 = Cheque Income 06 = Electronic Income 07 = Cash Payments 08 = Cheque Payments 09 = Electronic Payments 10 = Settling of GST / VAT (LC) 11 = Institution 12 = Hired Worker 13 = 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: 0 = None (off balance)1 = Revenues (P&L) 2 = Expenses (P&L) 3 = Assets 4 = Liabilities 5 = Equity |
Status | 0 | Select | Read Only | BalanceSheetCategory |
| 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 | |
| Hyper Integrations | Values List: ReceiptRefund FX Trade Crypto Wallet Loan Interest B. Deposit |
String | 200 | GroupSelect | HyperIntegrations | |
| Reg. Bank or Property on Country | String | 40 | Select | RegBankOrPropertyOnCountry | ||
| Bank Code | Serial | 12 | PopupEdit | BankCode | ||
| Branch / Swift | Serial | 15 | PopupEdit | BranchSwift | ||
| Account | Serial | 34 | Edit | Account | ||
| Bank Transfer Payment Format | Status | 0 | Select | BankTransferPaymentFormat | ||
| Reg. Bank Name | String | 40 | Edit | RegBankName | ||
| Reg. Bank Address | String | 100 | Edit | RegBankAddress | ||
| Letter Addressee Block | String | 400 | Memo | LetterAddresseeBlock | ||
| Language | Status | 0 | Select | Language |