Database Table "hyp_Journal"
Table Description
Book Keeping ModulNormal Storage |
Archive StorageAll 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: 00 = Unknown01 = Tax Invoice 02 = Receipt 03 = Credit Invoice 04 = Refund 05 = Importation Log 06 = Supplier Invoice 07 = Payment to Supplier 08 = Employees Salary 09 = For Balance Sheet 10 = Exportation Log 11 = Dividend Payment 12 = Internal Currency Conversion 13 = Balance Sheet Correction |
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 | 5 | Select | Mandatory | 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 | 5 | Select | Mandatory | 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 | 5 | Select | Mandatory | 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 | 5 | Select | Mandatory | 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 | 5 | Select | Mandatory | 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 | 5 | Select | Mandatory | 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: 0 = For All1 = GAAP 2 = IFRS 3 = Theory |
Status | 0 | Select | StandardPhilosophy | |
| Parent Doc / Project | Integer | 0 | Edit | ParentDocProject | ||
| by Module ID | Integer | 0 | Edit | Read Only | ByModuleId | |
| Module Record Link | Real | 0 | Edit | Hidden Read Only |
ModuleRecordLink | |
| Auth API ID | Integer | 0 | Edit | AuthApiId | ||
| TDS Rate % | TDS Rate % | Real | 0 | Edit | TdsRate_Percent |