[selectRecords]
select
	 wk.sir_cd
	,wk.sir_nm
	,wk.seikyu_ymd
	,wk.syukin_yotei_ymd
	,wk.shime_dd
	,wk.pay_m
	,wk.pay_d
	,wk.biko1
	--,wk.tan_cd
	,wk.tori_cond
	,wk.zei_calc_kbn
	,wk.keisyo
	,wk.sir_rnm
	,coalesce(sum(wk.zen_seikyu_zan),0) as zen_seikyu_zan
	,coalesce(sum(wk.syukin_gaku),0) as syukin_gaku
	,coalesce(sum(wk.kurikoshi_gaku),0) as kurikoshi_gaku
	,coalesce(sum(wk.zeinuki_gaku),0) as zeinuki_gaku
	,coalesce(sum(wk.zei_gaku),0) as zei_gaku
	,coalesce(sum(wk.zeikomi_gaku),0) as zeikomi_gaku
	,coalesce(sum(wk.seikyu_zan),0) as seikyu_zan 
	,coalesce(sum(wk.genkin),0) as genkin
	,coalesce(sum(wk.kogitte),0) as kogitte
	,coalesce(sum(wk.furikomi),0) as furikomi
	,coalesce(sum(wk.tesuryo),0) as tesuryo
	,coalesce(sum(wk.tegata),0) as tegata
	,coalesce(sum(wk.sousai),0) as sousai
	,coalesce(sum(wk.sonota),0) as sonota
	,coalesce(sum(wk.futan),0) as futan
	,COALESCE(sum(wk.total_gaku),0) as total_gaku
from(
	select
		--現金支払
		--'1' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		t.syukin_gaku as genkin,
		0 as kogitte,
		0 as furikomi,
		t.tesuryo as tesuryo,
		0 as tegata,
		0 as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'genkin'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--入金(小切手)
		--'2' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		t.syukin_gaku as kogitte,
		0 as furikomi,
		t.tesuryo as tesuryo,
		0 as tegata,
		0 as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'kogitte'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--入金(振込)
		--'3' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		t.syukin_gaku as furikomi,
		t.tesuryo as tesuryo,
		0 as tegata,
		0 as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'furikomi'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--振込手数料
		--'4' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		t.total_gaku as tesuryo,
		0 as tegata,
		0 as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'tesuryo'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--入金(手形)
		--'5' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		t.tesuryo as tesuryo,
		t.syukin_gaku as tegata,
		0 as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'tegata'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--相殺
		--'6' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		t.tesuryo as tesuryo,
		0 as tegata,
		t.syukin_gaku as sousai,
		t.cyosei_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = 'sousai'
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--その他
		--'7' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		0 as tesuryo,
		0 as tegata,
		0 as sousai,
		t.total_gaku as sonota,
		0 as futan,
		t.total_gaku as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and h19.koumoku1 = ''
	and COALESCE(h19.koumoku3,'') = ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--その他
		--'7' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		0 as zen_seikyu_zan,
		0 as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		0 as tesuryo,
		0 as tegata,
		0 as sousai,
		0 as sonota,
		t.total_gaku as futan,
		0 as total_gaku,
		0 as kurikoshi_gaku,
		0 as zeinuki_gaku,
		0 as zei_gaku,
		0 as zeikomi_gaku,
		0 as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	left join v_syukin t on (t.sir_cd = v.sir_cd)
	left join m_hanyo h19 on (h19.mst_kbn = '19' and h19.han_cd = syukin_kbn)
	where 1=1
	and v.del_flg= 0
	and COALESCE(h19.koumoku3,'') != ''
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	and ((v.seikyu_ymd >= coalesce(t.syukin_ymd,'yyyymmdd')) and (v.zen_seikyu_ymd < coalesce(t.syukin_ymd,'yyyymmdd')))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
	union all select
		--'8' as kbn,
		'支払一覧' as report_nm,
		v.sir_cd as sir_cd,
		to_char(to_date(v.zen_seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as zen_seikyu_ymd,
		to_char(to_date(v.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd,
		v.zen_seikyu_zan as zen_seikyu_zan,
		v.syukin_gaku as syukin_gaku,
		0 as genkin,
		0 as kogitte,
		0 as furikomi,
		0 as tesuryo,
		0 as tegata,
		0 as sousai,
		0 as sonota,
		0 as futan,
		0 as total_gaku,
		v.kurikoshi_gaku as kurikoshi_gaku,
		v.zeinuki_gaku as zeinuki_gaku,
		v.zei_gaku as zei_gaku,
		v.zeikomi_gaku as zeikomi_gaku,
		v.seikyu_zan as seikyu_zan,
		to_char(to_date(v.syukin_yotei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syukin_yotei_ymd,
--#19607 2021.06.23 MOD STT
--		mt.sir_nm as sir_nm,
		(case when(mt.sir_rnm != '')then(mt.sir_rnm)else(mt.sir_nm)end) as sir_nm,
--#19607 2021.06.23 MOD END
		mt.shime_dd,
		mt.pay_m,
		mt.pay_d,
		mt.biko1,
		--mt.tan_cd,
		mt.tori_cond,
		mt.zei_calc_kbn,
		mt.keisyo,
		mt.sir_rnm
	from t_kaikake v
	inner join m_sir mt on (v.sir_cd = mt.sir_cd)
	--left join m_tanto tn on (tn.tan_cd = mt.tan_cd)
	where 1=1
	and v.del_flg= 0
	--and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mt.cat_cd = '&4'))
	--and (('1' = '&30') or (v.seikyu_zan <> 0))
	--and (('' = '&24') or (tn.tan_cd >= '&24')) and (('' = '&25') or (tn.tan_cd <= '&25'))
	and (('' = '&22') or (mt.sir_cd >= '&22')) and (('' = '&23') or (mt.sir_cd <= '&23'))
	--and (('' = '&20') or (mt.sir_cd >= '&20')) and (('' = '&21') or (mt.sir_cd <= '&21'))
	and (('' = '&16') or (v.seikyu_ymd >= '&16')) and (('' = '&17') or (v.seikyu_ymd <= '&17'))
	and (('' = '&42') or (mt.eig_cd = '&42'))
	--#19817 2021.07.06 MOD STT
	and (('' = '&31') or (cast(mt.shime_dd as varchar) = '&31'))
	--#19817 2021.07.06 MOD END
) wk
group by wk.sir_cd,wk.sir_nm,wk.seikyu_ymd,wk.syukin_yotei_ymd,wk.shime_dd,wk.pay_m,wk.pay_d,wk.biko1,wk.tori_cond,wk.zei_calc_kbn,wk.keisyo,wk.sir_rnm
order by wk.seikyu_ymd,wk.sir_cd