d-artikel.i 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. FIELD Firma LIKE Artst.Firma VALIDATE ~
  2. FIELD Artnr LIKE Artst.Artnr VALIDATE ~
  3. FIELD Inhalt LIKE Artst.Inhalt VALIDATE ~
  4. FIELD Jahr LIKE Artst.Jahr VALIDATE ~
  5. FIELD Suchbe LIKE Artst.Suchbe VALIDATE ~
  6. FIELD Bez LIKE Artst.Bez VALIDATE ~
  7. FIELD KGeb_Cd LIKE Artst.KGeb_Cd VALIDATE ~
  8. FIELD VGeb_Cd LIKE Artst.VGeb_Cd VALIDATE ~
  9. FIELD GGeb_Cd LIKE Artst.GGeb_Cd VALIDATE ~
  10. FIELD Wg_Grp LIKE Artst.Wg_Grp VALIDATE FORMAT "999999"~
  11. FIELD Prod_Grp LIKE Artst.Prod_Grp VALIDATE FORMAT "999999"~
  12. FIELD Art_Grp LIKE Artst.Art_Grp VALIDATE FORMAT "999999"~
  13. FIELD Rab_Grp LIKE Artst.Rab_Grp VALIDATE ~
  14. FIELD Bonus_Grp LIKE Artst.Bonus_Grp VALIDATE ~
  15. FIELD Farbe LIKE Artst.Farbe VALIDATE ~
  16. FIELD Traub_Grp LIKE Artst.Traub_Grp VALIDATE ~
  17. FIELD Reg_Grp LIKE Artst.Reg_Grp VALIDATE ~
  18. FIELD Herk_Lkz LIKE Artst.Herk_Lkz VALIDATE ~
  19. FIELD Herst LIKE Artst.Herst VALIDATE ~
  20. FIELD MWSt LIKE Artst.MWSt VALIDATE ~
  21. FIELD Netto LIKE Artst.Netto VALIDATE ~
  22. FIELD Sk_Ber LIKE Artst.Sk_Ber VALIDATE ~
  23. FIELD Lager LIKE Artst.Lager VALIDATE ~
  24. FIELD Leih_Art LIKE Artst.Leih_Art VALIDATE ~
  25. FIELD Ausverk LIKE Artst.Ausverk VALIDATE ~
  26. FIELD Preisliste LIKE Artst.Preisliste VALIDATE ~
  27. FIELD Alk_Gehalt LIKE Artst.Alk_Gehalt VALIDATE ~
  28. FIELD Gewicht LIKE Artst.Gewicht VALIDATE ~
  29. FIELD WHK_Code LIKE Artst.WHK_Code VALIDATE ~
  30. FIELD EAV_Code LIKE Artst.EAV_Code VALIDATE ~
  31. FIELD Strichcode LIKE Artst.Strichcode VALIDATE ~
  32. FIELD Konto LIKE Artst.Konto VALIDATE ~
  33. FIELD Bestand LIKE Artst.Bestand VALIDATE ~
  34. FIELD Soll_Bestand LIKE Artst.Soll_Bestand VALIDATE ~
  35. FIELD Bestellt LIKE Artst.Bestellt VALIDATE ~
  36. FIELD Reserviert LIKE Artst.Reserviert VALIDATE ~
  37. FIELD DEP LIKE Artst.DEP VALIDATE ~
  38. FIELD LEP LIKE Artst.LEP VALIDATE ~
  39. FIELD Listen_EP LIKE Artst.Listen_EP VALIDATE ~
  40. FIELD Min_Marge LIKE Artst.Min_Marge VALIDATE ~
  41. FIELD Letzt_Ausg LIKE Artst.Letzt_Ausg VALIDATE ~
  42. FIELD Letzt_Eing LIKE Artst.Letzt_Eing VALIDATE ~
  43. FIELD ErfDat LIKE Artst.Edat VALIDATE LABEL "ErfDat"~
  44. FIELD ErfSb LIKE Artst.Esbkb VALIDATE LABEL "ErfSb"~
  45. FIELD MutDat LIKE Artst.Mdat VALIDATE LABEL "MutDat"~
  46. FIELD MutSb LIKE Artst.Msbkb VALIDATE LABEL "MutSb"~
  47. FIELD MutFlag LIKE Artst.MutFlag VALIDATE ~
  48. FIELD Res_c1 LIKE Artst.Res_c1 VALIDATE ~
  49. FIELD Res_c2 LIKE Artst.Res_c2 VALIDATE ~
  50. FIELD Res_i1 LIKE Artst.Res_i1 VALIDATE ~
  51. FIELD Style LIKE Artst.Style VALIDATE ~
  52. FIELD Aktiv LIKE Artst.Aktiv VALIDATE ~
  53. FIELD EShop LIKE Artst.EShop VALIDATE ~
  54. FIELD FremdNr LIKE Artst.FremdNr VALIDATE ~
  55. FIELD iRecid AS INTEGER FORMAT "->,>>>,>>9" LABEL "ARecid"~
  56. FIELD cRowid AS CHARACTER FORMAT "x(8)" LABEL "ARowid"~
  57. FIELD Mind_Bestand LIKE Artst.Mind_Bestand VALIDATE ~
  58. FIELD Mind_MHD LIKE Artst.Mind_MHD VALIDATE ~
  59. FIELD lVerfall LIKE Artst.lVerfall VALIDATE ~
  60. FIELD lLotnr LIKE Artst.lLotnr VALIDATE ~
  61. FIELD EShop_2 LIKE Artst.EShop_2 VALIDATE ~
  62. FIELD EP-Intern LIKE Artst.EP-Intern VALIDATE ~
  63. FIELD ArtikelBild LIKE Artst.ArtikelBild VALIDATE