[selectRecords]
select
	  t.tok_cd
	, to_char(to_date(t.seikyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as seikyu_ymd
	, '123456'as seikyu_no
	, t.zen_seikyu_ymd
	, t.zen_seikyu_zan
	, t.nyukin_gaku
	, t.kurikoshi_gaku
	, t.zeinuki_gaku
	, t.zei_gaku
	, t.zeikomi_gaku
	, t.seikyu_zan
	, t.den_cnt
	, t.tok_nm
	,yubin_no
	,address1
	,address2
	,address3
	--,tanto_nm
	,den_dt
	,den_no
	,kbn
	,hin_nm
	,suryo
	,tanka
	,kingaku
	,zei_per
	,color
	,sunpo
	, t.sort
from w_basr0030 w
inner join (
	select 
		  v.seikyu_ymd
		, v.tok_cd
		, 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
		,'〒'||substr(m1.zip_no,1,3)||'-'||substr(m1.zip_no,4,6) as yubin_no
		,m1.addr1 as address1
		,m1.addr2 as address2
		,m1.addr3||m1.addr4 as address3
		--,'('||lpad(cast(uh.jyucyu_no as varchar), 6, ' ')||'       ・'||rpad('担当者名', 12, '　')||'様 )' as tanto_nm
		,to_char(to_date(uh.syori_ymd, 'YYYYMMDD'), 'mm/dd') as den_dt
		,uh.den_no as den_no
		,'売上' as kbn
		,uh.payment_term as hin_nm
		,null as suryo
		,null as tanka
		,uh.zeinuki_gaku as kingaku
		,'' as zei_per
		,'' as color
		,'' as sunpo
		, 0 as sort
	from t_urikake v
	left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	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 t_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and v.tok_cd = n.tok_cd)
	union all select 
		  v.seikyu_ymd
		, v.tok_cd
		, 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
		,'〒'||substr(m1.zip_no,1,3)||'-'||substr(m1.zip_no,4,6) as yubin_no
		,m1.addr1 as address1
		,m1.addr2 as address2
		,m1.addr3||m1.addr4 as address3
		--,''
		,to_char(to_date(n.nyukin_ymd, 'YYYYMMDD'), 'mm/dd') as den_dt
		,n.nyukin_no as den_no
		,'振込' as kbn
		,'(御入金)' as hin_nm
		,'' as suryo
		,null as tanka
		,n.nyukin_gaku as kingaku
		,''
		,''
		,''
		, 1 as sort
	from t_urikake v
	left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	left join t_nyukin n on (v.seikyu_ymd = n.seikyu_ymd and v.tok_cd = n.tok_cd)
	where 1=1
	and n.nyukin_gaku is not null
	union all select 
		  v.seikyu_ymd
		, v.tok_cd
		, 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
		,'〒'||substr(m1.zip_no,1,3)||'-'||substr(m1.zip_no,4,6) as yubin_no
		,m1.addr1 as address1
		,m1.addr2 as address2
		,m1.addr3||m1.addr4 as address3
		--,''
		,null
		,null
		,''
		,'　　　　　　　　　　　　　　　　　【売上計】'
		,''
		,null
		,v.zeinuki_gaku as kingaku
		,''
		,''
		,''
		, 1 as sort
	from t_urikake v
	left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
	union all select 
		  v.seikyu_ymd
		, v.tok_cd
		, 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
		,'〒'||substr(m1.zip_no,1,3)||'-'||substr(m1.zip_no,4,6) as yubin_no
		,m1.addr1 as address1
		,m1.addr2 as address2
		,m1.addr3||m1.addr4 as address3
		--,''
		,null
		,null
		,''
		,'　　　　　　　　　　　　　　　　　【入金計】'
		,''
		,null
		,case v.nyukin_gaku when 0 then null else v.nyukin_gaku end  as kingaku
		,''
		,''
		,''
		, 1 as sort
	from t_urikake v
	left join m_tokui m1 on (m1.tok_cd = v.tok_cd)
) t on (t.seikyu_ymd = w.seikyu_ymd and t.tok_cd = w.tok_cd)
where 1=1
and w.s_id = &1
order by tok_cd, den_dt, sort