[selectRecords]
select
      w.tok_cd
    , w.tan_nm_s
    , w.seikyu_ymd_s
    , w.zen_seikyu_ymd
--#19509 2021.09.20 MOD STT
--    , w.zen_seikyu_zan
--    , w.nyukin_gaku
--    , w.kurikoshi_gaku
--    , w.zeinuki_gaku
--    , w.zei_gaku
--    , w.zeikomi_gaku
--    , w.seikyu_zan
--    , w.den_cnt
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_zen_seikyu_zan)else(w.zen_seikyu_zan)end) as zen_seikyu_zan
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_nyukin_gaku)else(w.nyukin_gaku)end) as nyukin_gaku
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_kurikoshi_gaku)else(w.kurikoshi_gaku)end) as kurikoshi_gaku
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_zeinuki_gaku)else(w.zeinuki_gaku)end) as zeinuki_gaku
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_zei_gaku)else(w.zei_gaku)end) as zei_gaku
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_zeikomi_gaku)else(w.zeikomi_gaku)end) as zeikomi_gaku
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_seikyu_zan)else(w.seikyu_zan)end) as seikyu_zan
    , (case when('&7' != '1' and w.group_cd != '')then(w.g_den_cnt)else(w.den_cnt)end) as den_cnt
--#19509 2021.09.20 MOD END
    , w.tok_nm
--#19564 2021.06.17 MOD STT
--    , w.tok_nm_s
--	, case when '&4' = '1' then ''
--		else w.tok_tan
--		end as tok_tan
--#20755 2021.09.17 MOD STT
--	, w.tok_nm||'　'||fnc_get_keisyo_1(w.tok_nm, w.tok_tan, w.keisyo) as tok_nm_s
--	, (case when(w.tok_tan != '')then(w.tok_tan||'　'||fnc_get_keisyo_2(w.tok_nm, w.tok_tan, w.keisyo))end) as tok_tan
	, (case when(mt.hojin_nm != '')then(mt.hojin_nm)else( w.tok_nm||'　'||fnc_get_keisyo_1(w.tok_nm, w.tok_tan, w.keisyo) )end) as tok_nm_s
	, (case when(mt.hojin_nm != '')then(w.tok_nm||'　'||fnc_get_keisyo_1(w.tok_nm, w.tok_tan, w.keisyo))else( (case when(w.tok_tan != '')then(w.tok_tan||'　'||fnc_get_keisyo_2(w.tok_nm, w.tok_tan, w.keisyo))end) )end) as tok_tan
	, (case when(mt.hojin_nm != '')then((case when(w.tok_tan != '')then(w.tok_tan||'　'||fnc_get_keisyo_2(w.tok_nm, w.tok_tan, w.keisyo))end))else( '' )end) as tok_nm_add
--#19564 2021.06.17 MOD END
    , w.tel_no
--#19564 2021.06.17 MOD STT
--    , w.keisyou
--    , w.keisyou2
    , w.keisyo
--#19564 2021.06.17 MOD END
    , w.yubin_no
    , w.address1
    , w.address2
    , w.address3
    , to_char(w.den_dt, 'mm/dd') as den_dt
--#20621 2021.09.17 MOD STT
    , w.den_dt_view
    , w.den_no_view
    , w.kbn_view
--#20621 2021.09.17 MOD END
    , w.den_no
	, case when '&3' = w.hin_cd then w.kbn
		else w.kbn
		end as kbn
	, case when '&3' = w.hin_cd then null
		else w.hin_cd
		end as hin_cd
	, w.hin_nm
	, case when '&3' = w.hin_cd then null
		else w.suryo
		end as suryo
	, case when '&3' = w.hin_cd then null
		else w.tanka
		end as tanka
	, (case when('&3' = w.hin_cd and w.m_row >= 0)then(null)else(w.kingaku)end) as kingaku
    , w.zei_per
    , w.color
    , w.sunpo
    , w.sort
	, w.m_row
	, w.tani
	, w.meisai_biko
	, w.hosoku1
	, w.meisai_biko_s
	, w.zei_rate
	, (case when(w.den_dt is not null)then(cast(w.den_dt as varchar))else('')end) as den_dt_sort
	--, w.midasi_kbn
	, COALESCE(case when(h99a.han_name = '1')then(h99a.koumoku5)else('')end,'')||jis.han_name as jis_nm
	, jis.koumoku1 as jis_post_s
	, coalesce(jis.koumoku2,'') || coalesce(jis.koumoku3,'') as jis_address
	, (case when(jis.koumoku5 != '')then('TEL:' || jis.koumoku5)else('')end) as jis_tel_s
	, (case when(jis.koumoku6 != '')then('FAX:' || jis.koumoku6)else('')end) as jis_fax_s
--#26348 2022.12.02 MOD STT
--	, (case when(jis.koumoku7 != '')then('URL:' || jis.koumoku7)else('')end) as jis_url_s
	, (case when(jis.koumoku7 != '')then(coalesce(h98a.koumoku1,'URL:') || jis.koumoku7)else('')end) as jis_url_s
--#26348 2022.12.02 MOD END
	, (case when(jis.koumoku8 != '')then('EMAIL:' || jis.koumoku8)else('')end) as jis_mail_s
--#19545 2021.06.22 MOD STT
	, w.c_tok_cd
	, w.c_tok_nm
--#19545 2021.06.22 MOD END
	, mt.eig_cd
--#19509 2021.09.20 MOD STT
	, w.group_cd
	, w.g_zen_seikyu_zan
	, w.g_nyukin_gaku
	, w.g_kurikoshi_gaku
	, w.g_zeinuki_gaku
	, w.g_zei_gaku
	, w.g_zeikomi_gaku
	, w.g_seikyu_zan
	, w.g_den_cnt
--#19509 2021.09.20 MOD END
--#22097 2021.12.20 MOD STT
	, w.nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
	, w.htanka
	, w.disc_per
--#23703 2022.06.08 MOD END
	,case coalesce(r.koumoku1,'')
	when '' then '毎度お引き立てくださいましてありがとうございます。'
	else r.koumoku1
	end as mongon1
	,case coalesce(r.koumoku2,'')
	when '' then '下記の通りご請求させて頂きます。'
	else replace(r.koumoku2,'%tok_cd%',w.tok_cd)
	end as mongon2
	,case coalesce(r.koumoku3,'')
	when '' then '尚、締切日以降の入金は含まれておりませんのでご了承ください。'
	else r.koumoku3
	end as mongon3
--#23703 2022.06.09 MOD STT
	--元々出力されてなかったから、デフォルト値なし
--		,case coalesce(r.koumoku4,'')
--		when '' then  '※お振込手数料はお客様にてご負担願います。'
--		else r.koumoku4
--		end as mongon4
	,r.koumoku4 as mongon4
--#23703 2022.06.09 MOD END
--#23688 2022.07.05 MOD STT
	,(case when('&9' = '1')then(mt.tok_kana)else(w.tok_cd)end) as tok_sort
--#23688 2022.07.05 MOD END
from(
	select
--#19509 2021.09.20 MOD STT
--	      t.tok_cd as tok_cd
--	    , '担当:' || t.tan_nm as tan_nm_s
	      (case when('&7' != '1' and mt.group_cd != '')then(mt.group_cd)else(t.tok_cd)end) as tok_cd
	    , '担当:' || (case when('&7' != '1' and mt.group_cd != '')then(gta.tan_nm)else(t.tan_nm)end) as tan_nm_s
--#19509 2021.09.20 MOD END
	    , to_char(to_date(t.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd_s
	    , t.zen_seikyu_ymd as zen_seikyu_ymd
	    , t.zen_seikyu_zan as zen_seikyu_zan
	    , t.nyukin_gaku as nyukin_gaku
	    , t.kurikoshi_gaku as kurikoshi_gaku
	    , t.zeinuki_gaku as zeinuki_gaku
	    , t.zei_gaku as zei_gaku
	    , t.zeikomi_gaku as zeikomi_gaku
	    , t.seikyu_zan as seikyu_zan
	    , t.den_cnt as den_cnt
--#19509 2021.09.20 MOD STT
--	    , t.tok_nm as tok_nm
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.tok_nm)else(t.tok_nm)end) as tok_nm
--#19509 2021.09.20 MOD END
--#19564 2021.06.17 MOD STT
/*
        ,(case  coalesce(t.tok_nm,'')
			when '' then ''
			else t.tok_nm ||'　'|| (case coalesce(t.keisyou,'') when '' then '様' else t.keisyou end)
		  end) as tok_nm_s
*/
--#19564 2021.06.17 MOD END
--#19509 2021.09.20 MOD STT
--	    , t.tel_no as tel_no
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.tel_no)else(t.tel_no)end) as tel_no
--#19509 2021.09.20 MOD END
--#19564 2021.06.17 MOD STT
--	    , t.tok_tan as tok_tan
		--得意先担当者非表示対応
