This is the most detailed level, representing an actual account in the General Ledger where transactions are posted. Each ledger account has a unique code and name.
Table Schema: ledger_accounts
Column
Data Type
Description
Constraints
id
INTEGER
Primary key for the ledger account.
PK, Auto-Increment
account_code
VARCHAR(20)
The unique identifier for the ledger account.
NOT NULL, UNIQUE
account_name
VARCHAR(255)
The specific name of the account (e.g. "HBL Main Account").
NOT NULL
type_id
INTEGER
Foreign key linking to the parent account type.
NOT NULL, FK (account_types.id)
is_active
BOOLEAN
Indicates if transactions can be posted to this account.