תוספת עמודת חישוב

[left][right]
/* ע"קפל חוויד ןמז לומ ןקת ןמז */
SELECT SERIAL.SERIALNAME AS 'ע"קפ',
PART.PARTNAME AS 'ט"קמ',
PART.PARTDES AS 'רצומ רואת',
ACT.ACTDES AS 'הלועפ רואת',
ACT.ACTNAME AS 'הלועפ',
WORKC.WORKCNAME AS 'הדובע זכרמ',
ORDERS.ORDNAME AS 'הנמזה',
( (SUM(ALINE.EMPASPAN))) AS 'דבוע ןמז ךס',
( ( (SUM(ALINE.EMPASPAN))) /(INTQUANT(REALQUANT(((SUM(ALINE.QUANT))+(SUM(ALINE.MQUANT)))/1000))))
AS 'הדיחיל לעופב ןמז',
(REALQUANT(SUM(ALINE.QUANT))),
(REALQUANT(SUM(ALINE.SQUANT))),
(SUM(ALINE.MQUANT)),
(STRIND(STRCAT((STRCAT(ITOA(((( /* (INTQUANT(AVG((PARTVAR5.SIZE)))/1000)
* ((SUM(ALINE.QUANT)) + (SUM(ALINE.MQUANT)))/1000 */ (INTQUANT(AVG((PARTVAR5.SIZE)))/1000)))/60)),':',ITOA((((
/* (INTQUANT(AVG((PARTVAR5.SIZE)))/1000) * ((SUM(ALINE.QUANT)) + (SUM(ALINE.MQUANT)))/1000
*/ (INTQUANT(AVG((PARTVAR5.SIZE)))/1000))) MOD 60)))), ' '), 1, 7))
AS 'ןקת ןמז',
UNIT.UNITNAME AS '\'חי',
ALINE.TYPE AS 'רזוח דוביע',
((STRCAT(ITOA(((( /* (INTQUANT(AVG((PARTVAR5.SIZE)))/1000) * ((SUM(ALINE.QUANT))
+ (SUM(ALINE.MQUANT)))/1000 */ (INTQUANT(AVG((PARTVAR5.SIZE)))/1000)))/60)),':',ITOA((((
/* (INTQUANT(AVG((PARTVAR5.SIZE)))/1000) * ((SUM(ALINE.QUANT)) + (SUM(ALINE.MQUANT)))/1000
*/ (INTQUANT(AVG((PARTVAR5.SIZE)))/1000))) MOD 60))))-( ( (SUM(ALINE.EMPASPAN)))
/(INTQUANT(REALQUANT(((SUM(ALINE.QUANT))+(SUM(ALINE.MQUANT)))/1000)))))
AS 'לעופב-ןקת שרפה'
FROM ORDERITEMS ?, VAR VAR5 ?, PARTVAR PARTVAR5 ?, ALINE , UNIT ,
WORKC , ORDERS ?, ACT , PART , SERIAL
WHERE (ORDERITEMS.ORD = ORDERS.ORD)
AND (SERIAL.ORDI = ORDERITEMS.ORDI)
AND (PARTVAR5.PARAM = 'E')
AND (PART.PART = PARTVAR5.PART)
AND (PARTVAR5.VAR = VAR5.VAR)
AND (PARTVAR5.ACT = ACT.ACT)
AND (ALINE.ACT = ACT.ACT)
AND (ALINE.WORKC = WORKC.WORKC)
AND (SERIAL.PART = PART.PART)
AND (ALINE.SERIAL > 0)
AND (ALINE.SERIAL = SERIAL.SERIAL)
AND (PART.UNIT = UNIT.UNIT)
AND (PARTVAR5.VALID = 'Y')
AND ( 1=1 )
GROUP BY 1, 2, 3, 4, 5, 6, 7, 14, 15
;