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
- 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