chart.sql
set pages 0 set lines 400 set termout off SELECT to_char(gl.account,'99999') || ltrim(to_char(gl.sub_account,'0000'),' ') || '|' || rtrim(GL.DESCRIPTION,' ') || '|' || rtrim(GL.OPTION_FLD_3,' ') || '|' || rtrim(gl.ACCT_UNIT) || '|' || substr(OPTION_FLD_2,1,2) || '|' || substr(OPTION_FLD_2,3,2) || '|' || substr(OPTION_FLD_2,5,1) || '|' || gl.active_status || '|' || gl.AMOUNT_01 || '|' || gl.AMOUNT_02 ||'|' || gl.AMOUNT_03 || '|' || gl.AMOUNT_04 || '|' || gl.AMOUNT_05 || '|' || gl.AMOUNT_06 || '|' || gl.AMOUNT_07 || '|' || gl.AMOUNT_08 || '|' || gl.AMOUNT_09 || '|' || gl.AMOUNT_10 || '|' || gl.AMOUNT_11 || '|' || gl.AMOUNT_12 || '|' || fb.AMOUNT_01 || '|' || fb.AMOUNT_02 || '|' || fb.AMOUNT_03 || '|' || fb.AMOUNT_04 || '|' || fb.AMOUNT_05 || '|' || fb.AMOUNT_06 || '|' || fb.AMOUNT_07 || '|' || fb.AMOUNT_08 || '|' || fb.AMOUNT_09 || '|' || fb.AMOUNT_10 || '|' || fb.AMOUNT_11 || '|' || fb.AMOUNT_12 || '|' || gl.AMOUNT_14 || '|' || gl.AMOUNT_15 || '|' || gl.AMOUNT_16 || '|' || gl.AMOUNT_17 || '|' || gl.AMOUNT_18 || '|' || gl.AMOUNT_19 || '|' || gl.AMOUNT_20 || '|' || gl.AMOUNT_21 || '|' || gl.AMOUNT_22 || '|' || gl.AMOUNT_23 || '|' || gl.AMOUNT_24 || '|' || gl.AMOUNT_25 FROM glmaster gl, fbdetail fb where gl.account = fb.account(+) and gl.sub_account = fb.sub_account(+) and gl.acct_unit = fb.acct_unit(+) and fb.budget_nbr(+) = 1 and fb.fiscal_year(+) = 1998 and ((gl.ACTIVE_STATUS = 'A') or (gl.ACTIVE_STATUS='I' AND gl.SUB_ACCOUNT=0)) Order by gl.acct_unit spool /xfer/chart.txx / spool off exit
Last updated: 05/14/2025 03:50:36