GKSNET DB 쿼리
ERP ERP연동전환계정이(가) 일년 이상 전에 추가함
insert into GKSNET_CARD_buy (
CARD_INI,CARD_NO,PURCH_DATE,COLL_NO,APPR_DATE,TYPE_DVCD,APPR_NO,CONTRACT_ID,SLIP_NO,PURCH_TIME,CURR_CODE,APPR_TOT,ACQU_TOT,ACQU_EXCH,USD_ACQU_TOT,CONV_FEE,
PURCH_TOT,INST_TYPE,SETT_DATE,ABROAD,PURCH_YN,MERCH_BIZ_NO,MERCH_NO,MERCH_NAME,MASTER,MERCH_TEL,MERCH_ZIPCODE,MERCH_ADDR1,MERCH_ADDR2,MCC_NAME,MCC_CODE,PART_ACQU_CANC_YN,
NONE_APPR_YN,SERV_TYPE_YN,ORGIN_COLL_NO,DISC_AMT,CURR_ACQU_TOT,ACQU_FEE,APPR_AMT,VAT,TIPS,ORIGIN_MERCH_NAME,ORIGIN_MERCH_BIZ_NO,TAX_TYPE,MERCH_CESS_DATE,NTSDATE,SEQ,CLASS)
select CARD_INI,CARD_NO,PURCH_DATE,COLL_NO,APPR_DATE,class,APPR_NO,CONTRACT_ID,SLIP_NO,PURCH_TIME,CURR_CODE,APPR_TOT,ACQU_TOT,ACQU_EXCH,USD_ACQU_TOT,CONV_FEE,
PURCH_TOT,INST_TYPE,SETT_DATE,ABROAD,PURCH_YN,MERCH_BIZ_NO,MERCH_NO,MERCH_NAME,MASTER,MERCH_TEL,MERCH_ZIPCODE,MERCH_ADDR1,MERCH_ADDR2,MCC_NAME,MCC_CODE,PART_ACQU_CANC_YN,
NONE_APPR_YN,SERV_TYPE_YN,ORGIN_COLL_NO,DISC_AMT,CURR_ACQU_TOT,ACQU_FEE,APPR_AMT,VAT,TIPS,ORIGIN_MERCH_NAME,ORIGIN_MERCH_BIZ_NO,TAX_TYPE,MERCH_CESS_DATE,NTSDATE,SEQ,CLASS from [dzicube].[dbo].GKSNET_CARD_buy;
insert into GKSNET_CARD_APPR (CARD_INI,CARD_NO,APPR_NO,TRANS_DATE,TYPE_DVCD,CONTRACT_ID,TRANS_TIME,CARD_TYPE1,CARD_TYPE2,CURR_CODE,APPR_AMT,VAT,TIPS,APPR_TOT,APPR_EXCH,USD_ACQU_TOT,INST_TYPE,INST_MONTH,ABROAD,
SLIP_NO,TERMINAL_NO,PURCH,ACQU_ISSUER,MERCH_BIZ_NO,MERCH_NO,MERCH_NAME,MASTER,MERCH_TEL,MERCH_ZIPCODE,MERCH_ADDR1,MERCH_ADDR2,MERCH_STATUS,MCC_NAME,MCC_CODE,PART_ACQU_CANC_YN,
SERV_TYPE_YN,COLL_NO,TAX_TYPE,MERCH_CESS_DATE,ORGIN_TRANS_DATE,ORGIN_APPR_NO,ORGIN_TRANS_TIME,ORIGIN_MERCH_NAME,ORIGIN_MERCH_BIZ_NO,NTSDATE,SEQ,CLASS)
select CARD_INI,CARD_NO,APPR_NO,TRANS_DATE,class,CONTRACT_ID,TRANS_TIME,CARD_TYPE1,CARD_TYPE2,CURR_CODE,APPR_AMT,VAT,TIPS,APPR_TOT,APPR_EXCH,USD_ACQU_TOT,INST_TYPE,
INST_MONTH,ABROAD,SLIP_NO,TERMINAL_NO,PURCH,ACQU_ISSUER,MERCH_BIZ_NO,MERCH_NO,MERCH_NAME,MASTER,MERCH_TEL,MERCH_ZIPCODE,MERCH_ADDR1,MERCH_ADDR2,
MERCH_STATUS,MCC_NAME,MCC_CODE,PART_ACQU_CANC_YN,SERV_TYPE_YN,COLL_NO,TAX_TYPE,MERCH_CESS_DATE,ORGIN_TRANS_DATE,ORGIN_APPR_NO,ORGIN_TRANS_TIME,ORIGIN_MERCH_NAME,
ORIGIN_MERCH_BIZ_NO,NTSDATE,SEQ,CLASS from [dzicube].[dbo].GKSNET_CARD_APPR;
insert into GKSNET_CARD_bill (
CARD_INI,CARD_NO,SETT_DATE,BIL_TYPE,COLL_NO,ORGN_APPR_DATE,APPR_NO,TYPE_DVCD,BIL_WORK_DATE,CORP_BIZ_NO,CORP_NO,ESTB_NO,SLIP_NO,BIL_AMT,BIL_FEE,MEMBSHIP_FEE,ACQU_EXCH,
USD_ACQU_TOT,CONV_FEE,BIL_TOT,INST_TYPE,INST_MONTH,REST_INST_MONTH,MERCH_BIZ_NO,MERCH_NAME,SERV_TYPE_YN,DISC_AMT,ESTB_NAME,USER_NO,USER_NAME,ORGN_APPR_TOT,ORGIN_TRANS_TIME,
ORIGIN_MERCH_NAME,ORIGIN_MERCH_BIZ_NO,TAX_TYPE,MERCH_CESS_DATE,NTSDATE,CONTRACT_ID,SEQ,CLASS)
select CARD_INI,CARD_NO,SETT_DATE,BIL_TYPE,COLL_NO,ORGN_APPR_DATE,APPR_NO,class,BIL_WORK_DATE,CORP_BIZ_NO,CORP_NO,ESTB_NO,SLIP_NO,BIL_AMT,BIL_FEE,MEMBSHIP_FEE,ACQU_EXCH,
USD_ACQU_TOT,CONV_FEE,BIL_TOT,INST_TYPE,INST_MONTH,REST_INST_MONTH,MERCH_BIZ_NO,MERCH_NAME,SERV_TYPE_YN,DISC_AMT,ESTB_NAME,USER_NO,USER_NAME,ORGN_APPR_TOT,ORGIN_TRANS_TIME,
ORIGIN_MERCH_NAME,ORIGIN_MERCH_BIZ_NO,TAX_TYPE,MERCH_CESS_DATE,NTSDATE,CONTRACT_ID,SEQ,CLASS from [dzicube].[dbo].GKSNET_CARD_bill;