export const qrequestQuery = `
select IdArtikelVarianten as article,
ArtikelVariantenBez as description,
Lfdnr as runningNr,
Produktionslos as lotNr,
IdWarenlager as idWarehouse,
WarenLagerKurzBez as warehouseAtRequest,
IdLagerAbteilung as idLocation,
LagerAbteilungKurzBez as locationAtRequest,
BewegungsDatumMax as lastMove
from AlplaPROD_test1.dbo.V_LagerPositionenBarcodes (nolock)

where /* VerfuegbareMengeSum = 0 and */ IdLagerAbteilung  not in (0, 20000, 21000) and lfdnr = [runningNumber] 
`;
