revision in progress: Sparten ff keine Einzelabfrage Finanzart and Finanzkategorie
EN- English:
ASQL commands for static master data: MEC, category, ingredients &allergens, recipe, price levels
DE - Deutsch:
ASQL Befehle für statische Artikelstammdaten: 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
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"
}
}
}Table of commands
| command | parameter | result |
|---|---|---|
| search fullarticle; | - | full article master data, see above |
| 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
- 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 Finanzart and Finanzkategorie
- PRICELEVEL are different prices to use in different areas
DE: Erklärung der Suchbereiche
Die Suche kann ohne explizite Anmeldung gemacht werden.
- 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 Finanzart und Finanzkategorie
- PRICELEVEL für verschiedene Preislevel in verschiedenen Bereichen