Journal Entries

Manual Adjustments & Corrections

This table stores the header information for manual journal entries, which are typically used for adjustments, accruals, and corrections that don't fit into standard voucher types like payments or receipts.

Column Definitions

Column Data Type Description Constraints
idINTEGERPrimary key for the journal entry.PK, Auto-Increment
numberVARCHAR(255)A unique number for the journal entry.NOT NULL, UNIQUE
journal_dateDATEThe effective date of the journal entry.NOT NULL

Relationships

  • This table is often linked conceptually to a "Journal" type Voucher, which in turn contains the detailed Transactions that make up the entry.