ttDDArtikel.i 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. /* ---------------------------------------------- */
  2. /* Temp-Table der ArtikelExport-Abfrage bei DD */
  3. /* ---------------------------------------------- */
  4. DEFINE TEMP-TABLE ttDDArtikel
  5. FIELD iArt AS INTEGER
  6. FIELD Bezeichnung AS CHARACTER
  7. FIELD HerstArtnr AS CHARACTER
  8. FIELD EANKGeb AS CHARACTER
  9. FIELD EANVGeb AS CHARACTER
  10. FIELD EANGGeb AS CHARACTER
  11. FIELD LieferGLN AS CHARACTER
  12. FIELD Gebinde AS CHARACTER
  13. FIELD lFound AS LOGICAL
  14. FIELD Artnr AS INTEGER
  15. FIELD Inhalt AS INTEGER
  16. FIELD Jahr AS INTEGER
  17. FIELD rArtst AS RECID
  18. FIELD KGebMe AS INTEGER
  19. FIELD VGebMe AS INTEGER
  20. FIELD GGebMe AS INTEGER
  21. FIELD KGebCd AS CHARACTER
  22. FIELD VGebCd AS CHARACTER
  23. FIELD GGebCd AS CHARACTER
  24. FIELD lAktiv AS LOGICAL
  25. FIELD lVerfuegbar AS LOGICAL
  26. FIELD lAnzeigen AS LOGICAL
  27. INDEX ttDDArtikel-k1 IS PRIMARY
  28. iArt
  29. Bezeichnung
  30. INDEX ttDDArtikel-k2
  31. iArt
  32. EANKGeb
  33. INDEX ttDDArtikel-k3
  34. HerstArtnr
  35. INDEX ttDDArtikel-k4
  36. iArt
  37. EANVGeb
  38. .