FastReport Daten für Bestellung: 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 einer Bestellung zur Verfügung gestellt werden. :Hinweis ;Diese…“) |
|||
(Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt) | |||
Zeile 2: | Zeile 2: | ||
Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck einer Bestellung zur Verfügung gestellt werden. | Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck einer Bestellung zur Verfügung gestellt werden. | ||
+ | |||
+ | |||
+ | Tabellen, die in allen Formularen vorkommen könne, werden im Abschnitt [[FastReport Daten für alle Formulare]] beschrieben. | ||
+ | |||
+ | |||
:Hinweis | :Hinweis | ||
;Diese Abschnitt ist derzeit in Bearbeitung! | ;Diese Abschnitt ist derzeit in Bearbeitung! | ||
+ | |||
+ | == Tabelle BestellKopf== | ||
+ | |||
+ | {| 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%;"|BestNr | ||
+ | |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%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Gebucht | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|AdrKurzname | ||
+ | |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%;"|AnsprPartner | ||
+ | |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%;"|LandKennz | ||
+ | |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%;"|Filiale | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BearbeiterNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BearbeiterKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kenzz_1Einkauf_2Miete_3Personal | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LieferSollDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LiefAuftrDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LiefAuftrNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LiefAuftrErteiltDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|120 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|200 | ||
+ | |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%;"|Berechnen | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerEinheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |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%;"|ZuAuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckDatum | ||
+ | |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%;"|DruckDurch | ||
+ | |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%;"|ErfDurch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AendDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AendDurch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |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%;"|Berechnet | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bezahlt | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuBestNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Fixiert | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle BestellFuss== | ||
+ | |||
+ | {| 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%;"|Waehrung | ||
+ | |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%;"|PauschRabattJN | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschRabattProzent | ||
+ | |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%;"|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%;"|SummeNetto1 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeNetto2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeNettoGesamt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschalPreis0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschBetrag2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattProzent1 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattBetrag1 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattProzent2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattBetrag2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nettobetrag1 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Nettobetrag2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSatz1 | ||
+ | |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%;"|MwstBetrag1 | ||
+ | |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%;"|BruttoBetrag1 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BruttoBetrag2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |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%;"|Waehrungsbetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlungsbedingungKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlungsbedingungText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|200 | ||
+ | |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%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle BestellPositionen== | ||
+ | |||
+ | {| 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%;"|BestNr | ||
+ | |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%;"|10 | ||
+ | |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%;"|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%;"|Artikelart_1M_2V_3DL_4AZ | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Artkelherkunft | ||
+ | |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%;"|KennzMieteKauf | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|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%;"|BerechnenMenge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|DruckKennzeichen | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Seitenwechsel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SetKopf | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SetNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |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%;"|GesamtPreis | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZwischenSumme | ||
+ | |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%;"|GesamtBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstKennz | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSatz | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BisherGeliefert | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PosText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZusatzText | ||
+ | |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%;"|Kennz3 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|LieferantArtNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|LieferSollDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TeuerungszuschlagProz | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TeuerungszuschlagBetrag | ||
+ | |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_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%;"|ZuAuftrKopf_AdrKurzname | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrKopf_Firma | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|160 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrKopf_Strasse | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrKopf_PLZ | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrKopf_Ort | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuAuftrKopf_LanndKennz | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|5 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle BestellPositionen== | ||
+ | |||
+ | {| 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%;"|BestellNr | ||
+ | |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%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtikelNr | ||
+ | |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%;"|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%;"|Menge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BisherGeliefert | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|KennzMieteKauf | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|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%;"|Berechnen | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|BerEinheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DruckKennz | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SEitenwechsel | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|GesamtPreis | ||
+ | |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%;"|GesamtBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstKennz | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|MwstSatz | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PosText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|FreiText | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AdrKurzname | ||
+ | |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%;"|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%;"|VersandText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|120 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Versandart | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle BestellLieferAnschrift== | ||
+ | |||
+ | {| 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%;"|LandKennzeichen | ||
+ | |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%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle BestellRueckholAnschrift== | ||
+ | |||
+ | {| 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%;"|Landkennzeichen | ||
+ | |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%;"| | ||
+ | |} | ||
Aktuelle Version vom 9. August 2017, 14:51 Uhr
Inhaltsverzeichnis
1 Allgemeines
Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck einer Bestellung zur Verfügung gestellt werden.
Tabellen, die in allen Formularen vorkommen könne, werden im Abschnitt FastReport Daten für alle Formulare beschrieben.
- Hinweis
- Diese Abschnitt ist derzeit in Bearbeitung!
2 Tabelle BestellKopf
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
BestNr | Integer | 4 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 10 | |
Gebucht | SmallInt | 2 | |
AdrNr | Integer | 4 | |
AdrKurzname | String | 40 | |
NameFirma | String | 160 | |
Abteilung | String | 40 | |
AnsprPartner | String | 40 | |
Str | String | 40 | |
LandKennz | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Landname | String | 40 | |
Sprache | String | 1 | |
PersAnrede | String | 50 | |
Filiale | String | 5 | |
BearbeiterNr | Integer | 4 | |
BearbeiterKurzname | String | 20 | |
Kenzz_1Einkauf_2Miete_3Personal | SmallInt | 2 | |
LieferSollDatum | DateTime | 8 | |
LiefAuftrDatum | DateTime | 8 | |
LiefAuftrNr | String | 20 | |
LiefAuftrErteiltDatum | DateTime | 8 | |
Versandart | String | 40 | |
Versandtext | String | 120 | |
Bemerkung | String | 200 | |
DatumVon | DateTime | 8 | |
ZeitVon | String | 5 | |
DatumBis | DateTime | 8 | |
ZeitBis | String | 5 | |
Berechnen | Float | 8 | |
BerEinheit | String | 6 | |
ProjektNr | Integer | 4 | |
Kostenstelle | Integer | 4 | |
ZuAuftrNr | Integer | 4 | |
DruckDatum | DateTime | 8 | |
DruckZeit | String | 8 | |
DruckDurch | String | 10 | |
ErfDatum | DateTime | 8 | |
ErfDurch | String | 10 | |
AendDatum | DateTime | 8 | |
AendDurch | String | 10 | |
Kopftext | Memo | 0 | |
Berechnet | Integer | 4 | |
Bezahlt | Integer | 4 | |
ZuBestNr | Integer | 4 | |
Fixiert | Integer | 4 |
3 Tabelle BestellFuss
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Waehrung | String | 6 | |
Kurs | BCD | 34 | |
PauschRabattJN | SmallInt | 2 | |
PauschRabattProzent | BCD | 34 | |
SummeMiete | BCD | 34 | |
SummeVerkauf | BCD | 34 | |
SummeDienstlstg | BCD | 34 | |
SummeArbZeit | BCD | 34 | |
SummeNetto1 | BCD | 34 | |
SummeNetto2 | BCD | 34 | |
SummeNettoGesamt | BCD | 34 | |
PauschalPreis0_1 | SmallInt | 2 | |
PauschBetrag2 | BCD | 34 | |
RabattProzent1 | BCD | 34 | |
RabattBetrag1 | BCD | 34 | |
RabattProzent2 | BCD | 34 | |
RabattBetrag2 | BCD | 34 | |
Nettobetrag1 | BCD | 34 | |
Nettobetrag2 | BCD | 34 | |
MwstSatz1 | BCD | 34 | |
MwstSatz2 | BCD | 34 | |
MwstBetrag1 | BCD | 34 | |
MwstBetrag2 | BCD | 34 | |
BruttoBetrag1 | BCD | 34 | |
BruttoBetrag2 | BCD | 34 | |
GesamtBetrag | BCD | 34 | |
Waehrungsbetrag | BCD | 34 | |
ZahlungsbedingungKurzname | String | 30 | |
ZahlungsbedingungText | String | 200 | |
SkontoProzent | BCD | 34 | |
SkontoBetrag | BCD | 34 |
4 Tabelle BestellPositionen
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
BestNr | Integer | 4 | |
Kapitel | SmallInt | 2 | |
PosNr | SmallInt | 2 | |
StatusNr | SmallInt | 2 | |
Statustext | String | 10 | |
ArtNr | String | 20 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
Artikelart_1M_2V_3DL_4AZ | SmallInt | 2 | |
Artkelherkunft | SmallInt | 2 | |
Menge | Float | 8 | |
KennzMieteKauf | SmallInt | 2 | |
Einheit | String | 10 | |
DatumVon | DateTime | 8 | |
ZeitVon | String | 5 | |
DatumBis | DateTime | 8 | |
ZeitBis | String | 5 | |
BerechnenMenge | Float | 8 | |
BerechnEinheit | String | 6 | |
DruckKennzeichen | SmallInt | 2 | |
Seitenwechsel | SmallInt | 2 | |
SetKopf | String | 30 | |
SetNr | Integer | 4 | |
EinzelPreis | BCD | 34 | |
GesamtPreis | BCD | 34 | |
ZwischenSumme | BCD | 34 | |
RabattProzent | BCD | 34 | |
RabattBetrag | BCD | 34 | |
GesamtBetrag | BCD | 34 | |
MwstKennz | SmallInt | 2 | |
MwstSatz | BCD | 34 | |
BisherGeliefert | Float | 8 | |
PosText | Memo | 0 | |
ZusatzText | Memo | 0 | |
Kennz1 | SmallInt | 2 | |
Kennz2 | SmallInt | 2 | |
Kennz3 | SmallInt | 2 | |
BerechnEinheit | Float | 8 | |
LieferantArtNr | String | 40 | |
LieferSollDatum | DateTime | 8 | |
TeuerungszuschlagProz | Float | 8 | |
TeuerungszuschlagBetrag | 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_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 | |
ZuAuftrKopf_AdrKurzname | String | 40 | |
ZuAuftrKopf_Firma | String | 160 | |
ZuAuftrKopf_Strasse | String | 40 | |
ZuAuftrKopf_PLZ | String | 10 | |
ZuAuftrKopf_Ort | String | 40 | |
ZuAuftrKopf_LanndKennz | String | 5 |
5 Tabelle BestellPositionen
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
BestellNr | Integer | 4 | |
Kapitel | SmallInt | 2 | |
PosNr | SmallInt | 2 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 10 | |
ArtikelNr | String | 20 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
Artikelart_1MT_2VK_3DL_4AZ | SmallInt | 2 | |
Artikelherkunft | SmallInt | 2 | |
Menge | Float | 8 | |
BisherGeliefert | Float | 8 | |
KennzMieteKauf | SmallInt | 2 | |
Einheit | String | 10 | |
DatumVon | DateTime | 8 | |
ZeitVon | String | 5 | |
DatumBis | DateTime | 8 | |
ZeitBis | String | 5 | |
Berechnen | Float | 8 | |
BerEinheit | String | 6 | |
DruckKennz | SmallInt | 2 | |
SEitenwechsel | SmallInt | 2 | |
EinzelPreis | BCD | 34 | |
GesamtPreis | BCD | 34 | |
RabattProzent | BCD | 34 | |
RabattBetrag | BCD | 34 | |
GesamtBetrag | BCD | 34 | |
MwstKennz | SmallInt | 2 | |
MwstSatz | BCD | 34 | |
PosText | Memo | 0 | |
FreiText | Memo | 0 | |
AdrKurzname | String | 40 | |
NameFirma | String | 160 | |
Str | String | 40 | |
LandKennzch | String | 5 | |
PLZ | String | 10 | |
Ort | String | 40 | |
VersandText | String | 120 | |
Versandart | String | 40 |
6 Tabelle BestellLieferAnschrift
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
NameFirma | String | 160 | |
Strasse | String | 40 | |
LandKennzeichen | String | 10 | |
PLZ | String | 10 | |
Ort | String | 40 | |
Landname | String | 40 |
7 Tabelle BestellRueckholAnschrift
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
NameFirma | String | 160 | |
Strasse | String | 40 | |
Landkennzeichen | String | 10 | |
PLZ | String | 10 | |
Ort | String | 40 |