Woozle: extracted from "discarded" page

2016-03-02T21:58:10Z

extracted from "discarded" page

New page

==Details==
* '''Status''': deleted (uses old restock table, and no longer works)
* '''Requires''': {{vbzcart/table|core_restocks}}
* '''Used by''': {{l/same|qryCbx_Restocks}}
==SQL==
<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks_byPurchOrd AS
SELECT
r.ID,
CAST(r.PurchOrdNum AS CHAR) AS Descr,
NOT IsLocked AS IsOpen,
r.WhenOrdered,
r.WhenReceived,
r.WhenConfirmed,
r.ID_Supplier
FROM core_restocks AS r WHERE r.PurchOrdNum IS NOT NULL
ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;</mysql>

VbzCart/queries/discarded/qryCbx Restocks byPurchOrd - Revision history

Woozle: extracted from "discarded" page