Kundenakte: Adressen, Aufträge und Positionen — Pro
Kundenkontakte und Konditionen, alle Adressen sowie kundenbezogene Aufträge mit Positionsdetails.
INOFFIZIELL — NICHT AN EINER ECHTEN ERP-INSTALLATION VALIDIERT. Für JTL-Wawi 2.0.1.0 / SQL Server. Offizielle physische Dokumentation, synthetische Prüfungen und native Cifru-DEMO-Aufnahmen; kein Test auf einer echten Installation. Quelle beim Import zuordnen, Lesetest ausführen und Version, Berechtigungen, Ergebnisse sowie Laufzeit prüfen.
Für Vertrieb, Kundenservice und Geschäftsführung: eine Kundenakte mit aktuellen Kontakten, Buchhaltungsreferenzen und Konditionen. Alle Adressen öffnen; danach die Aufträge dieses Kunden und deren Positionen mit Mengen, Einheiten, nativen Preisen, Rabatt, Steuer und Hinweisen prüfen.
Warum Cifru? Passen Sie Konfigurationen an Ihre Arbeitsweise an. Wählen Sie die benötigten Felder, Filter und Details und holen Sie Informationen aufs Smartphone, die in der mobilen App Ihrer Unternehmenssoftware möglicherweise fehlen. Die Möglichkeiten hängen von den zugänglichen Daten Ihrer autorisierten Quelle und Ihrem Cifru-Tarif ab.
Ein Datensatz je Kunde, auch ohne Adresse. Die Kontaktanzeige wählt zuerst eine Rechnungsadresse, bei mehreren die kleinste interne Adress-ID, andernfalls die kleinste vorhandene Adresse. Das ist eine nachvollziehbare Anzeigeauswahl, nicht die Zusage der JTL-Standardadresse. Alle anderen Adressen stehen im Unterbutton. Es sind aktuelle Stammdaten, keine historischen Dokumentanschriften.
Zahlungsziel 0 bedeutet JTL-Standard aus der ersten Mahnstufe, nicht sofortige Fälligkeit. Kundenrabatt ist der Stammwert, nicht der effektiv angewandte Rabatt jedes Auftrags. Kreditlimit ist der native Stammwert; Währungsbasis in der Installation prüfen. Es ist keine offene Forderung und keine garantierte Liefersperre. Undokumentierte Sperr-/POS-Codes werden nicht als sichere Statusangaben ausgelegt.
Aufträge: nur Vorgangstyp 1; Angebote, Umlagerungen und Abonnements ausgeschlossen. Alte, archivierte oder stornierte Aufträge werden nicht durch ein willkürliches Datumsfenster ausgeblendet. Lieferstatus unterscheidet unvollständig, vollständig per Lieferschein und vollständig manuell; er ist kein Zahlungsstatus. Positionen werden durch die echte Auftrags-ID eingeschränkt, einschließlich Freitext-/Versand-/Sonderpositionen. Originalwerte bleiben unverändert; keine selbst errechnete Auftragssumme, Marge, Währungsumrechnung oder Zahlungssumme. Hierarchische Positionen dürfen nicht blind summiert werden.
Pro: eine Quelle, vier Listen, drei Verknüpfungen und schreibgeschütztes SQL. Land beim Öffnen wählen (oder alle); Details lesen Kinder nur auf Anfrage. Limits: 2.000 Kunden, 500 Adressen je Kunde, 1.000 Aufträge je Kunde, 1.000 Positionen je Auftrag. Bei Erreichen eines Limits keine Vollständigkeitszusage. Suche/Filter betreffen geladene Zeilen. Keine periodische Aktualisierung. Ein Zeilenlimit garantiert keine kurze Serverlaufzeit; Indizes und Berechtigungen lokal prüfen.
Nur autorisierte SELECT-Zugriffe. UI-Filter ersetzen keine Datenbankrechte oder Mandantentrennung. Keine Zugangsdaten, Bankverbindungen oder echten Kunden im Paket/den Bildern. Kontaktdaten und Steuerreferenzen nur berechtigten Nutzern zeigen. Screenshots: vollständig erfundene DEMO-Daten. Keine Zertifizierung durch JTL. Dokumentation: https://guide.jtl-software.com/jtl-wawi/kunden/dialogfenster-kundenstammdaten/ https://guide.jtl-software.com/jtl-wawi/verkauf/auftragsdetails/ https://wawi-db.jtl-software.de/tables/2.0.1.0
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Kundenakte
- Details: Alle Adressen
- Details: Aufträge
- Details: Positionen
- Sub-button: Kundenadressen
- Sub-button: Kundenaufträge
- Sub-button: Auftragspositionen
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT k.kKunde,COALESCE(NULLIF(LTRIM(RTRIM(a.cFirma)),N''),NULLIF(LTRIM(RTRIM(CONCAT(a.cVorname,N' ',a.cName))),N''),NULLIF(LTRIM(RTRIM(k.cKundenNr)),N''),N'Kunde ohne Namen') AS CustomerName,k.cKundenNr,k.dErstellt,k.fRabatt,k.cWWW,k.cHerkunft,k.nDebitorennr,k.cSteuerNr,k.nKreditlimit,CASE WHEN k.nZahlungsziel IS NULL THEN N'Nicht angegeben' WHEN k.nZahlungsziel=0 THEN N'JTL-Standard (erste Mahnstufe)' ELSE CONCAT(k.nZahlungsziel,N' Tage') END AS PaymentTerm,a.cAnrede,a.cTitel,a.cVorname,a.cName,a.cStrasse,a.cPLZ,a.cOrt,a.cLand,a.cTel,a.cMobil,a.cMail,a.cBundesland,a.cZusatz,CASE WHEN a.nTyp IS NULL THEN N'Nicht angegeben' WHEN a.nTyp=0 THEN N'Lieferadresse' WHEN a.nTyp=1 THEN N'Rechnungsadresse' WHEN a.nTyp=2 THEN N'Sonstige Adresse' ELSE N'Unbekannter Adresstyp' END AS ContactAddressKind,(SELECT COUNT(*) FROM dbo.tAdresse x WHERE x.kKunde=k.kKunde) AS AddressCount FROM dbo.tkunde k LEFT JOIN dbo.tAdresse a ON a.kAdresse=COALESCE((SELECT MIN(b.kAdresse) FROM dbo.tAdresse b WHERE b.kKunde=k.kKunde AND b.nTyp=1),(SELECT MIN(b.kAdresse) FROM dbo.tAdresse b WHERE b.kKunde=k.kKunde))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT a.kAdresse,a.kKunde,COALESCE(NULLIF(LTRIM(RTRIM(a.cFirma)),N''),NULLIF(LTRIM(RTRIM(CONCAT(a.cVorname,N' ',a.cName))),N''),N'Adresse ohne Namen') AS AddressName,CASE WHEN a.nTyp IS NULL THEN N'Nicht angegeben' WHEN a.nTyp=0 THEN N'Lieferadresse' WHEN a.nTyp=1 THEN N'Rechnungsadresse' WHEN a.nTyp=2 THEN N'Sonstige Adresse' ELSE N'Unbekannter Adresstyp' END AS AddressKind,a.cAnrede,a.cTitel,a.cVorname,a.cName,a.cStrasse,a.cPLZ,a.cOrt,a.cLand,a.cTel,a.cMobil,a.cMail,a.cBundesland,a.cZusatz,a.cISO FROM dbo.tAdresse a WHERE a.kKunde=:customer_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT o.kAuftrag,o.kKunde,o.cAuftragsNr,o.dErstellt,o.cWaehrung,o.fFaktor,o.cExterneAuftragsnummer,o.cVersandlandISO,o.nZahlungszielTage,o.dVoraussichtlichesLieferdatum,o.nLieferPrioritaet,CASE WHEN o.nStorno IS NULL THEN N'Nicht angegeben' WHEN o.nStorno=0 THEN N'Nein' WHEN o.nStorno=1 THEN N'Ja' ELSE N'Unbekannt' END AS Cancelled,CASE WHEN o.nArchiv IS NULL THEN N'Nicht angegeben' WHEN o.nArchiv=0 THEN N'Nein' WHEN o.nArchiv=1 THEN N'Ja' ELSE N'Unbekannt' END AS Archived,CASE WHEN o.nKomplettAusgeliefert IS NULL THEN N'Nicht angegeben' WHEN o.nKomplettAusgeliefert=0 THEN N'Nicht vollständig ausgeliefert' WHEN o.nKomplettAusgeliefert=1 THEN N'Vollständig über Lieferschein' WHEN o.nKomplettAusgeliefert=2 THEN N'Vollständig manuell' ELSE N'Unbekannter Lieferstatus' END AS DeliveryState FROM Verkauf.tAuftrag o WHERE o.nType=1 AND o.kKunde=:customer_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT p.kAuftragPosition,p.kAuftrag,p.nSort,p.cArtNr,p.cName,p.cHinweis,p.fAnzahl,p.fVkNetto,p.fRabatt,p.fMwSt,p.cNameStandard,p.cEinheit,p.fVkNettoGesamt,p.fVkBruttoGesamt,o.cWaehrung,o.fFaktor,o.cAuftragsNr FROM Verkauf.tAuftragPosition p INNER JOIN Verkauf.tAuftrag o ON o.kAuftrag=p.kAuftrag WHERE o.nType=1 AND p.kAuftrag=:order_id
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "JTL-Wawi — SQL Server",
"id": "A00AB8E7-E3B6-520E-9971-8DC3CA1ACC29",
"kind": "sqlServer",
"requiredObjects": [
"dbo.tkunde",
"dbo.tAdresse",
"Verkauf.tAuftrag",
"Verkauf.tAuftragPosition"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "JTL-Wawi",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "86B05A44-5770-5C45-A489-16F62D4A060D",
"key": "kKunde",
"type": "number"
}
],
"id": "E0FFC8FF-BD49-56B2-B78F-76DAA121869C",
"mappings": [
{
"commonFieldKey": "",
"key": "kKunde",
"label": "Schlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kKunde",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Kunde",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cKundenNr",
"label": "Kundennummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cKundenNr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dErstellt",
"label": "Kunde seit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dErstellt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nDebitorennr",
"label": "Debitorennummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nDebitorennr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cSteuerNr",
"label": "Steuernummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cSteuerNr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cHerkunft",
"label": "Erstkontakt über",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cHerkunft",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressCount",
"label": "Gespeicherte Adressen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ContactAddressKind",
"label": "Gewählter Adresstyp",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContactAddressKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cAnrede",
"label": "Anrede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cAnrede",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cTitel",
"label": "Titel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cTitel",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cVorname",
"label": "Vorname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cVorname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cName",
"label": "Nachname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cTel",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cMobil",
"label": "Mobil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cMobil",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cWWW",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cWWW",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cStrasse",
"label": "Straße",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cStrasse",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cZusatz",
"label": "Zusatz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cZusatz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cPLZ",
"label": "Postleitzahl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cPLZ",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cOrt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cBundesland",
"label": "Bundesland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cBundesland",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cLand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymentTerm",
"label": "Zahlungsziel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaymentTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fRabatt",
"label": "Kundenrabatt (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fRabatt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nKreditlimit",
"label": "Kreditlimit (Stammwert)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nKreditlimit",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Kundenakte",
"primaryKey": "kKunde",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CustomerName",
"cKundenNr",
"nDebitorennr",
"cSteuerNr",
"cHerkunft",
"ContactAddressKind",
"cAnrede",
"cTitel",
"cVorname",
"cName",
"cTel",
"cMobil",
"cMail",
"cWWW",
"cStrasse",
"cZusatz",
"cPLZ",
"cOrt",
"cBundesland",
"cLand",
"PaymentTerm"
],
"sourceID": "A00AB8E7-E3B6-520E-9971-8DC3CA1ACC29",
"sqlQuery": "SELECT k.kKunde,COALESCE(NULLIF(LTRIM(RTRIM(a.cFirma)),N''),NULLIF(LTRIM(RTRIM(CONCAT(a.cVorname,N' ',a.cName))),N''),NULLIF(LTRIM(RTRIM(k.cKundenNr)),N''),N'Kunde ohne Namen') AS CustomerName,k.cKundenNr,k.dErstellt,k.fRabatt,k.cWWW,k.cHerkunft,k.nDebitorennr,k.cSteuerNr,k.nKreditlimit,CASE WHEN k.nZahlungsziel IS NULL THEN N'Nicht angegeben' WHEN k.nZahlungsziel=0 THEN N'JTL-Standard (erste Mahnstufe)' ELSE CONCAT(k.nZahlungsziel,N' Tage') END AS PaymentTerm,a.cAnrede,a.cTitel,a.cVorname,a.cName,a.cStrasse,a.cPLZ,a.cOrt,a.cLand,a.cTel,a.cMobil,a.cMail,a.cBundesland,a.cZusatz,CASE WHEN a.nTyp IS NULL THEN N'Nicht angegeben' WHEN a.nTyp=0 THEN N'Lieferadresse' WHEN a.nTyp=1 THEN N'Rechnungsadresse' WHEN a.nTyp=2 THEN N'Sonstige Adresse' ELSE N'Unbekannter Adresstyp' END AS ContactAddressKind,(SELECT COUNT(*) FROM dbo.tAdresse x WHERE x.kKunde=k.kKunde) AS AddressCount FROM dbo.tkunde k LEFT JOIN dbo.tAdresse a ON a.kAdresse=COALESCE((SELECT MIN(b.kAdresse) FROM dbo.tAdresse b WHERE b.kKunde=k.kKunde AND b.nTyp=1),(SELECT MIN(b.kAdresse) FROM dbo.tAdresse b WHERE b.kKunde=k.kKunde))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "JTL-Wawi",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "9D065D48-53DD-5144-8AE3-D93DD4DC6C59",
"key": "AddressKind",
"type": "text"
},
{
"direction": "ascending",
"id": "6A8A2085-D478-504D-9362-F79FA0B35F18",
"key": "kAdresse",
"type": "number"
}
],
"id": "775461E4-2DA1-5302-938D-5CD4D40F3FE9",
"mappings": [
{
"commonFieldKey": "",
"key": "kAdresse",
"label": "Schlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kAdresse",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "kKunde",
"label": "Kundenschlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kKunde",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressName",
"label": "Empfänger",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressKind",
"label": "Adresstyp",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cAnrede",
"label": "Anrede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cAnrede",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cTitel",
"label": "Titel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cTitel",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cVorname",
"label": "Vorname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cVorname",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cName",
"label": "Nachname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cTel",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cMobil",
"label": "Mobil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cMobil",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cStrasse",
"label": "Straße",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cStrasse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cZusatz",
"label": "Zusatz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cZusatz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cPLZ",
"label": "Postleitzahl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cPLZ",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cOrt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cBundesland",
"label": "Bundesland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cBundesland",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cLand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cISO",
"label": "Ländercode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cISO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Kundenadressen",
"primaryKey": "kAdresse",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "kKunde",
"id": "E1E12692-E05C-58AC-9095-BEE3BF092395",
"name": "customer_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AddressName",
"AddressKind",
"cAnrede",
"cTitel",
"cVorname",
"cName",
"cTel",
"cMobil",
"cMail",
"cStrasse",
"cZusatz",
"cPLZ",
"cOrt",
"cBundesland",
"cLand",
"cISO"
],
"sourceID": "A00AB8E7-E3B6-520E-9971-8DC3CA1ACC29",
"sqlQuery": "SELECT a.kAdresse,a.kKunde,COALESCE(NULLIF(LTRIM(RTRIM(a.cFirma)),N''),NULLIF(LTRIM(RTRIM(CONCAT(a.cVorname,N' ',a.cName))),N''),N'Adresse ohne Namen') AS AddressName,CASE WHEN a.nTyp IS NULL THEN N'Nicht angegeben' WHEN a.nTyp=0 THEN N'Lieferadresse' WHEN a.nTyp=1 THEN N'Rechnungsadresse' WHEN a.nTyp=2 THEN N'Sonstige Adresse' ELSE N'Unbekannter Adresstyp' END AS AddressKind,a.cAnrede,a.cTitel,a.cVorname,a.cName,a.cStrasse,a.cPLZ,a.cOrt,a.cLand,a.cTel,a.cMobil,a.cMail,a.cBundesland,a.cZusatz,a.cISO FROM dbo.tAdresse a WHERE a.kKunde=:customer_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "JTL-Wawi",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "8F78B086-8905-5C07-B35C-EA47654D44AD",
"key": "dErstellt",
"type": "date"
},
{
"direction": "ascending",
"id": "0A108056-7622-5B44-A62F-B5029C4025B9",
"key": "kAuftrag",
"type": "number"
}
],
"id": "992A1023-B4EF-515B-8F50-6A3690E9D854",
"mappings": [
{
"commonFieldKey": "",
"key": "kAuftrag",
"label": "Schlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kAuftrag",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "kKunde",
"label": "Kundenschlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kKunde",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cAuftragsNr",
"label": "Auftrag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cAuftragsNr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dErstellt",
"label": "Auftragsdatum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dErstellt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cExterneAuftragsnummer",
"label": "Externe Auftragsnummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cExterneAuftragsnummer",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DeliveryState",
"label": "Lieferstatus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Cancelled",
"label": "Storniert",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Cancelled",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Archived",
"label": "Archiviert",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Archived",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dVoraussichtlichesLieferdatum",
"label": "Voraussichtliches Lieferdatum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dVoraussichtlichesLieferdatum",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cVersandlandISO",
"label": "Versandland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cVersandlandISO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nLieferPrioritaet",
"label": "Lieferpriorität",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nLieferPrioritaet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cWaehrung",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fFaktor",
"label": "Währungsfaktor (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fFaktor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nZahlungszielTage",
"label": "Zahlungsziel (Tage)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nZahlungszielTage",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Kundenaufträge",
"primaryKey": "kAuftrag",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "kKunde",
"id": "FCD6BB5F-CE55-53C7-A5E8-A0105D46C97A",
"name": "customer_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cAuftragsNr",
"cExterneAuftragsnummer",
"DeliveryState",
"Cancelled",
"Archived",
"cVersandlandISO",
"cWaehrung"
],
"sourceID": "A00AB8E7-E3B6-520E-9971-8DC3CA1ACC29",
"sqlQuery": "SELECT o.kAuftrag,o.kKunde,o.cAuftragsNr,o.dErstellt,o.cWaehrung,o.fFaktor,o.cExterneAuftragsnummer,o.cVersandlandISO,o.nZahlungszielTage,o.dVoraussichtlichesLieferdatum,o.nLieferPrioritaet,CASE WHEN o.nStorno IS NULL THEN N'Nicht angegeben' WHEN o.nStorno=0 THEN N'Nein' WHEN o.nStorno=1 THEN N'Ja' ELSE N'Unbekannt' END AS Cancelled,CASE WHEN o.nArchiv IS NULL THEN N'Nicht angegeben' WHEN o.nArchiv=0 THEN N'Nein' WHEN o.nArchiv=1 THEN N'Ja' ELSE N'Unbekannt' END AS Archived,CASE WHEN o.nKomplettAusgeliefert IS NULL THEN N'Nicht angegeben' WHEN o.nKomplettAusgeliefert=0 THEN N'Nicht vollständig ausgeliefert' WHEN o.nKomplettAusgeliefert=1 THEN N'Vollständig über Lieferschein' WHEN o.nKomplettAusgeliefert=2 THEN N'Vollständig manuell' ELSE N'Unbekannter Lieferstatus' END AS DeliveryState FROM Verkauf.tAuftrag o WHERE o.nType=1 AND o.kKunde=:customer_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "JTL-Wawi",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "167E1231-410E-5EF0-9DDD-F96ABD9C9162",
"key": "nSort",
"type": "number"
},
{
"direction": "ascending",
"id": "9E252AB6-C2A7-5A5F-AFB4-8B7A5B38208E",
"key": "kAuftragPosition",
"type": "number"
}
],
"id": "AFAD3495-C8AA-5403-BA22-3074D7A7866F",
"mappings": [
{
"commonFieldKey": "",
"key": "kAuftragPosition",
"label": "Schlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kAuftragPosition",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "kAuftrag",
"label": "Auftragsschlüssel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "kAuftrag",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nSort",
"label": "Sortierung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nSort",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cName",
"label": "Position",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cArtNr",
"label": "Artikelnummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cArtNr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cNameStandard",
"label": "Name in Standardsprache",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cNameStandard",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cAuftragsNr",
"label": "Auftrag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cAuftragsNr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "fAnzahl",
"label": "Menge",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fAnzahl",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cEinheit",
"label": "Einheit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cEinheit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fVkNetto",
"label": "Nettopreis (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fVkNetto",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fRabatt",
"label": "Rabatt (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fRabatt",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fMwSt",
"label": "MwSt. (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fMwSt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "fVkNettoGesamt",
"label": "Positionssumme netto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fVkNettoGesamt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "fVkBruttoGesamt",
"label": "Positionssumme brutto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fVkBruttoGesamt",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cWaehrung",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fFaktor",
"label": "Währungsfaktor (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fFaktor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cHinweis",
"label": "Hinweis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cHinweis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Auftragspositionen",
"primaryKey": "kAuftragPosition",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "kAuftrag",
"id": "EA9CA41D-FD76-590F-B9C2-CD670A219A9D",
"name": "order_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cName",
"cArtNr",
"cNameStandard",
"cAuftragsNr",
"cEinheit",
"cWaehrung",
"cHinweis"
],
"sourceID": "A00AB8E7-E3B6-520E-9971-8DC3CA1ACC29",
"sqlQuery": "SELECT p.kAuftragPosition,p.kAuftrag,p.nSort,p.cArtNr,p.cName,p.cHinweis,p.fAnzahl,p.fVkNetto,p.fRabatt,p.fMwSt,p.cNameStandard,p.cEinheit,p.fVkNettoGesamt,p.fVkBruttoGesamt,o.cWaehrung,o.fFaktor,o.cAuftragsNr FROM Verkauf.tAuftragPosition p INNER JOIN Verkauf.tAuftrag o ON o.kAuftrag=p.kAuftrag WHERE o.nType=1 AND p.kAuftrag=:order_id",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "85439C9A-E04F-5FBE-AE96-57C72055B6AD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "3C599AFE-D3A0-5FDB-98F4-FA6917C51944",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "775461E4-2DA1-5302-938D-5CD4D40F3FE9",
"title": "Alle Adressen",
"urlKey": ""
},
{
"id": "B0D09F57-D5A6-50AF-8B09-68041AF5240C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "66A3FF8B-688A-515A-B487-19256A78988C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "992A1023-B4EF-515B-8F50-6A3690E9D854",
"title": "Aufträge",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentTerm",
"label": "Zahlungsziel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AddressCount",
"label": "Gespeicherte Adressen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E0FFC8FF-BD49-56B2-B78F-76DAA121869C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Kunde",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "cKundenNr",
"label": "Kundennummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "dErstellt",
"label": "Kunde seit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "nDebitorennr",
"label": "Debitorennummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "cSteuerNr",
"label": "Steuernummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identität",
"detailRole": "information",
"isVisible": true,
"key": "cHerkunft",
"label": "Erstkontakt über",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "AddressCount",
"label": "Gespeicherte Adressen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "ContactAddressKind",
"label": "Gewählter Adresstyp",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cAnrede",
"label": "Anrede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cTitel",
"label": "Titel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cVorname",
"label": "Vorname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cName",
"label": "Nachname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cMobil",
"label": "Mobil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cWWW",
"label": "Website",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cStrasse",
"label": "Straße",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cZusatz",
"label": "Zusatz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cPLZ",
"label": "Postleitzahl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cBundesland",
"label": "Bundesland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontaktadresse",
"detailRole": "information",
"isVisible": true,
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "PaymentTerm",
"label": "Zahlungsziel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "fRabatt",
"label": "Kundenrabatt (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "nKreditlimit",
"label": "Kreditlimit (Stammwert)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "13F66746-6C42-51FD-8B52-FCD16A1F3AD7",
"openFilters": [
{
"id": "7C139360-BDE7-58BE-BBEB-2BB95521F627",
"includeAllOption": true,
"key": "cLand",
"title": "Land",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "86B05A44-5770-5C45-A489-16F62D4A060D",
"key": "kKunde",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "cKundenNr",
"systemImage": "person.2",
"title": "Kundenakte",
"titleKey": "CustomerName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cStrasse",
"label": "Straße",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cPLZ",
"label": "Postleitzahl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "775461E4-2DA1-5302-938D-5CD4D40F3FE9",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "AddressName",
"label": "Empfänger",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "AddressKind",
"label": "Adresstyp",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cAnrede",
"label": "Anrede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cTitel",
"label": "Titel",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cVorname",
"label": "Vorname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cName",
"label": "Nachname",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cTel",
"label": "Telefon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cMobil",
"label": "Mobil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kontakt",
"detailRole": "information",
"isVisible": true,
"key": "cMail",
"label": "E-Mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cStrasse",
"label": "Straße",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cZusatz",
"label": "Zusatz",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cPLZ",
"label": "Postleitzahl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cOrt",
"label": "Ort",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cBundesland",
"label": "Bundesland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cLand",
"label": "Land",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Adresse",
"detailRole": "information",
"isVisible": true,
"key": "cISO",
"label": "Ländercode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D0FD02F4-0FC7-5860-BD70-B3BA247FBD0A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "9D065D48-53DD-5144-8AE3-D93DD4DC6C59",
"key": "AddressKind",
"type": "text"
},
{
"direction": "ascending",
"id": "6A8A2085-D478-504D-9362-F79FA0B35F18",
"key": "kAdresse",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "AddressKind",
"systemImage": "person.2",
"title": "Kundenadressen",
"titleKey": "AddressName"
},
{
"actions": [
{
"id": "5F2F3892-8167-5650-B2A5-5F151433D681",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1C3E8B5F-1153-52DD-8F5F-70A07A3D7CF1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "AFAD3495-C8AA-5403-BA22-3074D7A7866F",
"title": "Positionen",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryState",
"label": "Lieferstatus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Cancelled",
"label": "Storniert",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dVoraussichtlichesLieferdatum",
"label": "Voraussichtliches Lieferdatum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nZahlungszielTage",
"label": "Zahlungsziel (Tage)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cExterneAuftragsnummer",
"label": "Externe Auftragsnummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "992A1023-B4EF-515B-8F50-6A3690E9D854",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Referenzen",
"detailRole": "information",
"isVisible": true,
"key": "cAuftragsNr",
"label": "Auftrag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Referenzen",
"detailRole": "information",
"isVisible": true,
"key": "dErstellt",
"label": "Auftragsdatum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Referenzen",
"detailRole": "information",
"isVisible": true,
"key": "cExterneAuftragsnummer",
"label": "Externe Auftragsnummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryState",
"label": "Lieferstatus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "Cancelled",
"label": "Storniert",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "Archived",
"label": "Archiviert",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "dVoraussichtlichesLieferdatum",
"label": "Voraussichtliches Lieferdatum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "cVersandlandISO",
"label": "Versandland",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Lieferung",
"detailRole": "information",
"isVisible": true,
"key": "nLieferPrioritaet",
"label": "Lieferpriorität",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "fFaktor",
"label": "Währungsfaktor (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Konditionen",
"detailRole": "information",
"isVisible": true,
"key": "nZahlungszielTage",
"label": "Zahlungsziel (Tage)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FDB4309A-C22C-51B1-A6C3-8FEF2D92FE62",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "8F78B086-8905-5C07-B35C-EA47654D44AD",
"key": "dErstellt",
"type": "date"
},
{
"direction": "ascending",
"id": "0A108056-7622-5B44-A62F-B5029C4025B9",
"key": "kAuftrag",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "dErstellt",
"systemImage": "person.2",
"title": "Kundenaufträge",
"titleKey": "cAuftragsNr"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "fAnzahl",
"label": "Menge",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cEinheit",
"label": "Einheit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "fVkNetto",
"label": "Nettopreis (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "fRabatt",
"label": "Rabatt (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "fVkBruttoGesamt",
"label": "Positionssumme brutto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "AFAD3495-C8AA-5403-BA22-3074D7A7866F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Position",
"detailRole": "information",
"isVisible": true,
"key": "cName",
"label": "Position",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Position",
"detailRole": "information",
"isVisible": true,
"key": "cArtNr",
"label": "Artikelnummer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Position",
"detailRole": "information",
"isVisible": true,
"key": "cNameStandard",
"label": "Name in Standardsprache",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Position",
"detailRole": "information",
"isVisible": true,
"key": "cAuftragsNr",
"label": "Auftrag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fAnzahl",
"label": "Menge",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "cEinheit",
"label": "Einheit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fVkNetto",
"label": "Nettopreis (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fRabatt",
"label": "Rabatt (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fMwSt",
"label": "MwSt. (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fVkNettoGesamt",
"label": "Positionssumme netto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fVkBruttoGesamt",
"label": "Positionssumme brutto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "cWaehrung",
"label": "Auftragswährung",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Menge und Preise",
"detailRole": "information",
"isVisible": true,
"key": "fFaktor",
"label": "Währungsfaktor (nativ)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Hinweise",
"detailRole": "information",
"isVisible": true,
"key": "cHinweis",
"label": "Hinweis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4771CFB8-270A-5C9B-89E1-34C8217A6FFB",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "167E1231-410E-5EF0-9DDD-F96ABD9C9162",
"key": "nSort",
"type": "number"
},
{
"direction": "ascending",
"id": "9E252AB6-C2A7-5A5F-AFB4-8B7A5B38208E",
"key": "kAuftragPosition",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "cArtNr",
"systemImage": "person.2",
"title": "Auftragspositionen",
"titleKey": "cName"
}
],
"relations": [
{
"childDatasetID": "775461E4-2DA1-5302-938D-5CD4D40F3FE9",
"childKey": "kKunde",
"id": "3C599AFE-D3A0-5FDB-98F4-FA6917C51944",
"name": "Alle Adressen",
"parentDatasetID": "E0FFC8FF-BD49-56B2-B78F-76DAA121869C",
"parentKey": "kKunde"
},
{
"childDatasetID": "992A1023-B4EF-515B-8F50-6A3690E9D854",
"childKey": "kKunde",
"id": "66A3FF8B-688A-515A-B487-19256A78988C",
"name": "Aufträge",
"parentDatasetID": "E0FFC8FF-BD49-56B2-B78F-76DAA121869C",
"parentKey": "kKunde"
},
{
"childDatasetID": "AFAD3495-C8AA-5403-BA22-3074D7A7866F",
"childKey": "kAuftrag",
"id": "1C3E8B5F-1153-52DD-8F5F-70A07A3D7CF1",
"name": "Positionen",
"parentDatasetID": "992A1023-B4EF-515B-8F50-6A3690E9D854",
"parentKey": "kAuftrag"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "JTL-Wawi",
"configurationLanguages": [
"de"
],
"countries": [
"DE"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "INOFFIZIELL — NICHT AN EINER ECHTEN ERP-INSTALLATION VALIDIERT. Für JTL-Wawi 2.0.1.0 / SQL Server. Offizielle physische Dokumentation, synthetische Prüfungen und native Cifru-DEMO-Aufnahmen; kein Test auf einer echten Installation. Quelle beim Import zuordnen, Lesetest ausführen und Version, Berechtigungen, Ergebnisse sowie Laufzeit prüfen.\n\nFür Vertrieb, Kundenservice und Geschäftsführung: eine Kundenakte mit aktuellen Kontakten, Buchhaltungsreferenzen und Konditionen. Alle Adressen öffnen; danach die Aufträge dieses Kunden und deren Positionen mit Mengen, Einheiten, nativen Preisen, Rabatt, Steuer und Hinweisen prüfen.\n\nWarum Cifru? Passen Sie Konfigurationen an Ihre Arbeitsweise an. Wählen Sie die benötigten Felder, Filter und Details und holen Sie Informationen aufs Smartphone, die in der mobilen App Ihrer Unternehmenssoftware möglicherweise fehlen. Die Möglichkeiten hängen von den zugänglichen Daten Ihrer autorisierten Quelle und Ihrem Cifru-Tarif ab.\n\nEin Datensatz je Kunde, auch ohne Adresse. Die Kontaktanzeige wählt zuerst eine Rechnungsadresse, bei mehreren die kleinste interne Adress-ID, andernfalls die kleinste vorhandene Adresse. Das ist eine nachvollziehbare Anzeigeauswahl, nicht die Zusage der JTL-Standardadresse. Alle anderen Adressen stehen im Unterbutton. Es sind aktuelle Stammdaten, keine historischen Dokumentanschriften.\n\nZahlungsziel 0 bedeutet JTL-Standard aus der ersten Mahnstufe, nicht sofortige Fälligkeit. Kundenrabatt ist der Stammwert, nicht der effektiv angewandte Rabatt jedes Auftrags. Kreditlimit ist der native Stammwert; Währungsbasis in der Installation prüfen. Es ist keine offene Forderung und keine garantierte Liefersperre. Undokumentierte Sperr-/POS-Codes werden nicht als sichere Statusangaben ausgelegt.\n\nAufträge: nur Vorgangstyp 1; Angebote, Umlagerungen und Abonnements ausgeschlossen. Alte, archivierte oder stornierte Aufträge werden nicht durch ein willkürliches Datumsfenster ausgeblendet. Lieferstatus unterscheidet unvollständig, vollständig per Lieferschein und vollständig manuell; er ist kein Zahlungsstatus. Positionen werden durch die echte Auftrags-ID eingeschränkt, einschließlich Freitext-/Versand-/Sonderpositionen. Originalwerte bleiben unverändert; keine selbst errechnete Auftragssumme, Marge, Währungsumrechnung oder Zahlungssumme. Hierarchische Positionen dürfen nicht blind summiert werden.\n\nPro: eine Quelle, vier Listen, drei Verknüpfungen und schreibgeschütztes SQL. Land beim Öffnen wählen (oder alle); Details lesen Kinder nur auf Anfrage. Limits: 2.000 Kunden, 500 Adressen je Kunde, 1.000 Aufträge je Kunde, 1.000 Positionen je Auftrag. Bei Erreichen eines Limits keine Vollständigkeitszusage. Suche/Filter betreffen geladene Zeilen. Keine periodische Aktualisierung. Ein Zeilenlimit garantiert keine kurze Serverlaufzeit; Indizes und Berechtigungen lokal prüfen.\n\nNur autorisierte SELECT-Zugriffe. UI-Filter ersetzen keine Datenbankrechte oder Mandantentrennung. Keine Zugangsdaten, Bankverbindungen oder echten Kunden im Paket/den Bildern. Kontaktdaten und Steuerreferenzen nur berechtigten Nutzern zeigen. Screenshots: vollständig erfundene DEMO-Daten. Keine Zertifizierung durch JTL. Dokumentation: https://guide.jtl-software.com/jtl-wawi/kunden/dialogfenster-kundenstammdaten/ https://guide.jtl-software.com/jtl-wawi/verkauf/auftragsdetails/ https://wawi-db.jtl-software.de/tables/2.0.1.0",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "847A173A-21B8-5E83-BE92-7E3514D2B0E4",
"rootButtonCount": 1,
"summary": "Kundenkontakte und Konditionen, alle Adressen sowie kundenbezogene Aufträge mit Positionsdetails.",
"tags": [
"JTL-Wawi",
"SQL Server",
"Kunden",
"Vertrieb",
"Pro"
],
"title": "Kundenakte: Adressen, Aufträge und Positionen — Pro"
}
}