FastReport Daten für Angebot/Auftrag: Unterschied zwischen den Versionen
Aus GEVITAS
(Die Seite wurde neu angelegt: „== Allgemeines == Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck eines Angebots/einer Auftragsbestätigung zur Verfügung gestellt…“) |
|||
Zeile 6: | Zeile 6: | ||
;Diese Abschnitt ist derzeit in Bearbeitung! | ;Diese Abschnitt ist derzeit in Bearbeitung! | ||
+ | |||
+ | == Tabelle AuftragsKopf== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StatusNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StatusText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Berechnet | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bezahlt | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerechnenTageWochenMonate | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AdressNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KundenNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AdressKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NameFirma | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|160 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnsprechPartner | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Abteilung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Str | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LandKennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Sprache | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PersAnrede | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AbholerName | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-Name | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-OrtKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Stand | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-Raum | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-VonDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-VonZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-VonText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-BisDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-BisZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VA-BisText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AufbauDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AufbauZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AufbauText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Aufbau_Bemekung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProbeDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProbeZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProbeText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Probe_Bemekung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AbbauDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AbbauZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AbbauText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Abbau_Bemekung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bearbeiter | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftragErteiltAm | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProdBestNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VersandArt | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VersandText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoDatumVon | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoZeitVon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoKennzchVon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoDatumBis | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoZeitBis | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DispoKennzchBis | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Filiale | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckDat | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckZeit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProjektNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kostenstelle | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AngebotGueltigBis | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kopftext | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuVersion | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProdLeiter_Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TechnLeiter_Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DekoLeiter_Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LagerLeiter_Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mietpreis_A_B | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Preisart_Mietpreisstaffel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Aus_AuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Musterlieferung_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BusinessForecast | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Auftragsart | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerchnEinheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ErfDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ErfUser | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bereich_1Verkauf_2Miete_3Mietverkauf | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ6 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ7 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ8 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ9 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ10 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ11 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KENNZ12 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Positionen== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kapitel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PosNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StatusNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StatusText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LfdNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SPRACHE | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Typ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SetNrHauptArtikel | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikelart_1MT_2VK_3DL_4AZ | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ARTIKELHERKUNFT | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz_1MT_2VK_3MV | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Menge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mietpreisstaffel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Prio | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Einheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EK-Preis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DatumVon | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZeitVon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DatumBis | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZeitBis | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerechnEinheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EINSTAGE | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EINSWOCHEN | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EINSMONATE | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Berechnen_Tage_Wo_Mo | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StundenSoll_BeiArbZeit | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|STDIST | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MietFaktor | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Alternativ_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckKennzeichen_0Nicht_1Normal_2_MitBez_3NurKap_4OhneText | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SetNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Seitenwechsel_0Nein_1Vorher_2Nachher | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuschlagProzent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EinzelPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZWISUMME | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattProzent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BishBerMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeFremd | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeReserve | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeAusgegeben | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeAusgegebenFremd | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengePackliste | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeZurueck | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeRueckhol | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeRueckholZurueck | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MengeFremdZurueck | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AusgabeMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AbholMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KundArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerechnEinheit | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstKennz | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KapitelPauschal | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EK-Preis_Ges | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Fremdkosten | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ausschreibungsposition | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ERFUSER | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ERFDATUM | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ANDDAT | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TextFest | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TextPosition | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TextIntern | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz2 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZubehoerKennzch_1Haupt_2Unter | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_StListKennz | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EinzelArtikel_StListKennz | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Gepackt | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Obergruppe | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Gruppe | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Untergruppe | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|25 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Typ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Bezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Einheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Kennz1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Kennz2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Kennz3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Kennz4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Kennz5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Hersteller | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_UrsprLand | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Abmessungen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_NettoGewicht | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_BruttoGewicht | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Volumen | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_VerpEinheit | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_AbmessungenVK | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_VerpAbmessungen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_NettoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_BruttoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_VolumenVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_ArtikelArt | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Einzelartikel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Dispoartikel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Bestandsfuehrung | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_MwstKennz | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_KundArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Text | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_BruchPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_LetzterEKPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_DurchschnittsEKPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_StromVerbrauchWatt | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtBruttoGewichtMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtNettoGewichtMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtBruttoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtNettoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtVolumenMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtVolumenVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artikel_Lagerort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KapitelSumme | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KapitelBezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KapitelAusgabeMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KundenArtikelNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtStromverbrauch | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtDurchschnEK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BarcodeNrMengenartikel | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZentralLagerMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnzahlMaterialPos | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ObergruppeBezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GruppeBezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|UntGruppeBezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosBruttoGewichtMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosNettoGewichtMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosBruttoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosNettoGewichtVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosVolumenMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrPosVolumenVK | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ID_STRING | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle AuftragsFuss== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Waeherung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurs | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PosRabatt_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PosRabatt_Prozent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KalkSummeMiete | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KalkSummeVerkauf | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KalkSummeGesamt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Selbstkosten_Miete | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EK-SummeVerkauf | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Selbstkosten_Dienstlst | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Selbstkosten_ArbZeit | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Selbstkosten_Summe | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeMiete | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeVerkauf | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeDienstlst | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeArbzeit | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummePositionen | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NettoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Versicherung_Text | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Versicherung_Prozent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Versicherung_Betrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Pauschalpreis_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstKennzeichen | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSatzProzent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSatz2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MWSTBETRAG2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PortoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtBetragBrutto | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlBedKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlBedText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|200 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlungBis | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SkontoDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SkontoProzent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SkontoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeDienstlstg | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeArbZeit | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeVerkauf | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeMiete | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnzahlKopienAng | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnzahlKopienAuftr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckOptionPositionen | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckOptionPosBetrag | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckOptionGesBetrag | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckOptionBezeichnung | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckOptionUrsprLand | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|FussText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ErloesKonto | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle AuftrStatistik== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnzahlAlternativPos | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AnzahlRabattPos | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeRabatt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrVersion | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtBruttoGewicht | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtNettoGewicht | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtVerpackVolumen | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtAbholVolumen | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtAbholBruttoGewicht | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MaxKapitelNr | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle KapitelZusammenfassung== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kapitel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Typ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|GesamtBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Text | ||
+ | |style="width: 5%;"|Variant | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle LieferAnschrift== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NameFirma | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|160 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Sprache | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle RueckholAnschrift== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NameFirma | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|160 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Adresse== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NameFirma | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|160 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Abteilung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Sprache | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelGesch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelPriv | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelMobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|250 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Internet | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SKYPE_Name | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Stichwort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|200 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AdrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KundenNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LieferantNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SteuerNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|USTID | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Inaktiv | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz6 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz7 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz8 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz9 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz10 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz11 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz12 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz13 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz14 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz15 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz16 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz17 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz18 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz19 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz20 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz21 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz22 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz23 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz24 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz25 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz26 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz27 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz28 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz29 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz30 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz6 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz7 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz8 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz9 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz10 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz11 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftrKennz12 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AuftragsArt | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Filiale | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MatrikelNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Ansprechpartner== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Abteilung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PersAnrede | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Briefanrede | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Anrede | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurzzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Titel | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telgesch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelPriv | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelMobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Internet | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|60 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Geburtstag | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SkypeName | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Inaktiv | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz6 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz7 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz8 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz9 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz10 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz11 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz12 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz13 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz14 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz15 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz16 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz17 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz18 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz19 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz20 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz21 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz22 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz23 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz24 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz25 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz26 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz27 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz28 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz29 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz30 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle ArtikelFussTexte== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Typ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bezeichnung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtikelText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle AuftrMwst== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSchluessel | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstProzent | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NettoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BruttoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Bearbeiter== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kurzzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LandKennzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PersAnrede | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|200 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TelMobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Durchwahl | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PersNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle DekoLeiter== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EMail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Durchwahl | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle LagerLeiter== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EMail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Durchwahl | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle ProjektLeiter== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EMail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Durchwahl | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle TechnLeiter== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Vorname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nachname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Landkennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefon | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Telefax | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EMail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mobil | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Durchwahl | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Funktion | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle StListenPakete== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Sortierung | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Menge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz1 | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz2 | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz3 | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle StandardTextKopf== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StandardText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle StandardTextFuss== | ||
+ | |||
+ | {| class="wikitable" style="text-align: left;width: 80%;" | ||
+ | !style="width: 30%;"|Feld | ||
+ | !style="width: 5%;"|Typ | ||
+ | !style="width: 5%;"|Größe | ||
+ | !style="width: 60%;"|Beschreibung | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|StandardText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
Version vom 9. August 2017, 14:11 Uhr
Inhaltsverzeichnis
- 1 Allgemeines
- 2 Tabelle AuftragsKopf
- 3 Tabelle Positionen
- 4 Tabelle AuftragsFuss
- 5 Tabelle AuftrStatistik
- 6 Tabelle KapitelZusammenfassung
- 7 Tabelle LieferAnschrift
- 8 Tabelle RueckholAnschrift
- 9 Tabelle Adresse
- 10 Tabelle Ansprechpartner
- 11 Tabelle ArtikelFussTexte
- 12 Tabelle AuftrMwst
- 13 Tabelle Bearbeiter
- 14 Tabelle DekoLeiter
- 15 Tabelle LagerLeiter
- 16 Tabelle ProjektLeiter
- 17 Tabelle TechnLeiter
- 18 Tabelle StListenPakete
- 19 Tabelle StandardTextKopf
- 20 Tabelle StandardTextFuss
- 21 Links
1 Allgemeines
Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck eines Angebots/einer Auftragsbestätigung zur Verfügung gestellt werden.
- Hinweis
- Diese Abschnitt ist derzeit in Bearbeitung!
2 Tabelle AuftragsKopf
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
AuftrNr | Integer | 4 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 4 | |
Berechnet | SmallInt | 2 | |
Bezahlt | SmallInt | 2 | |
BerechnenTageWochenMonate | Float | 8 | |
AdressNr | Integer | 4 | |
KundenNr | Integer | 4 | |
AdressKurzname | String | 40 | |
NameFirma | String | 160 | |
AnsprechPartner | String | 40 | |
Abteilung | String | 40 | |
Str | String | 40 | |
LandKennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Landname | String | 40 | |
Sprache | String | 1 | |
PersAnrede | String | 50 | |
AbholerName | String | 40 | |
VA-Name | String | 40 | |
VA-OrtKurzname | String | 40 | |
Stand | String | 6 | |
VA-Ort | String | 30 | |
VA-Raum | String | 20 | |
VA-VonDatum | DateTime | 8 | |
VA-VonZeit | String | 5 | |
VA-VonText | String | 20 | |
VA-BisDatum | DateTime | 8 | |
VA-BisZeit | String | 5 | |
VA-BisText | String | 20 | |
AufbauDatum | DateTime | 8 | |
AufbauZeit | String | 5 | |
AufbauText | String | 15 | |
Aufbau_Bemekung | String | 25 | |
ProbeDatum | DateTime | 8 | |
ProbeZeit | String | 5 | |
ProbeText | String | 15 | |
Probe_Bemekung | String | 25 | |
AbbauDatum | DateTime | 8 | |
AbbauZeit | String | 5 | |
AbbauText | String | 15 | |
Abbau_Bemekung | String | 25 | |
Bearbeiter | String | 20 | |
AuftragErteiltAm | DateTime | 8 | |
ProdBestNr | String | 30 | |
VersandArt | String | 40 | |
VersandText | String | 40 | |
Bemerkung | String | 100 | |
DispoDatumVon | DateTime | 8 | |
DispoZeitVon | String | 5 | |
DispoKennzchVon | String | 1 | |
DispoDatumBis | DateTime | 8 | |
DispoZeitBis | String | 5 | |
DispoKennzchBis | String | 1 | |
Filiale | String | 5 | |
DruckDat | DateTime | 8 | |
DruckZeit | String | 8 | |
ProjektNr | Integer | 4 | |
Kostenstelle | Integer | 4 | |
AngebotGueltigBis | DateTime | 8 | |
Kopftext | Memo | 0 | |
ZuAuftrNr | Integer | 4 | |
ZuVersion | Integer | 4 | |
ProdLeiter_Kurzname | String | 20 | |
TechnLeiter_Kurzname | String | 20 | |
DekoLeiter_Kurzname | String | 20 | |
LagerLeiter_Kurzname | String | 20 | |
Mietpreis_A_B | SmallInt | 2 | |
Preisart_Mietpreisstaffel | SmallInt | 2 | |
Aus_AuftrNr | Integer | 4 | |
Musterlieferung_0_1 | SmallInt | 2 | |
BusinessForecast | Integer | 4 | |
Auftragsart | SmallInt | 2 | |
BerchnEinheit | String | 6 | |
ErfDatum | DateTime | 8 | |
ErfUser | String | 10 | |
Bereich_1Verkauf_2Miete_3Mietverkauf | SmallInt | 2 | |
KENNZ1 | String | 10 | |
KENNZ2 | String | 10 | |
KENNZ3 | String | 10 | |
KENNZ4 | String | 10 | |
KENNZ5 | String | 10 | |
KENNZ6 | String | 10 | |
KENNZ7 | String | 10 | |
KENNZ8 | String | 10 | |
KENNZ9 | String | 10 | |
KENNZ10 | String | 10 | |
KENNZ11 | String | 10 | |
KENNZ12 | String | 10 |
3 Tabelle Positionen
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
AuftrNr | Integer | 4 | |
Kapitel | SmallInt | 2 | |
PosNr | SmallInt | 2 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 4 | |
ArtNr | String | 20 | |
LfdNr | SmallInt | 2 | |
SPRACHE | String | 1 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
SetNrHauptArtikel | String | 10 | |
Artikelart_1MT_2VK_3DL_4AZ | SmallInt | 2 | |
ARTIKELHERKUNFT | SmallInt | 2 | |
Kennz_1MT_2VK_3MV | SmallInt | 2 | |
Menge | Float | 8 | |
Mietpreisstaffel | SmallInt | 2 | |
Prio | Integer | 4 | |
Einheit | String | 10 | |
EK-Preis | BCD | 34 | |
DatumVon | DateTime | 8 | |
ZeitVon | String | 5 | |
DatumBis | DateTime | 8 | |
ZeitBis | String | 5 | |
BerechnEinheit | String | 6 | |
EINSTAGE | Float | 8 | |
EINSWOCHEN | Float | 8 | |
EINSMONATE | Float | 8 | |
Berechnen_Tage_Wo_Mo | Float | 8 | |
StundenSoll_BeiArbZeit | Float | 8 | |
STDIST | Float | 8 | |
MietFaktor | Float | 8 | |
Alternativ_0_1 | SmallInt | 2 | |
DruckKennzeichen_0Nicht_1Normal_2_MitBez_3NurKap_4OhneText | SmallInt | 2 | |
SetNr | SmallInt | 2 | |
Seitenwechsel_0Nein_1Vorher_2Nachher | SmallInt | 2 | |
ZuschlagProzent | BCD | 34 | |
EinzelPreis | BCD | 34 | |
GesPreis | BCD | 34 | |
ZWISUMME | BCD | 34 | |
RabattProzent | BCD | 34 | |
RabattBetrag | BCD | 34 | |
GesBetrag | BCD | 34 | |
BishBerMenge | Float | 8 | |
MengeFremd | Float | 8 | |
MengeReserve | Float | 8 | |
MengeAusgegeben | Float | 8 | |
MengeAusgegebenFremd | Float | 8 | |
MengePackliste | Float | 8 | |
MengeZurueck | Float | 8 | |
MengeRueckhol | Float | 8 | |
MengeRueckholZurueck | Float | 8 | |
MengeFremdZurueck | Float | 8 | |
AusgabeMenge | Float | 8 | |
AbholMenge | Float | 8 | |
KundArtNr | String | 40 | |
BerechnEinheit | Float | 8 | |
MwstKennz | Integer | 4 | |
KapitelPauschal | Integer | 4 | |
EK-Preis_Ges | BCD | 34 | |
Fremdkosten | BCD | 34 | |
Ausschreibungsposition | String | 40 | |
ERFUSER | String | 10 | |
ERFDATUM | DateTime | 8 | |
ANDDAT | DateTime | 8 | |
TextFest | SmallInt | 2 | |
TextPosition | Memo | 0 | |
TextIntern | Memo | 0 | |
Kennz1 | SmallInt | 2 | |
Kennz2 | SmallInt | 2 | |
ZubehoerKennzch_1Haupt_2Unter | Integer | 4 | |
Artikel_StListKennz | Integer | 4 | |
EinzelArtikel_StListKennz | Integer | 4 | |
Gepackt | Float | 8 | |
Artikel_Obergruppe | String | 25 | |
Artikel_Gruppe | String | 25 | |
Artikel_Untergruppe | String | 25 | |
Artikel_Typ | String | 40 | |
Artikel_Bezeichnung | String | 255 | |
Artikel_Einheit | String | 10 | |
Artikel_Kennz1 | String | 15 | |
Artikel_Kennz2 | String | 15 | |
Artikel_Kennz3 | String | 15 | |
Artikel_Kennz4 | String | 15 | |
Artikel_Kennz5 | String | 15 | |
Artikel_Hersteller | String | 30 | |
Artikel_UrsprLand | String | 6 | |
Artikel_Abmessungen | String | 20 | |
Artikel_NettoGewicht | Float | 8 | |
Artikel_BruttoGewicht | Float | 8 | |
Artikel_Volumen | Float | 8 | |
Artikel_VerpEinheit | Float | 8 | |
Artikel_AbmessungenVK | String | 20 | |
Artikel_VerpAbmessungen | String | 20 | |
Artikel_NettoGewichtVK | Float | 8 | |
Artikel_BruttoGewichtVK | Float | 8 | |
Artikel_VolumenVK | Float | 8 | |
Artikel_ArtikelArt | SmallInt | 2 | |
Artikel_Einzelartikel | SmallInt | 2 | |
Artikel_Dispoartikel | SmallInt | 2 | |
Artikel_Bestandsfuehrung | SmallInt | 2 | |
Artikel_MwstKennz | SmallInt | 2 | |
Artikel_KundArtNr | String | 40 | |
Artikel_Text | Memo | 0 | |
Artikel_BruchPreis | BCD | 34 | |
Artikel_LetzterEKPreis | BCD | 34 | |
Artikel_DurchschnittsEKPreis | BCD | 34 | |
Artikel_StromVerbrauchWatt | Float | 8 | |
GesamtBruttoGewichtMiete | Float | 8 | |
GesamtNettoGewichtMiete | Float | 8 | |
GesamtBruttoGewichtVK | Float | 8 | |
GesamtNettoGewichtVK | Float | 8 | |
GesamtVolumenMiete | Float | 8 | |
GesamtVolumenVK | Float | 8 | |
Artikel_Lagerort | String | 20 | |
KapitelSumme | BCD | 34 | |
KapitelBezeichnung | String | 255 | |
KapitelAusgabeMenge | Float | 8 | |
KundenArtikelNr | String | 30 | |
GesamtStromverbrauch | Float | 8 | |
GesamtDurchschnEK | Float | 8 | |
BarcodeNrMengenartikel | String | 20 | |
ZentralLagerMenge | Float | 8 | |
AnzahlMaterialPos | Integer | 4 | |
ObergruppeBezeichnung | String | 50 | |
GruppeBezeichnung | String | 50 | |
UntGruppeBezeichnung | String | 50 | |
AuftrPosBruttoGewichtMiete | Float | 8 | |
AuftrPosNettoGewichtMiete | Float | 8 | |
AuftrPosBruttoGewichtVK | Float | 8 | |
AuftrPosNettoGewichtVK | Float | 8 | |
AuftrPosVolumenMiete | Float | 8 | |
AuftrPosVolumenVK | Float | 8 | |
ID_STRING | String | 30 |
4 Tabelle AuftragsFuss
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Waeherung | String | 6 | |
Kurs | BCD | 34 | |
PosRabatt_0_1 | SmallInt | 2 | |
PosRabatt_Prozent | BCD | 34 | |
KalkSummeMiete | BCD | 34 | |
KalkSummeVerkauf | BCD | 34 | |
KalkSummeGesamt | BCD | 34 | |
Selbstkosten_Miete | BCD | 34 | |
EK-SummeVerkauf | BCD | 34 | |
Selbstkosten_Dienstlst | BCD | 34 | |
Selbstkosten_ArbZeit | BCD | 34 | |
Selbstkosten_Summe | BCD | 34 | |
SummeMiete | BCD | 34 | |
SummeVerkauf | BCD | 34 | |
SummeDienstlst | BCD | 34 | |
SummeArbzeit | BCD | 34 | |
SummePositionen | BCD | 34 | |
NettoBetrag | BCD | 34 | |
Versicherung_Text | String | 50 | |
Versicherung_Prozent | BCD | 34 | |
Versicherung_Betrag | BCD | 34 | |
Pauschalpreis_0_1 | SmallInt | 2 | |
MwstKennzeichen | SmallInt | 2 | |
MwstSatzProzent | BCD | 34 | |
MwstSatz2 | BCD | 34 | |
MwstBetrag | BCD | 34 | |
MWSTBETRAG2 | BCD | 34 | |
PortoBetrag | BCD | 34 | |
GesamtBetragBrutto | BCD | 34 | |
ZahlBedKurzname | String | 30 | |
ZahlBedText | String | 200 | |
ZahlungBis | DateTime | 8 | |
SkontoDatum | DateTime | 8 | |
SkontoProzent | BCD | 34 | |
SkontoBetrag | BCD | 34 | |
SummeDienstlstg | BCD | 34 | |
SummeArbZeit | BCD | 34 | |
SummeVerkauf | BCD | 34 | |
SummeMiete | BCD | 34 | |
AnzahlKopienAng | SmallInt | 2 | |
AnzahlKopienAuftr | SmallInt | 2 | |
DruckOptionPositionen | SmallInt | 2 | |
DruckOptionPosBetrag | SmallInt | 2 | |
DruckOptionGesBetrag | SmallInt | 2 | |
DruckOptionBezeichnung | Integer | 4 | |
DruckOptionUrsprLand | Integer | 4 | |
FussText | Memo | 0 | |
ErloesKonto | String | 10 |
5 Tabelle AuftrStatistik
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
AnzahlAlternativPos | Integer | 4 | |
AnzahlRabattPos | Integer | 4 | |
SummeRabatt | BCD | 34 | |
AuftrVersion | Integer | 4 | |
GesamtBruttoGewicht | Float | 8 | |
GesamtNettoGewicht | Float | 8 | |
GesamtVerpackVolumen | Float | 8 | |
GesamtAbholVolumen | Float | 8 | |
GesamtAbholBruttoGewicht | Float | 8 | |
MaxKapitelNr | SmallInt | 2 |
6 Tabelle KapitelZusammenfassung
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Kapitel | SmallInt | 2 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
GesamtBetrag | BCD | 34 | |
Text | Variant | 0 |
7 Tabelle LieferAnschrift
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
NameFirma | String | 160 | |
Strasse | String | 40 | |
Landkennzch | String | 10 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Landname | String | 40 | |
Sprache | String | 1 |
8 Tabelle RueckholAnschrift
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
NameFirma | String | 160 | |
Strasse | String | 40 | |
Landkennzch | String | 10 | |
PLZ | String | 10 | |
Ort | String | 40 |
9 Tabelle Adresse
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Kurzname | String | 40 | |
NameFirma | String | 160 | |
Abteilung | String | 40 | |
Strasse | String | 40 | |
Landkennzeichen | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Landname | String | 40 | |
Sprache | String | 1 | |
TelGesch | String | 30 | |
TelPriv | String | 30 | |
TelMobil | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Bemerkung | String | 250 | |
Internet | String | 100 | |
SKYPE_Name | String | 100 | |
Stichwort | String | 200 | |
AdrNr | Integer | 4 | |
KundenNr | Integer | 4 | |
LieferantNr | Integer | 4 | |
SteuerNr | String | 30 | |
USTID | String | 20 | |
Inaktiv | Integer | 4 | |
Kennz1 | String | 6 | |
Kennz2 | String | 6 | |
Kennz3 | String | 6 | |
Kennz4 | String | 6 | |
Kennz5 | String | 6 | |
Kennz6 | String | 6 | |
Kennz7 | String | 6 | |
Kennz8 | String | 6 | |
Kennz9 | String | 6 | |
Kennz10 | String | 6 | |
Kennz11 | String | 6 | |
Kennz12 | String | 6 | |
Kennz13 | String | 6 | |
Kennz14 | String | 6 | |
Kennz15 | String | 6 | |
Kennz16 | String | 6 | |
Kennz17 | String | 6 | |
Kennz18 | String | 6 | |
Kennz19 | String | 6 | |
Kennz20 | String | 6 | |
Kennz21 | String | 6 | |
Kennz22 | String | 6 | |
Kennz23 | String | 6 | |
Kennz24 | String | 6 | |
Kennz25 | String | 6 | |
Kennz26 | String | 6 | |
Kennz27 | String | 6 | |
Kennz28 | String | 6 | |
Kennz29 | String | 6 | |
Kennz30 | String | 6 | |
AuftrKennz1 | String | 10 | |
AuftrKennz2 | String | 10 | |
AuftrKennz3 | String | 10 | |
AuftrKennz4 | String | 10 | |
AuftrKennz5 | String | 10 | |
AuftrKennz6 | String | 10 | |
AuftrKennz7 | String | 10 | |
AuftrKennz8 | String | 10 | |
AuftrKennz9 | String | 10 | |
AuftrKennz10 | String | 10 | |
AuftrKennz11 | String | 10 | |
AuftrKennz12 | String | 10 | |
AuftragsArt | SmallInt | 2 | |
Filiale | String | 5 | |
MatrikelNr | String | 20 |
10 Tabelle Ansprechpartner
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Kurzname | String | 40 | |
Nachname | String | 30 | |
Vorname | String | 20 | |
Abteilung | String | 50 | |
PersAnrede | String | 50 | |
Briefanrede | String | 50 | |
Anrede | String | 50 | |
Kurzzeichen | String | 5 | |
Titel | String | 40 | |
Funktion | String | 30 | |
Telgesch | String | 30 | |
TelPriv | String | 30 | |
TelMobil | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Internet | String | 60 | |
Bemerkung | String | 255 | |
Geburtstag | DateTime | 8 | |
SkypeName | String | 100 | |
Inaktiv | Integer | 4 | |
Kennz1 | String | 6 | |
Kennz2 | String | 6 | |
Kennz3 | String | 6 | |
Kennz4 | String | 6 | |
Kennz5 | String | 6 | |
Kennz6 | String | 6 | |
Kennz7 | String | 6 | |
Kennz8 | String | 6 | |
Kennz9 | String | 6 | |
Kennz10 | String | 6 | |
Kennz11 | String | 6 | |
Kennz12 | String | 6 | |
Kennz13 | String | 6 | |
Kennz14 | String | 6 | |
Kennz15 | String | 6 | |
Kennz16 | String | 6 | |
Kennz17 | String | 6 | |
Kennz18 | String | 6 | |
Kennz19 | String | 6 | |
Kennz20 | String | 6 | |
Kennz21 | String | 6 | |
Kennz22 | String | 6 | |
Kennz23 | String | 6 | |
Kennz24 | String | 6 | |
Kennz25 | String | 6 | |
Kennz26 | String | 6 | |
Kennz27 | String | 6 | |
Kennz28 | String | 6 | |
Kennz29 | String | 6 | |
Kennz30 | String | 6 |
11 Tabelle ArtikelFussTexte
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
ArtNr | String | 20 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
Kurzname | String | 10 | |
ArtikelText | Memo | 0 |
12 Tabelle AuftrMwst
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
MwstSchluessel | Integer | 4 | |
MwstProzent | Float | 8 | |
MwstBetrag | BCD | 34 | |
NettoBetrag | BCD | 34 | |
BruttoBetrag | BCD | 34 |
13 Tabelle Bearbeiter
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Kurzzeichen | String | 10 | |
Vorname | String | 30 | |
Nachname | String | 40 | |
Strasse | String | 40 | |
LandKennzeichen | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
PersAnrede | String | 50 | |
Telefon | String | 30 | |
Telefax | String | 30 | |
String | 200 | ||
TelMobil | String | 30 | |
Durchwahl | String | 30 | |
Funktion | String | 30 | |
PersNr | Integer | 4 |
14 Tabelle DekoLeiter
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Vorname | String | 30 | |
Nachname | String | 40 | |
Strasse | String | 40 | |
Landkennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Telefon | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Mobil | String | 30 | |
Durchwahl | String | 30 | |
Funktion | String | 30 |
15 Tabelle LagerLeiter
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Vorname | String | 30 | |
Nachname | String | 40 | |
Strasse | String | 40 | |
Landkennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Telefon | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Mobil | String | 30 | |
Durchwahl | String | 30 | |
Funktion | String | 30 |
16 Tabelle ProjektLeiter
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Vorname | String | 30 | |
Nachname | String | 40 | |
Strasse | String | 40 | |
Landkennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Telefon | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Mobil | String | 30 | |
Durchwahl | String | 30 | |
Funktion | String | 30 |
17 Tabelle TechnLeiter
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Vorname | String | 30 | |
Nachname | String | 40 | |
Strasse | String | 40 | |
Landkennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Telefon | String | 30 | |
Telefax | String | 30 | |
String | 100 | ||
Mobil | String | 30 | |
Durchwahl | String | 30 | |
Funktion | String | 30 |
18 Tabelle StListenPakete
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
ArtNr | String | 20 | |
Sortierung | Integer | 4 | |
Menge | Float | 8 | |
Kennz1 | Integer | 4 | |
Kennz2 | Integer | 4 | |
Kennz3 | Integer | 4 | |
Bemerkung | String | 50 |
19 Tabelle StandardTextKopf
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
StandardText | Memo | 0 |
20 Tabelle StandardTextFuss
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
StandardText | Memo | 0 |