Gl Detail

GL Detail (ODA Report 210)

Fetches journal-level GL activity for a given account and date range, with full breakdown by voucher and entity.

Query Pattern

SELECT
  main_account,
  sub_account,
  account_name,
  voucher_code,
  entity_type,
  entity_code,
  entity_name,
  journal_date,
  accrual_date,
  gl_description,
  CASE WHEN net_amount < 0 THEN ABS(net_amount) ELSE 0 END AS debit,
  CASE WHEN net_amount > 0 THEN net_amount ELSE 0 END AS credit,
  net_amount
FROM GOLD_FINANCIAL.gold_fct_gl_details
WHERE main_account = ?
  AND DATE(journal_date) BETWEEN ? AND ?
  AND company_code = ?
  {AND sub_account = ? IF sub_account provided}
ORDER BY journal_date, voucher_code

Inputs

• account (required): Main GL account number
• period_start (required): Start date (YYYY-MM-DD)
• period_end (required): End date (YYYY-MM-DD)
• company_code (optional): Default = '200'