[selectRecords]
SELECT
	tm.den_no,
    tm.row_no,
    ((tm.suryo *
        CASE
            WHEN (mh.iri_su > (1)::numeric) THEN mh.iri_su
            ELSE (1)::numeric
        END))::numeric(7,0) AS nyuko_su,
    NULL::numeric(7,0) AS syuko_su,
    COALESCE(tm.tanka_jpn, tm.tanka) AS tanka,
	to_char(to_date(th.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    th.sir_cd AS tor_cd,
    th.sir_nm AS tor_nm,
    '仕入'::character varying(8) AS tor_kbn,
    tm.hin_cd,
    tm.hin_nm,
    ms.now_stock,
    '02'::character varying(2) AS tor_kbn_key
   FROM ((t_sir_m tm
     JOIN t_sir th ON ((th.den_no = tm.den_no)))
	left join m_stock ms on (ms.hin_cd = tm.hin_cd)
     LEFT JOIN m_hin mh ON (((mh.hin_cd)::text = (tm.hin_cd)::text)))
  WHERE ((th.hacyu_flg = 0) AND (th.del_flg = 0))
and tm.hin_cd = '&2'
and th.syori_ymd >= '&3'

UNION ALL
SELECT
	tm.uri_no AS den_no,
    tm.uri_row_no AS row_no,
    tm.suryo AS nyuko_su,
    NULL::numeric(7,0) AS syuko_su,
    tm.tanka,
	to_char(to_date(uh.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    uh.tok_cd AS tor_cd,
    uh.tok_nm AS tor_nm,
    '入庫'::character varying(8) AS tor_kbn,
    tm.hin_cd,
    tm.hin_nm,
    ms.now_stock,
    '03'::character varying(2) AS tor_kbn_key
   FROM (t_nyuko tm
     LEFT JOIN t_uri uh ON ((uh.den_no = tm.uri_no)))
	left join m_stock ms on (ms.hin_cd = tm.hin_cd)
  WHERE (tm.del_flg = 0)
and tm.hin_cd = '&2'
and uh.syori_ymd >= '&3'

UNION ALL
SELECT
	tm.den_no,
    tm.row_no,
    tm.suryo AS nyuko_su,
    NULL::numeric(7,0) AS syuko_su,
    NULL::numeric(10,2) AS tanka,
	to_char(to_date(th.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    NULL::character varying(5) AS tor_cd,
    ((((((COALESCE(h1.han_name))::text || ' '::text) || (tm.old_hin_cd)::text) || ' '::text) || (COALESCE(th.biko1))::text))::character varying(50) AS tor_nm,
    '入庫'::character varying(8) AS tor_kbn,
    tm.new_hin_cd AS hin_cd,
    tm.new_hin_nm AS hin_nm,
    ms.now_stock,
    '07'::character varying(2) AS tor_kbn_key
   FROM ((t_ido tm
     JOIN t_nyusyuko th ON ((th.den_no = tm.den_no)))
	left join m_stock ms on (ms.hin_cd = tm.new_hin_cd)
     LEFT JOIN m_hanyo h1 ON ((((h1.mst_kbn)::text = '25'::text) AND ((h1.han_cd)::text = (th.ns_kbn)::text))))
  WHERE (tm.del_flg = 0)
	and th.syori_ymd >= '&3'

UNION ALL
SELECT
	tm.den_no,
    tm.row_no,
    NULL::numeric(7,0) AS nyuko_su,
    tm.suryo AS syuko_su,
    tm.tanka,
	to_char(to_date(th.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    th.tok_cd AS tor_cd,
    th.tok_nm AS tor_nm,
    '売上'::character varying(8) AS tor_kbn,
    tm.hin_cd,
    tm.hin_nm,
    ms.now_stock,
    '05'::character varying(2) AS tor_kbn_key
   FROM (t_uri_m tm
     JOIN t_uri th ON ((th.den_no = tm.den_no)))
	left join m_stock ms on (ms.hin_cd = tm.hin_cd)
  WHERE ((th.jucyu_flg = 0) AND (th.del_flg = 0))
and tm.hin_cd = '&2'
and th.syori_ymd >= '&3'

UNION ALL
SELECT
	tm.uri_no AS den_no,
    tm.uri_row_no AS row_no,
    NULL::numeric(7,0) AS nyuko_su,
    tm.suryo AS syuko_su,
    tm.tanka,
	to_char(to_date(uh.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    uh.tok_cd AS tor_cd,
    uh.tok_nm AS tor_nm,
    '出庫'::character varying(8) AS tor_kbn,
    tm.hin_cd,
    tm.hin_nm,
    ms.now_stock,
    '06'::character varying(2) AS tor_kbn_key
   FROM (t_syuko tm
     LEFT JOIN t_uri uh ON ((uh.den_no = tm.uri_no)))
	left join m_stock ms on (ms.hin_cd = tm.hin_cd)
  WHERE (tm.del_flg = 0)
and tm.hin_cd = '&2'
and uh.syori_ymd >= '&3'

UNION ALL
SELECT
	tm.den_no,
    tm.row_no,
    NULL::numeric(7,0) AS nyuko_su,
    tm.suryo AS syuko_su,
    NULL::numeric(10,2) AS tanka,
	to_char(to_date(th.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
    NULL::character varying(5) AS tor_cd,
    ((((((COALESCE(h1.han_name))::text || ' '::text) || (tm.new_hin_cd)::text) || ' '::text) || (COALESCE(th.biko1))::text))::character varying(50) AS tor_nm,
    '出庫'::character varying(8) AS tor_kbn,
    tm.old_hin_cd AS hin_cd,
    tm.old_hin_nm AS hin_nm,
    ms.now_stock,
    '08'::character varying(2) AS tor_kbn_key
   FROM ((t_ido tm
     JOIN t_nyusyuko th ON ((th.den_no = tm.den_no)))
     LEFT JOIN m_hanyo h1 ON ((((h1.mst_kbn)::text = '25'::text) AND ((h1.han_cd)::text = (th.ns_kbn)::text))))
	left join m_stock ms on (ms.hin_cd = tm.new_hin_cd)
  WHERE (tm.del_flg = 0)
and th.syori_ymd >= '&3'
order by syori_ymd,den_no