JD Edwards F0911 General Ledger SQL Query Generator

SELECT GLKCO AS company,
       GLDCT AS doc_type,
       GLDOC AS doc_number,
       GLJELN AS line_no,
       GLEXTL AS ext_code,
       DATEADD(DAY, (GLDGJ % 1000) - 1, DATEFROMPARTS(1900 + GLDGJ / 1000, 1, 1)) AS gl_date,
       LTRIM(RTRIM(GLMCU)) AS business_unit,
       GLOBJ AS object_acct,
       GLSUB AS subsidiary,
       GLLT AS ledger_type,
       CAST(GLAA AS DECIMAL(19,2)) / 100 AS amount,
       GLEXA AS explanation,
       GLPOST AS posted_code
FROM PRODDTA.F0911
WHERE GLKCO = '00001'
  AND GLLT = 'AA'
  AND GLDGJ BETWEEN 126001 AND 126365
  AND GLOBJ = '1110'
  AND LTRIM(GLMCU) = 'M30'
ORDER BY GLDGJ, GLDCT, GLDOC, GLJELN;

SELECT LTRIM(GLMCU) AS business_unit,
       GLOBJ AS object_acct,
       SUM(CAST(GLAA AS DECIMAL(19,2))) / 100 AS net_amount,
       COUNT(*) AS line_count
FROM PRODDTA.F0911
WHERE GLKCO = '00001'
  AND GLLT = 'AA'
  AND GLPOST = 'P'
  AND GLDGJ BETWEEN 126001 AND 126365
GROUP BY LTRIM(GLMCU), GLOBJ
ORDER BY business_unit, object_acct;

SELECT GLKCO, GLDCT, GLDOC, GLICU AS batch_number, GLICUT AS batch_type, GLPOST
FROM PRODDTA.F0911
WHERE GLKCO = '00001'
  AND GLLT = 'AA'
  AND GLPOST <> 'P'
  AND GLDGJ BETWEEN 126001 AND 126365
GROUP BY GLKCO, GLDCT, GLDOC, GLICU, GLICUT, GLPOST;