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','20250411','20250324','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 ('6804E01022','695282.00','20250513','20250423','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 ('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 ('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 ('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 ('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 ('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 ('6803E01018','1612040.00','20250430','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 ('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 ('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 ('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 ('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 ('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 ('6803E01032','1196635.00','20250429','20250320','EX950058  ','EX101     ')<HR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [25]