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