monthNumber : 04
curYear : 2025
period : 202504
curDate : 28
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','A31') 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('04') AND it.MMITGR in('425 G','450 G','425.0 G','450.0 G','425.00 G','450.00 G') AND (it.MMCFI3='G03') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'10' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('425 G','450 G','425.0 G','450.0 G','425.00 G','450.00 G') AND (it.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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('850 G','900 G','850.0 G','900.0 G','850.00 G','900.00 G') AND (it.MMCFI3='G03') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'11' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('850 G','900 G','850.0 G','900.0 G','850.00 G','900.00 G') AND (it.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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('1.0 L','1.00 L','0.5 L','0.50 L') AND (it.MMCFI3='G05') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'12' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('1.0 L','1.00 L','0.5 L','0.50 L') AND (it.MMCFI3='G05'))
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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('350 G','350.0 G') AND (it.MMCFI3='G06') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'13' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('350 G','350.0 G') AND (it.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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('500 G') AND (it.MMCFI3='G07') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'14' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('500 G') AND (it.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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('200 G') AND (it.MMCFI3='G08') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'15' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('200 G') AND (it.MMCFI3='G08'))
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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('800 G') AND (it.MMCFI3='G08') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'16' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('800 G') AND (it.MMCFI3='G08'))
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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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','A31') 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('04') AND it.MMITGR in('1000 G','1000.0G ') AND (it.MMCFI3='G09') then CONVERT(DECIMAL(10,2),(ol.OBORQT/MUCOFA)) else 0 end) [QTY],
count(distinct(st.OACUNO)) [SUMCUS],'17' as GROUP_,'2025' as YEAR,'04' 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 '202504%' AND (st.OAORTP IN ('A31'))
and (it.MMITGR in('1000 G','1000.0G ') AND (it.MMCFI3='G09'))
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 OBNEPR!='.00'
AND OBCONO = 410
AND OKCONO = 410
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