style24.doc/산출물/4.구축/데이터처리/정산(공급업체_공급벤더로변경).sql

UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_05', ACCOUNT_NO = '28891000726905', DEPOSITOR_NM = '주식회사엠씨마르니', BILL_EMAIL = 'miinnam@daum.net' WHERE SUPPLY_COMP_CD = '1003';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '31105084301026', DEPOSITOR_NM = '주식회사아담스패밀리', BILL_EMAIL = 'adams8@daum.net' WHERE SUPPLY_COMP_CD = '1012';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '140008727822', DEPOSITOR_NM = '(주)제이브로스', BILL_EMAIL = 'jbrostax@naver.com' WHERE SUPPLY_COMP_CD = '1075';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '36563704002017', DEPOSITOR_NM = '(주)엠도씨', BILL_EMAIL = 'lhwak74@mdoc.co.kr' WHERE SUPPLY_COMP_CD = '1097';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '620193174771', DEPOSITOR_NM = '여운천(HU컴퍼니)', BILL_EMAIL = 'huiz9@naver.com' WHERE SUPPLY_COMP_CD = '1102';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '37802184558', DEPOSITOR_NM = '윤길봉(엠엠씨)', BILL_EMAIL = 'help@girlplus.co.kr' WHERE SUPPLY_COMP_CD = '117';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '00570104000790', DEPOSITOR_NM = '김종삼', BILL_EMAIL = 'sam28790@naver.com' WHERE SUPPLY_COMP_CD = '1248';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1002241776129', DEPOSITOR_NM = '조아무역 이수영', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '1321';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100022018696', DEPOSITOR_NM = '설성화(월드토이)', BILL_EMAIL = 'ha2029@naver.com' WHERE SUPPLY_COMP_CD = '1357';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3550006250923', DEPOSITOR_NM = '(주)피앤에프컴퍼니', BILL_EMAIL = 'pippin19@naver.com' WHERE SUPPLY_COMP_CD = '1389';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140012602314', DEPOSITOR_NM = '(주)와이아이씨컴퍼니 유남민', BILL_EMAIL = 'tax@eround.co.kr' WHERE SUPPLY_COMP_CD = '1405';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '11712044304011', DEPOSITOR_NM = '(주)포드커머스', BILL_EMAIL = 'sadtear1@naver.com' WHERE SUPPLY_COMP_CD = '1410';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110216923957', DEPOSITOR_NM = '안근태(두인코퍼레이', BILL_EMAIL = 'dooinstyle@naver.com' WHERE SUPPLY_COMP_CD = '1436';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '53401125804015', DEPOSITOR_NM = '연승용', BILL_EMAIL = 'equusyeon@nate.com' WHERE SUPPLY_COMP_CD = '1445';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '06206104101014', DEPOSITOR_NM = '(주)시장닷컴', BILL_EMAIL = 'cyzangbalju@hanmail.net' WHERE SUPPLY_COMP_CD = '154';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1002633445100', DEPOSITOR_NM = '성연숙(굿앤모아)', BILL_EMAIL = 'goodnmore@naver.com' WHERE SUPPLY_COMP_CD = '1583';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100026907690', DEPOSITOR_NM = '(주)알유진코리아', BILL_EMAIL = 'rujeansk@naver.com' WHERE SUPPLY_COMP_CD = '1722';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '27273704002135', DEPOSITOR_NM = '주식회사알프렌즈', BILL_EMAIL = 'popopor2@alfriends.co.kr' WHERE SUPPLY_COMP_CD = '1746';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_23', ACCOUNT_NO = '58920125772', DEPOSITOR_NM = '박상길MJ글로벌', BILL_EMAIL = 'parksk72@korea.com' WHERE SUPPLY_COMP_CD = '1779';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1002636254247', DEPOSITOR_NM = '문상의', BILL_EMAIL = 'rena07@nate.com' WHERE SUPPLY_COMP_CD = '1811';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '11308102301018', DEPOSITOR_NM = '황인준', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '182';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '61300023604010', DEPOSITOR_NM = '김정식', BILL_EMAIL = 'xsunmi@naver.com' WHERE SUPPLY_COMP_CD = '1949';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005701847938', DEPOSITOR_NM = '(주)자야', BILL_EMAIL = 'kshine777@naver.com' WHERE SUPPLY_COMP_CD = '1960';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '15091001594904', DEPOSITOR_NM = '(주)SG세계물산', BILL_EMAIL = 'yjkim@sgsegye.com' WHERE SUPPLY_COMP_CD = '1972';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '53592501109397', DEPOSITOR_NM = '최창원(서진)', BILL_EMAIL = 'sotde@hanmail.net' WHERE SUPPLY_COMP_CD = '2009';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '96270201160157', DEPOSITOR_NM = '김동욱', BILL_EMAIL = 'cutejp@nate.com' WHERE SUPPLY_COMP_CD = '2058';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '91036393075', DEPOSITOR_NM = '하재홍(에스앤디)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2130';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '49200556601011', DEPOSITOR_NM = '(주)성진물산', BILL_EMAIL = 'rose4383@nate.com' WHERE SUPPLY_COMP_CD = '2138';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '100022777121', DEPOSITOR_NM = '(주)솔트라이트아이엔씨', BILL_EMAIL = 'mjyu@cnbi.co.kr' WHERE SUPPLY_COMP_CD = '2173';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '58090101017681', DEPOSITOR_NM = '김인안', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2175';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '23205641601011', DEPOSITOR_NM = '(주)트랜드이십일', BILL_EMAIL = '444ask@naver.com' WHERE SUPPLY_COMP_CD = '218';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '05810104251877', DEPOSITOR_NM = '나정민', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2190';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3510408069403', DEPOSITOR_NM = '신제영 (태성ACC', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2191';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100014523270', DEPOSITOR_NM = '(주)칠성무역', BILL_EMAIL = '7startrade@hanmail.net' WHERE SUPPLY_COMP_CD = '2203';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '35620104133615', DEPOSITOR_NM = '최진환(러브앤시티)', BILL_EMAIL = 'angel889@naver.com' WHERE SUPPLY_COMP_CD = '2216';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '38791007334107', DEPOSITOR_NM = '윤수경 브랜드존', BILL_EMAIL = 'ekadid21@hanmail.net' WHERE SUPPLY_COMP_CD = '2240';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005501977250', DEPOSITOR_NM = 'HWANG SUJUNG', BILL_EMAIL = 'psyche312@nate.com' WHERE SUPPLY_COMP_CD = '2241';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '00570104148218', DEPOSITOR_NM = '김윤희(아카비스)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2336';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_02', ACCOUNT_NO = '2249010736861', DEPOSITOR_NM = '한세드림', BILL_EMAIL = 'eunjinkim@hansaedreams.co.kr' WHERE SUPPLY_COMP_CD = '2385';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '59060201197794', DEPOSITOR_NM = '송남수', BILL_EMAIL = 'beat208@gsgm.co.kr' WHERE SUPPLY_COMP_CD = '2394';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '53260104078659', DEPOSITOR_NM = '정현우(지온트레이딩', BILL_EMAIL = 'xeeongolf@nate.com' WHERE SUPPLY_COMP_CD = '2430';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '58601671001038', DEPOSITOR_NM = '(주)웹이즈', BILL_EMAIL = 'webisaccount@webis.com' WHERE SUPPLY_COMP_CD = '2436';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005402091373', DEPOSITOR_NM = '심재협(이제이컴퍼', BILL_EMAIL = 'ejcompany@hanmail.net' WHERE SUPPLY_COMP_CD = '2446';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '67800359301027', DEPOSITOR_NM = '(주)필코스', BILL_EMAIL = 'feelcos@korea.com' WHERE SUPPLY_COMP_CD = '2452';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '9303544404010', DEPOSITOR_NM = '㈜그린조이', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2455';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '2472';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '32290104078094', DEPOSITOR_NM = '또래친구주식회사', BILL_EMAIL = 'ttolaefriend@naver.com' WHERE SUPPLY_COMP_CD = '2489';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '28091018747707', DEPOSITOR_NM = '신사야황준', BILL_EMAIL = 'ericajuny@naver.com' WHERE SUPPLY_COMP_CD = '2505';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '01103929304014', DEPOSITOR_NM = '(주)미래보고', BILL_EMAIL = '7startrade@hanmail.net' WHERE SUPPLY_COMP_CD = '2597';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '2627';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '2628';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_23', ACCOUNT_NO = '18120531836', DEPOSITOR_NM = '조진관', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2636';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_03', ACCOUNT_NO = '51001232204015', DEPOSITOR_NM = '(주)제이케이컴퍼', BILL_EMAIL = 'jk3030@hanmail.net' WHERE SUPPLY_COMP_CD = '2663';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '16450204119073', DEPOSITOR_NM = '김현철', BILL_EMAIL = 'banana3539@naver.com' WHERE SUPPLY_COMP_CD = '2672';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_27', ACCOUNT_NO = '1500416226701', DEPOSITOR_NM = '이형민', BILL_EMAIL = 'jh_inter@naver.com' WHERE SUPPLY_COMP_CD = '2673';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '28205190801019', DEPOSITOR_NM = '고석룡', BILL_EMAIL = 'kosukyong@hanmail.net' WHERE SUPPLY_COMP_CD = '2706';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '65401068601015', DEPOSITOR_NM = '(주)남선아이엠', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2714';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3020289832891', DEPOSITOR_NM = '한경남', BILL_EMAIL = 'hkn124@nate.com' WHERE SUPPLY_COMP_CD = '2744';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '16613704002061', DEPOSITOR_NM = '주)맘스보드', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2748';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '44790104036887', DEPOSITOR_NM = '오은영(내이름은소녀', BILL_EMAIL = 'alex@ogram.co.kr' WHERE SUPPLY_COMP_CD = '2759';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '27905640701019', DEPOSITOR_NM = '정상재 빔', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2774';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_03', ACCOUNT_NO = '23008275201013', DEPOSITOR_NM = '황광원', BILL_EMAIL = 'coolsun119@hanmail.net' WHERE SUPPLY_COMP_CD = '2781';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '44150101343407', DEPOSITOR_NM = '류재희', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2783';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005802296248', DEPOSITOR_NM = '주식회사넥시스코어', BILL_EMAIL = 'yang1072@daum.net' WHERE SUPPLY_COMP_CD = '2798';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '02209000401011', DEPOSITOR_NM = '주식회사 뉴키즈온', BILL_EMAIL = 'jh9206@hanmail.net' WHERE SUPPLY_COMP_CD = '2826';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '06590104110600', DEPOSITOR_NM = '(주)패션포유', BILL_EMAIL = 'fashion4you@hanmail.net' WHERE SUPPLY_COMP_CD = '2839';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '42080101142878', DEPOSITOR_NM = '성미정(러브하우스)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2843';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '05907594504012', DEPOSITOR_NM = '주식회사 에이블에이', BILL_EMAIL = 'zizibeeh@nate.com' WHERE SUPPLY_COMP_CD = '2875';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '91350101177835', DEPOSITOR_NM = '주식회사 해피원', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '2886';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '92900101277480', DEPOSITOR_NM = '(주)월비통상', BILL_EMAIL = 'admin@evisujeans.co.kr' WHERE SUPPLY_COMP_CD = '2977';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '69300100002511', DEPOSITOR_NM = '(주)보스크리에이티', BILL_EMAIL = 'bosswide@gmail.com' WHERE SUPPLY_COMP_CD = '2984';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '100029445156', DEPOSITOR_NM = '(주)에스엠어페럴', BILL_EMAIL = 'sck1113@naver.com' WHERE SUPPLY_COMP_CD = '2993';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_02', ACCOUNT_NO = '2249010736861', DEPOSITOR_NM = '한세드림', BILL_EMAIL = 'eunjinkim@hansaedreams.co.kr' WHERE SUPPLY_COMP_CD = '3';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_20', ACCOUNT_NO = '1002940097139', DEPOSITOR_NM = '지큐(박영순)', BILL_EMAIL = 'ljklove0322@nate.com' WHERE SUPPLY_COMP_CD = '3022';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110195805687', DEPOSITOR_NM = '양선모(바나나팜스)', BILL_EMAIL = 'younguppro@naver.com' WHERE SUPPLY_COMP_CD = '3023';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '23891000637605', DEPOSITOR_NM = '(주)계림에치앤에스', BILL_EMAIL = 'gaelimhs@naver.com' WHERE SUPPLY_COMP_CD = '3041';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '140009027965', DEPOSITOR_NM = '(주)뷰텍', BILL_EMAIL = 'oh@beautech.co.kr' WHERE SUPPLY_COMP_CD = '3088';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '140009027965', DEPOSITOR_NM = '(주)뷰텍', BILL_EMAIL = 'oh@beautech.co.kr' WHERE SUPPLY_COMP_CD = '3089';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '10507824501017', DEPOSITOR_NM = '(주)페이퍼플레인키', BILL_EMAIL = 'yoochan3@naver.com' WHERE SUPPLY_COMP_CD = '3099';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_31', ACCOUNT_NO = '508101682217', DEPOSITOR_NM = '간지나라(남영순)', BILL_EMAIL = 'young3336@hanmail.net' WHERE SUPPLY_COMP_CD = '3101';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '1811636704011', DEPOSITOR_NM = '고운머리주식회사', BILL_EMAIL = 'mic33@hanmail.net' WHERE SUPPLY_COMP_CD = '3106';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100021561930', DEPOSITOR_NM = '(주)원페이스 김용희', BILL_EMAIL = 'lohas001@naver.com' WHERE SUPPLY_COMP_CD = '313';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '910334904016', DEPOSITOR_NM = '(주)익스트리모', BILL_EMAIL = 'extremo.inc@gmail.com' WHERE SUPPLY_COMP_CD = '3132';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '28350104342272', DEPOSITOR_NM = '김진웅(양지가구)', BILL_EMAIL = 'k12j27@naver.com' WHERE SUPPLY_COMP_CD = '3143';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '8805520404014', DEPOSITOR_NM = '빅터상사권명현', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3150';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '64060104017191', DEPOSITOR_NM = '(주)유아이티통상', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3177';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005102240715', DEPOSITOR_NM = '주식회사에포드', BILL_EMAIL = 'ephod2012@nate.com' WHERE SUPPLY_COMP_CD = '3208';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110198027063', DEPOSITOR_NM = '이동석(드레스날다)', BILL_EMAIL = 'dressnalda@naver.com' WHERE SUPPLY_COMP_CD = '3236';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '68080201172027', DEPOSITOR_NM = '신경진', BILL_EMAIL = 'vinusman@hanmail.net' WHERE SUPPLY_COMP_CD = '3243';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '08212198896', DEPOSITOR_NM = '정용호', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3263';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '07816775004017', DEPOSITOR_NM = '주)두코아이앤티', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3272';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '22308310201018', DEPOSITOR_NM = '(주)해리슨', BILL_EMAIL = 'hoon2588@nate.com' WHERE SUPPLY_COMP_CD = '3273';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '54003543304015', DEPOSITOR_NM = '(주)탑보이', BILL_EMAIL = 'topboy7@naver.com' WHERE SUPPLY_COMP_CD = '3280';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005481797079', DEPOSITOR_NM = '채성석(비오유(B', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3294';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '32290104075291', DEPOSITOR_NM = '이흥규(흥규컴퍼니)', BILL_EMAIL = 'lsw2179@nate.com' WHERE SUPPLY_COMP_CD = '3296';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '1566851300', DEPOSITOR_NM = '(주)조이컴퍼니', BILL_EMAIL = 'jieun.kang@joycompany.co.kr' WHERE SUPPLY_COMP_CD = '3309';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '95880101275307', DEPOSITOR_NM = '정현미(수건넷)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3323';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '630008873490', DEPOSITOR_NM = '주식회사은총에벤에셀', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3328';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '42209084704016', DEPOSITOR_NM = '메이저월드 ㈜', BILL_EMAIL = 'majorworld@hometax.go.kr' WHERE SUPPLY_COMP_CD = '3332';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100030275397', DEPOSITOR_NM = '고은주(티티진)', BILL_EMAIL = 'ttjcokr@naver.com' WHERE SUPPLY_COMP_CD = '3355';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140010103992', DEPOSITOR_NM = '(주) 레더랩', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3359';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '14102534704029', DEPOSITOR_NM = '유인태', BILL_EMAIL = 'youil-art@hanmail.net' WHERE SUPPLY_COMP_CD = '3365';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '65070101296082', DEPOSITOR_NM = '(주)웰라이프', BILL_EMAIL = 'wellifebw@daum.net' WHERE SUPPLY_COMP_CD = '3379';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '94200698904010', DEPOSITOR_NM = '(주)에이치알엘', BILL_EMAIL = 'goldsun@happyhr.co.kr' WHERE SUPPLY_COMP_CD = '3380';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '07043354182', DEPOSITOR_NM = '(주)쿠친', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3386';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '00810888701016', DEPOSITOR_NM = '김병철(디앤에프)', BILL_EMAIL = 'zulupang@hanmail.net' WHERE SUPPLY_COMP_CD = '3396';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '64201747404013', DEPOSITOR_NM = '바바앤클릭 주식회사', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3397';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005602433361', DEPOSITOR_NM = '(주)영민네트웍스', BILL_EMAIL = 'mh_kim@ymnetworks.com' WHERE SUPPLY_COMP_CD = '3403';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140010583930', DEPOSITOR_NM = '(주)지오', BILL_EMAIL = 'ziorltk@nate.com' WHERE SUPPLY_COMP_CD = '3414';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '12891009047807', DEPOSITOR_NM = '김남현', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3421';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_03', ACCOUNT_NO = '02907536301014', DEPOSITOR_NM = '(주)비케이커머스', BILL_EMAIL = 'bkcommerce@naver.com' WHERE SUPPLY_COMP_CD = '3437';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '33130104122089', DEPOSITOR_NM = '박지훈(에스겔코스메틱)', BILL_EMAIL = 'brendan@ezekielcos.co.kr' WHERE SUPPLY_COMP_CD = '3457';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140012602314', DEPOSITOR_NM = '(주)와이아이씨컴퍼니 유남민', BILL_EMAIL = 'tax@eround.co.kr' WHERE SUPPLY_COMP_CD = '3471';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '65780101558363', DEPOSITOR_NM = '김영민', BILL_EMAIL = 'play_mall@naver.com' WHERE SUPPLY_COMP_CD = '3500';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '32901136078', DEPOSITOR_NM = '패션지오(주)', BILL_EMAIL = 'simplexi@hanmail.net' WHERE SUPPLY_COMP_CD = '352';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '79660104050389', DEPOSITOR_NM = '주식회사 쿤타', BILL_EMAIL = 'tax@qunta.co.kr' WHERE SUPPLY_COMP_CD = '3530';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005001795110', DEPOSITOR_NM = '네츄럴 컴퍼니', BILL_EMAIL = 'shsh5088@naver.com' WHERE SUPPLY_COMP_CD = '3537';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '39502132401029', DEPOSITOR_NM = '한신프로젝트(주)', BILL_EMAIL = 'master@mastersgolf.co.kr' WHERE SUPPLY_COMP_CD = '3569';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005402351440', DEPOSITOR_NM = '(주)이루자', BILL_EMAIL = 'mjeong@iruza.com' WHERE SUPPLY_COMP_CD = '3574';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '77191000527604', DEPOSITOR_NM = '(주)아이엔에프아이', BILL_EMAIL = 'okixee@toossa.com' WHERE SUPPLY_COMP_CD = '358';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '02907480201018', DEPOSITOR_NM = '주식회사컨트롤케이앤', BILL_EMAIL = 'lookie02@hanmail.net' WHERE SUPPLY_COMP_CD = '3591';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '43890101317510', DEPOSITOR_NM = '박두진(미디어VES', BILL_EMAIL = 'seaone7@nate.com' WHERE SUPPLY_COMP_CD = '3603';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '81650101193017', DEPOSITOR_NM = '김재홍(365BUY', BILL_EMAIL = 'icong0703@lycos.co.kr' WHERE SUPPLY_COMP_CD = '3609';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '10850175802101', DEPOSITOR_NM = '원상미', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3622';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '77191000527604', DEPOSITOR_NM = '(주)아이엔에프아이', BILL_EMAIL = 'okixee@toossa.com' WHERE SUPPLY_COMP_CD = '3629';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '863250001394', DEPOSITOR_NM = '(주)중산물산', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3643';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3010117890051', DEPOSITOR_NM = '주식회사아들과딸', BILL_EMAIL = 'bookfam@nate.com' WHERE SUPPLY_COMP_CD = '3653';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005202350105', DEPOSITOR_NM = '박재영(JS)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3654';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '03290104243984', DEPOSITOR_NM = '(주)스텝코퍼레이션', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3667';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '40500283604021', DEPOSITOR_NM = '(주)미래바이텍', BILL_EMAIL = 'admin-sss@mediness.com' WHERE SUPPLY_COMP_CD = '3714';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_45', ACCOUNT_NO = '9002172350032', DEPOSITOR_NM = '신은숙', BILL_EMAIL = 'zoomm2001@naver.com' WHERE SUPPLY_COMP_CD = '3726';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1002734519791', DEPOSITOR_NM = '투교샵', BILL_EMAIL = 'twokyoshop@gmail.com' WHERE SUPPLY_COMP_CD = '3731';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '1005302753283', DEPOSITOR_NM = '(주)파베르코리아 김명주', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3739';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '110291003475804', DEPOSITOR_NM = '(주)아름연화장품', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3765';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005301735139', DEPOSITOR_NM = '김민재(민영상사)', BILL_EMAIL = 'mail@mkoutdoor.co.kr' WHERE SUPPLY_COMP_CD = '3769';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '77191000527604', DEPOSITOR_NM = '(주)아이엔에프아이', BILL_EMAIL = 'okixee@toossa.com' WHERE SUPPLY_COMP_CD = '3796';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '42400101312840', DEPOSITOR_NM = '(주)야벳', BILL_EMAIL = 'yyabet@naver.com' WHERE SUPPLY_COMP_CD = '3823';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005001129442', DEPOSITOR_NM = '(주)유앤아이위드', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '387';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '4.66046E+13', DEPOSITOR_NM = '권유경', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3873';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005002560467', DEPOSITOR_NM = '어경현', BILL_EMAIL = 'eodaeng8980@naver.com' WHERE SUPPLY_COMP_CD = '3892';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '1088957411', DEPOSITOR_NM = '(주)대양', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3904';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005304113255', DEPOSITOR_NM = '김은중', BILL_EMAIL = 'kaiser33@nate.com' WHERE SUPPLY_COMP_CD = '3906';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '307010569841', DEPOSITOR_NM = '김성호', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '3910';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '9343704009540', DEPOSITOR_NM = '(주)스타일에스', BILL_EMAIL = 'cheawoo@nate.com' WHERE SUPPLY_COMP_CD = '3961';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_03', ACCOUNT_NO = '64201357704021', DEPOSITOR_NM = '(주)대성아이엔지', BILL_EMAIL = 'duriasd@daum.net' WHERE SUPPLY_COMP_CD = '3988';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_20', ACCOUNT_NO = '1005001549919', DEPOSITOR_NM = '(주)에프알제이', BILL_EMAIL = 'united1@bill36524.com' WHERE SUPPLY_COMP_CD = '4';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '01037697976', DEPOSITOR_NM = '이지훈 레디코', BILL_EMAIL = 'bloster@naver.com' WHERE SUPPLY_COMP_CD = '4002';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '22170104435141', DEPOSITOR_NM = '화진유통_이석진', BILL_EMAIL = 'lsj0926@hotmail.com' WHERE SUPPLY_COMP_CD = '4017';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005102048854', DEPOSITOR_NM = '(주)디플러스케이', BILL_EMAIL = 'koollookshop@naver.com' WHERE SUPPLY_COMP_CD = '4018';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '01065436420', DEPOSITOR_NM = '(주)빌리버스', BILL_EMAIL = 'tibero@nate.com' WHERE SUPPLY_COMP_CD = '4019';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '34091002467704', DEPOSITOR_NM = '주식회사 디엠그룹', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4047';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_20', ACCOUNT_NO = '23310921612001', DEPOSITOR_NM = '구본진', BILL_EMAIL = 'babymax@iotshop.com' WHERE SUPPLY_COMP_CD = '4104';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '64550101568949', DEPOSITOR_NM = '(주)베스톰코리아', BILL_EMAIL = 'cfclub777@naver.com' WHERE SUPPLY_COMP_CD = '4105';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140009935986', DEPOSITOR_NM = '(주)새김어페럴(박병관)', BILL_EMAIL = 'saegim03@hanmail.net' WHERE SUPPLY_COMP_CD = '4108';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005202805081', DEPOSITOR_NM = '(주)로빈인터내셔널', BILL_EMAIL = 'lplp7677@naver.com' WHERE SUPPLY_COMP_CD = '4118';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4127';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4137';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4138';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4139';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4140';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4141';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4142';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4143';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4144';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4145';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4146';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4147';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4148';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4149';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4150';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4151';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4152';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_23', ACCOUNT_NO = '28020163687', DEPOSITOR_NM = '주식회사태평누리', BILL_EMAIL = 'tp_jhlee@naver.com' WHERE SUPPLY_COMP_CD = '4156';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4158';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100031646624', DEPOSITOR_NM = '(주)올진컴퍼니', BILL_EMAIL = 'bbong8103@nate.com' WHERE SUPPLY_COMP_CD = '4169';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100013032292', DEPOSITOR_NM = '한세엠케이㈜', BILL_EMAIL = 'syjeong@hansaemk.com' WHERE SUPPLY_COMP_CD = '4337';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '32391003948505', DEPOSITOR_NM = '(주)아이앤비', BILL_EMAIL = 'tashya@nate.com' WHERE SUPPLY_COMP_CD = '4339';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100031684984', DEPOSITOR_NM = '(주)하루이너웨어 김현주', BILL_EMAIL = 'ssagazi668@nate.com' WHERE SUPPLY_COMP_CD = '4341';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '16004601900108', DEPOSITOR_NM = '정장헌', BILL_EMAIL = 'rbk2001@naver.com' WHERE SUPPLY_COMP_CD = '4364';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005402685609', DEPOSITOR_NM = '주식회사 씨스리글로벌', BILL_EMAIL = 'C3GLOBAL0101@hanmail.net' WHERE SUPPLY_COMP_CD = '4368';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005402351440', DEPOSITOR_NM = '(주)이루자', BILL_EMAIL = 'mjeong@iruza.com' WHERE SUPPLY_COMP_CD = '4370';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3024989147271', DEPOSITOR_NM = '김상철(스페루스)', BILL_EMAIL = 'aha382@nate.com' WHERE SUPPLY_COMP_CD = '4372';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '45093701006132', DEPOSITOR_NM = '토마토팩토리', BILL_EMAIL = 'kiho0815@naver.com' WHERE SUPPLY_COMP_CD = '4377';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_05', ACCOUNT_NO = '11791001379204', DEPOSITOR_NM = '(주)송월영등포대리점', BILL_EMAIL = 'mull81@naver.com' WHERE SUPPLY_COMP_CD = '4393';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '32611540101011', DEPOSITOR_NM = '주식회사 인터페이스', BILL_EMAIL = 'yori3393@naver.com' WHERE SUPPLY_COMP_CD = '4394';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '84593700000153', DEPOSITOR_NM = '(주)아따맘', BILL_EMAIL = 'addamam2080@naver.com' WHERE SUPPLY_COMP_CD = '4399';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '27991048183507', DEPOSITOR_NM = '정선두(유행의미아 아이폰픽스존)', BILL_EMAIL = 'i12ub4@nate.com' WHERE SUPPLY_COMP_CD = '4430';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '27853704004137', DEPOSITOR_NM = '주식회사 애슬레저', BILL_EMAIL = 'athleisure@naver.com' WHERE SUPPLY_COMP_CD = '4450';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_21', ACCOUNT_NO = '140009815530', DEPOSITOR_NM = '김은진', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4477';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3120147862211', DEPOSITOR_NM = '김현욱', BILL_EMAIL = 'minipocket7@naver.com' WHERE SUPPLY_COMP_CD = '4484';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '52305095301018', DEPOSITOR_NM = '(주)제이앤제이컴퍼니', BILL_EMAIL = 'subin1206@gmail.com' WHERE SUPPLY_COMP_CD = '4485';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100029867474', DEPOSITOR_NM = '(주)이너스코어', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4487';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4494';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3010194352891', DEPOSITOR_NM = '제이케이어패럴 주식회사', BILL_EMAIL = 'jkid000@naver.com' WHERE SUPPLY_COMP_CD = '4496';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '15010117401019', DEPOSITOR_NM = '주식회사 상보아이엔티', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4497';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110226622627', DEPOSITOR_NM = '한만준', BILL_EMAIL = 'adorar@adorar.co.kr' WHERE SUPPLY_COMP_CD = '4498';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '76380100092688', DEPOSITOR_NM = '주식회사 규(GYU)', BILL_EMAIL = 'gyu201608251@gmail.com' WHERE SUPPLY_COMP_CD = '4505';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3510815739443', DEPOSITOR_NM = '박병남', BILL_EMAIL = 'dail50@naver.com' WHERE SUPPLY_COMP_CD = '4512';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '31191000469004', DEPOSITOR_NM = '정해상(제이에스인터네셔널)', BILL_EMAIL = 'haesangj@gmail.com' WHERE SUPPLY_COMP_CD = '4519';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_05', ACCOUNT_NO = '34491001560004', DEPOSITOR_NM = '손윤미', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4522';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4525';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_04', ACCOUNT_NO = '06170204064164', DEPOSITOR_NM = '최승영', BILL_EMAIL = 'trendcody@naver.com' WHERE SUPPLY_COMP_CD = '453';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4536';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '2930204344176', DEPOSITOR_NM = '장경희', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4547';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110481455946', DEPOSITOR_NM = '박은희(엘오엘)', BILL_EMAIL = 'lol@inabyss.com' WHERE SUPPLY_COMP_CD = '4572';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3521289833733', DEPOSITOR_NM = '정은주', BILL_EMAIL = 'kla0923@naver.com' WHERE SUPPLY_COMP_CD = '4580';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005503347528', DEPOSITOR_NM = '더비오유컴퍼니(주)', BILL_EMAIL = 'retail.thebou@gmail.com' WHERE SUPPLY_COMP_CD = '4581';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '52305334401011', DEPOSITOR_NM = '주식회사허그코리아', BILL_EMAIL = 'joongyong00@nate.com' WHERE SUPPLY_COMP_CD = '4585';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '140012028264', DEPOSITOR_NM = '(주)엠엠마일즈', BILL_EMAIL = 'mmmiles@milkmile.co.kr' WHERE SUPPLY_COMP_CD = '4600';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '14708171304018', DEPOSITOR_NM = '(주)지오클라비스', BILL_EMAIL = 'arsal77@hanmail.net' WHERE SUPPLY_COMP_CD = '4604';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005802409239', DEPOSITOR_NM = '김상수 나무와 사람들', BILL_EMAIL = 'isss0521@nate.com' WHERE SUPPLY_COMP_CD = '4611';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '31009662301011', DEPOSITOR_NM = '이성재(정글컴퍼니)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4612';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '37373704011032', DEPOSITOR_NM = '(주)라벨영세일즈', BILL_EMAIL = 'cst@lbysales.com' WHERE SUPPLY_COMP_CD = '4625';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4626';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '34943704023478', DEPOSITOR_NM = '주식회사 셀러허브', BILL_EMAIL = 'kjh@pravs.co.kr' WHERE SUPPLY_COMP_CD = '4629';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '81024794402001', DEPOSITOR_NM = '정광수(이루자)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '464';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '31480104211935', DEPOSITOR_NM = '장윤오(제이엠패션)', BILL_EMAIL = 'tin6013@gmail.com' WHERE SUPPLY_COMP_CD = '4642';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '47610101391695', DEPOSITOR_NM = '박재형(JH컴퍼니)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4646';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '2908185301010', DEPOSITOR_NM = '이승복(스튜머스)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4647';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_05', ACCOUNT_NO = '55991002600104', DEPOSITOR_NM = '주식회사투박스', BILL_EMAIL = 'amy@toobox.co.kr' WHERE SUPPLY_COMP_CD = '4648';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '1600011404062', DEPOSITOR_NM = '블레스컴퍼니(주)', BILL_EMAIL = 'bless@blesscompany.co.kr' WHERE SUPPLY_COMP_CD = '4699';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '13008826204012', DEPOSITOR_NM = '웰파코리아㈜', BILL_EMAIL = 'gmlalfla007@naver.com' WHERE SUPPLY_COMP_CD = '4702';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '66970104055136', DEPOSITOR_NM = '김현아(바올)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4703';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100033300279', DEPOSITOR_NM = '㈜파르마인터내셔널', BILL_EMAIL = 'mikpek@naver.com' WHERE SUPPLY_COMP_CD = '4739';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '60730101357488', DEPOSITOR_NM = '황채명(아쿠아밸유)', BILL_EMAIL = 'aquavalue_37@naver.com' WHERE SUPPLY_COMP_CD = '4742';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '21612650804018', DEPOSITOR_NM = '이호정', BILL_EMAIL = 'merrybaum@naver.com' WHERE SUPPLY_COMP_CD = '4744';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '21611439404028', DEPOSITOR_NM = '(주)온더리버', BILL_EMAIL = 'on_the_river@naver.com' WHERE SUPPLY_COMP_CD = '4745';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '19460104207341', DEPOSITOR_NM = '김희정(아바드)', BILL_EMAIL = 'jhl@avade.co.kr' WHERE SUPPLY_COMP_CD = '4748';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '66603133201015', DEPOSITOR_NM = '주식회사 피엠제이인터네셔널', BILL_EMAIL = 'pmj9977@naver.com' WHERE SUPPLY_COMP_CD = '4757';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_03', ACCOUNT_NO = '57902980101011', DEPOSITOR_NM = '㈜이지바이', BILL_EMAIL = 'cutejp@nate.com' WHERE SUPPLY_COMP_CD = '4785';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100033729168', DEPOSITOR_NM = '(주)샵앤', BILL_EMAIL = 'papabro@naver.com' WHERE SUPPLY_COMP_CD = '4787';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_11', ACCOUNT_NO = '3021444239861', DEPOSITOR_NM = '선하승(디에스코리아)', BILL_EMAIL = 'plnky666@naver.com' WHERE SUPPLY_COMP_CD = '4825';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '6604661001021', DEPOSITOR_NM = '㈜인터파크', BILL_EMAIL = 'eunyoungshin@interpark.com' WHERE SUPPLY_COMP_CD = '4828';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '6604661001021', DEPOSITOR_NM = '㈜인터파크', BILL_EMAIL = 'eunyoungshin@interpark.com' WHERE SUPPLY_COMP_CD = '4829';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '6604661001021', DEPOSITOR_NM = '㈜인터파크', BILL_EMAIL = 'eunyoungshin@interpark.com' WHERE SUPPLY_COMP_CD = '4830';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '56100695096939', DEPOSITOR_NM = '(주)이월드쥬얼리사업', BILL_EMAIL = 'lee_mihyun84@eland.co.kr' WHERE SUPPLY_COMP_CD = '4831';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110151943542', DEPOSITOR_NM = '김남일 (왕미 비어체스터)', BILL_EMAIL = 'i12ub4@nate.com' WHERE SUPPLY_COMP_CD = '4839';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '02209000401011', DEPOSITOR_NM = '주식회사 뉴키즈온', BILL_EMAIL = 'jh9206@hanmail.net' WHERE SUPPLY_COMP_CD = '4855';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '39910104344634', DEPOSITOR_NM = '㈜아크컴퍼니', BILL_EMAIL = 'feelgold7@naver.com' WHERE SUPPLY_COMP_CD = '4857';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '3013452801013', DEPOSITOR_NM = '(주) 티에이치커뮤니티', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '4864';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005900398332', DEPOSITOR_NM = '이경구', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '495';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005301735139', DEPOSITOR_NM = '김민재(민영상사)', BILL_EMAIL = 'mail@mkoutdoor.co.kr' WHERE SUPPLY_COMP_CD = '499';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100013032292', DEPOSITOR_NM = '한세엠케이㈜', BILL_EMAIL = 'syjeong@hansaemk.com' WHERE SUPPLY_COMP_CD = '5';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '100023099295', DEPOSITOR_NM = '(주)코스메이트코스메틱', BILL_EMAIL = 'hee1408@nate.com' WHERE SUPPLY_COMP_CD = '550';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1002634340830', DEPOSITOR_NM = '이동익', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '554';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_27', ACCOUNT_NO = '35712094265', DEPOSITOR_NM = '박정호', BILL_EMAIL = 'eksmcokr@naver.com' WHERE SUPPLY_COMP_CD = '561';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_20', ACCOUNT_NO = '1005700979752', DEPOSITOR_NM = '박지영(지인)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '580';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_04', ACCOUNT_NO = '48390101170540', DEPOSITOR_NM = '권혁재(패션프린스)', BILL_EMAIL = '' WHERE SUPPLY_COMP_CD = '622';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_21', ACCOUNT_NO = '110255571904', DEPOSITOR_NM = '김순일(하이지비)', BILL_EMAIL = 'epoplar@nate.com' WHERE SUPPLY_COMP_CD = '662';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'N', BANK_CD = 'G940_20', ACCOUNT_NO = '77614903702001', DEPOSITOR_NM = '송미애', BILL_EMAIL = 'sasoo@dreamwiz.com' WHERE SUPPLY_COMP_CD = '833';
UPDATE TB_SUPPLY_COMPANY SET ECONTRACT_YN = 'Y', BANK_CD = 'G940_03', ACCOUNT_NO = '06105755101011', DEPOSITOR_NM = '최석원', BILL_EMAIL = 'eunju3469@nate.com' WHERE SUPPLY_COMP_CD = '874';

CREATE TABLE TMP_SUPPLY_VENDOR1 AS
SELECT SUPPLY_VENDOR_CD
     , MAX(SETTLE_DAY)   AS SETTLE_DAY
     , MAX(BANK_CD)      AS BANK_CD
     , MAX(ACCOUNT_NO)   AS ACCOUNT_NO
     , MAX(DEPOSITOR_NM) AS DEPOSITOR_NM
     , MAX(BILL_EMAIL)   AS BILL_EMAIL
     , MAX(ECONTRACT_YN) AS ECONTRACT_YN
FROM   TB_SUPPLY_COMPANY
-- WHERE  ECONTRACT_YN = 'Y'
WHERE  BANK_CD IS NOT NULL
GROUP  BY SUPPLY_VENDOR_CD
ORDER  BY 1
;

UPDATE TB_SUPPLY_VENDOR Z SET SETTLE_DAY = (SELECT SETTLE_DAY FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);
UPDATE TB_SUPPLY_VENDOR Z SET BANK_CD = (SELECT BANK_CD FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);
UPDATE TB_SUPPLY_VENDOR Z SET ACCOUNT_NO = (SELECT ACCOUNT_NO FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);
UPDATE TB_SUPPLY_VENDOR Z SET DEPOSITOR_NM = (SELECT DEPOSITOR_NM FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);
UPDATE TB_SUPPLY_VENDOR Z SET BILL_EMAIL = (SELECT BILL_EMAIL FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);
UPDATE TB_SUPPLY_VENDOR Z SET ECONTRACT_YN = (SELECT ECONTRACT_YN FROM TMP_SUPPLY_VENDOR1 WHERE SUPPLY_VENDOR_CD = Z.SUPPLY_VENDOR_CD) WHERE SUPPLY_VENDOR_CD IN (SELECT SUPPLY_VENDOR_CD FROM TMP_SUPPLY_VENDOR1);

COMMIT;

SELECT * FROM TB_SUPPLY_VENDOR;

SELECT * FROM TB_USAC;

SELECT * FROM TB_ORDER_DETAIL;

################################################################################
# 정산
################################################################################
DROP TABLE IF EXISTS TB_USAC RESTRICT;
CREATE TABLE TB_USAC (
  USAC_DT          VARCHAR(8)          NOT NULL COMMENT '정산일',
  SUPPLY_VENDOR_CD VARCHAR(20)         NOT NULL COMMENT '공급벤더코드(공급벤더)',
  -- ECONTRACT_YN     CHAR(1) DEFAULT 'N' NOT NULL COMMENT '전자계약여부',
  -- DISTRIBUTION_GB  VARCHAR(20)         NOT NULL COMMENT '유통구분(공통코드 G065)',
  -- SETTLE_DAY       VARCHAR(20)                  COMMENT '정산일(공통코드G075)',
  SELL_QTY         INT     DEFAULT 0   NOT NULL COMMENT '판매수량',
  REAL_SELL_AMT    INT     DEFAULT 0   NOT NULL COMMENT '실판매금액(=상품총액)',
  SELL_FEE_AMT     INT     DEFAULT 0   NOT NULL COMMENT '판매수수료금액',
  CPN_DC_AMT       INT     DEFAULT 0   NOT NULL COMMENT '쿠폰할인금액',
  SELF_CPN_DC_AMT  INT     DEFAULT 0   NOT NULL COMMENT '자사쿠폰분담액',
  SUPPLY_COMP_CPN_DC_AMT  INT     DEFAULT 0   NOT NULL COMMENT '입점쿠폰분담액',
  TMTB_DC_AMT      INT     DEFAULT 0   NOT NULL COMMENT '다다익선할인금액',
  SELF_TMTB_DC_AMT  INT     DEFAULT 0   NOT NULL COMMENT '자사다다익선분담액',
  SUPPLY_COMP_TMTB_DC_AMT  INT     DEFAULT 0   NOT NULL COMMENT '입점다다익선분담액',
  BILL_AMT         INT     DEFAULT 0   NOT NULL COMMENT '계산서발행금액(판매수수료금액 - 자사쿠폰분담액. < 0인 경우 0)',
  SUPPLY_AMT       INT     DEFAULT 0   NOT NULL COMMENT '공급가액. INT(계산서발행금액 / 1.1)',
  TAX_AMT          INT     DEFAULT 0   NOT NULL COMMENT '세액(계산서발행금액 - 공급가액)',
  DELV_FEE         INT     DEFAULT 0   NOT NULL COMMENT '배송비',
  -- BANK_CD          VARCHAR(20) COMMENT '은행코드(공통코드G940)',
  -- ACCOUNT_NO       VARCHAR(20) COMMENT '계좌번호',
  -- DEPOSITOR_NM     VARCHAR(50) COMMENT '예금주명',
  -- BILL_EMAIL       VARCHAR(100) NULL COMMENT '계산서이메일',
  REG_NO           INT UNSIGNED        NOT NULL COMMENT '등록자번호', -- 등록자번호
  REG_DT           TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '등록일시' -- 등록일시
)
COMMENT '정산. 정산확정에 의한 발생';

-- 정산
ALTER TABLE TB_USAC
  ADD CONSTRAINT PK_USAC -- 정산 기본키
    PRIMARY KEY (
      USAC_DT,
      SUPPLY_VENDOR_CD
    );

   ################################################################################
# 정산미수금
################################################################################
DROP TABLE IF EXISTS TB_USAC_RECEIVE RESTRICT;
CREATE TABLE TB_USAC_RECEIVE (
  USAC_YM          VARCHAR(6)          NOT NULL COMMENT '정산연월',
  SUPPLY_VENDOR_CD VARCHAR(20)         NOT NULL COMMENT '공급벤더코드(공급벤더)',
  RECEIVABLE_AMT   INT     DEFAULT 0   NOT NULL COMMENT '미수금',
  REG_NO           INT UNSIGNED        NOT NULL COMMENT '등록자번호',
  REG_DT           TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '등록일시',
  UPD_NO           INT UNSIGNED        NOT NULL COMMENT '수정자번호',
  UPD_DT           TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '수정일시'
)
COMMENT '정산미수금. 정산미수금 등록에 의한 발생';

ALTER TABLE TB_USAC_RECEIVE
  ADD CONSTRAINT PK_USAC_RECEIVE
    PRIMARY KEY (
      USAC_YM,
      SUPPLY_VENDOR_CD
    );

################################################################################
# 정산기타차감
################################################################################
DROP TABLE IF EXISTS TB_USAC_DEDUCT RESTRICT;
CREATE TABLE TB_USAC_DEDUCT (
  DEDUCT_SQ        INT UNSIGNED        NOT NULL COMMENT '차감일련번호',
  OCCUR_YM         VARCHAR(6)          NOT NULL COMMENT '발행연월',
  SUPPLY_VENDOR_CD VARCHAR(20)         NOT NULL COMMENT '공급벤더코드(공급벤더)',
  SUPPLY_VENDOR_NM VARCHAR(100)        NULL     COMMENT '공급벤더명',
  CUST_ID          VARCHAR(30)         NULL     COMMENT '고객ID',
  CUST_NM          VARCHAR(200)        NULL     COMMENT '고객명',
  ORD_NO           INT UNSIGNED        NULL     COMMENT '주문번호(주문)',
  CATE_NM          VARCHAR(50)         NULL     COMMENT '카테고리명',
  CHARGE_NM        VARCHAR(50)         NULL     COMMENT '업체담당자명',
  ORD_GOODS        VARCHAR(200)        NULL     COMMENT '주문상품',
  CURR_PRICE       INT     DEFAULT 0   NOT NULL COMMENT '판매가(=상품가)',
  REWARD_AMT       INT     DEFAULT 0   NOT NULL COMMENT '보상액',
  REASON           VARCHAR(4000)       NULL     COMMENT '사유',
  REG_NO           INT UNSIGNED        NOT NULL COMMENT '등록자번호',
  REG_DT           TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '등록일시'
)
COMMENT '정산기타차감. 정산 기타차감내역 등록에 의한 발생';

ALTER TABLE TB_USAC_DEDUCT
  ADD CONSTRAINT PK_USAC_DEDUCT
    PRIMARY KEY (
      DEDUCT_SQ
    );

CREATE INDEX IX_USAC_DEDUCT_01
  ON TB_USAC_DEDUCT(
    OCCUR_YM ASC,
    SUPPLY_VENDOR_CD ASC
  );

ALTER TABLE TB_USAC_DEDUCT
  MODIFY COLUMN DEDUCT_SQ INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '차감일련번호';

ALTER TABLE TB_USAC_DEDUCT
  AUTO_INCREMENT = 1;

SELECT * FROM TB_USAC;

/* TsaSettle.getSettleConfirmList */
		SELECT U.USAC_YM                                                                                                 /*정산연월*/
		     , U.SUPPLY_VENDOR_CD                                                                                        /*공급벤더코드*/
		     , SV.SUPPLY_VENDOR_NM                                                                                       /*공급벤더명*/
		     , SV.ECONTRACT_YN                                                                                           /*전자계약여부*/
		     , SV.BIZ_NO                                                                                                 /*사업자번호*/
		     , SV.SETTLE_DAY                                                                                             /*정산주기*/
		     , FN_GET_CODE_NM('G075',SV.SETTLE_DAY)                                                     AS SETTLE_DAY_NM /*정산주기명*/
		     , U.SELL_QTY                                                                                                /*판매수량*/
		     , U.REAL_SELL_AMT                                                                                           /*실판매금액(=상품총액)*/
		     , U.SELL_FEE_AMT                                                                                            /*수수료*/
		     , U.CPN_DC_AMT                                                                                              /*쿠폰할인금액*/
		     , U.SELF_CPN_DC_AMT                                                                                         /*자사쿠폰분담액*/
		     , U.SUPPLY_COMP_CPN_DC_AMT                                                                                  /*입점쿠폰분담액*/
		     , U.TMTB_DC_AMT                                                                                             /*다다익선할인금액*/
		     , U.SELF_TMTB_DC_AMT                                                                                        /*자사다다익선분담액*/
		     , U.SUPPLY_COMP_TMTB_DC_AMT                                                                                 /*입점다다익선분담액*/
		     , U.BILL_AMT                                                                                                /*계산서발행금액*/
		     , U.SUPPLY_AMT                                                                                              /*공급금액*/
		     , U.TAX_AMT                                                                                                 /*세액*/
		     , U.DELV_FEE                                                                                                /*배송비*/
		     , IFNULL(UR2.ETC_DEDUCT_AMT,0)                                                            AS ETC_DEDUCT_AMT /*기타차감*/
		     , (U.REAL_SELL_AMT - U.SELL_FEE_AMT + U.SELF_CPN_DC_AMT + U.SELF_TMTB_DC_AMT)
		       + U.DELV_FEE - IFNULL(UR2.ETC_DEDUCT_AMT,0)                                             AS GIVE_AMT       /*지급금액*/
		     , IFNULL(UR1.RECEIVABLE_AMT,0)                                                            AS RECEIVABLE_AMT /*미수금*/
		     , (U.REAL_SELL_AMT - U.SELL_FEE_AMT + U.SELF_CPN_DC_AMT + U.SELF_TMTB_DC_AMT)
		       + U.DELV_FEE - IFNULL(UR2.ETC_DEDUCT_AMT,0)
		       - IFNULL(UR1.RECEIVABLE_AMT,0)                                                          AS TOT_GIVE_AMT   /*총지급금액*/
		     , CASE WHEN SV.ECONTRACT_YN = 'N' THEN '보류'
		            ELSE
		                CASE WHEN (U.BILL_AMT + U.DELV_FEE - IFNULL(UR2.ETC_DEDUCT_AMT,0))  <  0 THEN
		                         '미수금'
		                     ELSE
		                         '정상'
		                END
		       END                                                                                     AS SETTLE_STAT    /*정산상태*/
		     , SV.BANK_CD                                                                                                /*은행코드*/
		     , FN_GET_CODE_NM('G940',SV.BANK_CD)                                                       AS BANK_NM        /*은행명*/
		     , SV.ACCOUNT_NO                                                                                             /*계좌번호*/
		     , SV.DEPOSITOR_NM                                                                                           /*예금주명*/
		     , SV.BILL_EMAIL                                                                                             /*계산서이메일*/
		FROM   (
		        SELECT DATE_FORMAT(U.USAC_DT,'%Y%m')                    AS USAC_YM                 /*정산연월*/
		             , U.SUPPLY_VENDOR_CD                                                          /*공급벤더코드*/
		             , SUM(U.SELL_QTY)                                  AS SELL_QTY                /*판매수량*/
		             , SUM(U.REAL_SELL_AMT)                             AS REAL_SELL_AMT           /*실판매금액(=상품총액)*/
		             , SUM(U.SELL_FEE_AMT)                              AS SELL_FEE_AMT            /*수수료*/
		             , SUM(U.CPN_DC_AMT)                                AS CPN_DC_AMT              /*쿠폰할인금액*/
		             , SUM(U.SELF_CPN_DC_AMT)                           AS SELF_CPN_DC_AMT         /*자사쿠폰분담액*/
		             , SUM(U.SUPPLY_COMP_CPN_DC_AMT)                    AS SUPPLY_COMP_CPN_DC_AMT  /*입점쿠폰분담액*/
		             , SUM(U.TMTB_DC_AMT)                               AS TMTB_DC_AMT             /*다다익선할인금액*/
		             , SUM(U.SELF_TMTB_DC_AMT)                          AS SELF_TMTB_DC_AMT        /*자사다다익선분담액*/
		             , SUM(U.SUPPLY_COMP_TMTB_DC_AMT)                   AS SUPPLY_COMP_TMTB_DC_AMT /*입점다다익선분담액*/
		             , SUM(U.BILL_AMT)                                  AS BILL_AMT                /*계산서발행금액*/
		             , SUM(U.SUPPLY_AMT)                                AS SUPPLY_AMT              /*공급금액*/
		             , SUM(U.TAX_AMT)                                   AS TAX_AMT                 /*세액*/
		             , SUM(U.DELV_FEE)                                  AS DELV_FEE                /*배송비*/
		        FROM   TB_USAC U
		        WHERE  1 = 1
		        AND    U.USAC_DT  >=  REPLACE(CONCAT( '2021-08' /**P*/,'-01'),'-','')
		        AND    U.USAC_DT  <  DATE_ADD(STR_TO_DATE(CONCAT( '2021-08' /**P*/,'-01'),'%Y-%m-%d'), INTERVAL 1 MONTH)
		        GROUP  BY DATE_FORMAT(U.USAC_DT,'%Y%m'), U.SUPPLY_VENDOR_CD
		       ) U
		INNER JOIN TB_SUPPLY_VENDOR SV ON U.SUPPLY_VENDOR_CD = SV.SUPPLY_VENDOR_CD
		LEFT OUTER JOIN TB_USAC_RECEIVE UR1 ON U.USAC_YM = UR1.USAC_YM
		                                   AND U.SUPPLY_VENDOR_CD = UR1.SUPPLY_VENDOR_CD
		LEFT OUTER JOIN (
		                 SELECT OCCUR_YM         AS USAC_YM
		                      , SUPPLY_VENDOR_CD
		                      , SUM(REWARD_AMT)  AS ETC_DEDUCT_AMT
		                 FROM   TB_USAC_DEDUCT
		                 WHERE  OCCUR_YM = REPLACE( '2021-08' /**P*/,'-','')
		                 GROUP  BY OCCUR_YM, SUPPLY_VENDOR_CD
		                ) UR2 ON U.USAC_YM = UR2.USAC_YM
		                     AND U.SUPPLY_VENDOR_CD = UR2.SUPPLY_VENDOR_CD
;
/* TsaSettle.getTaxBillSettleList */
		SELECT U.USAC_YM                                  /*정산연월*/
		     , '상품판매수수료'    AS BILL_TYPE           /*계산서유형*/
		     , U.SUPPLY_AMT                               /*공급가액*/
		     , U.TAX_AMT                                  /*세액*/
		     , U.BILL_AMT          AS TRADE_AMT           /*거래금액*/
		     , SV.BIZ_NO                                  /*사업자번호*/
		     , U.SUPPLY_VENDOR_CD                         /*공급업체코드*/
		     , SV.SUPPLY_VENDOR_NM                        /*공급업체명*/
		     , SV.OWNER_NM                                /*대표자명*/
		     , SV.BIZ_TYPE                                /*업태*/
		     , SV.BIZ_KIND                                /*업종*/
		     , SV.BIZ_BASE_ADDR                           /*사업장기본주소*/
		     , SV.BIZ_DTL_ADDR                            /*사업장상세주소*/
		     , (SELECT MAX(SETTLE_CHARGE_NM)
		        FROM   TB_SUPPLY_COMPANY
		        WHERE  SUPPLY_VENDOR_CD = SV.SUPPLY_VENDOR_CD
		       )                   AS SETTLE_CHARGE_NM    /*정산담당자명*/
		     , (SELECT MAX(SETTLE_CHARGE_TELNO)
		        FROM   TB_SUPPLY_COMPANY
		        WHERE  SUPPLY_VENDOR_CD = SV.SUPPLY_VENDOR_CD
		       )                   AS SETTLE_CHARGE_TELNO /*정산담당자전화번호*/
		     , SV.BILL_EMAIL                              /*계산서이메일*/
		     , U.BILL_AMT                                 /*계산서발행금액*/
		FROM   (
		        SELECT DATE_FORMAT(U.USAC_DT,'%Y%m') AS USAC_YM    /*정산연월*/
		             , U.SUPPLY_VENDOR_CD                          /*공급업체코드*/
		             , SUM(U.SUPPLY_AMT)             AS SUPPLY_AMT /*공급가액*/
		             , SUM(U.TAX_AMT)                AS TAX_AMT    /*세액*/
		             , SUM(U.BILL_AMT)               AS BILL_AMT   /*계산서발행금액*/
		        FROM   TB_USAC U
		        WHERE  1 = 1
		        AND    U.USAC_DT  >=  REPLACE(CONCAT( '2021-08' /**P*/,'-01'),'-','')
		        AND    U.USAC_DT  <  DATE_ADD(STR_TO_DATE(CONCAT( '2021-08' /**P*/,'-01'),'%Y-%m-%d'), INTERVAL 1 MONTH)
		        GROUP  BY DATE_FORMAT(U.USAC_DT,'%Y%m'), U.SUPPLY_VENDOR_CD
		       ) U
		INNER JOIN TB_SUPPLY_VENDOR SV ON U.SUPPLY_VENDOR_CD = SV.SUPPLY_VENDOR_CD
		;
		
SELECT *
FROM   TB_USAC_DEDUCT
;

UPDATE TB_USAC_DEDUCT
SET    OCCUR_YM = '202108'
;

COMMIT;