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, DSCGB, VANMSG, ORICARDNO, CRTID, CRTDT) VALUES ('20241201-01000-00005', '2024-12-01', '01', '999', '99999955', 'SI', '0110', 'N', 00, 9, 1, 10, '5428-79**-****-****', '000', '004', '신한 카드', '63674051', '20241201002458', 'D004', '신한카드', '07279672', '243363674051', '','= 신용  승인 =    정상  승인    63674051    신한카드', '5428-79**-****-****', '999', '2024-12-01 00:24:58') MATCHING (JPNO)
UPDATE OR INSERT INTO SAL_SALEMASTER (JPNO, MCGB, JPGB, GJGB, TAXGB, ILJA, SIGAN, POSNO, SWNO, COSCD, SALEAMT, BPAMT, MSAMT, TOTALAMT, GGGAMT, TAXAMT, BECASH, IGCASH, IGCARD, IGSPG, IGJRG, IGCP1, IGCP2, MISUAMT, DCAMT, CUTAMT, BELAMT, BENAMT, GSRAMT, DMIGAMT, DMHMSAMT, BUYERCD, BUYERNM, DEPTNM, MBRCD, MBRNM, JRAMT, JPNY, CARDNO, CASHYSJBH, CASHYSJNO, TAXBHGB, TAXJPNO, POINTGB, POINTJPNO, GJJPNO, GJBUYERNM, PRTCNT, JPCHECK, INFOMSG, GRMSSMSG1, GRMSSMSG2, GJMSG1, GJMSG2, CRTID, MODID, CRTDT, MODDT) VALUES ('20241201-01000-00005', 'SM', 'MJMC', 'CASH', 'PO', '2024-12-01', '00:25:05','01', '999', '', 10, 0, 0, 10, 9, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 0, 0, 0, '', '', '', '', '', 0, '비닐봉투','20241201-01000-00005', 'N', '', 'N', '', 'N', '', '', '', 0, 'N', '', '', '', '', '', '999', '999', '2024-12-01 00:25:05', '2024-12-01 00:25:05') MATCHING (JPNO)
UPDATE OR INSERT INTO SAL_SALEDETAIL (JPNO, JPSEQ, MCGB, JPGB, ILJA, SIGAN, POSNO, BUYERCD, BUYERNM, PDCODE, SEQNO, BARCODE, PRODNM, GYUKUK, MEQTY, DANWE, TAXMJ, JRGJY, MIBUYER, JJSCD, INDANGA, SBJAMT, QTY, DANGA1, PMHIGB, PMHIJDG, HALINY, DCAMT, TAXGB, GGGAMT, TAXAMT, TOTALAMT, MSAMT, BPAMT, CRTID, CRTDT, MODID, MODDT) VALUES ('20241201-01000-00005', '1','SM','MJMC','2024-12-01','00:25:05','01', '', '','08',1,'08','비닐봉투','',1,'개','N','Y','','',0,10,1,10,'N',10,0, 0,'PO',9,1,10,0,0,'999', '2024-12-01 00:25:05', '999', '2024-12-01 00:25:05') MATCHING (JPNO, JPSEQ)
Update or INSERT INTO SYS_IRNO (IRNOGRP, IRNOGB, IRNO) VALUES ('MCJP', '', 5)