UPDATE OR INSERT INTO SAL_CARDJP (JPNO, ILJA, POSNO, SWNO, TERMID, SIGB, JMGB, TAXMJ, HBMONTH, GGGAMT, TAXAMT, TOTALAMT, CARDNO, CARDGG, CARDOFFICE, CARDNAME, SINO, SIDATE, MISCD, MISNM, GMJNO, GRIRNO, VANMSG, ORICARDNO, CRTID, CRTDT) VALUES ('20180404-02000-00001', '2018-04-04', '02', '999', '´Ü¸»±â¹øÈ£', 'SI', '0110', 'N', 0, °ø±Þ°¡, ºÎ°¡¼¼, ¿äû±Ý¾×, '9430-11**-****-****', '000', '001', '¹ß±Þ»ç', '½ÂÀιøÈ£', '½ÂÀÎÀÏÀÚyyyymmddhhmmss', 'E001', '¸ÅÀÔ»ç', '°¡¸ÍÁ¡¹øÈ£', '10000000', '= ½Å¿ë  ½ÂÀÎ =    Á¤»ó  ½ÂÀÎ    (½ÂÀιøÈ£)    ºñ¾¾Ä«µå','9430-11**-****-****', '999', '2018-04-04 10:43:23') MATCHING (JPNO)


UPDATE OR INSERT INTO SAL_CARDJP (JPNO, ILJA, POSNO, SWNO, TERMID, SIGB, JMGB, TAXMJ, HBMONTH, GGGAMT, TAXAMT, TOTALAMT, CARDNO, CARDGG, CARDOFFICE, CARDNAME, SINO, SIDATE, MISCD, MISNM, GMJNO, GRIRNO, VANMSG, ORICARDNO, CRTID, CRTDT) VALUES 
('20191217-02002-00017', '2019-12-17', '02', '999', '11228367', 'SI', '0110', 'N', 0, 1090909, 109091, 1200000, '9410-49**-****-****', '000', '001', '±¹¹ÎÄ«µå', '30063863', '20191217163208', 
'02', 'KB±¹¹ÎÄ«µå', '00041002737', '10000000', '= ½Å¿ë  ½ÂÀÎ =    Á¤»ó  ½ÂÀÎ    (½ÂÀιøÈ£)    ±¹¹ÎÄ«µå','9410-49**-****-****', '999', '2019-12-17 16:32:08') MATCHING (JPNO)