:SQL_BEGIN SELECT A.ISU_DT,A.MM_SQ,A.ACCT_CD,A.PRT_NM,A.DRCR_FG,A.ACCT_AM FROM (SELECT B.ISU_DT,D.MM_SQ,B.ACCT_CD,C.PRT_NM,B.RMK_DC,CAST(B.ACCT_AM AS NUMERIC(17,2)) ACCT_AM,B.LN_SQ, (CASE WHEN B.DRCR_FG = '3' THEN '借' ELSE '贷' END) DRCR_FG FROM ADOCUH A INNER JOIN ADOCUD B ON A.CO_CD = B.CO_CD AND A.DIV_CD = B.DIV_CD AND A.ISU_DT = B.ISU_DT AND A.ISU_SQ = B.ISU_SQ INNER JOIN SACCT C ON B.CO_CD = C.CO_CD AND B.ACCT_CD = C.ACCT_CD LEFT OUTER JOIN ADOCUSEQ D ON A.ISU_DT = D.ISU_DT AND A.CO_CD = D.CO_CD AND A.ISU_SQ = D.ISU_SQ WHERE SUBSTRING(A.ISU_DT,1,6) = :[02] AND A.INSERT_IP = :[02]+'90' AND A.CO_CD = :[00] AND A.DIV_CD = :[01]) A ORDER BY A.MM_SQ :SQL_END [01]:@T会计主体@H(DIV_CD); [02]:@T结转年月@H(YM); [03]:@T转入科目@H(ACCT_CD); [05]:@T操作员@H(EMP_CD); [TITLE]:日期,凭证号,科目编码,科目名称,方向,金额; [LENGTH]:10,6,10,20,5,15; [DATEMASK]:0; [PROCEDURE]:ACCOUNT_COST_CARRY_FORWARD_MONTHLY (:[00],:[01],:[02],:[03],:[05]);