SELECT glapdocno as "单号",

       glapdocdt as "日期",

       glaqseq as "项次",

       glaq001 as "摘要",

       glaq002||'('||glaq022||')'||'\n'||l_glacl004 as "科目1",

       glaq002||'\n'||l_glacl004 as "科目2",

       glaq005 as "币种",

       glaq006 as "汇率",

       glaq003 as "借方金额",

       glaq004 as "贷方金额",

       l_glapld_desc as "账套",

       l_cnt as "审核",

       l_crt as "创建"

       FROM cglr310_f01_t WHERE fr_sessionid = '${fr_sessionid}' AND TO_CHAR(fr_timestamp,'YYYY-MM-DD HH24:MI:SS') = '${fr_timestamp}'

       order by glaqseq