EN- English:
ASQL commands for static master data: articles, course_compilations with options, tender, MEC, category, ingredients &allergens, recipe. It also contains configuration like price levels, finance payment methods
DE - Deutsch:
ASQL Befehle für statische Artikelstammdaten: Artikel, Menüzusammenstellungen, Tender, MEC, Warengruppe, Inhaltsstoffe & Allergene, Rezeptur. Sie enthalten auch Konfiguration wie Preisebenen, Finanzwege
TOC /INHALTSVERZEICHNIS
- return of fullarticle - Befehlsreferenz kompletter Artikelstamm
- Table of commands
- EN: explanation of search areas
- DE: Erklärung der Suchbereiche
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
command | parameter | result |
---|---|---|
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-100 | ARTICLES number 1-100 |
- | -50 | ARTICLES number first -50 |
- | 100- | ARTICLES number 100-end |
- | text %a% | all MEC name containing an "a" |
search MEC [param]; | - | all MEC |
- | 1 | name of MEC 1 |
- | 1-100 | MEC names of number 1-100 |
- | text %a% | all MEC name containing an "a" |
search MECGROUP [param]; | options similar to MEC | results similar to MEC |
search CAT [param]; | options similar to MEC | results similar to MEC |
search DETAILCAT [param]; | options similar to MEC | results similar to MEC |
search GROSSCAT [param]; | options similar to MEC | results similar to MEC |
search WAITER [param]; | options similar to MEC | results similar to MEC |
search FINANCE [param]; | options similar to MEC | results similar to MEC |
search FINANCECAT [param]; | options similar to MEC | results similar to MEC |
search PRICELEVEL [param]; | options similar to MEC | results similar to MEC |
search SORTORDER [param]; | options similar to MEC | results 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