API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Dec 10th, 2020
1,469
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 31.09 KB | None | 0 0
raw download clone embed print report
  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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!