Database Table "hyp_Journal"

Table Description

Book Keeping Modul

Normal Storage

All operations and activities made since the recent balance. All entries of Debits and credits.

Archive Storage

All entries of Debits and credits made after the balance

Deleted Storage(Recycle)

Delete Entries is prohibited.
Field Name Description and Notes Data Type Text Length
Entry ID Entry ID. Unique ID number for each Entry. Integer 0
Description Description of the bookkeeping entry - defined by the creator of the entry. This field should include a clear and understandable description for the bookkeeping entry, in order to allow an easy search for this entry in the future. This is a mandatory field. String 80
BK Entry Date BK Entry date. The date of creation in the accounting books. This is a mandatory field. Date 0
Reference Document Type Reference Document Type. Select from list. Status 0
Reference Document Reference Document. Auto reference number is given for invoices and receipts. Integer 0
Cash Flow Date Cash Flow Date. The actual date of payment. If no date is defined, the field will automatically be filled with the BK Entry Date. Date 0
Creation Time Creation Time. FixDT. This field is automatcally filled with the time and date of creation. FixDT 0
Created By Created By. This field is automatically filled with the name of the creating user. Name 40
Cancellation Time Cancellation Time. Auto time stamp (FixDT) of the the time of cancellation. FixDT 0
Cancelled By Cancelled By. This field is automatically filled with the user name that have made the cancellation. Name 40
Batch From ID Batch from ID. For sequence of 3 or more records in Entry. Auto filled with the Entry ID of the first Entry. Integer 0
Batch Until ID Batch Until ID. For sequence of 3 or more records in Entry. Auto filled with the Entry ID of the last Entry. Integer 0
1st Debit Account Number Debit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
1st Debit Account Name 1st Debit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
1st Debit Transferred Amount Debit Transferred Amount. The amount to charge. Money 0
1st Debit Currency Debit Currency. Choose from list. String 4
1st Debit Exchange Rate Debit Exchange Rate. The exchange rate for the chosen Currency in "Debit Currency" field. Real 0
1st Debit Bundle Number Real 0
2nd Debit Account Number Debit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
2nd Debit Account Name 2nd Debit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
2nd Debit Transferred Amount Debit Transferred Amount. The amount to charge. Money 0
2nd Debit Currency Debit Currency. Choose from list. String 4
2nd Debit Exchange Rate Debit Exchange Rate. The exchange rate for the chosen Currency in "Debit Currency" field. Real 0
2nd Debit Bundle Number Real 0
3rd Debit Account Number Debit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
3rd Debit Account Name 3rd Debit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
3rd Debit Transferred Amount Debit Transferred Amount. The amount to charge. Money 0
3rd Debit Currency Debit Currency. Choose from list. String 4
3rd Debit Exchange Rate Debit Exchange Rate. The exchange rate for the chosen Currency in "Debit Currency" field. Real 0
3rd Debit Bundle Number Real 0
1st Credit Account Number Credit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
1st Credit Account Name 1st Credit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
1st Credit Transferred Amount Credit transffered amount. Total incoming. Money 0
1st Credit Currency Credit Currency. Choose from list. String 4
1st Credit Exchange Rate Credit Exchange Rate. The exchange rate for the chosen Currency in "Crefit Currency" field. Real 0
1st Credit Bundle Number Real 0
2nd Credit Account Number Credit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
2nd Credit Account Name 2nd Credit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
2nd Credit Transferred Amount Credit transffered amount.Total incoming. Money 0
2nd Credit Currency Credit Currency. Choose from list. String 4
2nd Credit Exchange Rate Credit Exchange Rate. The exchange rate for the chosen Currency in "Crefit Currency" field. Real 0
2nd Credit Bundle Number Real 0
3rd Credit Account Number Credit Account number. Auto field. filled with the number of the chosen Account name. Integer 0
3rd Credit Account Name 3rd Credit Account Name. Choose from list of clients / Suppliers / Accounts / Projects String 50
3rd Credit Transferred Amount Credit transffered amount. Total incoming. Money 0
3rd Credit Currency Credit Currency. Choose from list. String 4
3rd Credit Exchange Rate Credit Exchange Rate. The exchange rate for the chosen Currency in "Crefit Currency" field. Real 0
3rd Credit Bundle Number Real 0
Government Report Date Government Report Date. Choose date from Calendar. Month 0
1st Debit Private Description 1st Debit private description String 35
2nd Debit Private Description 2nd Debit private description String 35
3rd Debit Private Description 3rd Debit private description String 35
1st Credit Private Description 1st Credit private description String 35
2nd Credit Private Description 2nd Credit private description String 35
3rd Credit Private Description 3rd Credit private description String 35
TDS Rate % Real 0
Internal Entry Type String 1
Total Amount LC Total amount LC. Auto filled with the total sum of the Entry. Money 0
Internal Notes Internal notes for the Bookkeeping Entry. . String 100
Currency Exchange ID Verification Made by The user name of the employee that have verified the client's ID for the currency exchange. String 40
Standard / Philosophy Status 0