--#19509 2021.09.20 MOD STT
--		, (case when('&4' = '1')then('')else(t.tok_tan)end) as tok_tan
		, (case when('&4' = '1')then('')else( (case when('&7' != '1' and mt.group_cd != '')then(g.tok_tan)else(t.tok_tan)end) )end) as tok_tan
--#19509 2021.09.20 MOD END
--#19564 2021.06.17 MOD END
--#19564 2021.06.17 MOD STT
--	    , t.keisyou as keisyou
--	    , t.keisyou2 as keisyou2
--#19509 2021.09.20 MOD STT
--	    , t.keisyo
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.keisyo)else(t.keisyo)end) as keisyo
--#19509 2021.09.20 MOD END
--#19564 2021.06.17 MOD END
--#19509 2021.09.20 MOD STT
--	    ,'〒'||substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6) as yubin_no
--	    ,t.address1 as address1
--	    ,t.address2 as address2
--	    ,t.address3 as address3
	    ,'〒'||(case when('&7' != '1' and mt.group_cd != '')then(substr(replace(g.zip_no,'-',''),1,3)||'-'||substr(replace(g.zip_no,'-',''),4,6))else(substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6))end) as yubin_no
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.addr1)else(t.address1)end) as address1
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.addr2)else(t.address2)end) as address2
	    , (case when('&7' != '1' and mt.group_cd != '')then(g.addr3)else(t.address3)end) as address3
--#19509 2021.09.20 MOD END
	    ,t.den_dt as den_dt
--#20621 2021.09.17 MOD STT
        ,t.den_dt_view
		,t.den_no_view
		,t.kbn_view
--#20621 2021.09.17 MOD END
	    ,t.den_no as den_no
	    ,t.kbn as kbn
	    ,t.hin_cd as hin_cd
	    ,t.hin_nm as hin_nm
	    ,t.suryo as suryo
	    ,t.tanka as tanka
	    ,t.kingaku as kingaku
	    ,t.zei_per as zei_per
	    ,t.color as color
	    ,t.sunpo as sunpo
	    , t.sort as sort
		, t.m_row as m_row
		, t.tani
		, t.meisai_biko
		, t.hosoku1
		, t.meisai_biko_s
		, t.zei_rate
		--, midasi_kbn as midasi_kbn
--#19545 2021.06.22 MOD STT
		,t.c_tok_cd
		,t.c_tok_nm
