EN- English: 

ASQL commands for static master data: articles, course_compilations with options, tender, MEC, category, ingredients &allergens, recipe, price levels


DE - Deutsch:

ASQL Befehle für statische Artikelstammdaten: Artikel, Menüzusammenstellungen, Tender, MEC, Warengruppe, Inhaltsstoffe & Allergene, Rezeptur, Preisebenen



TOC /INHALTSVERZEICHNIS



return of fullarticle - Befehlsreferenz kompletter Artikelstamm


query - Anfrage fullarticle

search fullarticle;

return json - Antwort json

{
    article.energy: 0,
    article.salt: 0,
    aprio: 1,
    aean1: "1234567890",
    aean2: "234567891",
    article.sugar: 0,
    aco: "NOTSET",
    an: 1,
    article.saturatedfat: 0,
    article.carbohydrate: 0,
    article.protein: 0,
    article.fat: 0,
    mns: "6",
    at: "MAIN",
    t: "article",
    ana: "Aperol Sprizz O.k. 0,2",
    article.dietaryfiber: 0,
    apr: {
        s: {
            ds: [{
                    ast: false,
                    aop: false,
                    t: "articlePrice",
                    aw: false,
                    men: 0,
                    sn: 0,
                    apr: {
                        s: {
                            ds: [{
                                    t: "price1",
                                    ap: 6.5
                                }, {
                                    t: "price2",
                                    ap: 0
                                }, {
                                    t: "price3",
                                    ap: 0
                                }
                            ],
                            n: "prices"
                        }
                    },
                    awe: true
                }
            ],
            n: "articlePrices"
        }
    }
}



query - Anfrage fullarticle menus

search fullarticle menus;

return json - Antwort json


 {   "name": "course.composition",
     "dataset": [
         {
             "article.number": 8352,
             "article.count": 1,
             "name": "article",
             "article.name": "Smokey barbecue Burger",
             "article.price": 8.5,
             "book.category": "tender",
             "type": "article"
         },
         {
             "course.maxcount": 1,
             "course.number": 1,
             "name": "course",
             "course.name": "Zubereitung",
             "course.sortnbr": 0,
             "course.included": 0,
             "course.options": {
  "section": {
      "name": "course.options",
      "dataset": [
          {
              "option.mecarticles": {
   "section": {
       "name": "option.mecarticles",
       "dataset": [
           {
               "mecarticle.number": 19,
               "name": "mecarticle",
               "mecarticle.name": "0,5 Mineralwasser",
               "type": "mecarticle"
           },
           {
               "mecarticle.number": 9,
               "name": "mecarticle",
               "mecarticle.name": "0,2 Fanta",
               "type": "mecarticle"
           }
       ]
   }
              },
              "option.type": "MECCODE",
              "option.acquire": false,
              "name": "option",
              "option.name": "AFG",
              "option.default": 0,
              "option.price": 0,
              "type": "option",
              "option.number": 10
         }]}},
             "course.pricefromarticle": false,
             "type": "course",
             "course.mincount": 1
         }]},
 {   "name": "tender.list",
     "dataset": [
         {
             "tender.price": 0,
             "tender.name": "Amadeus-Fax",
             "tender.number": -1008,
             "action": {
  "standard": "book plu -1008 #FAX"
             },
             "type": "tender",
             "mec.number": 0,
             "mec.name": "Keine Zuordnung",
             "tender.priority": 0
         },
         {
             "tender.price": 0.5,
             "tender.name": "Vanille",
             "tender.number": 4001,
             "action": {
  "standard": "book plu 4001"
 }]}



Table of commands


commandparameterresult
search fullarticle;-full article master data, see above
search fullarticle menus;-course_compilation options and tender
search ARTICLE [param];-all articles
-#name of article number #
-1-100ARTICLES number 1-100
-50ARTICLES number first -50
-100-ARTICLES number 100-end
text %a%all MEC name containing an "a"
search MEC [param];-all MEC
-1name of MEC 1
-1-100MEC names of number 1-100
text %a%all MEC name containing an "a"
search MECGROUP [param];options similar to MECresults similar to MEC
search CAT [param];options similar to MECresults similar to MEC
search DETAILCAT [param];options similar to MECresults similar to MEC
search GROSSCAT [param];options similar to MECresults similar to MEC
search WAITER [param];options similar to MECresults similar to MEC
search FINANCE [param];options similar to MECresults similar to MEC
search FINANCECAT [param];options similar to MECresults similar to MEC
search PRICELEVEL [param];options similar to MECresults similar to MEC
search SORTORDER [param];options similar to MECresults similar to MEC



EN: explanation of search areas

searching the master data is available without explicit logon

  • ARTICLE, FULLARTICLE and FULLARTICLE MENUS return articles, course_compilations, options, tender
  • MEC is a bunch of articles grouped in a basket on POS screen. An article may be in additional MEC's.
  • MECGROUP is a group of MEC
    Example: MECGROUP "drinks", MEC "beer", wine", "nonalc", ...
  • SORTORDER is the ascending display order inside a MEC
  • CAT, DETAILCAT and GROSSCAT are referencing merchandise management
  • FINANCE and FINANCECAT are Finanzweg and Finanzart (different Finanzwege eg Gutschein LINA, Gutschein Franchise... are connected to one payment type Gutschein)
  • PRICELEVEL are different prices to use in different areas



DE: Erklärung der Suchbereiche

Die Suche kann ohne explizite Anmeldung gemacht werden.

  • ARTICLE, FULLARTICLE and FULLARTICLE MENUS geben die Verkaufsartikel, den gesamten Stamm, die Menüzusammenstellungen mit Optionen und die Tender zurück
  • MEC ist ein Bündel von Artikeln in einer Gruppe auf dem POS Bildschirm. Ein Artikel kann in mehreren MEC sein.
  • MECGROUP ist eine Gruppe von MEC
    Beispiel: MECGROUP "drinks", MEC "beer", wine", "nonalc", ...
  • SORTORDER ist die ansteigende Anzeigereihenfolge innerhalb der MEC
  • CAT, DETAILCAT and GROSSCAT beziehen sich auf die Warenwirtschaft
    In der Gastronomie häüfig bezeichnet als Sparte, Feinsparte und Hauptsparte 
  • FINANCE and FINANCECAT sind Finanzweg and Finanzart (verschiedene Finanzwege z.B. Gutschein LINA, Gutschein Franchise... werden behandelt als eine Finanzart Gutschein) 
  • PRICELEVEL für verschiedene Preislevel in verschiedenen Bereichen