SELECT
NYUKIN_NO
,NYUKIN_STAT
,NYUKIN_ROUTE_CD
,SEIKY_NO
,SEIKY_KEI_NO
,NYUKIN_SYRZM_FLG
,NYUKIN_TRN_YMD
,NYUKIN_TRN_HMS
,RECEIPT_YMD
,RECEIPT_HMS
,MK_FLG
FROM
CH_T_NYUKIN
WHERE
NYUKIN_SYRZM_FLG = '0'
AND MK_FLG = '0'