בבקשה:
/* תוטומ ח"וד */
SELECT WORKC.WORKCNAME AS 'הדובע .מ',
AFORM.CURDATE AS 'חוויד .ת',
ALINE.XXX_MOT AS 'טומ \'סמ',
SERIAL.SERIALNAME AS 'ע"קפ',
PART.PARTNAME AS 'ט"קמ',
ACT.ACTNAME AS 'הלועפ',
AFORM.FORMNAME AS 'ספוט',
(MIN(ALINE.EMPASPAN) + SUM(ALINEEMP.ASPAN)) AS 'דבוע .ז ךשמ',
(REALQUANT(ALINE.QUANT)) AS 'םיניקת',
REALQUANT(SERIAL.QUANT) AS 'ע"קפה .כ',
(0.0 + (REALQUANT(SERIAL.QUANT – (ALINE.QUANT + ALINE.SQUANT)) * -1))
AS 'םיחוויד שרפה תרקב',
REALQUANT(ALINE.XXXX_TOTREP) AS 'חוודמ םיניקת תומכ ךס',
(A= 0 ? 1 : 0) AS '1',
(0.0 + (REALQUANT(SERIAL.QUANT -XXXX_TOTREP))) AS 'םיחוויד שרפה תרקב',
USERSB5.SNAME AS 'דבוע םש',
USERSB5.USERID AS 'דבוע \'סמ',
ALINE.XXXX_AMPERSHAA AS 'העש/רפמא',
REALQUANT(ALINE.XXXX_TOTREP) AS 'םיניקת תומכ ךס',
PART.PARTDES AS 'רצומ רואת',
ALINE.LINE AS 'הרוש'
FROM ALINEEMP ?, USERSB USERSB5 ?, ACT , PART , SERIAL , ALINE
, AFORM , WORKC
WHERE (ALINE.SERN = USERSB5.USERB)
AND (ALINE.AL = ALINEEMP.AL)
AND (ALINE.ACT = ACT.ACT)
AND (ALINE.WORKC = WORKC.WORKC)
AND (SERIAL.PART = PART.PART)
AND (ALINE.FORM = AFORM.FORM)
AND (ALINE.SERIAL > 0)
AND (ALINE.SERIAL = SERIAL.SERIAL)
AND ( 1=1 )
GROUP BY 1, 2, 3, 4, 5, 6, 7, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19,
20
;
.
