横江製作所 DBviewer [F20 今月分の経過合計Q45]

SELECT 今月分の受入税込金額の合計,今月の納品済税込金額の合計,未納品の今月分約束納期の税込金額合計,今月分の未納品税込金額の合計,今月分の未注文の見積金額合計,今月の納品済税込金額の合計+未納品の今月分約束納期の税込金額合計+今月分の未注文の見積金額合計 AS 今月約束分の予定税込売上,今月の納品済税込金額の合計+今月分の未納品税込金額の合計+今月分の未注文の見積金額合計 AS 今月分の予定税込売上,翌月分受注税込金額の合計,翌月分の未注文の見積金額合計,翌月分受注税込金額の合計+翌月分の未注文の見積金額合計 AS 翌月分の予定税込売上,翌々月分の見積金額の合計 FROM (SELECT COALESCE(SUM(t0124*t0109),0) as 納品済注文金額の合計,COALESCE(SUM(ROUND(t0124*t0109*t0130/100)),0) as 率消費税の合計,COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 今月の納品済税込金額の合計 FROM t01 WHERE invalid=0 and t0123>=20251001 and t0123 <20251101) as Q12,(SELECT COALESCE(SUM(t0124*t0109),0) as 受入注文金額の合計,COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 今月分の受入税込金額の合計 FROM t01 WHERE invalid=0 and t0116>=20251001 and t0116 <20251101) as Q30,(SELECT COALESCE(SUM(t0124*t0109),0) as 未納品注文金額の合計,COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 今月分の未納品税込金額の合計 FROM t01 WHERE invalid=0 and t0113<20251101 and t0113>=20251001 and t0123 IS NULL) as Q44,(SELECT COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 翌月分受注税込金額の合計 FROM t01 WHERE invalid=0 and t0113>=20251001 and t0123 IS NULL and t0123 IS NULL and t0113>=20251101 and t0113<20251201) as Q47,(SELECT COALESCE(SUM(t0109*t0122),0) as 翌々月分の見積金額の合計,COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 翌々月分受注税込金額の合計 FROM t01 WHERE invalid=0 and t0113>=20251001 and t0123 IS NULL and t0113>=20251201 and t0113<20260101) as Q49,(SELECT COALESCE(SUM(t0109*t0122),0) as 今月分の未注文の見積金額合計 FROM t01 WHERE invalid=0 and t0113<20251101 and t0113>=20251001 and t0123 IS NULL and t0103>=20251001 and t0124 IS NULL) as Q51,(SELECT COALESCE(SUM(t0109*t0122),0) as 翌月分の未注文の見積金額合計 FROM t01 WHERE invalid=0 and t0113>=20251001 and t0123 IS NULL and t0113>=20251101 and t0113<20251201 and t0124 IS NULL) as Q26,(SELECT COALESCE(SUM(t0124*t0109),0) as 未納品の今月分約束納期の注文金額合計,COALESCE(SUM(ROUND(t0124*t0109*(t0130+100)/100)),0) as 未納品の今月分約束納期の税込金額合計 FROM t01 WHERE invalid=0 and t0123 IS NULL and t0129>=20251001 and t0129<20251101) as Q38