Advertisement
psi_mmobile

Untitled

Dec 10th, 2020
1,378
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 31.09 KB | None | 0 0
  1. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Opleidingscentrum Gentbrugge (lessen, MO, lessen) /  Centre de formation Gentbrugge (formations, MO, cours)' WHERE ERP_ID ='1503';
  2. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Opleidingscentrum Sodemat Strée (opleiding, MU, lessen..) / Centre de Formation Sodemat Strée (formations, MO, cours..)' WHERE ERP_ID ='1504';
  3. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenparkt techniekers SDM / Véhicules techniciens SDM' WHERE ERP_ID ='1505';
  4. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenpark SDM Electriciens / Véhicules Electriciens SDM' WHERE ERP_ID ='1506';
  5. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenpark SDM Techniekers Kranen (herstelling) / Véhicules Techniciens SDM Grues (reparations)' WHERE ERP_ID ='1507';
  6. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenpark Lassers / Véhicules soudeurs' WHERE ERP_ID ='1508';
  7. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties Magazijn / Prestations Magasin' WHERE ERP_ID ='1509';
  8. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Checkin@work / Checkin@work' WHERE ERP_ID ='1510';
  9. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik Klein materieel Lasatelier / Petit matériel atelier de soudage' WHERE ERP_ID ='1511';
  10. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Kranen / Petit matériel grues' WHERE ERP_ID ='1512';
  11. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik Klein materieel Containers / Petit matériel containers' WHERE ERP_ID ='1513';
  12. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik atelier / Petit matériel atelier' WHERE ERP_ID ='1514';
  13. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Meubelen voor werven,brandblustoeste / Meubles pour chantiers + extincteurs' WHERE ERP_ID ='1515';
  14. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruiksproducten zoals nagels,bind / Consommables' WHERE ERP_ID ='1516';
  15. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren voor topo-,meet- en labo / Accessoires topo' WHERE ERP_ID ='1517';
  16. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren elektrische installatiema / Accessoires électricité' WHERE ERP_ID ='1518';
  17. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren electrisch materieel / Accessoires matériel électrique' WHERE ERP_ID ='1519';
  18. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Kleine toebehoren kraanspoor / Accessoires voies grues' WHERE ERP_ID ='1520';
  19. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren pompen:slangen,aanzuigkor / Accessoires pompes' WHERE ERP_ID ='1521';
  20. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Werfgereedschappen en zaagbladen hou / Outils de chantiers : lames ..' WHERE ERP_ID ='1522';
  21. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Ladders in staal,aluminium,hout / Echelles alu, bois, ..' WHERE ERP_ID ='1523';
  22. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren voor bekisting:trekstaven / Accessoires de coffrage' WHERE ERP_ID ='1524';
  23. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren lastenbehandeling:ketting / Accessoires de levage : chaines' WHERE ERP_ID ='1525';
  24. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Toebehoren compressoren en pneumatis / Accessoires compresseurs, pneumatique' WHERE ERP_ID ='1526';
  25. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Onderhoud algemeen / Entretien général' WHERE ERP_ID ='1527';
  26. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Betonneermateriaal / Matériel de de bétonnage' WHERE ERP_ID ='1528';
  27. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop materieel voor containers :slot,vuilbak,kapstok .. / Vente matériel pour containers :serrures, poubelle, porte-ma' WHERE ERP_ID ='1529';
  28. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur containers + inhoud Sodemat / loc containers + contenu Sodemat' WHERE ERP_ID ='1530';
  29. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Keuringen / Inspections techniques' WHERE ERP_ID ='1531';
  30. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur betonneermateriaal / locaton matériel de bétonnage' WHERE ERP_ID ='1532';
  31. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling topo- en meettoestellen / Réparation appareils topo et de mesurage' WHERE ERP_ID ='1533';
  32. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur topo- en meettoestellen Sodemat / Location appareils topo et de mesurage Sodemat' WHERE ERP_ID ='1534';
  33. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Betontrillers:omvormers;naalden enz / Aiguilles' WHERE ERP_ID ='1536';
  34. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur damplanken / loc palplanche' WHERE ERP_ID ='1537';
  35. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur torenkranen Yongmao Vuylsteke / Location grues à tour Yongmao Vuylsteke' WHERE ERP_ID ='1538';
  36. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur torenkranen en onderdelen Sodemat / location  grues à tour + éléments Sodemat' WHERE ERP_ID ='1539';
  37. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Torenkranen ;snelmontagetorenkranen / Grues tour, + montage rapide' WHERE ERP_ID ='1540';
  38. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling Lichtreclame 2018 - NIET FACTUREREN / Réparation panneaux publicitaires - PAS A FACTURER' WHERE ERP_ID ='1541';
  39. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Telescopische kranen / Grues télescopiques' WHERE ERP_ID ='1542';
  40. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Betonbakken / Bacs de béton' WHERE ERP_ID ='1544';
  41. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Personen- en lastenliften / Monte charges + personnes' WHERE ERP_ID ='1545';
  42. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Elektrische palletrol / Transpalette électrique' WHERE ERP_ID ='1546';
  43. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Vorkhefliften elektrisch en diesel / Chariots élévateurs électr + diesel' WHERE ERP_ID ='1547';
  44. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Ruw terrein telescopische stapelaars / Gerbeurs télescopiques' WHERE ERP_ID ='1548';
  45. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Spoor en toebehoren / Voies et accessoires' WHERE ERP_ID ='1549';
  46. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Grondwerk / Terrassement' WHERE ERP_ID ='1550';
  47. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Dumper klein / Dumper petit' WHERE ERP_ID ='1551';
  48. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur mobiele hijskranen / Location grues mobiles de levage' WHERE ERP_ID ='1552';
  49. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Kabelkranen op rupsen / Grues treillis sur chenilles' WHERE ERP_ID ='1553';
  50. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Telescopische rupskraan / Grue treillis télescopiques' WHERE ERP_ID ='1554';
  51. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Minigraafschop event met hydraulisch / Minipelle' WHERE ERP_ID ='1555';
  52. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Miniladers en schrankladers / Chargeuses compactes' WHERE ERP_ID ='1556';
  53. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Trilplaten en trilstampers / Plaques vibrantes' WHERE ERP_ID ='1557';
  54. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Trilwalsen / Rouleaux vibrants' WHERE ERP_ID ='1558';
  55. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Heftransport / transport mat levage' WHERE ERP_ID ='1559';
  56. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Pompen: dompelpompen .. / Pompe : submersibles ..' WHERE ERP_ID ='1561';
  57. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop klein verbruiksmaterieel divers / Vente petit matériel / consommables  divers' WHERE ERP_ID ='1562';
  58. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur divers materieel (manutentie; bakken enz) / location matériel divers (manutention: bennes, broches etc)' WHERE ERP_ID ='1563';
  59. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur  tanks en supports / location réservoirs et supports' WHERE ERP_ID ='1564';
  60. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Diversen materieel / Divers matériel' WHERE ERP_ID ='1565';
  61. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop veiligheidsmaterieel (blussers-EHBO koffer ..) / Vente matériel de sécurité (extincteurs- trousse de secours)' WHERE ERP_ID ='1566';
  62. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = ' Verhuur veiligheidsmaterieel (harnas, leeflijn..) / Location matériel de sécurité (harnais, longe ..)' WHERE ERP_ID ='1567';
  63. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Pneumatische hamers  / Marteaux pneumatiques' WHERE ERP_ID ='1568';
  64. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'breekmaterieel / Matériel de démolition' WHERE ERP_ID ='1569';
  65. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur compressor, breekmaterieel / Location compresseur,  matériel de démolition' WHERE ERP_ID ='1570';
  66. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Stroomgroepen / Groupes électrogènes' WHERE ERP_ID ='1571';
  67. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Transformatieposten en HS-transfo's / Postes de transof + transfo HT' WHERE ERP_ID ='1572';
  68. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Elektrische verdeelkasten en  LS-ins / Armoires électriques' WHERE ERP_ID ='1573';
  69. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop electrisch distr. materieel SDM (kabels, contacten) / Vente matériel de distrib. électrique SDM (prises, câbles)' WHERE ERP_ID ='1574';
  70. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur electrisch materieel Sodemat (groepen) / Location matériel électrique Sodemat (groupes)' WHERE ERP_ID ='1575';
  71. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur verlichting (schijnwerpers..) / Location éclairage (phares..)' WHERE ERP_ID ='1576';
  72. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur transport extern / Location transport par tiers' WHERE ERP_ID ='1577';
  73. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Vrachtwagen Sodemat Strée / Location Camion Sodemat Stree' WHERE ERP_ID ='1578';
  74. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Montage Torenkranen / Montage  Grue a tour' WHERE ERP_ID ='1579';
  75. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Installatie werfliften / Installation  monte-charge' WHERE ERP_ID ='1580';
  76. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Technische controle: periodiek, electrisch, indienststelling / Contrôle technique : périodique, électrique, mises en se' WHERE ERP_ID ='1582';
  77. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Installatie Prestaties Containers / Installation Prestations conteneurs' WHERE ERP_ID ='1583';
  78. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop mat. werfInstallatie (water,gas ..) / Vente mat. d'installation chantier :eau et gaz ..' WHERE ERP_ID ='1584';
  79. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Regieprestaties Lasatelier / Prestations en régie atelier de soudage' WHERE ERP_ID ='1585';
  80. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Inhuur materieel atelier / Location matériel atelier' WHERE ERP_ID ='1586';
  81. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie externe bekisting / Refacturation coffrage externe' WHERE ERP_ID ='1587';
  82. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur containers extern / Location  containers externes' WHERE ERP_ID ='1588';
  83. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur extern electrisch materieel / Location  matériel électrique externe' WHERE ERP_ID ='1589';
  84. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur  Grondwerkmachines extern / Location engins de terrassement externes' WHERE ERP_ID ='1591';
  85. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Torenkranen en toebehoren extern / Location de Grues à tour + accessoires externes' WHERE ERP_ID ='1592';
  86. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur mobiele externe hijskranen / Location grues de levage mobiles externes' WHERE ERP_ID ='1593';
  87. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Regieprestaties Opleidingsplatform extern :instructeur,mach / Prestation externe centre de formation :instructeur, machine' WHERE ERP_ID ='1594';
  88. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur rijplaten extern / Location plaques externes' WHERE ERP_ID ='1595';
  89. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling  bekisting SDM / Prestations réparation coffrage SDM' WHERE ERP_ID ='1597';
  90. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling bekisting extern / Refacturation réparation coffrage externe' WHERE ERP_ID ='1598';
  91. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling materieel electriciteit SDM / Prestations réparation matériel électricité SDM' WHERE ERP_ID ='1599';
  92. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling materieel electriciteit extern / Refacturation réparation matériel électricité externe' WHERE ERP_ID ='1600';
  93. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling grondwerkmaterieel SDM / Prestations réparation matériel de terrassement SDM' WHERE ERP_ID ='1601';
  94. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling materieel grondwerken extern / Refacturation réparation matériel de terrassement externe' WHERE ERP_ID ='1602';
  95. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Presaties herstelling ingehuurd hijsmaterieel SDM / Prestations réparation matériel de levage externe par SDM' WHERE ERP_ID ='1603';
  96. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling ingehuurd hijsmaterieel extern / Refacturation réparation matériel de levage externe' WHERE ERP_ID ='1604';
  97. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling extern materieel verhuur door SDM / Prestations réparation matériel externe location par SDM' WHERE ERP_ID ='1605';
  98. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie réparaton matériel externe location / Refacturation réparation matériel externe location' WHERE ERP_ID ='1606';
  99. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling extern materieel werfinrichting door SDM / Réparation matériel externe d'installation de chantier SDM' WHERE ERP_ID ='1607';
  100. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling extern materieel werfinrichting / Refacturation répar. matériel  installation chantier  extern' WHERE ERP_ID ='1608';
  101. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling materieel atelier sdm / Prestations réparation matériel atelier sdm' WHERE ERP_ID ='1609';
  102. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie  herstelling materieel atelier extern / Refacturation réparation matériel atelier extern' WHERE ERP_ID ='1610';
  103. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling containers SDM / Prestations réparation containers SDM' WHERE ERP_ID ='1611';
  104. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling containers extern / Refacturation réparation containers externe' WHERE ERP_ID ='1612';
  105. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties herstelling lasmaterieel SDM / Prestations réparation matériel de soudage SDM' WHERE ERP_ID ='1613';
  106. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Doorfacturatie herstelling lasmaterieel extern / Refacturation réparation matériel de soudage externe' WHERE ERP_ID ='1614';
  107. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop bekistingsmaterieel  algemeen (incl bandijzer..) / Vente matériel de coffrage général (incl. feuillard..)' WHERE ERP_ID ='1615';
  108. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur  bekisting algemeen / Location  coffrage général' WHERE ERP_ID ='1616';
  109. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur framax bekisting / Location  coffrage  Framax' WHERE ERP_ID ='1617';
  110. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Tafelzaagmachines, steenzaagen / Tables scie,' WHERE ERP_ID ='1618';
  111. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur ondersteuning : schoren, kaders / Location soutènement : étais, cadres ..' WHERE ERP_ID ='1619';
  112. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur houten balken / Location poutres en bois' WHERE ERP_ID ='1620';
  113. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Zend- en ontvangstoestellen;camera's, walkie-talkie / Walkie talkie ; caméras, matériel de communication' WHERE ERP_ID ='1622';
  114. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur ronde wand bekisitng / Location coffrage circulaire' WHERE ERP_ID ='1623';
  115. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Bekisting Hussor / Location coffrage Hussor' WHERE ERP_ID ='1624';
  116. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Maximo Bekisting - PERI / Location Maximo Coffrage - PERI' WHERE ERP_ID ='1625';
  117. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Schroefstempels met koppen D-flex / Etancons réglables avec tête D-flex' WHERE ERP_ID ='1626';
  118. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Dokadurplaten / Dokadur' WHERE ERP_ID ='1627';
  119. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'T 90 / T90' WHERE ERP_ID ='1628';
  120. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Balkbekisting:batterij,konsool,omlij / Coffrage poutres' WHERE ERP_ID ='1629';
  121. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Elektropneumatische boor- en hamerma / Electropneumatiques' WHERE ERP_ID ='1630';
  122. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Hoogwerkers : telescopisch, knik, schaar / Nacelles : télescopiques, articulées, ciseaux ..' WHERE ERP_ID ='1631';
  123. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Werfafsluitingen Heras  en Nadarbarelen / Location barrières Heras + Nadar' WHERE ERP_ID ='1632';
  124. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Recup stalen balken en profielen / Récup poutres acier' WHERE ERP_ID ='1633';
  125. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur bekisting extern / Location coffrage externe' WHERE ERP_ID ='1634';
  126. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Divers electr. mat: lasposten, stofzuigers, slijpmolen / Location mat éléctr. divers:  soudage, aspirateurs, meuleuse' WHERE ERP_ID ='1635';
  127. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Bouwdrogers en verwarmers (electr., / Chauffage' WHERE ERP_ID ='1636';
  128. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Damplanken / Palplanches' WHERE ERP_ID ='1637';
  129. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Declassering materieel / Déclassement' WHERE ERP_ID ='1638';
  130. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Opleiding en vorming / Formations' WHERE ERP_ID ='1639';
  131. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Vakbladen en vakliteratuur / Littérature' WHERE ERP_ID ='1640';
  132. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Representatiekosten / Frais de représentation' WHERE ERP_ID ='1641';
  133. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Veiligheid / Sécurité' WHERE ERP_ID ='1643';
  134. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Kantine / Cantine' WHERE ERP_ID ='1642';
  135. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenpark bedienden / Voitures employés' WHERE ERP_ID ='1644';
  136. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende CO2>175 / Voitures employé CO2>175' WHERE ERP_ID ='1645';
  137. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende CO2>145<175 / Voitures employé CO2>145>175' WHERE ERP_ID ='1646';
  138. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende CO2>115<145 / Voitures employé CO2>115>145' WHERE ERP_ID ='1647';
  139. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende CO2>105<115 / Voitures employé CO2>105<115' WHERE ERP_ID ='1648';
  140. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende CO2<105 / Voitures employé CO2<105' WHERE ERP_ID ='1649';
  141. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert bediende - lichte vracht / Voitures employé camionette' WHERE ERP_ID ='1650';
  142. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Werkkledij en veiligheidsuitrusting / Vêtements et équipements de sécurité' WHERE ERP_ID ='1651';
  143. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Wagenpark  SDM techniekers Atelier / Véhicules techniciens SDM ATELIER' WHERE ERP_ID ='1652';
  144. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur / Location' WHERE ERP_ID ='1653';
  145. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Onderhoud, aanpass. infrastructuur / Entretien infra SDM' WHERE ERP_ID ='1654';
  146. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verwarming / Chauffage' WHERE ERP_ID ='1655';
  147. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Electriciteit / Electricité' WHERE ERP_ID ='1656';
  148. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Water / Eau' WHERE ERP_ID ='1657';
  149. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verzekeringen,taxen en belastingen / Assurances, taxes et impôts' WHERE ERP_ID ='1658';
  150. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huis J. Vervaenestraat  135 / Maison rue J Vervaene 135' WHERE ERP_ID ='1659';
  151. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Site Gentbrugge 2014 / Site Gentbrugge 2014' WHERE ERP_ID ='1660';
  152. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Alarm / Alarme' WHERE ERP_ID ='1661';
  153. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Informatica / Informatique' WHERE ERP_ID ='1662';
  154. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Fotocopies / Photocopies' WHERE ERP_ID ='1663';
  155. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Bureel benodigdheden / Fournitures de bureau' WHERE ERP_ID ='1664';
  156. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Publiciteit,advertenties en foto's / Publicité, photos' WHERE ERP_ID ='1665';
  157. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel magazijn / Petit matériel magasin' WHERE ERP_ID ='1666';
  158. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik Klein materieel Fondedile / Petit matériel Fondedile' WHERE ERP_ID ='1667';
  159. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Grondwerken / Petit matériel terrassement' WHERE ERP_ID ='1668';
  160. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Verhuur / Petit matériel location' WHERE ERP_ID ='1669';
  161. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Transport / Petit matériel Transport' WHERE ERP_ID ='1670';
  162. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Voertuigen / Petit matériel véhicules' WHERE ERP_ID ='1671';
  163. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Werfinrichting / Petit matériel installation de chantier' WHERE ERP_ID ='1672';
  164. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Electriciteit / Petit matériel électricité' WHERE ERP_ID ='1673';
  165. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verbruik klein materieel Bekisting / Petit matériel coffrage' WHERE ERP_ID ='1674';
  166. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot materieel Atelier SDM / Grand matériel Atelier SDM' WHERE ERP_ID ='1675';
  167. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot materieel Electriciteit SDM / Grand matériel électricité' WHERE ERP_ID ='1677';
  168. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot materieel Fondedile / Grand matériel Fondedile' WHERE ERP_ID ='1678';
  169. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot mat SDM Grondwerk / Grand matériel terrassement' WHERE ERP_ID ='1679';
  170. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot materieel Magazijn / Grand matériel Magasin' WHERE ERP_ID ='1682';
  171. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Groot materieel Containers / Grand matériel containers' WHERE ERP_ID ='1685';
  172. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Afval / Déchets' WHERE ERP_ID ='1686';
  173. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Werkkledij en persoonlijke beschermi / Vêtements et EPI' WHERE ERP_ID ='1687';
  174. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Verkoop allerhande klein materieel / Vente Petit matériel divers' WHERE ERP_ID ='1688';
  175. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'herstelling / reparation' WHERE ERP_ID ='1689';
  176. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'diversen / divers' WHERE ERP_ID ='1690';
  177. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeenschappelijk vervoer / location transport collectif' WHERE ERP_ID ='1691';
  178. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeenschappelijk vervoer CO2 >175 (LV zd chauffeur) / location transport collectif CO2 >175 (camionette s. chauff)' WHERE ERP_ID ='1692';
  179. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeensch. vervoer CO2>145<175 (LV zd chauffeur) / location transport collectif CO2>145<175 (cami. s chauffeur)' WHERE ERP_ID ='1693';
  180. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeensch.  vervoer CO2>115<145 (camionette zd chauff.) / location transport collectif CO2>115<145 (cami.s. chauffeur)' WHERE ERP_ID ='1694';
  181. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeensch. vervoer CO2>105<115 (LV zd chauffeur) / location transport collectif CO2>105<115 (cami s. chauffeur)' WHERE ERP_ID ='1695';
  182. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeensch. vervoer  CO2<105  (LV zd chauffeur) / location transport collectif  CO2<105 (cami s. chauffeur)' WHERE ERP_ID ='1696';
  183. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur lichte vracht (reserve) / location camionette (réserve)' WHERE ERP_ID ='1697';
  184. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur gemeenschappelijk vervoer (reserve) / location transport collectif (réserve)' WHERE ERP_ID ='1698';
  185. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'aankoop werkkledij / achat vêtements de travail' WHERE ERP_ID ='1699';
  186. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'guinitage / guinitage' WHERE ERP_ID ='1700';
  187. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'transport / transport' WHERE ERP_ID ='1701';
  188. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Betonspuit install. / Install. de pulvérisateur a béton' WHERE ERP_ID ='1702';
  189. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Tractor / Tracteur' WHERE ERP_ID ='1703';
  190. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Graaf- laadcombinatie en Mecalac / Pelle' WHERE ERP_ID ='1704';
  191. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Brokk en minicut / Brokk - Minicut' WHERE ERP_ID ='1705';
  192. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur  diverse tanks (water, olie ..) en supports / location citernes diverses (eau, huile..) et supports' WHERE ERP_ID ='1706';
  193. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'vervoer vrachtwagen / transport camion' WHERE ERP_ID ='1707';
  194. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert kraanman CO2>145 / Véhicule grutier CO2 > 145' WHERE ERP_ID ='1708';
  195. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert kraanman CO2 > 115 / Véhicule grutier CO2 > 115' WHERE ERP_ID ='1709';
  196. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert kraanman CO2 > 105 / Véhicule grutier CO2 > 105' WHERE ERP_ID ='1710';
  197. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert kraanman CO2 < 105 / Véhicule grutier CO2 < 105' WHERE ERP_ID ='1711';
  198. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Voert kraanman lichte vracht / Camionette grutier' WHERE ERP_ID ='1712';
  199. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'vervoer trekker / trans tracteur' WHERE ERP_ID ='1713';
  200. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'huur bedrijfsvoertuigen / loc véhicul utiliage' WHERE ERP_ID ='1714';
  201. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voertuigen extern CO2 > 175 / Location Véhicule utilitaire externe CO2 > 175' WHERE ERP_ID ='1715';
  202. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voertuigen extern  CO2>145<175 / Location Véhicule utilitaire externe CO2>145<175' WHERE ERP_ID ='1716';
  203. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voertuigen extern  CO2>115<145 / Location Véhicule utilitaire externe CO2>115<145' WHERE ERP_ID ='1717';
  204. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voertuigen extern CO2>105<115 / Location Véhicule utilitaire externe CO2>105<115' WHERE ERP_ID ='1718';
  205. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voertuigen extern CO2<105 / Location Véhicule utilitaire externe CO2<105' WHERE ERP_ID ='1719';
  206. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Huur Lichte voert - lichte vracht - reserve / Location Véhicule utilitaire - reserve' WHERE ERP_ID ='1720';
  207. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Minibus 8+1 externe - réserve / Minibus 8+1 externe - reserve' WHERE ERP_ID ='1721';
  208. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Vrachtwagen Actros met kraan en afze / trans camion Actros avec grue' WHERE ERP_ID ='1722';
  209. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Koerierdiensten / service express' WHERE ERP_ID ='1723';
  210. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'MAN Stree / MAN Stree' WHERE ERP_ID ='1724';
  211. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Lichte vracht Sodemat voor verhuring / Location véhicule utilitaire  Sodemat' WHERE ERP_ID ='1725';
  212. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Vrachtwagen voor verhuring / Camion  pour location' WHERE ERP_ID ='1726';
  213. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstellingen van materieel bekisting / Prestations réparations matériel coffrage' WHERE ERP_ID ='1727';
  214. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Prestaties Herstelling materieel electriciteit / Réparation matériel  électrique' WHERE ERP_ID ='1728';
  215. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling materieel Fondedile / Réparations Fondedile' WHERE ERP_ID ='1729';
  216. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling materieel Grondwerk / Prestations réparation terrassement' WHERE ERP_ID ='1730';
  217. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling materieel opleidingsplatform / Réparation matériel centre de Formation' WHERE ERP_ID ='1732';
  218. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling materieel Atelier / Réparation matériel atelier' WHERE ERP_ID ='1735';
  219. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Herstelling materieel Containers / Réparation matériel containers' WHERE ERP_ID ='1736';
  220. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'herstel Lasatelier / repar containers' WHERE ERP_ID ='1737';
  221. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'diversen / divers' WHERE ERP_ID ='1738';
  222. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Refter- en bureelroulotten / Roulottes réfectoire et bureau' WHERE ERP_ID ='1739';
  223. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Bureel- en reftercontainers;alarm vo / Containers bureau et réfectoire; alarme' WHERE ERP_ID ='1740';
  224. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'magazijnen:containers en barakken / Containers Magasin' WHERE ERP_ID ='1741';
  225. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Sanitaire containers en roulotten / Containers sanitaires' WHERE ERP_ID ='1742';
  226. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Ondersteuning D2 ;PAL / bekisting algemeen/coffrage général' WHERE ERP_ID ='1743';
  227. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Ondersteuning ADRIA R97 / Supports Adria R97' WHERE ERP_ID ='1744';
  228. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Borstweringen en veiligheidsleuninge / Garde-corps' WHERE ERP_ID ='1745';
  229. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Klimsystemen Doka met inbegrip van o / Système grimpant Doka' WHERE ERP_ID ='1746';
  230. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Bekisting Outinord / Outinord' WHERE ERP_ID ='1747';
  231. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Metalen onderdelen grootwandkist / coffrage métallique' WHERE ERP_ID ='1748';
  232. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Modulaire ramenbekisting Framax en P / Coffrage Framax' WHERE ERP_ID ='1749';
  233. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Ronde kist / Coffrage circ' WHERE ERP_ID ='1750';
  234. UPDATE MFC_SERVICE SET LM_DATE=SYSDATE, NAME = 'Houten dragers H20;H30 enz / H20 poutres' WHERE ERP_ID ='1751';
  235.  
  236. --SYSDATE was approx. 4-5h ago
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement