JSK
,
utf-8
"
CRLF
1
114
ACCOUNT_YM,SEQ_NO,SRC_CD,RESULT_CD,JD_NHI_CD,DATA_DIV_CD,LOAD_DT,REC_SEQ_NO,LOAD_SEQ_NO,ORIG_WHLSLR_CD,ORIG_WHLSLR_SUB_CD,ORIG_WHLSLR_ORG_CD,ORIG_ENDUSR_CD,ORIG_SALES_DT,ORIG_SLIP_NO,ORIG_DEAL_DIV_CD,ORIG_BILL_YM,ORIG_UNIV_PRODUCT_CD,ORIG_SALES_QTY,ORIG_SALES_UNTPRC,ORIG_SALES_AMT,ORIG_PRE_DISC_UNTPRC,ORIG_AFTER_DISC_UNTPRC,ORIG_PRE_SALES_DT,ORIG_PRE_SLIP_NO,ORIG_PROD_NM,ORIG_ENDUSR_NM,ORIG_JAN_CD,ORIG_ARB_ITEM,ORIG_LOT_NO_1,ORIG_LOT_SALES_QTY_1,ORIG_LOT_NO_2,ORIG_LOT_SALES_QTY_2,ORIG_LOT_NO_3,ORIG_LOT_SALES_QTY_3,ORIG_JD44_FILLER1,ORIG_JD44_FILLER2,ORIG_LOT_NO,ORIG_EXPIRATION_DATE,ORIG_JAN_GTIN13,ORIG_GTIN14,ORIG_SALES_DT8,ORIG_PRE_SALES_DT8,ORIG_ACTUAL_ENDUSR_CD,ORIG_ENDUSR_COMMON_CD,ORIG_ACTUAL_ENDUSR_COMMON_CD,ORIG_ACTUAL_ENDUSR_NM,ORIG_ACTUAL_ENDUSR_ADDR_NM,ORIG_ACTUAL_ENDUSR_TEL,ORIG_DETAIL_SEQ_NO,ORIG_NODELIVERED_KBN,ORIG_BIO_ORG_KBN,ORIG_DEPO_CD,ORIG_DEPO_NM,ORIG_WHLSLR_ORG_NM,ORIG_BIKO,ORIG_MS_CD,ORIG_FILLER3,ORIG_JD45_ADDR_TXT,ORIG_JD45_FILLER1,ORIG_JD45_FILLER2,ORIG_JD45_FILLER3,ORIG_NHI_FILLER1,ORIG_NHI_PROC_DT,ORIG_NHI_ADDR1_TXT,ORIG_NHI_ADDR2_TXT,ORIG_NHI_TALLY_DIV_CD,ORIG_NHI_TALLY_QTY,ORIG_NHI_PAR_UNIV_PRODUCT_CD,ORIG_MAN_REMARK1,ORIG_MAN_REMARK2,ORIG_MAN_REMARK3,ORIG_MAN_REMARK4,ORIG_MAN_REMARK5,ORIG_MAN_REMARK6,ORIG_MAN_REMARK7,ORIG_MAN_REMARK8,ORIG_MAN_REMARK9,ORIG_MAN_REMARK10,EDIT_WHLSLR_ORG_CD,EDIT_DEAL_DIV_CD,EDIT_ENDUSR_CD,CNVS_WHLSLR_CD,CLS_WHLSLR_NM,CNVS_DEPO_CD,CLS_DEPO_NM,CNVS_SLIP_NO,CNVS_SALES_DT,CNVS_DEAL_DIV_CD,CLS_DEAL_DIV_NM,CNVS_BILL_YM,CNVS_INST_CD,CLS_INST_NM,CNVS_PROD_CD,CLS_PROD_NM,CNVS_SALES_UNTPRC,CNVS_SALES_AMT,CNVS_SALES_QTY,CLS_CHRG_FR_MDCN,CLS_INVC_PRCNG,CNVS_SIGN_CNV_SALES_QTY,CNVS_SIGN_CNV_SALES_UNTPRC,CNVS_SIGN_CNV_SALES_AMT,CNVS_LOT_NO_1,CNVS_LOT_SALES_QTY_1,CNVS_LOT_NO_2,CNVS_LOT_SALES_QTY_2,CNVS_LOT_NO_3,CNVS_LOT_SALES_QTY_3,LAST_CNVS_DT,CNVS_CD,ACCOUNT_DT,CUSTOMER_ID,LAST_UPD_DTT
account_ym,seq_no,src_cd,result_cd,jd_nhi_cd,data_div_cd,load_dt,rec_seq_no,load_seq_no,orig_whlslr_cd,orig_whlslr_sub_cd,orig_whlslr_org_cd,orig_endusr_cd,orig_sales_dt,orig_slip_no,orig_deal_div_cd,orig_bill_ym,orig_univ_product_cd,orig_sales_qty,orig_sales_untprc,orig_sales_amt,orig_pre_disc_untprc,orig_after_disc_untprc,orig_pre_sales_dt,orig_pre_slip_no,orig_prod_nm,orig_endusr_nm,orig_jan_cd,orig_arb_item,orig_lot_no_1,orig_lot_sales_qty_1,orig_lot_no_2,orig_lot_sales_qty_2,orig_lot_no_3,orig_lot_sales_qty_3,orig_jd44_filler1,orig_jd44_filler2,orig_lot_no,orig_expiration_date,orig_jan_gtin13,orig_gtin14,orig_sales_dt8,orig_pre_sales_dt8,orig_actual_endusr_cd,orig_endusr_common_cd,orig_actual_endusr_common_cd,orig_actual_endusr_nm,orig_actual_endusr_addr_nm,orig_actual_endusr_tel,orig_detail_seq_no,orig_nodelivered_kbn,orig_bio_org_kbn,orig_depo_cd,orig_depo_nm,orig_whlslr_org_nm,orig_biko,orig_ms_cd,orig_filler3,orig_jd45_addr_txt,orig_jd45_filler1,orig_jd45_filler2,orig_jd45_filler3,orig_nhi_filler1,orig_nhi_proc_dt,orig_nhi_addr1_txt,orig_nhi_addr2_txt,orig_nhi_tally_div_cd,orig_nhi_tally_qty,orig_nhi_par_univ_product_cd,orig_man_remark1,orig_man_remark2,orig_man_remark3,orig_man_remark4,orig_man_remark5,orig_man_remark6,orig_man_remark7,orig_man_remark8,orig_man_remark9,orig_man_remark10,edit_whlslr_org_cd,edit_deal_div_cd,edit_endusr_cd,cnvs_whlslr_cd,cls_whlslr_nm,cnvs_depo_cd,cls_depo_nm,cnvs_slip_no,cnvs_sales_dt,cnvs_deal_div_cd,cls_deal_div_nm,cnvs_bill_ym,cnvs_inst_cd,cls_inst_nm,cnvs_prod_cd,cls_prod_nm,cnvs_sales_untprc,cnvs_sales_amt,cnvs_sales_qty,cls_chrg_fr_mdcn,cls_invc_prcng,cnvs_sign_cnv_sales_qty,cnvs_sign_cnv_sales_untprc,cnvs_sign_cnv_sales_amt,cnvs_lot_no_1,cnvs_lot_sales_qty_1,cnvs_lot_no_2,cnvs_lot_sales_qty_2,cnvs_lot_no_3,cnvs_lot_sales_qty_3,last_cnvs_dt,cnvs_cd,account_dt,customer_id,last_upd_dtt
src07.hst_result_data
org07.hst_result_data
HST_RESULT_DATA_ex.sql

truncate_src_table:src07.hst_result_data
1
1
zip