00
'','','','','','',''
SELECT ol.OBITNO AS ITEMNO,
ol.OBITDS AS ITEMNAME,
CONVERT(DECIMAL(10,2),sum(ol.OBORQA)) AS QTY,
CONVERT(DECIMAL(10,2),sum(ol.OBORQA*ol.OBNEPR)) AS NET_AMOUNT,
case
WHEN oh.OAORTP in('021','921') THEN 'CREDIT'
WHEN oh.OAORTP in('051') THEN 'PC'
WHEN oh.OAORTP in('031','035') THEN 'CASH'
WHEN oh.OAORTP in('011','911') THEN 'MT'
WHEN oh.OAORTP in('041','941') THEN 'IDS'
END AS CHANNEL,
it.MMITGR AS WEIGHT
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO
INNER JOIN MVXJDTA.CMNUSR as cm ON oh.OASMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '00%') AND
(oh.OAORTP IN ()) AND
(((oh.OAORST between '22' and '77') OR (oh.OAORST in ('99'))) and (oh.OAORSL not in('99'))) AND
(ol.OBORST not in ('90','99')) AND
(ol.OBSAPR<=0)
AND (ol.OBORQA>='1')
AND (ol.OBITNO in('','','','','','',''))
GROUP BY oh.OAORTP,ol.OBITNO,ol.OBITDS,it.MMITGR
ORDER BY oh.OAORTP,it.MMITGR ASCSUMMARY
ItemCode |
ItemName |
Qty |
Amount |
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'., SQL state 37000 in SQLExecDirect in E:\www\_mango2\ps\use_ps_get_free_item.php on line 97
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\_mango2\ps\use_ps_get_free_item.php on line 99
|
| TOTAL |
|
0.00 |
0.00 |