אני עובד בגריסה 13
מצ"ב DUMB :
/*
*
* Report ORDERSBYCUST : לקוח לפי הזמנות
*
*/
/* לקוח לפי הזמנות */
SELECT CUSTOMERS.CUSTNAME AS 'לקוח .מס', CUSTOMERS.CUSTDES AS 'לקוח שם',
ORDERS.ORDNAME AS 'הזמנה', ORDERITEMS.DUEDATE AS 'אספקה .ת', PART.PARTNAME
AS 'ט"מק', RSTRIND(STRCAT(' ',
((NONSTANDARD.TEXT " ? NONSTANDARD.TEXT : PART.PARTDES))), 1, 48) AS
'מוצר תאור', REALQUANT(ORDERITEMS.TQUANT) AS 'כמות', REALQUANT(ORDERITEMS.TBALANCE)
AS 'לאספקה יתרה', UNIT1.UNITNAME AS '\'יח', (0.0 + ((ORDERITEMS.QPRICE
* (100.0 – ORDERS.PERCENT) / 100.0 ))) AS 'כולל מחיר', (0.0 + (ORDERITEMS.QPRICE
* (100.0 – ORDERS.PERCENT) / 100.0 * ORDERITEMS.TBALANCE / ORDERITEMS.TQUANT))
AS 'יתרה שווי', CURRENCIES.CODE AS 'מטבע', (0.0 + ((((ORDERITEMS.QPRICE
* (100.0 – ORDERS.PERCENT) / 100.0 ))) * CURRENCIES.EXCHANGE)) AS 'בשקלים כולל מחיר',
CPROFTYPES.TYPECODE AS 'הזמנה סוג', CPROFTYPES.TYPEDES AS 'הזמנה סוג תאור',
PORDERITEMSA.PACK AS '(ID) אריזה', PORDERITEMSA.MATRIXSERIAL AS '(ID) מטריצה ע"פק',
ORDERITEMS.LINE AS 'שורה'
FROM ORDSTATUS , NONSTANDARD ?, PORDERITEMSA , CURRENCIES , UNIT
UNIT1 , ORDERITEMS , CPROFTYPES , PART , ORDERS , CUSTOMERS
WHERE (ORDSTATUS.MANAGERREPOUT 'Y')
AND (ORDERS.ORDSTATUS = ORDSTATUS.ORDSTATUS)
AND (ORDERITEMS.NONSTANDARD = NONSTANDARD.NONSTANDARD)
AND (ORDERS.FORECASTFLAG 'S'
AND ORDERS.FORECASTFLAG 'F')
AND (ORDERS.ORDTYPE = CPROFTYPES.CPROFTYPE)
AND (ORDERITEMS.TUNIT = UNIT1.UNIT)
AND (ORDERS.CLOSED = (:CLS = 'Y' ? '\0' : ORDERS.CLOSED))
AND (ORDERITEMS.CLOSED = (:CLS = 'Y' ? '\0' : ORDERITEMS.CLOSED))
AND (ORDERS.CUST = CUSTOMERS.CUST)
AND (ORDERITEMS.CURRENCY = CURRENCIES.CURRENCY)
AND (ORDERITEMS.PART = PART.PART)
AND (ORDERITEMS.ORD = ORDERS.ORD)
AND (ORDERITEMS.DUEDATE BETWEEN :FDT
AND :TDT)
AND ( 1=1 )
ORDER BY 1 ASC, 3 ASC, 18 ASC ;
.
