Need help to modify SQL to retrieve the journal approver field please
Summary: I am trying to update the GL Ledger script to include the following additional fields
- Journal Approver name
- beginning and closing GL account balances for the selected year
Thanks
Content (please ensure you mask any confidential information):
SELECT
'NEW' NEW,
GLL.NAME GLL_LEDGER_ID,
to_date(JEL.EFFECTIVE_DATE,'YYYY-MM-DD') EFFECTIVE_DATE_OF_TRANSACTION,
jes.JE_SOURCE_key JEH_SOURCE,
case when JEC.JE_CATEGORY_key = 'A_ADJ' THEN 'A Adjustment'
when JEC.JE_CATEGORY_key = 'A_TB' THEN 'A Trial Balance'
when JEC.JE_CATEGORY_key = 'A_ISC' THEN 'A Income Statement Close'
when JEC.JE_CATEGORY_key = 'A_INV_AM' THEN 'A Investment - AM'
1