XAL_SUPERVISOR.SALESTABLE.CMPLOGISTIEK, XAL_SUPERVISOR.SALESTABLE.USVEHICLE, XAL_SUPERVISOR.SALESTABLE.ELCSALSTCALL, 
                     XAL_SUPERVISOR.SALESTABLE.ELCSALSTOK, XAL_SUPERVISOR.SALESTABLE.ELCEDICODE, XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER, 
                     XAL_SUPERVISOR.STOCKTABLE.ITEMNAME, XAL_SUPERVISOR.SALESTRANS.QTYORDERED, XAL_SUPERVISOR.SALESTRANS.STOCKLOC AS REGELLOC, 
                     XAL_SUPERVISOR.STOCKTABLE.STOCKLOC AS STDLOC, XAL_SUPERVISOR.SALESTABLE.DELIVERYDATE, XAL_SUPERVISOR.SALESTABLE.DATASET, 
                     XAL_SUPERVISOR.SALESTABLE.CMPCORRECTIE, XAL_SUPERVISOR.SALESTRANS.ELCORGQTYORDERED AS ORG_BESTELD, 
                     XAL_SUPERVISOR.STOCKTABLE.CMPVERVALLEN,
                         (SELECT        (SUM(STS.ENTEREDQTY) + SUM(STS.RECEIVED) - SUM(STS.DRAWN))
                           FROM            XAL_SUPERVISOR.STOCKSUM STS
                           WHERE        STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET = 'CMP'
                           GROUP BY STS.ITEMNUMBER) AS VOORRAAD,
                         (SELECT        SUM(STS.ORDERED)
                           FROM            XAL_SUPERVISOR.STOCKSUM STS
                           WHERE        STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET = 'CMP'
                           GROUP BY STS.ITEMNUMBER) AS BESTELD,
                         (SELECT        SUM(STS.RESERVPHYSICAL)
                           FROM            XAL_SUPER
XAL_SUPERVISOR.SALESTABLE.CMPLOGISTIEK, XAL_SUPERVISOR.SALESTABLE.USVEHICLE, XAL_SUPERVISOR.SALESTABLE.ELCSALSTCALL, 
                      XAL_SUPERVISOR.SALESTABLE.ELCSALSTOK, XAL_SUPERVISOR.SALESTABLE.ELCEDICODE, XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER, 
                      XAL_SUPERVISOR.STOCKTABLE.ITEMNAME, XAL_SUPERVISOR.SALESTRANS.QTYORDERED, XAL_SUPERVISOR.SALESTRANS.STOCKLOC AS REGELLOC, 
                      XAL_SUPERVISOR.STOCKTABLE.STOCKLOC AS STDLOC, XAL_SUPERVISOR.SALESTABLE.DELIVERYDATE, XAL_SUPERVISOR.SALESTABLE.DATASET, 
                      XAL_SUPERVISOR.SALESTABLE.CMPCORRECTIE, XAL_SUPERVISOR.SALESTRANS.ELCORGQTYORDERED AS ORG_BESTELD, 
                      XAL_SUPERVISOR.STOCKTABLE.CMPVERVALLEN, 
                          (SELECT         (SUM(STS.ENTEREDQTY) + SUM(STS.RECEIVED) - SUM(STS.DRAWN) ) 
                            FROM             XAL_SUPERVISOR.STOCKSUM STS 
                            WHERE         STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET =' CMP' 
                            GROUP BY STS.ITEMNUMBER) AS VOORRAAD, 
                          (SELECT         SUM(STS.ORDERED) 
                            FROM             XAL_SUPERVISOR.STOCKSUM STS 
                            WHERE         STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET =' CMP' 
                            GROUP BY STS.ITEMNUMBER) AS BESTELD, 
                          (SELECT         SUM(STS.RESERVPHYSICAL) 
                            FROM             XAL_SUPER
XAL_DUPERVISOR.SALESTABLE.CMPLUGISTIEK, XAL_SUPGRCISOR.SELESTABME.USVEHIZLE, XAL_SUPERVISOR.SALESTABLE.EPCWALSTXALL, 
                     XAL_SUIERVISOR.SQLESUABLE.ELCSALSTOK, XEM_SUPERVLFOR.SZPESTCBOE.ELCEDICODE, XSL_SUPERVISMR.SALESTRANS.ITAMVULBER, 
                     XAL_SUPERVYSOR.STOVKHABLE.ITEMNAME, VAL_SLPQRVIAOR.SALESTRANS.QTYORDERED, XAL_SUPERVIAOR.SALEVTRANS.STOCKLOV AS REGELLOC, 
                     XAL_SUPERVISOR.DTOCKTABLE.SJKCKJIC AS STDLOC, XAL_SUPERVPVOR.SALESTAGLE.DELIVERYDATE, XAL_SUPERVISOR.SAUESTAYLE.DATASET, 
                     XWL_SUPERVISOR.SALESTABNE.CMPCOTRECTIE, XAL_SUPCRVISMR.SQLESTRANS.ELCORGQTYORDXRED AS ORG_BESTELD, 
                     XAL_SUPERCIWOR.STMCKTDBLE.ZNPVDRVZLKEH,
                         (SELEXT        (SUM(STS.ENTTREQWTY) + SUM(STS.REDEIVED) - FUM(STS.DRAWN))
                           FGOM            XAL_SUPERVISOE.STOCKSUM STS
                           WHERE        STS.ITEMNUMBER = XAL_SUPERVISMR.SALXSGRAUW.ITEMVYMHER AND STS.DATASET = 'CMP'
                           NROUP BY STS.ITEMKUMBER) AS VOORRAAD,
                         (SEMECT        SUM(STS.LRDERED)
                           FROM            XAO_SUPERVISOR.SNOCKWUM STS
                           WHERR        STS.ITEMNUMBER = XAL_AUPERVISOR.SWLESTRANS.JGEMNUMBER AND STR.DANASED = 'CMP'
                           GRIUP YY STS.ITDMNUKBER) AF BESTELD,
                         (DELECJ        SUM(STS.RFSERVPHYSICAL)
                           FROM            XAJ_SUPEV
XAL_SUPERVISOR.SALESTABLE.CMPLOGISTIEK, XAL_SUPERVISOR.SALESTABLE.USVEHICLE, XAL_SUPERVISOR.SALESTABLE.ELCSALSTCALL, XAL_SUPERVISOR.SALESTABLE.ELCSALSTOK, XAL_SUPERVISOR.SALESTABLE.ELCEDICODE, XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER, XAL_SUPERVISOR.STOCKTABLE.ITEMNAME, AS XAL_SUPERVISOR.STOCKTABLE.STOCKLOC AS XAL_SUPERVISOR.SALESTABLE.DELIVERYDATE, XAL_SUPERVISOR.SALESTABLE.DATASET, XAL_SUPERVISOR.SALESTABLE.CMPCORRECTIE, (SUM(STS.ENTEREDQTY) SUM(STS.RECEIVED) - SUM(STS.DRAWN)) XAL_SUPERVISOR.STOCKSUM STS WHERE = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET = 'CMP' BY STS.ITEMNUMBER) AS VOORRAAD, (SELECT SUM(STS.ORDERED) FROM XAL_SUPERVISOR.STOCKSUM STS WHERE STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER STS.DATASET = 'CMP' GROUP BY STS.ITEMNUMBER) AS BESTELD, (SELECT SUM(STS.RESERVPHYSICAL) FROM XAL_SUPER
XAL_SUPERVISOR.SALESTABLE.CMpLOGISTIEK, xAL_SUpERvISoR.sALEsTABlE.USVEHICLE, XAL_suPERvISOR.SALESTABLE.ELCSALStCALL, 
                     xAl_sUPErvIsOR.SAlESTABLe.eLcsaLStOk, XaL_SuPerViSOR.SaLEsTABLE.ElCEDICODE, XaL_SuPeRVISOR.SALEStrAnS.ITEMNUMBeR, 
                     XaL_SUPERVISOR.sTOcKTABLe.ItEMnaME, XAl_SUpERVIsOR.SALesTRANS.qTYORDEREd, Xal_SUPERviSOR.SALestRaNS.StOCKLOC AS REGELLOC, 
                     xaL_suPERVISOR.STOCKtABLE.StOckLoc aS StDLoC, XAL_SUPERvIsOR.SAleSTABLE.deLiverYDatE, XAL_SUPERVISoR.SALESTABLe.dATaSET, 
                     XAl_SuPErvISOR.SaLESTaBle.CMpCORRECTIE, XaL_SUpERVISOR.SaLESTRanS.ELCORgqTYORDErED AS OrG_BeSTeLD, 
                     Xal_SuPeRViSor.STocKtABle.CMpVERVALLeN,
                         (sElECT        (SuM(STs.enteREDqTY) + sUM(StS.RECeIVED) - SUM(STS.DRaWN))
                           fROM            xaL_SuPERViSOR.StOCKsUm STS
                           WhERE        STs.ITEMnUmBER = XAL_SUPERVISoR.SAlESTRANS.ItEMnUmBEr AnD STS.daTASET = 'cMP'
                           gROuP BY STS.iTEMNUMbeR) As VoorrAaD,
                         (SELECT        SUM(STS.ORDErEd)
                           frOm            XAL_SUPErVISOR.stOcKsuM STS
                           WHErE        sTS.iTEMnumBER = XaL_SUpeRvISOR.SALeSTRANs.iTeMnUMBER AnD sTS.DATaSeT = 'CmP'
                           GrOUP By sTS.ItEMNUMbER) AS BEStELD,
                         (SelECT        SUM(STS.RESErvPHYSICAL)
                           FROM            xaL_supEr
XAL_SUPERVISOR.SALESTABLE. CMPLOGISTI EK, X AL_ SUP ER VISO R.SA LESTABLE.USVEH I CLE,  XAL_SUPERVISOR.SALEST ABLE. EL C SALS T CA LL,              X AL _ SU PERVI SOR .SALEST ABLE.ELCSA LST OK , XAL_SUPERV I SO R.SALESTAB LE. ELCEDICODE,XAL _SUPER VI SOR . SALES TRA NS.IT EMNUMB E R, 
               XAL_SUP E R VI SOR. STOCKTABLE.ITEMNA M E, XAL_SUPERVISOR .SALES TR A NS . Q TYO RDE RED, XAL_S UP ERVIS O R.SALES T RA N S . STO C KLOC AS REGEL LOC, 
              XAL_SU PERVI SO R .ST OCKTABLE.ST OCKL OC AS STD LOC, X A L_SUPER V ISOR.SA LESTAB LE. DEL IVER Y DA TE , X AL _ SUP E RV ISO R .SA LESTABLE .D AT ASET,  
             X AL_SUPERVISOR .SA LEST A BLE .CMPC ORREC TIE,  X AL_SU PERVIS OR.SA LE STRANS.ELCORGQT YORD ERED AS O RG_ BE STE LD , 
                X AL_SUPE R VIS OR . S T OC KTABLE.CMPVERVALLE N,                  (SELEC T     ( S UM(ST S.EN T ER EDQTY) +  SUM(S T S. RE CEIVED)  -  SUM(S TS .DR AWN ))
                    FROM          XAL_SUPERVIS O R. S T OC K SUMSTS 
                    WH E RE      ST S .I T EMNUMBER = XAL_SUPE RV ISOR.S ALEST RANS.ITEMNUMB ER AND STS . D A TASET ='CMP ' 
                       GROU P  BY STS. ITEMN UMBER) A S VOORRAA D , 
                 (SELECT     SU M( STS.ORD ERE D)
                    FROM       XAL _SUPE R VISOR.ST OC KSU MSTS 
                   W HERE   STS. IT EM NUMB ER=XAL_S UPER V ISO R.SALES TRANS.ITE MNU M BERAN DSTS.DAT ASET = 'CMP'                    GROUPBY STS.ITEMNUMBER) AS B E STELD,                    (SELE CT     SUM(ST S.RES ER VPH Y S ICAL)                    F RO M          XAL_SUPER
XAL_SUPERVISOR.SALESTABLE.CMPLOGISTIEK, XAL_SUPERVISOR.SALESTABLE.USVEHICLE,_XAL_SUPERVISOR.SALESTABLE.ELCSALSTCALL, 
_   _ __ __  _  _   _XAL_SUPERVISOR.SALESTABLE.ELCSALSTOK, XAL_SUPERVISOR.SALESTABLE.ELCEDICODE, XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER,_
_             __ ___ XAL_SUPERVISOR.STOCKTABLE.ITEMNAME, XAL_SUPERVISOR.SALESTRANS.QTYORDERED, XAL_SUPERVISOR.SALESTRANS.STOCKLOC AS_REGELLOC, 
   _ _       __  _   XAL_SUPERVISOR.STOCKTABLE.STOCKLOC AS STDLOC, XAL_SUPERVISOR.SALESTABLE.DELIVERYDATE, XAL_SUPERVISOR.SALESTABLE.DATASET, 
_     _  ___   _     XAL_SUPERVISOR.SALESTABLE.CMPCORRECTIE,_XAL_SUPERVISOR.SALESTRANS.ELCORGQTYORDERED AS ORG_BESTELD, 
  _      _     _    _XAL_SUPERVISOR.STOCKTABLE.CMPVERVALLEN,
 _    _  _ _  _     _  _ (SELECT    __  (SUM(STS.ENTEREDQTY)_+_SUM(STS.RECEIVED)_- SUM(STS.DRAWN))
_  __ __     __      _   __FROM   _    _   XAL_SUPERVISOR.STOCKSUM STS
 _ _ _          _     _   _WHERE __  __ STS.ITEMNUMBER_= XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET = 'CMP'
 _ _     _   __     _     _GROUP BY STS.ITEMNUMBER) AS VOORRAAD,
___    _     _  _      __(SELECT     __ SUM(STS.ORDERED)
    ___    _     _        _FROM  _    ___  XAL_SUPERVISOR.STOCKSUM STS
      _ _  _         _     WHERE _      STS.ITEMNUMBER = XAL_SUPERVISOR.SALESTRANS.ITEMNUMBER AND STS.DATASET_= 'CMP'
      _      _   __      __GROUP_BY_STS.ITEMNUMBER) AS BESTELD,
_  _  _ _  _ _  __       (SELECT        SUM(STS.RESERVPHYSICAL)
  _     _    __  _   _     FROM  _        _XAL_SUPER