ช่วงเวลา : 06|11
delete : DELETE FROM 12sku_data WHERE YEARR like '2025%' and MONTHH like '09%'
and ((SUBSTRING(AREA,3,2) = '11' or SUBSTRING(AREA,3,2) = '12' or SUBSTRING(AREA,3,2) = '13' or SUBSTRING(AREA,3,2) = '10' ))
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('75 G') AND (MMCFI3='G02') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'1' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('75 G') AND (MMCFI3='G02'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 1
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('165 G') AND (MMCFI3='G02') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'2' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('165 G') AND (MMCFI3='G02'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 2
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('425 G','400 G') AND (MMCFI3='G03') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'3' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('425 G','400 G') AND (MMCFI3='G03'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 3
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('850 G','800 G') AND (MMCFI3='G03') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'4' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('850 G','800 G') AND (MMCFI3='G03'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 4
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('1.2 KG','1.5 KG') AND (MMCFI3='G03') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'5' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('1.2 KG','1.5 KG') AND (MMCFI3='G03'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 5
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('70 G','75 G') AND (MMCFI3='G04') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'6' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('70 G','75 G') AND (MMCFI3='G04'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 6
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('165 G') AND (MMCFI3='G04') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'7' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('165 G') AND (MMCFI3='G04'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 7
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('425 G','400 G') AND (MMCFI3='G04') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'8' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('425 G','400 G') AND (MMCFI3='G04'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 8
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('850 G','800 G') AND (MMCFI3='G04') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'9' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('850 G','800 G') AND (MMCFI3='G04'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 9
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('80 G','350 G','350.0 G') AND (MMCFI3='G07') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'10' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('80 G','350 G','350.0 G') AND (MMCFI3='G07'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 10
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMCFI3 = 'G06' then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'11' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMCFI3 = 'G06')
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 11
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMCFI3 = 'G13' then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'12' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMCFI3 = 'G13')
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 12
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('500 G','1.0 KG') AND MMCFI3 IN ('G08','G12') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'13' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('500 G','1.0 KG') AND MMCFI3 IN ('G08','G12'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 13
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND (MMITGR in('200 G','800 G') AND MMCFI3 = 'G10' OR MMCFI3 = 'G15' OR MMCFI3 = 'G19') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'14' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and ((MMITGR in('200 G','800 G') AND MMCFI3 = 'G10' OR MMCFI3 = 'G15' OR MMCFI3 = 'G19'))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 14
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMCFI3 = 'G16' then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'15' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMCFI3 = 'G16')
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 15
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMITGR in('100 G','1 KG','75 G') AND (MMCFI3 IN ('G17') ) then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'16' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMITGR in('100 G','1 KG','75 G') AND (MMCFI3 IN ('G17') ))
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 16
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMCFI3 = 'G18' then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'17' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMCFI3 = 'G18')
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 17
select st.OACUNO as cuno,ol.OBORNO as cono,ol.OBITNO as ITNO,cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
CASE
WHEN st.OAORTP IN ('021') THEN 'SALE'
WHEN st.OAORTP IN ('025' ,'024','022') THEN 'CN' ELSE st.OAORTP END as TYPE,
Sum(case when substring(cast(ol.OBRGDT as VARCHAR(8)),5,2) IN('09') AND MMCFI3 = 'G11' then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'18' as GROUP_,'2025' as YEAR,'09' as MONTH,st.OASMCD as SALE_CODE
from MVXJDTA.OOHEAD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.OOLINE AS ol ON st.OAORNO = ol.OBORNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO AND MMCONO = '410'
INNER JOIN MVXJDTA.MITAUN uniI on ol.OBITNO=uniI.MUITNO AND MUCONO = '410'
where OAORDT like '202509%' AND (st.OAORTP IN ('021','025','024','022'))
and (MMCFI3 = 'G11')
AND (cu.OKCFC1 NOT LIKE '%30%' OR cu.OKCFC1 NOT LIKE '%40%')
AND OBORST NOT IN ('90','99')
AND OAORSL NOT IN ('90','99')
AND cu.OKCFC1 <> ''
AND MUALUN = 'CTN' AND MUAUTP = 1
AND OBCONO = 410
AND OKCONO = 410
and OBNEPR!='.00'
GROUP BY ol.OBORNO,cu.OKCFC1,ol.OBITNO,cu.OKSDST,cu.OKCUNO,st.OASMCD,st.OAORTP,st.OACUNO
ORDER BY cu.OKCFC1,st.OACUNO,ol.OBORNO ASC
กลุ่ม : 18