Warning: include(connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\12SKU\insert_12sku_data_TST.php on line 13
Warning: include() [function.include]: Failed opening 'connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\12SKU\insert_12sku_data_TST.php on line 13
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'1' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('80 G','75 G') AND (it.MMCFI3='G01'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASC
Warning: array_diff() [function.array-diff]: Argument #2 is not an array in E:\www\12SKU\insert_12sku_data_TST.php on line 118
Warning: array_unique() [function.array-unique]: The argument should be an array in E:\www\12SKU\insert_12sku_data_TST.php on line 120
กลุ่ม : 1
Warning: Invalid argument supplied for foreach() in E:\www\12SKU\insert_12sku_data_TST.php on line 125
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'2' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('165 G','170 G') AND (it.MMCFI3='G01'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 2 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','2','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','2','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'3' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('425 G','450 G') AND (it.MMCFI3='G02'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 3 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','3','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','3','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'4' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('850 G','900 G') AND (it.MMCFI3='G02'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 4 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','4','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','4','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'5' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('1.2 KG') AND (it.MMCFI3='G02'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 5 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','5','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','5','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'6' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('60 G','60.0 G','70 G','70.0 G','75 G','75.0 G','80 G','80.0 G') AND (it.MMCFI3='G03'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 6 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','6','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','6','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'7' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('165 G','170 G') AND (it.MMCFI3='G03'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 7 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','7','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','7','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'8' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('425 G','450 G') AND (it.MMCFI3='G03'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 8 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','8','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','8','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'9' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('850 G','900 G') AND (it.MMCFI3='G03'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 9 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','9','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','9','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'10' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('1.0 L','1.00 L','0.5 L','0.50 L') AND (it.MMCFI3='G05'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 10 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','10','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','10','2025','04','')
select
cu.OKCFC1 as AREA,cu.OKSDST as ZONE,
Sum(case when substring(cast(st.UCIVDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),st.UCIVQA) else 0 end) [QTY],
count(distinct(case when st.UCORTP in('021','911','921','941','025','924','925','024') then (st.UCCUNO) else 0 end)) [SUMCUS],
'11' as GROUP_,'2025' as YEAR,'04' as MONTH
from MVXJDTA.OSBSTD as st
INNER JOIN MVXJDTA.OCUSMA AS cu ON st.UCCUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.MITMAS AS it ON st.UCITNO = it.MMITNO
where UCIVDT like '202504%' AND (st.UCORTP IN ('021','911','921','941','025','924','925','024'))
and (it.MMITGR in('350 G','350.0 G') AND (it.MMCFI3='G06'))
GROUP BY cu.OKCFC1,cu.OKSDST
ORDER BY cu.OKCFC1 ASCกลุ่ม : 11 INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B101','B','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B102','B','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('B103','B','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C101','C','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C102','C','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('C103','C','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E101','E','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E102','E','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('E103','E','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N101','N','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N102','N','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N103','N','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E101','N/E','0.00','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E102','N/E','0.00','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E103','N/E','0.00','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('N/E104','N/E','0.00','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S101','S','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S102','S','0','0','11','2025','04','')
INSERT INTO 12SKU_TST (AREA,ZONE,QTY,SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT) value ('S103','S','0','0','11','2025','04','')