/*
*
* Report OPENCUSTORDERSN2 : פקעות פתוחות הזמנות
*
*/
/* הזמנות פתוחות פקעות */
SELECT CUSTOMERS.CUSTNAME AS 'לקוח .מס',
CUSTOMERS.CUSTDES AS 'לקוח שם',
ACCOUNTS.ACCDES AS 'חשבון תאור',
ACCOUNTS.ACCNAME AS 'חשבון \'מס',
CUSTOMERS.PHONE AS 'טלפון מספר',
ORDERS.ORDNAME AS 'הזמנה',
ORDERS.CURDATE AS 'תאריך',
ORDERS.REFERENCE AS '(לקוח) רכש .הז',
AGENTS.AGENTNAME AS 'סוכן שם',
CPROF.CPROFNUM AS 'מחיר הצעת',
USERS2.USERLOGIN AS 'לביצוע',
CURRENCIES.CODE AS 'מטבע',
(0.0 + (CURRENCIES.EXCHANGE * CURRENCIES.EXCHQUANT)) AS 'חליפין שער',
PART.PARTNAME AS 'פריט מספר',
RSTRIND(STRCAT(' ', ((NONSTANDARD.TEXT
" ? NONSTANDARD.TEXT : PART.PARTDES))), 1, 96) AS 'פריט תאור',
SERIAL.SERIAL AS 'ע"פק',
ORDERITEMS.DUEDATE AS 'אספקה .ת',
REALQUANT(ORDERITEMS.TQUANT) AS 'בהזמנה כמות',
REALQUANT(ORDERITEMS.TBALANCE) AS 'לאספקה יתרה',
UNIT1.UNITNAME AS '\'יח',
ORDERITEMS.PRICE AS 'ליחידה מחיר',
CURRENCIES1.CODE AS 'מטבע',
ORDERITEMS.PERCENT AS '(%)לשורה הנחה',
ORDERS.PERCENT 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 * ORDERITEMS.TBALANCE
/ ORDERITEMS.TQUANT) * (CURREGITEMS.EXCHANGE = 0.0 ? CURRENCIES.EXCHANGE
: CURREGITEMS.EXCHANGE))) AS 'ישראלי בשקל סופי מחיר',
CPROFTYPES.TYPECODE AS 'הזמנה סוג',
CPROFTYPES.TYPEDES AS 'הזמנה סוג תאור',
ORDERITEMS.LINE AS 'שורה'
FROM CURREGITEMS ?, NONSTANDARD ?, CURRENCIES CURRENCIES1 , UNIT UNIT1
, ORDERITEMS , CURRENCIES , USERS USERS2 , CPROF ?, AGENTS ?, ACCOUNTS
, CPROFTYPES , SERIAL , PART , ORDERS , CUSTOMERS
WHERE (ORDERS.CURRENCY = CURREGITEMS.CURRENCY)
AND (ORDERS.ORDTYPE = CPROFTYPES.CPROFTYPE)
AND (AGENTS.AGENT = ORDERS.AGENT)
AND (ORDERITEMS.NONSTANDARD = NONSTANDARD.NONSTANDARD)
AND (ORDERS.FORECASTFLAG 'S'
AND ORDERS.FORECASTFLAG 'F')
AND (ORDERITEMS.TUNIT = UNIT1.UNIT)
AND (ORDERS.DOER = USERS2.USER)
AND (ORDERITEMS.CLOSED = '\0')
AND (ORDERITEMS.ICURRENCY = CURRENCIES1.CURRENCY)
AND (ORDERS.CLOSED = '\0')
AND (CUSTOMERS.ACCOUNT = ACCOUNTS.ACCOUNT)
AND (ORDERS.PROF = CPROF.PROF)
AND (ORDERS.CUST = CUSTOMERS.CUST)
AND (ORDERITEMS.CURRENCY = CURRENCIES.CURRENCY)
AND (ORDERITEMS.PART = PART.PART)
AND (ORDERITEMS.ORD = ORDERS.ORD)
AND (SERIAL.ORDI = ORDERITEMS.ORDI)
AND (ORDERITEMS.TBALANCE > 0
AND ORDERITEMS.TQUANT > 0 OR (ORDERITEMS.TBALANCE < 0
AND ORDERITEMS.TQUANT < 0))
AND (ORDERITEMS.DUEDATE BETWEEN :FDT
AND :TDT)
AND ( 1=1 )
ORDER BY 1 ASC, 6 ASC, 30 ASC ;
.