--#19545 2021.06.22 MOD END
--#19509 2021.09.20 MOD STT
		,mt.group_cd
		,(select sum(uk.zen_seikyu_zan) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_zen_seikyu_zan
		,(select sum(uk.nyukin_gaku) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_nyukin_gaku
		,(select sum(uk.kurikoshi_gaku) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_kurikoshi_gaku
		,(select sum(uk.zeinuki_gaku) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_zeinuki_gaku
		,(select sum(uk.zei_gaku) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_zei_gaku
		,(select sum(uk.zeikomi_gaku) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_zeikomi_gaku
		,(select sum(uk.seikyu_zan) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_seikyu_zan
		,(select sum(uk.den_cnt) from m_tokui g inner join t_urikake uk on (uk.tok_cd = g.tok_cd and uk.seikyu_ymd = w.seikyu_ymd) where g.group_cd = mt.group_cd and '&7' != '1' and mt.group_cd != '') as g_den_cnt
--#19509 2021.09.20 MOD END
--#22097 2021.12.20 MOD STT
		,t.nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
		,t.htanka
		,t.disc_per
--#23703 2022.06.08 MOD END
	from w_basr0030 w
--#19509 2021.09.20 MOD STT
	inner join m_tokui mt on (mt.tok_cd = w.tok_cd)
	left join m_tokui g on (g.tok_cd = mt.group_cd)
	left join m_tanto gta on (gta.tan_cd = g.tan_cd)
--#19509 2021.09.20 MOD END
	inner join(
		--明細単位
	    select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
--#19564 2021.06.17 MOD STT
/*
	        , case m1.cat_cd
	            when '1' then
	            case coalesce(m1.tok_tan,'')
	            when '' then '御中'
	            else ''
	            end
	            when '2' then '様'
	            else '御中'
	            end as keisyou
	        , case coalesce(m1.tok_tan,'')
	            when '' then ''
	            else '様'
	            end as keisyou2
*/
			, m1.keisyo
--#19564 2021.06.17 MOD END
	        --,'〒'||substr(replace(m1.zip_no,'-',''),1,3)||'-'||substr(replace(m1.zip_no,'-',''),4,6) as yubin_no
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,to_date(uh.syori_ymd, 'YYYYMMDD') as den_dt
--#20621 2021.09.17 MOD STT
	        ,(case when(h99c.han_name = '1')then('')else(to_char(to_date(uh.syori_ymd, 'YYYYMMDD'),'MM/DD'))end) as den_dt_view
--#23684 2022.04.23 MOD STT
--	        ,(case when(h99c.han_name = '1')then('')else(cast(uh.den_no as varchar))end) as den_no_view
	        ,(case when(h99c.han_name = '1')then('')else( case when('&2' = '1' and uh.kanri_no != '')then(uh.kanri_no)else(cast(uh.den_no as varchar))end )end) as den_no_view
--#23684 2022.04.23 MOD END
	        ,(case when(h99c.han_name = '1')then('')when(uh.henpin_flg = 1)then('御返品')else('御買上')end) as kbn_view
--#20621 2021.09.17 MOD END
	        /*,case when coalesce(uh.kanri_no,'') = '' then coalesce(uh.den_no::varchar,null)
	        	else coalesce(uh.kanri_no,'')
	        	end as den_no*/
--#23684 2022.04.23 MOD STT
--	        ,case when &2 = '1' then --汎用マスタ99のuri-jknrno
--			(case when coalesce(uh.kanri_no,'') = '' then coalesce(uh.den_no::varchar,'')
--	 		else coalesce(uh.kanri_no,'') end)
--     		else coalesce(uh.den_no::varchar,'')
--     		end as den_no --有明、受注番号と伝票番号切替
	        ,(case when('&2' = '1' and uh.kanri_no != '')then(uh.kanri_no)else(cast(uh.den_no as varchar))end) as den_no
--#23684 2022.04.23 MOD END
	        ,case (uh.henpin_flg)
				when '1' then '御返品'
				else case (coalesce(uh.den_no::varchar,''))
				when '' then ''
				else '御買上'
				end 
				end as kbn
	        ,um.hin_cd as hin_cd
--#18663 2021.05.06 MOD STT
--#19636 2021.08.22 MOD STT
--	        ,um.hin_nm as hin_nm
--	        ,(case when(h99b.han_name = '1')then(coalesce(um.hin_cd,'')||' ')else('')end)||um.hin_nm as hin_nm
--#24729 2022.07.05 MOD STT
--	        ,(case when('&3' = um.hin_cd)then('')when(h99b.han_name = '1')then(coalesce(um.hin_cd,'')||' ')else('')end)||um.hin_nm||(case when('&8' = '1')then('')else(coalesce(hin_nm_ext,''))end) as hin_nm
			,(case when('&3' = um.hin_cd)then('')when(h99k.han_name = '1' and um.tok_hacyu_no != '')then(um.tok_hacyu_no||' ')when(h99b.han_name = '1')then(coalesce(um.hin_cd,'')||' ')else('')end)||um.hin_nm||(case when('&8' = '1')then('')else(coalesce(hin_nm_ext,''))end) as hin_nm
--#24729 2022.07.05 MOD END
--#19636 2021.08.22 MOD END
--	        ,um.hin_nm||(case when(h99a.han_name = '1' and um.hosoku2 != '')then(' '||um.hosoku2||' '||coalesce(um.hosoku3,'')||' / '||coalesce(um.hosoku4,''))else('')end) as hin_nm
--#18663 2021.05.06 MOD END
	        ,um.suryo
--#20314 2021.08.14 MOD STT
--	        ,um.tanka
--	        ,um.kingaku as kingaku
	        ,(case when(h0f.koumoku2 = '1')then(cast(null as numeric(12,2)))else(um.tanka)end) as tanka
	        ,(case when(h0f.koumoku2 = '1')then(cast(null as numeric(12,2)))else(um.kingaku)end) as kingaku
--#20314 2021.08.14 MOD END
		,case when uh.zei_kbn = '2' then ''
			else'(8.00%)'
			end as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, um.row_no as m_row
			, um.tani
			, um.meisai_biko
			, um.hosoku1
--			, coalesce(meisai_biko,'')||(um.hosoku1) as meisai_biko_s
--#18943 2022.01.18 MOD STT
--			, coalesce(hin_nm_ext,'')||coalesce(meisai_biko,'')||(case when(COALESCE(h99a.han_name,'') != '1')then(um.hosoku1)else('')end) as meisai_biko_s
--#24729 2022.07.05 MOD STT
--			, (case when('&8' = '1')then(coalesce(hin_nm_ext,''))else('')end)
--				||(case when(h99g.han_name = '1' and um.tok_hacyu_no != '')then(um.tok_hacyu_no)else('')end)
--				||(case when(h99f.han_name = '1')then('')else(coalesce(meisai_biko,''))end)
--				||(case when(COALESCE(h99a.han_name,'') != '1')then(coalesce(um.hosoku1,''))else('')end)
----#24325 2022.06.08 MOD STT
--				||(case when(h99h.han_name = '1' and um.htanka != 0 and COALESCE(um.zei_kbn,0) = 0)then( '税込定価 '||to_char(um.htanka + fnc_get_zei(um.htanka,uh.syori_ymd),'FM999,999,990') )when(h99h.han_name = '1' and um.zei_kbn = 1)then('(税込)')else('')end)
----#24325 2022.06.08 MOD END
--			 as meisai_biko_s
			,(case when(h99j.han_name = '1')then(case when(uh.biko1 != '')then(uh.biko1)else(uh.nonyu_nm)end)
			else(
			 (case when('&8' = '1' and um.hin_nm_ext != '')then(um.hin_nm_ext||' ')else('')end)
				||(case when(h99g.han_name = '1' and um.tok_hacyu_no != '')then('お客様注文No:'||um.tok_hacyu_no)else('')end)
				||(case when(h99f.han_name = '1')then('')else(coalesce(meisai_biko,''))end)
				||(case when(COALESCE(h99a.han_name,'') != '1')then(coalesce(um.hosoku1,''))else('')end)
				||(case when(h99h.han_name = '1' and um.htanka != 0 and COALESCE(um.zei_kbn,0) = 0)then( '税込定価 '||to_char(um.htanka + fnc_get_zei(um.htanka,uh.syori_ymd),'FM999,999,990') )when(h99h.han_name = '1' and um.zei_kbn = 1)then('(税込)')else('')end)
			)end) as meisai_biko_s
--#24729 2022.07.05 MOD END
--#18943 2022.01.18 MOD END
			, to_char(um.zei_rate,'FM90') as zei_rate
			--, ar1.han_name as midasi_kbn
--#19545 2021.06.22 MOD STT
			, uh.tok_cd as c_tok_cd
			, uh.tok_nm as c_tok_nm
--#19545 2021.06.22 MOD END
--#22097 2021.12.20 MOD STT
			, (case when(h99e.han_name = '1')then('納品先:'||COALESCE(uh.nonyu_nm,''))else('')end) as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
--			, um.htanka
			, (case when('&3' = um.hin_cd)then(null)else(um.htanka)end) as htanka
			, (case when(coalesce(um.disc_per,0) = 0)then(null)else(case when(h99i.koumoku2 = 'rev')then(100 - coalesce(um.disc_per,0))else(coalesce(um.disc_per,0))end)end) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
--#17989 2021.02.16 MOD STT
--	    left join t_uri uh on (v.seikyu_ymd = uh.seikyu_ymd and v.tok_cd = uh.tok_cd and uh.jucyu_flg = 0)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join t_uri uh on (v.seikyu_ymd = uh.seikyu_ymd and m2.tok_cd = uh.tok_cd and uh.jucyu_flg = 0)
--#17989 2021.02.16 MOD END
	    left join t_uri_m um on (uh.den_no = um.den_no)
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
	    --left join m_hanyo ar1 on (ar1.mst_kbn='99' and ar1.han_cd='uri-jknrno')
--#18810 2021.04.18 MOD STT
		--left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'hsk2-v0210')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'nhs1-r0033')
		left join m_hanyo h99b on (h99b.mst_kbn = '99' and h99b.han_cd = 'hinc-r0033')
		left join m_hanyo h99c on (h99c.mst_kbn = '99' and h99c.han_cd = 'urih-r0033')
		left join m_hanyo h99d on (h99d.mst_kbn = '99' and h99d.han_cd = 'nstp-r0033')
		left join m_hanyo h99e on (h99e.mst_kbn = '99' and h99e.han_cd = 'nnyb-r0033')
--#18943 2022.01.18 MOD STT
		left join m_hanyo h99f on (h99f.mst_kbn = '99' and h99f.han_cd = 'sp-r0033-1')
		left join m_hanyo h99g on (h99g.mst_kbn = '99' and h99g.han_cd = 'aitm-r0033')
--#18943 2022.01.18 MOD END
		left join m_hanyo h99h on (h99h.mst_kbn = '99' and h99h.han_cd = 'sp-r0033-2')
		left join m_hanyo h99i on (h99i.mst_kbn = '99' and h99i.han_cd = 'tok-disc' and h99i.han_name = '1')
		left join m_hanyo h99j on (h99j.mst_kbn = '99' and h99j.han_cd = 'sp-r0030-4') --ヘッダ備考と納入先表示
		left join m_hanyo h99k on (h99k.mst_kbn = '99' and h99k.han_cd = 'sp-r0030-5') --得意先発注番号+(半角スペース)+品名表示
		left join m_hanyo h0f on (h0f.mst_kbn = '0F' and h0f.han_cd = um.dtl_kbn)
		where 1 = 1
		and uh.del_flg = 0
		--個別請求を除く
		and COALESCE(uh.kobetsu_kbn,'') = ''
--#21153 2021.10.14 MOD STT
		--TODO セット親を除く
		and ((COALESCE(h99d.han_name,'') != '1') or (COALESCE(um.dtl_kbn,'') != 'P'))
--#21153 2021.10.14 MOD END
--#18810 2021.04.18 MOD END

--#23659 2022.04.23 MOD STT
		--受注明細
		union all
	    select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,to_date(uh.syori_ymd, 'YYYYMMDD') as den_dt
	        ,(case when(h99c.han_name = '1')then('')else(to_char(to_date(uh.syori_ymd, 'YYYYMMDD'),'MM/DD'))end) as den_dt_view
--#23684 2022.04.23 MOD STT
--	        ,(case when(h99c.han_name = '1')then('')else(cast(uh.den_no as varchar))end) as den_no_view
	        ,(case when(h99c.han_name = '1')then('')else( case when('&2' = '1' and uh.kanri_no != '')then(uh.kanri_no)else(cast(uh.den_no as varchar))end )end) as den_no_view
--#23684 2022.04.23 MOD END
	        ,(case when(h99c.han_name = '1')then('')when(uh.henpin_flg = 1)then('御返品')else('御買上')end) as kbn_view
--#23684 2022.04.23 MOD STT
--	        ,case when &2 = '1' then --汎用マスタ99のuri-jknrno
--			(case when coalesce(uh.kanri_no,'') = '' then coalesce(uh.den_no::varchar,'')
--	 		else coalesce(uh.kanri_no,'') end)
--     		else coalesce(uh.den_no::varchar,'')
--     		end as den_no --有明、受注番号と伝票番号切替
	        ,(case when('&2' = '1' and uh.kanri_no != '')then(uh.kanri_no)else(cast(uh.den_no as varchar))end) as den_no
--#23684 2022.04.23 MOD END
	        ,case (uh.henpin_flg)
				when '1' then '御返品'
				else case (coalesce(uh.den_no::varchar,''))
				when '' then ''
				else '御買上'
				end 
				end as kbn
	        ,um.hin_cd as hin_cd
	        ,(case when('&3' = um.hin_cd)then('')when(h99b.han_name = '1')then(coalesce(um.hin_cd,'')||' ')else('')end)||um.hin_nm||(case when('&8' = '1')then('')else(coalesce(hin_nm_ext,''))end) as hin_nm
	        ,(COALESCE(um.jucyu_su,0) - COALESCE(um.uri_su,0)) as suryo
	        ,(case when(h0f.koumoku2 = '1')then(cast(null as numeric(12,2)))else(um.tanka)end) as tanka
	        ,(case when(h0f.koumoku2 = '1')then(cast(null as numeric(12,2)))else(um.kingaku)end) as kingaku
		,case when uh.zei_kbn = '2' then ''
			else'(8.00%)'
			end as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, um.row_no as m_row
			, um.tani
			, um.meisai_biko
			, um.hosoku1
			, (case when('&8' = '1')then(coalesce(hin_nm_ext,''))else('')end)
				||(case when(h99g.han_name = '1' and um.tok_hacyu_no != '')then(um.tok_hacyu_no)else('')end)
				||(case when(h99f.han_name = '1')then('')else(coalesce(meisai_biko,''))end)
				||(case when(COALESCE(h99a.han_name,'') != '1')then(coalesce(um.hosoku1,''))else('')end)
			 as meisai_biko_s
			, to_char(um.zei_rate,'FM90') as zei_rate
			, uh.tok_cd as c_tok_cd
			, uh.tok_nm as c_tok_nm
			, (case when(h99e.han_name = '1')then('納品先:'||COALESCE(uh.nonyu_nm,''))else('')end) as nonyu_sort
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    inner join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	    inner join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    inner join t_uri uh on (m2.tok_cd = uh.tok_cd and uh.jucyu_flg = 1)
	    inner join t_uri_m um on (uh.den_no = um.den_no and v.seikyu_ymd = um.seikyu_ymd)
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'nhs1-r0033')
		left join m_hanyo h99b on (h99b.mst_kbn = '99' and h99b.han_cd = 'hinc-r0033')
		left join m_hanyo h99c on (h99c.mst_kbn = '99' and h99c.han_cd = 'urih-r0033')
		left join m_hanyo h99d on (h99d.mst_kbn = '99' and h99d.han_cd = 'nstp-r0033')
		left join m_hanyo h99e on (h99e.mst_kbn = '99' and h99e.han_cd = 'nnyb-r0033')
		left join m_hanyo h99f on (h99f.mst_kbn = '99' and h99f.han_cd = 'sp-r0033-1')
		left join m_hanyo h99g on (h99g.mst_kbn = '99' and h99g.han_cd = 'aitm-r0033')
		left join m_hanyo h0f on (h0f.mst_kbn = '0F' and h0f.han_cd = um.dtl_kbn)
		where 1 = 1
		and uh.del_flg = 0
		--個別請求を除く
		and COALESCE(uh.kobetsu_kbn,'') = ''
		--TODO セット親を除く
		and ((COALESCE(h99d.han_name,'') != '1') or (COALESCE(um.dtl_kbn,'') != 'P'))
--#23659 2022.04.23 MOD END

--#19493 2021.06.21 MOD STT
		--伝票単位
	    union all
	    select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,to_date(uh.syori_ymd, 'YYYYMMDD') as den_dt
--#20621 2021.09.17 MOD STT
	        ,to_char(to_date(uh.syori_ymd, 'YYYYMMDD'),'MM/DD') as den_dt_view
	        ,cast(uh.den_no as varchar) as den_no_view
	        ,(case when(uh.henpin_flg = 1)then('御返品')else('御買上')end) as kbn_view
--#20621 2021.09.17 MOD END
	        ,case when &2 = '1' then --汎用マスタ99のuri-jknrno
			(case when coalesce(uh.kanri_no,'') = '' then coalesce(uh.den_no::varchar,'')
	 		else coalesce(uh.kanri_no,'') end)
       		else coalesce(uh.den_no::varchar,'')
       		end as den_no --有明、受注番号と伝票番号切替
	        ,case (uh.henpin_flg)
				when '1' then '御返品'
				else case (coalesce(uh.den_no::varchar,''))
				when '' then ''
				else '御買上'
				end 
				end as kbn
	        ,'' as hin_cd
--#20621 2021.09.17 MOD STT
--	        ,uh.tok_nm as hin_nm
--#19509 2021.09.20 MOD STT
--#22163 2021.12.20 MOD STT
--	        ,(case when('&7' != '1' and m1.group_cd != '')then(uh.tok_nm)else('納品先:'||uh.nonyu_nm)end) as hin_nm
	        ,'納品先:'||uh.nonyu_nm as hin_nm
--#22163 2021.12.20 MOD END
--#19509 2021.09.20 MOD END
--#20621 2021.09.17 MOD END
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
--#20621 2021.09.17 MOD STT
--TODO 朝日教育社対応
--#22097 2021.12.20 MOD STT
	        ,uh.zeinuki_gaku as kingaku
--	        ,cast(null as numeric(12,2)) as kingaku
--#22097 2021.12.20 MOD END
--#20621 2021.09.17 MOD END
			,case when uh.zei_kbn = '2' then '' else'(8.00%)' end as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, -1 as m_row
			, '' as tani
			, uh.biko1 as meisai_biko
			, '' as hosoku1
--#19635 2021.08.22 MOD STT
--			, coalesce(uh.biko1,'') as meisai_biko_s
			, coalesce(uh.tok_hacyu_no,'') as meisai_biko_s
			, '' as zei_rate
--#19635 2021.08.22 MOD END
--#19545 2021.06.22 MOD STT
			, uh.tok_cd as c_tok_cd
			, uh.tok_nm as c_tok_nm
--#19545 2021.06.22 MOD END
--#22097 2021.12.20 MOD STT
			, (case when(h99e.han_name = '1')then('納品先:'||COALESCE(uh.nonyu_nm,''))else('')end) as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
		inner join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'urih-r0033' and h99a.han_name = '1')
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join t_uri uh on (v.seikyu_ymd = uh.seikyu_ymd and m2.tok_cd = uh.tok_cd and uh.jucyu_flg = 0)
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99e on (h99e.mst_kbn = '99' and h99e.han_cd = 'nnyb-r0033')
		where 1 = 1
		and uh.del_flg = 0
		--個別請求を除く
		and COALESCE(uh.kobetsu_kbn,'') = ''
--#19493 2021.06.21 MOD END

--#19545 2021.06.22 MOD STT
		--得意先計
	    union all
	    select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null as den_dt
--#20621 2021.09.17 MOD STT
	        ,'' as den_dt_view
--#22162 2021.12.20 MOD STT
--	        ,'' as den_no_view
	        ,uh.tok_cd as den_no_view
--#22162 2021.12.20 MOD END
--#22162 2021.12.20 MOD STT
--	        ,'' as kbn_view
	        ,'得意先' as kbn_view
--#22162 2021.12.20 MOD END
--#20621 2021.09.17 MOD END
	        ,null as den_no
	        ,'' kbn
	        ,'' as hin_cd
--#22162 2021.12.20 MOD STT
--	        ,uh.tok_cd||' '||uh.tok_nm||'【御買上計】' as hin_nm
	        ,uh.tok_nm as hin_nm
--#22162 2021.12.20 MOD END
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(uh.zeinuki_gaku) as kingaku
			,'' as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, -1 as m_row
			, '' as tani
			, '' as meisai_biko
			, '' as hosoku1
--#22162 2021.12.20 MOD STT
--			, '' as meisai_biko_s
			, '【得意先計】' as meisai_biko_s
--#22162 2021.12.20 MOD END
			, '' as zei_rate
			, uh.tok_cd as c_tok_cd
			, uh.tok_nm as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join t_uri uh on (v.seikyu_ymd = uh.seikyu_ymd and m2.tok_cd = uh.tok_cd and uh.jucyu_flg = 0)
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'tok-sgrp')
		left join m_hanyo h99e on (h99e.mst_kbn = '99' and h99e.han_cd = 'nnyb-r0033')
		where 1 = 1
		and uh.del_flg = 0
		--個別請求を除く
		and COALESCE(uh.kobetsu_kbn,'') = ''
--#22162 2021.12.20 MOD STT
--		--TODO グループ請求のみ
--		and exists (select 1 from m_tokui m3 where m3.sei_cd = v.tok_cd and m3.tok_cd != v.tok_cd)
--#24324 2022.06.08 MOD STT
--		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and ((h99a.han_name = '1') or exists (select 1 from m_tokui m3 where m3.sei_cd = v.tok_cd and m3.tok_cd != v.tok_cd)) --グループである
		and ((coalesce(h99a.han_name,'') != '1') or ('&7' != '1' and COALESCE(m2.group_cd,'') != '')) --グループである
--#24324 2022.06.08 MOD END
--#22162 2021.12.20 MOD END
		group by 
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			, uh.tok_cd
			, uh.tok_nm
--#19545 2021.06.22 MOD END

--#22097 2021.12.20 MOD STT
		--納入先計
	    union all
	    select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null as den_dt
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'納品先' as kbn_view
	        ,null as den_no
	        ,'' kbn
	        ,'' as hin_cd
	        ,COALESCE(uh.nonyu_nm,'') as hin_nm
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(uh.zeinuki_gaku) as kingaku
			,'' as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, -1 as m_row
			, '' as tani
			, '' as meisai_biko
			, '' as hosoku1
			, '【納品先計】' as meisai_biko_s
			, '' as zei_rate
			, uh.tok_cd as c_tok_cd
			, uh.tok_nm as c_tok_nm
			, '納品先:'||COALESCE(uh.nonyu_nm,'') as nonyu_sort
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
		inner join m_hanyo h99e on (h99e.mst_kbn = '99' and h99e.han_cd = 'nnyb-r0033')
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join t_uri uh on (v.seikyu_ymd = uh.seikyu_ymd and m2.tok_cd = uh.tok_cd and uh.jucyu_flg = 0)
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		where 1 = 1
		and uh.del_flg = 0
		--個別請求を除く
		and COALESCE(uh.kobetsu_kbn,'') = ''
--		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and h99e.han_name = '1' --納入先計あり
		group by 
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			, uh.tok_cd
			, uh.tok_nm
	        ,COALESCE(uh.nonyu_nm,'')
			, '納品先:'||COALESCE(uh.nonyu_nm,'')
--#22097 2021.12.20 MOD END

	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
--#19564 2021.06.17 MOD STT
/*
	        , case m1.cat_cd
	            when '1' then
	            case coalesce(m1.tok_tan,'')
	            when '' then '御中'
	            else ''
	            end
	            when '2' then '様'
	            else '御中'
	            end as keisyou
	        ,case coalesce(m1.tok_tan,'')
	            when '' then ''
	            else '様'
	            end as keisyou2
*/
			, m1.keisyo
--#19564 2021.06.17 MOD END
	        --,'〒'||substr(replace(m1.zip_no,'-',''),1,3)||'-'||substr(replace(m1.zip_no,'-',''),4,6) as yubin_no
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,to_date(n.nyukin_ymd, 'YYYYMMDD') as den_dt
--#20621 2021.09.17 MOD STT
	        ,to_char(to_date(n.nyukin_ymd, 'YYYYMMDD'),'MM/DD') as den_dt_view
	        ,cast(n.nyukin_no as varchar) as den_no_view
	        ,'御入金' as kbn_view
--#20621 2021.09.17 MOD END
	        ,coalesce(n.nyukin_no::varchar,'') as den_no
	        ,'御入金' as kbn
	        ,'御入金' as hin_cd
--#19142 2021.08.22 MOD STT
--	        ,'                                ('||COALESCE(han.han_name,'')||')' as hin_nm
	        ,'                                ('||COALESCE( case when(han.koumoku6 != '')then(han.koumoku6)else(han.han_name)end ,'')||')' as hin_nm
--#19142 2021.08.22 MOD END
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
--#22078 2022.02.01 MOD STT
--	        ,n.total_gaku as kingaku
	        ,sum(n.total_gaku) as kingaku
--#22078 2022.02.01 MOD END
	        ,'' as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
--#22078 2022.02.01 MOD STT
--			, null as m_row
			, min(n.row_no) as m_row
--#22078 2022.02.01 MOD END
	        ,'' as tani
			,'' as meisai_biko
			,'' as hosoku1
	        ,n.biko as meisai_biko_s
			, '' as zei_rate
	        --,'' --midasi_kbn
--#19545 2021.06.22 MOD STT
			, n.tok_cd as c_tok_cd
			, n.tok_nm as c_tok_nm
--#19545 2021.06.22 MOD END
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
--#17322 2020.12.26 MOD STT
--	    left join t_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and v.tok_cd = n.tok_cd)
--#17989 2021.02.16 MOD STT
--	    left join v_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and v.tok_cd = n.tok_cd)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join v_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and m2.tok_cd = n.tok_cd)
--#17989 2021.02.16 MOD END
--#17322 2020.12.26 MOD END
	    left join m_hanyo han on (n.nyukin_kbn = han.han_cd and han.mst_kbn = '13')
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#13823 2020.04.29 MOD STT
--	    left join m_hanyo h1 on (h1.mst_kbn = '15')
--#13823 2020.04.29 MOD END
--#20207 2021.08.06 MOD STT
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'nnkn-r0033')
--#20207 2021.08.06 MOD END
	    where 1=1
	    and n.nyukin_gaku is not null
