aufze_anzeig.i 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. DO WHILE TRUE:
  2. F_Bez1 = {1}.Bez1.
  3. F_Bez2 = {1}.Bez2.
  4. IF {1}.Artnr = 0 THEN LEAVE.
  5. FIND Artst USE-INDEX Artst-k1
  6. WHERE Artst.Firma = GVFirma
  7. AND Artst.Artnr = {1}.Artnr
  8. AND Artst.Inhalt = {1}.Inhalt
  9. AND Artst.Jahr = {1}.Jahr NO-LOCK.
  10. FIND Wust USE-INDEX Wust-k3
  11. WHERE Wust.CodeK = 99
  12. AND Wust.CodeA = {1}.WC NO-LOCK.
  13. FIND KGebinde USE-INDEX KGebinde-k1 NO-LOCK
  14. WHERE KGebinde.Firma = GVFirma
  15. AND KGebinde.Geb_Cd = {1}.KGeb_Cd NO-ERROR.
  16. FIND VGebinde USE-INDEX VGebinde-k1 NO-LOCK
  17. WHERE VGebinde.Firma = GVFirma
  18. AND VGebinde.Geb_Cd = {1}.VGeb_Cd NO-ERROR.
  19. F_KGebinde = (IF AVAILABLE KGebinde THEN KGebinde.KBez ELSE '').
  20. xKGebinde = (IF AVAILABLE KGebinde THEN KGebinde.KBez ELSE '').
  21. F_VGebinde = (IF AVAILABLE VGebinde THEN VGebinde.KBez ELSE '').
  22. F_MWST = Wust.KText.
  23. F_Artnr = STRING({1}.Artnr,"999999").
  24. F_Inhalt = {1}.Inhalt.
  25. F_Jahr = {1}.Jahr.
  26. F_Alk_Gehalt = {1}.Alk_Gehalt.
  27. F_MBest = {1}.MBest.
  28. F_MGeli = {1}.MGeli.
  29. F_MRuek = {1}.MRuek.
  30. F_Preis = {1}.Preis.
  31. F_Rab_Art = {1}.Rab_Art.
  32. F_Rab_Wert = {1}.Rab_Wert.
  33. F_Zus_Art = {1}.Zus_Art.
  34. F_Zus_Wert = {1}.Zus_Wert.
  35. F_AlteNr = Artst.FremdNr.
  36. LEAVE.
  37. END.