/*------------------------------------------------------------
-- 請求スキーマ 累積データ削除用のアンロード
-- 2017.07.24 【OM-2017-0000538】 CRECARD_NO_AZKRI_ID、SHIKOSAKI_COMP_CD の順番がDB定義とおりではないが影響が大きいので修正しない
--            替わりに EO61U0186J0.sh(ＢＫＵＰファイル退避)を修正する。
-- 2018.05.29 【ANK-3366-00-00】 卸先事業者コードを追加
-- 2019.10.14 【ANK-3586-00-00】
-- 2020.10.21 【ANK-3838-00-00】 
-- 2022.04.18 【ANK-3846-00-00】 
-- 2023.06.29 【ANK-4401-00-00】 
------------------------------------------------------------*/
SELECT
    CH0051.SEIKY_NO,
    CH0051.SEIKY_STAT,
    CH0051.SEIKY_KEI_NO,
    CH0051.TOKUSOKU_NO,
    CH0051.SEIKY_YM,
    CH0051.SEIKY_FIX_YMD,
    CH0051.SEIKY_SBT_CD,
    CH0051.KEI_SEIKY_WAY_CD,
    CH0051.SEIKY_WAY_CD,
    CH0051.KYOSEI_MADOGUCHI_FLG,
    CH0051.SEIKY_REQ_YMD,
    CH0051.DOFU_CD,
    CH0051.SKS_HAKKO_SEQ,
    CH0051.CUSTOMER_BARCODE,
    CH0051.INFO_PATTERN_CD,
    CH0051.DOHUBT_PATTERN_CD,
    CH0051.SOHUS_AD_CD,
    CH0051.SOHUS_PCD,
    CH0051.SOHUS_STATE_NM,
    CH0051.SOHUS_CITY_NM,
    CH0051.SOHUS_OAZTSU_NM,
    CH0051.SOHUS_AZCHO_NM,
    CH0051.SOHUS_AD_BNCHIGO,
    CH0051.SOHUS_ADRTTM,
    CH0051.SOHUS_ADRRM,
    CH0051.SOHUS_TELNO,
    CH0051.SOHUS_NM,
    CH0051.SOHUS_BKM,
    CH0051.SOHUS_TNTSHA_NM,
    CH0051.SHS_HOJIN_SBT_CD,
    CH0051.SHS_HOJIN_ZENGO_SHITEI_CD,
    CH0051.SHS_KANA,
    CH0051.SOHUS_MLAD,
    CH0051.SKHK_SVKEI_STAT_CD,
    CH0051.SKHK_SVKEI_DLRE_SKBT_CD,
    CH0051.SEIKYUS_HAKKO_YH,
    CH0051.NEXT_SEIKY_WAY_DIV,
    CH0051.RECEIPT_AMNT_OUTPUT_UM,
    CH0051.PAY_KIGEN_YMD,
    CH0051.SEIKYUS_HIKINUKI_FLG,
    CH0051.SEIKYUS_HAKKO_TG_FLG,
    CH0051.SEIKYUS_HAKKO_YMD,
    CH0051.SEIKY_AMNT_ADJ_YMD,
    CH0051.SEIKY_AMNT_CHGE_YMD,
    CH0051.SEIKY_CL_YMD,
    CH0051.BANK_CD,
    CH0051.BANK_SHITEN_CD,
    CH0051.YOKIN_SHUMOKU_CD,
    CH0051.KOZA_NO,
    CH0051.NEW_CD,
    CH0051.TSUCHO_SYMBOL,
    CH0051.TSUCHO_NO,
    CH0051.KOZA_MEIGIN_KANA,
    CH0051.KHRI_RSLT_RTN_YMD,
    CH0051.KHRI_RSLT_CD,
    CH0051.FLRLMT_CHOK_FLG,
    CH0051.CRECARD_COMP_CD,
    CH0051.CRECARD_NM_KANA,
    '' AS CRECARD_NM_ROMAJI,
    CH0051.AUTHORI_RSLT_CD,
    CH0051.MEMBSTR_NO_15,
    CH0051.CRECARD_NO,
    CH0051.CRECARD_YK_KIGEN,
    CH0051.CREDIT_KOKAN_CD,
    CH0051.DEAL_YMD,
    CH0051.SALES_AUTHORI_JSSI_DTM,
    CH0051.AUTHORI_SHONIN_NO,
    CH0051.DEAL_SKBT_NO,
    CH0051.SALES_DENPYO_NO,
    CH0051.SHANAIUSE_SKBT_FLG,
    CH0051.EAN_BARCODE,
    CH0051.EAN_MAKER_CD,
    CH0051.EAN_TRAT_LIMIT_YMD,
    CH0051.OCR_BARCODE,
    CH0051.ADD_DTM,
    CH0051.ADD_OPEACNT,
    CH0051.UPD_DTM,
    CH0051.UPD_OPEACNT,
    CH0051.DEL_DTM,
    CH0051.DEL_OPEACNT,
    CH0051.MK_FLG,
    CH0051.ADD_UNYO_YMD,
    CH0051.ADD_TRN_ID,
    CH0051.UPD_UNYO_YMD,
    CH0051.UPD_TRN_ID,
    CH0051.DEL_UNYO_YMD,
    CH0051.DEL_TRN_ID,
    CH0051.CRECARD_NO_AZKRI_ID,
    CH0051.SHIKOSAKI_COMP_CD,
    CH0051.ORSJGS_CD,
    CH0051.KAKGT_SEIKY_SKIP_FLG,
    CH0051.COMMISION_FTN_HSK_CD,
    CH0051.PKOZA_USE_KH,
    CH0051.KSSAI_ID,
    CH0051.MERCHANT_DEAL_ID,
    CH0051.PRC_CHG_FLG
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.MK_FLG = '0'