--#13823 2020.04.29 MOD STT
--	    and COALESCE(h1.koumoku6,'') = ''
	    and '&5' = ''
--#13823 2020.04.29 MOD END
--#18810 2021.04.18 MOD STT
		--個別請求に対する入金を除く
		AND not exists (select 1 from t_nyu_keshi nk inner join t_uri uh on (uh.den_no = nk.uri_no) where nk.nyukin_no = n.nyukin_no and nk.keshi_kind = 1 and COALESCE(uh.kobetsu_kbn,'') != '')
--#18810 2021.04.18 MOD END
--#20207 2021.08.06 MOD STT
		--入金明細印字無し
		AND COALESCE(h99a.han_name,'') != '1'
--#20207 2021.08.06 MOD END
--#22078 2022.02.01 MOD STT
		group by 
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
	        ,to_date(n.nyukin_ymd, 'YYYYMMDD')
	        ,to_char(to_date(n.nyukin_ymd, 'YYYYMMDD'),'MM/DD')
	        ,cast(n.nyukin_no as varchar)
	        ,coalesce(n.nyukin_no::varchar,'')
	        ,'                                ('||COALESCE( case when(han.koumoku6 != '')then(han.koumoku6)else(han.han_name)end ,'')||')'
	        ,n.biko
			, n.tok_cd
			, n.tok_nm
