SELECT oh.OAORNO as ORDER_NO,
CONVERT(DECIMAL(10,2),oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100)) as TOT_AMT,
oh.OARLDT as SEND_DATE,
oh.OAORDT as ORDER_DATE,
oh.OACUNO as CUS_NO,
cu.OKCFC1 as CUS_AREA
FROM MVXJDTA.OOHEAD AS oh 
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO 
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO 
WHERE oh.OAORDT like ('2025%') AND (oh.OAORTP IN ('021','911','921','941','281')) AND (((oh.OAORST between '22' and '77') ) and (oh.OAORSL not in('99'))) AND (ol.OBORST not in ('90','99')) 
AND (oh.OASMCD not in('11000','30001','30002','30003','30004')) 
GROUP BY oh.OAORNO,oh.OAORDT,oh.OACUNO,cu.OKSDST,cu.OKCFC1,oh.OANTLA,oh.OAOTDP,oh.OASMCD,oh.OAORST,oh.OARLDT
ORDER BY oh.OACUNO ASC<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01036','19691.20','20250502','20250324','EX600001  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01010','1162.80','20250526','20250411','EX600001  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01025','1101500.00','20250408','20250314','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01020','1405620.00','20250623','20250609','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01024','1516110.00','20250409','20250314','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01026','1478760.00','20250424','20250314','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01014','1309130.00','20250513','20250421','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01016','1164466.00','20250520','20250421','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01033','643500.00','20250514','20250428','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01023','1441926.00','20250409','20250314','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01027','1272600.00','20250424','20250314','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01017','1147700.00','20250526','20250421','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01022','695282.00','20250519','20250423','EX950007  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01017','1526790.00','20250505','20250311','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01029','686700.00','20250324','20250317','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01039','773450.00','20250403','20250324','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01013','690000.00','20250604','20250516','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01011','1345210.00','20250702','20250605','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01012','1463230.00','20250710','20250605','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01025','1421700.00','20250520','20250424','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01026','1556160.00','20250529','20250424','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01027','1492540.00','20250610','20250424','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01002','412350.00','20250520','20250505','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01006','432000.00','20250620','20250605','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01018','1612040.00','20250514','20250311','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01045','1486000.00','20250401','20250327','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01028','1503500.00','20250616','20250424','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01010','1411560.00','20250626','20250605','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01014','1508000.00','20250410','20250311','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01049','398600.00','20250408','20250331','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01050','644400.00','20250428','20250331','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01023','370790.00','20250502','20250423','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01008','795200.00','20250523','20250514','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01021','1795450.00','20250619','20250520','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01007','1673900.00','20250620','20250605','EX950014  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01008','7720.00','20250327','20250310','EX950021  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01001','108080.00','20250516','20250505','EX950021  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01015','115800.00','20250502','20250421','EX950021  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01048','46320.00','20250411','20250328','EX950021  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01006','15440.00','20250410','20250408','EX950021  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01005','506325.00','20250513','20250507','EX950024  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01033','506325.00','20250328','20250320','EX950024  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01015','506325.00','20250617','20250605','EX950024  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01003','30081.50','20250618','20250506','EX950029  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01029','29492.50','20250529','20250523','EX950029  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01001','29492.50','20250527','20250401','EX950029  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01013','1451600.00','20250522','20250421','EX950033  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6806E01029','126212.00','20250527','20250613','EX950038  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01043','247250.00','20250423','20250326','EX950045  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01020','12760.00','20250429','20250313','EX950046  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6804E01020','1168810.00','20250609','20250422','EX950053  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01044','1265760.00','20250430','20250327','EX950054  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6805E01018','247250.00','20250526','20250519','EX950055  ','EX101     ')<HR>INSERT INTO c_coprocess (ORDER_NO,TOT_AMT,SEND_DATE,ORDER_DATE,CUS_NO,CUS_AREA) value ('6803E01032','1196635.00','20250429','20250320','EX950058  ','EX101     ')<HR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [54]