[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"
}')

[selectRecords]
select
  w.*
from fnc_query_nohinsyo(&23, '{}') w

[SelectRecords_Furi]
select
	h09.han_name || ' ' || 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')
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"}')