Account Ledger by Account Greece Report
The Greek statutory account ledger — every posting to each general ledger account over a period, in date order with a running balance, in the format the Greek authorities require for the books of account.
Run note · BIP run High-volume GL extracts can exceed BI Publisher's online output limit and time out. Run it as a scheduled process (ESS) with output bursted to file or email rather than online preview, and bound it by ledger and period.
Sample build of the Account Ledger by Account Greece Report — reconciled, and rendered tool-neutral so it runs in Power BI, ThoughtSpot, or Tableau.
| Account | Journal Date | Source | Debit | Credit | Running Balance |
|---|---|---|---|---|---|
| 1000-2100-000 | 2026-04-30 | Sample | $1,240,500.00 | $1,240,500.00 | $1,240,500.00 |
| 1000-5400-000 | 2026-03-31 | — | $842,150.75 | $842,150.75 | $842,150.75 |
| 1000-1410-000 | 2026-02-28 | Sample | $96,400.00 | $96,400.00 | $96,400.00 |
| 2000-2100-000 | 2026-01-31 | — | $1,005,233.10 | $1,005,233.10 | $1,005,233.10 |
| 1000-6300-000 | 2025-12-31 | Sample | $58,720.40 | $58,720.40 | $58,720.40 |
| 1000-2100-000 | 2026-04-30 | Sample | $1,240,500.00 | $1,240,500.00 | $1,240,500.00 |
The report reads GL_JE_LINES per account in date order, carrying a running balance in the Greek statutory layout.
A few accounts carry backdated postings whose journal date precedes their entry date — the statutory book must present movements in strict date order, so these can break the legal sequence.
Confirm the backdated entries are authorized adjustments and document them; Greek statutory ledgers require chronological integrity, so unexplained backdating is a filing risk.
The SQL behind this report is not published. Its logic is one organisation's own setup, so it would not run anywhere else. The tables it reads are listed below, and the warehouse model shows how the same data lands in your warehouse.
Data sources
The data-warehouse model — one fact surrounded by conformed dimensions (what you slice by) and measures (what you aggregate), expressed as dbt so it migrates with you. Grain: one row per source transaction.
| Element | Type | Definition |
|---|---|---|
| GL_JE_HEADERS | dimension | dimension |
| GL_CODE_COMBINATIONS | dimension | dimension |
| GL_BALANCES | dimension | dimension |
| GL_LEDGERS | dimension | dimension |
| Debit | measure | measure |
| Credit | measure | measure |
| Running Balance | measure | measure |
Every source object behind this report. Each linked table has its own page with full column descriptions, drawn from the Oracle BICC lineage and articulated for practitioners.
| Table | Reporting columns | Subject areas |
|---|---|---|
| GL_JE_LINES | 26 | 2 |
| GL_JE_HEADERS | 34 | 2 |
| GL_CODE_COMBINATIONS | 7 | 61 |
| GL_BALANCES | No page in this catalog’s data dictionary yet | |
| GL_LEDGERS | 10 | 104 |