[UpdateDb]
select fnc_update_nohinsyo(&23, '{
  "dt_from":"&1"
, "dt_to":"&2"
, "input_dt_from":"&19"
, "input_dt_to":"&20"
, "den_no":"&3"
, "tok_cd":"&4"
, "hin_nm":"&5"
, "seikyu_s_id":"&7"
, "eig_cd":"&18"
, "jucyu_flg":"&8"
, "rep_type":"&21"
, "mongon":"&22"
, "location_flg":"&17"
, "hide_kingaku_flg":"&14"
, "hide_htanka_flg":"&15"
, "hide_disc_flg":"&16"
, "title":"&6"
, "title_custom":"&13"
, "no_zei_mode":"&24"
, "internal_flg":"&25"
, "line1_mode":"&26"
, "biko_wide_flg":"&27"
, "hext_flg":"&28"
, "print_kind":"&29"
, "login_id":"&30"
}')

[selectRecords]
select
  w.*
, (case when(w.biko_hide_flg = 1)then(0)else(1)end) as biko_print_flg
from fnc_query_nohinsyo(&23, '{}') w

[SelectRecords_Furi]
select
  (case when(h99c.han_name = '1')then('')else(h09.han_name || ' ')end) || h09.koumoku1 || ' ' || h09.koumoku2 || ' ' || h09.koumoku3 as furikikan
from m_hanyo h09
left join m_hanyo h99a on (h99a.mst_kbn = '99' and h99a.han_cd = 'mtok-eig-f')
left join t_uri uh on (uh.den_no = '&3')
left join m_hanyo h76 on (h76.mst_kbn = '76' and h76.han_cd = uh.pay_kbn)
left join m_hanyo h99b on (h99b.mst_kbn = '99' and h99b.han_cd = 'tfur-r0023')
--振込先に汎用名称は結合しない
left join m_hanyo h99c on (h99c.mst_kbn = '99' and h99c.han_cd = 'sp-r0020-9')
where 1 = 1
and h09.mst_kbn = '09'
and coalesce(h09.koumoku6,'') = ''
and ((coalesce(h99a.han_name,'') != '1') or (h09.koumoku12 = uh.eig_cd))
--#18971 2023.01.23 MOD STT
--伝票指定した振込口座のみ
and ((COALESCE(h99b.han_name,'') != '1') or (h09.han_cd = h76.koumoku6))
--#18971 2023.01.23 MOD END
order by h09.sort_key, h09.han_cd

[SelectLogo]
select 
	koumoku2 as image_cd
	, koumoku3 as logo_row
	, koumoku4 as logo_col
from m_hanyo
where 1=1
and mst_kbn = '99' 
and han_cd = 'logo-r0020' 
and han_name = '1'

[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-r0023'
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

[SelectMeisaiType]
select * from fnc_query_basr0029_meisai('{
  "zei_multi_mode":"&1"
, "disc_per_mode":"&2"
, "hinnm_wide_mode":"&3"
, "tani_mode":"&4"
, "uri_tn_dec":"&5"
, "uri_su_dec":"&6"
, "hincd_hide_mode":"&7"
, "line1_mode":"&8"
}')