--#22078 2022.02.01 MOD END
--#19545 2021.06.22 MOD STT
	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null as den_dt
--#20621 2021.09.17 MOD STT
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
--#20621 2021.09.17 MOD END
	        ,null as den_no
	        ,'' as kbn
	        ,'' as hin_cd
	        ,n.tok_cd||' '||n.tok_nm||'【御入金計】' as hin_nm
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(n.total_gaku) as kingaku
	        ,'' as zei_per
	        ,'' as color
	        ,'' as sunpo
	        , 1 as sort
			, null as m_row
	        ,'' as tani
			,'' as meisai_biko
			,'' as hosoku1
	        ,'' meisai_biko_s
			, '' as zei_rate
			, n.tok_cd as c_tok_cd
			, n.tok_nm as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	    left join m_tokui m2 on ((case when(m2.sei_cd != '''')then(m2.sei_cd)else(m2.tok_cd)end) = v.tok_cd)
	    left join v_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and m2.tok_cd = n.tok_cd)
	    left join m_hanyo han on (n.nyukin_kbn = han.han_cd and han.mst_kbn = '13')
	    left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
	    where 1 = 1
	    and n.nyukin_gaku is not null
	    and '&5' = ''
		--個別請求に対する入金を除く
		AND not exists (select 1 from t_nyu_keshi nk inner join t_uri uh on (uh.den_no = nk.uri_no) where nk.nyukin_no = n.nyukin_no and nk.keshi_kind = 1 and COALESCE(uh.kobetsu_kbn,'') != '')
		--TODO グループ請求のみ
		and exists (select 1 from m_tokui m3 where m3.sei_cd = v.tok_cd and m3.tok_cd != v.tok_cd)
		group by 
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			, n.tok_cd
			, n.tok_nm
--#19545 2021.06.22 MOD END

	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
--#19564 2021.06.17 MOD STT
/*
	        , case m1.cat_cd
	            when '1' then
	            case coalesce(m1.tok_tan,'')
	            when '' then '御中'
	            else ''
	            end
	            when '2' then '様'
	            else '御中'
	            end as keisyou
	        ,case coalesce(m1.tok_tan,'')
	            when '' then ''
	            else '様'
	            end as keisyou2
*/
			, m1.keisyo
--#19564 2021.06.17 MOD END
	        --,'〒'||substr(replace(m1.zip_no,'-',''),1,3)||'-'||substr(replace(m1.zip_no,'-',''),4,6) as yubin_no
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
--#20621 2021.09.17 MOD STT
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
--#20621 2021.09.17 MOD END
	        ,''
	        ,''
	        ,'御買上計'　--hin_cd
	        ,'　　　　　　　　　　　　　　　　　【御買上計】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,coalesce(v.zeinuki_gaku,0) + (case when(COALESCE(h99a.han_name,'') = '1')then(coalesce(v.uchi_gaku,0) + coalesce(v.uchi_gaku2,0))else(0)end) as kingaku
	        ,''
	        ,''
	        ,''
	        , 2 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			--,'' --midasi_kbn
--#19545 2021.06.22 MOD STT
			, '' as c_tok_cd
			, '' as c_tok_nm
--#19545 2021.06.22 MOD END
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#19509 2021.09.20 MOD STT
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		where 1 = 1
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
--#19509 2021.09.20 MOD END

--#18101 2021.10.10 MOD STT
		--内消費税
	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'内消費税'　--hin_cd
	        ,'【うち消費税（'||COALESCE(mzei.han_name,'')||'）】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,coalesce(v.uchi_gaku,'0') as kingaku
	        ,''
	        ,''
	        ,''
	        , 3 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.uchi_gaku != 0
		--内消費税2
	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'内消費税'　--hin_cd
	        ,'【うち消費税（'||COALESCE(mzei.koumoku4,'')||'）】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,coalesce(v.uchi_gaku2,'0') as kingaku
	        ,''
	        ,''
	        ,''
	        , 4 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.uchi_gaku2 != 0

		--外消費税
	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'消費税'　--hin_cd
--#23659 2022.04.23 MOD STT
--	        ,'【消費税（'||COALESCE(mzei.han_name,'')||'）】課税対象額 '||to_char(v.kazei_gaku,'FM999,999,999,990')
	        ,'【消費税（'||COALESCE(mzei.han_name,'')||'）】課税対象額 '||to_char(COALESCE(v.kazei_gaku,0) + COALESCE(v.jucyu_kazei_gaku1,0),'FM999,999,999,990')
--#23659 2022.04.23 MOD END
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
--#23659 2022.04.23 MOD STT
--	        ,coalesce(v.soto_gaku,'0') as kingaku
	        ,coalesce(v.soto_gaku,0) + coalesce(v.jucyu_soto_gaku1,0) as kingaku
--#23659 2022.04.23 MOD END
	        ,''
	        ,''
	        ,''
	        , 5 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
--#23659 2022.04.23 MOD STT
--		and v.soto_gaku != 0
		and ((v.soto_gaku != 0) or (v.jucyu_soto_gaku1 != 0))
--#23659 2022.04.23 MOD END
		--外消費税2
	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'消費税'　--hin_cd
--#23659 2022.04.23 MOD STT
--	        ,'【消費税（'||COALESCE(mzei.koumoku4,'')||'）】課税対象額 '||to_char(v.kazei_gaku2,'FM999,999,999,990')
	        ,'【消費税（'||COALESCE(mzei.koumoku4,'')||'）】課税対象額 '||to_char(COALESCE(v.kazei_gaku2,0) + COALESCE(v.jucyu_kazei_gaku2,0),'FM999,999,999,990')
--#23659 2022.04.23 MOD END
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
--#23659 2022.04.23 MOD STT
--	        ,coalesce(v.soto_gaku2,'0') as kingaku
	        ,coalesce(v.soto_gaku2,0) + coalesce(v.jucyu_soto_gaku2,0) as kingaku
--#23659 2022.04.23 MOD END
	        ,''
	        ,''
	        ,''
	        , 6 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
--#23659 2022.04.23 MOD STT
--		and v.soto_gaku2 != 0
		and ((v.soto_gaku2 != 0) or (v.jucyu_soto_gaku2 != 0))
--#23659 2022.04.23 MOD END

--#18101 2021.10.10 MOD END

--#19509 2021.09.20 MOD STT
		--売上計（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'御買上計'　--hin_cd
	        ,'　　　　　　　　　　　　　　　　　【御買上計】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(coalesce(v.zeinuki_gaku,0) + (case when(COALESCE(h99a.han_name,'') = '1')then(coalesce(v.uchi_gaku,0) + coalesce(v.uchi_gaku2,0))else(0)end)) as kingaku
	        ,''
	        ,''
	        ,''
	        , 2 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
		left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		where 1 = 1
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		group by
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
--#19509 2021.09.20 MOD END

--#18101 2021.10.10 MOD STT
		--内消費税（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'内消費税'　--hin_cd
	        ,'【うち消費税（'||COALESCE(mzei.han_name,'')||'）】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(v.uchi_gaku) as kingaku
	        ,''
	        ,''
	        ,''
	        , 3 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
		left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.uchi_gaku != 0
		group by
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			,COALESCE(mzei.han_name,'')
		--内消費税2（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'内消費税'　--hin_cd
	        ,'【うち消費税（'||COALESCE(mzei.koumoku4,'')||'）】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(v.uchi_gaku2) as kingaku
	        ,''
	        ,''
	        ,''
	        , 4 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
		left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.uchi_gaku2 != 0
		group by
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			,COALESCE(mzei.koumoku4,'')
		--外消費税（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'消費税'　--hin_cd
	        ,'【消費税（'||COALESCE(mzei.han_name,'')||'）】課税対象額 '||to_char(sum(v.kazei_gaku),'FM999,999,999,990')
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(v.soto_gaku) as kingaku
	        ,''
	        ,''
	        ,''
	        , 5 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
		left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#21167 2021.11.11 MOD STT
--		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zeid-r0033')
--#21167 2021.11.11 MOD END
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.soto_gaku != 0
		group by
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			,COALESCE(mzei.han_name,'')
		--外消費税2（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,''
	        ,''
	        ,'消費税'　--hin_cd
	        ,'【消費税（'||COALESCE(mzei.koumoku4,'')||'）】課税対象額 '||to_char(sum(v.kazei_gaku2),'FM999,999,999,990')
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,sum(v.soto_gaku2) as kingaku
	        ,''
	        ,''
	        ,''
	        , 6 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
		left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'zei-multi')
		left join m_hanyo mzei on (mzei.mst_kbn = '93' and v.seikyu_ymd between mzei.koumoku1 and mzei.koumoku2)
		where 1 = 1
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループである
		and COALESCE(h99a.han_name,'') = '1' --軽減税率
		and v.soto_gaku2 != 0
		group by
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
			,COALESCE(mzei.koumoku4,'')
--#18101 2021.10.10 MOD END

	    union all
		select
	          v.seikyu_ymd
	        , v.tok_cd
	        , ta.tan_nm as tan_nm
	        , v.zen_seikyu_ymd
	        , v.zen_seikyu_zan
	        , v.nyukin_gaku
	        , v.kurikoshi_gaku
	        , v.zeinuki_gaku
	        , v.zei_gaku
	        , v.zeikomi_gaku
	        , v.seikyu_zan
	        , v.den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
--#19564 2021.06.17 MOD STT
/*
	        , case m1.cat_cd
	            when '1' then
	            case coalesce(m1.tok_tan,'')
	            when '' then '御中'
	            else ''
	            end
	            when '2' then '様'
	            else '御中'
	            end as keisyou
	        ,case coalesce(m1.tok_tan,'')
	            when '' then ''
	            else '様'
	            end as keisyou2
*/
			, m1.keisyo
--#19564 2021.06.17 MOD END
	        --,'〒'||substr(replace(m1.zip_no,'-',''),1,3)||'-'||substr(replace(m1.zip_no,'-',''),4,6) as yubin_no
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
--#20621 2021.09.17 MOD STT
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
--#20621 2021.09.17 MOD END
	        ,null
	        ,''
	        ,'御入金計' --hin\cd
	        ,'　　　　　　　　　　　　　　　　　【御入金計】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,coalesce(v.nyukin_gaku,'0')  as kingaku
	        ,''
	        ,''
	        ,''
	        , 9 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			--,'' --midasi_kbn
--#19545 2021.06.22 MOD STT
			, '' as c_tok_cd
			, '' as c_tok_nm
--#19545 2021.06.22 MOD END
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
--#20231 2021.08.06 MOD STT
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
--#20231 2021.08.06 MOD END
	    left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
--#20207 2021.08.06 MOD STT
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'nnkn-r0033')
--#20207 2021.08.06 MOD END
--#13823 2020.04.29 MOD STT
--		left join m_hanyo h1 on (h1.mst_kbn = '15')
--#13823 2020.04.29 MOD END
		where 1=1
--#13823 2020.04.29 MOD STT
--		and COALESCE(h1.koumoku6,'') = ''
		and '&5' = ''
--#20207 2021.08.06 MOD STT
		--入金明細印字無し
		AND COALESCE(h99a.han_name,'') != '1'
--#20207 2021.08.06 MOD END
--#13823 2020.04.29 MOD END
--#19509 2021.09.20 MOD STT
		and (('&7' = '1') or (COALESCE(m1.group_cd,'') = '')) --グループでない
--#19509 2021.09.20 MOD END

--#19509 2021.09.20 MOD STT
		--入金計（グループ）
	    union all
		select
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm as tan_nm
	        , max(v.zen_seikyu_ymd) as zen_seikyu_ymd
	        , sum(v.zen_seikyu_zan) as zen_seikyu_zan
	        , sum(v.nyukin_gaku) as nyukin_gaku
	        , sum(v.kurikoshi_gaku) as kurikoshi_gaku
	        , sum(v.zeinuki_gaku) as zeinuki_gaku
	        , sum(v.zei_gaku) as zei_gaku
	        , sum(v.zeikomi_gaku) as zeikomi_gaku
	        , sum(v.seikyu_zan) as seikyu_zan
	        , sum(v.den_cnt) as den_cnt
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'') as tok_tan
			, m1.keisyo
	        ,m1.zip_no as zip_no
	        ,m1.addr1 as address1
	        ,m1.addr2 as address2
	        ,m1.addr3||m1.addr4 as address3
	        ,null
	        ,'' as den_dt_view
	        ,'' as den_no_view
	        ,'' as kbn_view
	        ,null
	        ,''
	        ,'御入金計' --hin\cd
	        ,'　　　　　　　　　　　　　　　　　【御入金計】'
	        ,cast(null as numeric(9,2)) as suryo
	        ,cast(null as numeric(12,2)) as tanka
	        ,coalesce(sum(v.nyukin_gaku),'0')  as kingaku
	        ,''
	        ,''
	        ,''
	        , 9 as sort
			, null as m_row
	        ,''
	        ,''
			, ''
			, ''
			, '' as zei_rate
			, '' as c_tok_cd
			, '' as c_tok_nm
--#22097 2021.12.20 MOD STT
			, '' as nonyu_sort
--#22097 2021.12.20 MOD END
--#23703 2022.06.08 MOD STT
			, cast(null as numeric(12,2)) as htanka
			, cast(null as numeric(5,2)) as disc_per
--#23703 2022.06.08 MOD END
	    from t_urikake v
		inner join w_basr0030 w on (w.s_id = &1 and w.seikyu_ymd = v.seikyu_ymd and w.tok_cd = v.tok_cd)
	    left join m_tokui m2 on (m2.tok_cd = v.tok_cd)
	    left join m_tokui m1 on (m1.tok_cd = m2.group_cd)
		left join m_tanto ta on (m1.tan_cd = ta.tan_cd)
		left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'nnkn-r0033')
		where 1 = 1
		and '&5' = ''
		--入金明細印字無し
		AND COALESCE(h99a.han_name,'') != '1'
		and '&7' != '1' and COALESCE(m2.group_cd,'') != '' --グループでない
		group by 
	          v.seikyu_ymd
	        , m1.tok_cd
	        , ta.tan_nm
	        , m1.tok_nm
	        , m1.tel_no
	        , coalesce(m1.tok_tan,'')
			, m1.keisyo
	        ,m1.zip_no
	        ,m1.addr1
	        ,m1.addr2
	        ,m1.addr3||m1.addr4
--#19509 2021.09.20 MOD END

	) t on (t.seikyu_ymd = w.seikyu_ymd and t.tok_cd = w.tok_cd)
	where 1=1
	and w.s_id = &1
) w
left join m_hanyo eig on (eig.mst_kbn = '99' and eig.han_cd = 'mtok-eig')
left join m_tokui mt on (mt.tok_cd = w.tok_cd)
left join m_hanyo jis on (jis.mst_kbn = '90' and jis.han_cd = 'jisya' || (case when(eig.han_name = '1' and mt.eig_cd != '')then('_' || mt.eig_cd)else('')end))
left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'logo-r0033')
--#22557 2022.01.18 MOD STT
left join m_hanyo h99b on (h99b.mst_kbn = '99' and h99b.han_cd = 'fuyo-r0033')
--#22557 2022.01.18 MOD END
left join m_hanyo r on (r.mst_kbn = '90' and r.han_cd = 'r0030')
left join m_hanyo h98a on (h98a.mst_kbn = '98' and h98a.han_cd = 'jisya-k07')
where 1 = 1
--#19545 2021.06.22 MOD STT
--order by tok_cd, sort, den_dt_sort, den_no, m_row
--#22097 2021.12.20 MOD STT
--order by tok_cd, sort, c_tok_cd, den_dt_sort, den_no, m_row
--#22557 2022.01.18 MOD STT
and ((COALESCE(h99b.han_name,'') != '1') or (COALESCE(mt.seikyusyo_fuyo_flg,0) != 1))
--#22557 2022.01.18 MOD END
--#23688 2022.07.05 MOD STT
--order by tok_cd, sort, c_tok_cd, nonyu_sort, den_dt_sort, den_no, m_row
order by tok_sort, tok_cd, sort, c_tok_cd, nonyu_sort, den_dt_sort, den_no, m_row
--#23688 2022.07.05 MOD END
--#22097 2021.12.20 MOD END
--#19545 2021.06.22 MOD END

[SelectRecords_Jisya]
select
	 w.*
 	,(case coalesce(j_tel,'') when '' then '' else 'TEL:' || j_tel end) as j_tel_s
 	,(case coalesce(j_fax,'') when '' then '' else 'FAX:' || j_fax end) as j_fax_s
 	,(case coalesce(j_url,'') when '' then '' else 'URL:' || j_url end) as j_url_s
 	,(case coalesce(j_mail,'') when '' then '' else 'EMAIL:' || j_mail end) as j_mail_s
from(
	select
--#13823 2020.04.29 MOD STT
--		 j3.han_name as tait
--#13823 2020.04.29 MOD END
		 j.mst_kbn
		,j.han_cd
		,j.han_name as j_nm
		,j.koumoku1 as j_post_s
		,coalesce(j.koumoku2,'') || coalesce(j.koumoku3,'') as j_address
--		,j.koumoku3 as j_address2
--		,j.koumoku4
		,j.koumoku5 as j_tel
		,j.koumoku6 as j_fax
		,j.koumoku7 as j_url
		,j.koumoku8 as j_mail
--		,j.koumoku9
--		,j.koumoku10
		,j.sort_key
		,j2.mst_kbn
		,j2.han_cd
		,j2.han_name
		,j2.koumoku1 as koumoku1
		,j2.koumoku2 as koumoku2
		,j2.koumoku3 as koumoku3
		,j2.koumoku4 as koumoku4
		,j2.koumoku5 as koumoku5
		,j2.koumoku6 as koumoku6
		,j2.koumoku7 as koumoku7
		,j2.koumoku8 as koumoku8
		,j2.koumoku9 as koumoku9
		,j2.koumoku10 as koumoku10
		,case coalesce(r.koumoku1,'')
		when '' then '毎度お引き立てくださいましてありがとうございます。'
		else r.koumoku1
		end as mongon1
		,case coalesce(r.koumoku2,'')
		when '' then '下記の通りご請求させて頂きます。'
		else r.koumoku2
		end as mongon2
		,case coalesce(r.koumoku3,'')
		when '' then '尚、締切日以降の入金は含まれておりませんのでご了承ください。'
		else r.koumoku3
		end as mongon3
--#23703 2022.06.09 MOD STT
		--元々出力されてなかったから、デフォルト値なし
--		,case coalesce(r.koumoku4,'')
--		when '' then  '※お振込手数料はお客様にてご負担願います。'
--		else r.koumoku4
--		end as mongon4
		,r.koumoku4 as mongon4
--#23703 2022.06.09 MOD END
		--, '毎度お引き立てくださいましてありがとうございます。' as mongon1
		--, '下記の通りご請求させて頂きます。' as mongon2
		--, '尚、締切日以降の入金は含まれておりませんのでご了承ください。' as mongon3
		--, '※お振込手数料はお客様にてご負担願います。' as mongon4
		, '' as mongon5
		, case when coalesce(ar1.han_name,'') = '1' then coalesce(ar1.han_name,'')
			else '0' end as midasi_kbn
		, case when coalesce(m2.koumoku1,'') != '' then coalesce(m2.koumoku1,'')
			else '' end as midasi_FLG
		, case when coalesce(m3.han_name,'') = '1' then coalesce(m3.han_name,'')
			else '0' end as sp1_FLG
		, case when coalesce(m4.han_name,'') = '1' then coalesce(m4.han_name,'')
			else '0' end as sp2_FLG
		, case when coalesce(m5.han_name,'') = '1' then coalesce(m5.han_name,'')
			else '0' end as meisai_row_kbn
		, case when coalesce(uritndec.han_name,'0') = '' then '0'
			   when coalesce(uritndec.han_name,'0') = '0' then '0'
			else '1' end as uritndec
		, (case when(m6.han_name = '1')then(0)else(1)end) as head_furi_flg
		, (case when(f.koumoku1 != '')then(1)else(0)end) as footer_flg
		, f.koumoku1 as footer1
		, f.koumoku2 as footer2
		, f.koumoku3 as footer3
--#20800 2021.09.24 MOD STT
		, replace('&1','(単独)','') as tait
--#20800 2021.09.24 MOD END
	from m_hanyo j
	left join m_hanyo j2 on (j2.mst_kbn = '90' and j2.han_cd = 'jisya2')
--	left join m_hanyo j3 on (j3.mst_kbn = '15' and j3.han_cd = '1')
--#23684 2022.04.23 MOD STT
--	left join m_hanyo ar1 on (ar1.mst_kbn='99' and ar1.han_cd='uri-jknrno')
	left join m_hanyo ar1 on (ar1.mst_kbn='99' and ar1.han_cd='knrn-r0033')
--#23684 2022.04.23 MOD END
	left join m_hanyo m2 on (m2.mst_kbn = '90' and m2.han_cd = 'hin-title') --見出し行対応（数量・単価・金額の非表示）
	left join m_hanyo m3 on (m3.mst_kbn = '99' and m3.han_cd = 'sp-r0030-1') --請求書／連続コード非表示
	left join m_hanyo m4 on (m4.mst_kbn = '99' and m4.han_cd = 'sp-r0030-2') --請求書／得意先担当者非表示
	left join m_hanyo m5 on (m5.mst_kbn = '99' and m5.han_cd = 'sp-r0030-3') --請求書／行数拡張
	left join m_hanyo m6 on (m6.mst_kbn = '99' and m6.han_cd = 'nfur-r0033') --請求明細書／ヘッダ振込先印字無し
	left join m_hanyo uritndec on (uritndec.mst_kbn='99' and uritndec.han_cd='uri-tn-dec') --売上単価小数点(ある場合は小数点表示、標準はなし）
	left join m_hanyo r on (r.mst_kbn = '90' and r.han_cd = 'r0030')
	left join m_hanyo f on (f.mst_kbn = '90' and f.han_cd = 'r0033.f')
	where 1=1
	and j.mst_kbn = '90'
	and j.han_cd = 'jisya'
)w

[SelectRecords_Furi]
select
	han_name || ' ' || furikikan1 || ' ' || furikikan2 || ' ' || furikikan3 as furikikan
from(
	select 
		h09.mst_kbn,
		h09.han_cd,
		h09.han_name,
		h09.koumoku1 as furikikan1,
		h09.koumoku2 as furikikan2,
		h09.koumoku3 as furikikan3,
		h09.koumoku4,
		h09.koumoku5,
		coalesce(h09.koumoku6,''),
		h09.koumoku7,
		h09.koumoku8,
		h09.koumoku9,
		h09.koumoku10,
		h09.sort_key
	from m_hanyo h09
	left join m_tokui mt on (mt.tok_cd = '&2')
	left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'mtok-eig-f')
	where 1 = 1
	and h09.mst_kbn = '09'
	and coalesce(h09.koumoku6,'') = ''
	and ((coalesce(h99a.han_name,'') != '1') or (h09.koumoku12 = mt.eig_cd))
) w
order by han_cd

[SelectSyaban]
select 
  koumoku2 as image_cd
, koumoku3 as img_row
, koumoku4 as img_col
from m_hanyo
where 1 = 1
and mst_kbn = '99' 
and han_cd = 'syab-r0033'
and han_name = '1'

[SelectLogo]
select 
  koumoku2 as image_cd
, koumoku3 as img_row
, koumoku4 as img_col
from m_hanyo
where 1 = 1
and mst_kbn = '99' 
and han_cd = 'logo-r0033'
and han_name = '1'

[SelectImage]
select file_image
from m_image
where image_cd = '&1'

[SelectImageList]
select image_cd, file_image
from m_image
where image_cd like '&1%'
order by image_cd

[UpdateWork]
insert into w_basr0030 (
s_id, seikyu_ymd, tok_cd, del_flg, cre_id, cre_time, upd_id, upd_time
)
select
w1.s_id, w1.seikyu_ymd, w1.group_cd, 0, 'BASR0033', now(), 'BASR0033', now()
from (
select distinct w.s_id, w.seikyu_ymd, mt.group_cd
from w_basr0030 w
inner join m_tokui mt on (mt.tok_cd = w.tok_cd)
where w.s_id = &1
and mt.group_cd != ''
and not exists (select 1 from w_basr0030 w2 where w2.s_id = w.s_id and w2.seikyu_ymd = w.seikyu_ymd and w2.tok_cd = mt.group_cd)
) w1