FastReport Daten für Faktura: 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 Rechnung/Gutschrift zur Verfügung gestellt werden. :Hinwe…“) |
|||
Zeile 7: | Zeile 7: | ||
+ | |||
+ | == Tabelle RechnungsKopf== | ||
+ | |||
+ | {| 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%;"|RechNr | ||
+ | |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%;"|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%;"|RechnDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|DruckUser | ||
+ | |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%;"|ErfUser | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |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%;"|KundenNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |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%;"|Bearbeiter | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |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%;"|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-Stand | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |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%;"|ProbeText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|15 | ||
+ | |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%;"|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%;"|BestellDatum | ||
+ | |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%;"|DispoKennzVon | ||
+ | |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%;"|DispoKennzBis | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |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%;"|BerechnenEinheit | ||
+ | |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%;"|Preisgruppe | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Lieferdatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |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%;"|Kopftext | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |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%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ProjektLeiterKurzzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|TechnLeiterKurzzeichen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuRepaAuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuRechnNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZuVersion | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle RechnungsFuss== | ||
+ | |||
+ | {| 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%;"|RECHNR | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SummeAlles | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Pauschal_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschalBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschalRabatt_0_1 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|PauschalRabattProzent | ||
+ | |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%;"|MwstKennzch | ||
+ | |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%;"|MwstSatz2Prozent | ||
+ | |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%;"|PortoBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VersicherungText | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|50 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VersicherungProzent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|VersicherungBetrag | ||
+ | |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%;"|Währung | ||
+ | |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%;"|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%;"|SelbstkostenGesamt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EinkaufskostenGesamt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SelbstkostenDienstlst | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SelbstkostenArbZeit | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SKSumme | ||
+ | |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%;"|NettoBetrag2 | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlungsbedKurz | ||
+ | |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%;"|ZahlungBisDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Skonto1BisDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Skonto1Prozent | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |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%;"|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%;"|ZuAuftragNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |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%;"|Menge | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|BerechnEinheit | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|6 | ||
+ | |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%;"|Preisgruppe | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz_1M_2_VK_3MV | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ArtikelArt_1M_2VK_3DL_4AZ | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|Artikel_BerechnEinheit | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|StdSoll | ||
+ | |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%;"|FaktorMiete | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |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%;"|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%;"|DruckKennzch_0Nein_1Normal | ||
+ | |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%;"|Set | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|SetKennzch | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |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%;"|FreiText | ||
+ | |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%;"|MwwstKennz | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kapitelpauschal_0_1 | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AusAuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AusAuftrKapitel | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|AusAuftrPos | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|EinkaufKostenGesamt | ||
+ | |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%;"|AnzahlungsKennzch | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |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%;"|Artikel_Text | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |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%;"|GesamtNettttoGewichtMiete | ||
+ | |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%;"|GesamtNettttoGewichtVK | ||
+ | |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%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle RechStatistik== | ||
+ | |||
+ | {| 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%;"|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%;"|AnzahlLieferscheine | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Mahnungen== | ||
+ | |||
+ | {| 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%;"|ID | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RechnNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |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-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-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%;"|DatumLetzteMahnung | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|DatumZahlbatBis | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|NeueMahnstufe | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |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%;"|Bemerkung | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |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%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZinssatzProzent | ||
+ | |style="width: 5%;"|Float | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mahngebühr | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|FälligerBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |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%;"|ZuAuftrNr | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RechnDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Mahnungstexte== | ||
+ | |||
+ | {| 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%;"|Sprache | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Mahnstufe | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kopftext | ||
+ | |style="width: 5%;"|Memo | ||
+ | |style="width: 5%;"|0 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
+ | |||
+ | == Tabelle Kunde== | ||
+ | |||
+ | {| 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%;"|KundenLieferantenNr | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Status | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kredlimit | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz1 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz2 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz3 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz4 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz5 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz6 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz7 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz8 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Kennz9 | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|1 | ||
+ | |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%;"|Kundenart | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Zahlkond | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|30 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ZahlkondVerk | ||
+ | |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%;"|VersandartVerk | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|40 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Rabatt | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RabattVerk | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Preisgruppe | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Bemerkungen | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|255 | ||
+ | |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 | ||
+ | |style="width: 5%;"|SmallInt | ||
+ | |style="width: 5%;"|2 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|Erlkto | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|10 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|WunschKreditLimitBetrag | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|WunschKreditLimitVonUser | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|WunschKreditLimitVonDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|WunschKreditLimitGemachtUser | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|WunschKreditLimitGemachtDatum | ||
+ | |style="width: 5%;"|DateTime | ||
+ | |style="width: 5%;"|8 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|FaelligkeitsToleranz | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|ToleranzKREDLIMIT | ||
+ | |style="width: 5%;"|BCD | ||
+ | |style="width: 5%;"|34 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RechnungPerMail | ||
+ | |style="width: 5%;"|Integer | ||
+ | |style="width: 5%;"|4 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|RechnungAnMail | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|100 | ||
+ | |style="width: 60%;"| | ||
+ | |- valign="top" | ||
+ | |style="width: 30%;"|USTID | ||
+ | |style="width: 5%;"|String | ||
+ | |style="width: 5%;"|20 | ||
+ | |style="width: 60%;"| | ||
+ | |} | ||
Version vom 9. August 2017, 14:43 Uhr
Inhaltsverzeichnis
1 Allgemeines
Hier werden die Daten-Tabellen und -Felder beschrieben, die für den Druck eines Rechnung/Gutschrift zur Verfügung gestellt werden.
- Hinweis
- Diese Abschnitt ist derzeit in Bearbeitung!
2 Tabelle RechnungsKopf
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
RechNr | Integer | 4 | |
ZuAuftrNr | Integer | 4 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 4 | |
Berechnet | SmallInt | 2 | |
Bezahlt | SmallInt | 2 | |
RechnDatum | DateTime | 8 | |
DruckDatum | DateTime | 8 | |
DruckZeit | String | 8 | |
DruckUser | String | 10 | |
ErfDatum | DateTime | 8 | |
ErfUser | String | 10 | |
AdressKurzname | String | 40 | |
KundenNr | Integer | 4 | |
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 | |
Bearbeiter | String | 20 | |
VA-Name | String | 40 | |
VA-OrtKurzname | String | 40 | |
VA-Ort | String | 30 | |
VA-Raum | String | 20 | |
VA-Stand | String | 6 | |
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 | |
ProbeText | String | 15 | |
ProbeDatum | DateTime | 8 | |
ProbeZeit | String | 5 | |
AbbauDatum | DateTime | 8 | |
AbbauZeit | String | 5 | |
AbbauText | String | 15 | |
BestellDatum | DateTime | 8 | |
ProdBestNr | String | 30 | |
VersandArt | String | 40 | |
VersandText | String | 40 | |
Bemerkung | String | 100 | |
DispoDatumVon | DateTime | 8 | |
DispoZeitVon | String | 5 | |
DispoKennzVon | String | 1 | |
DispoDatumBis | DateTime | 8 | |
DispoZeitBis | String | 5 | |
DispoKennzBis | String | 1 | |
Auftragsart | SmallInt | 2 | |
BerechnenEinheit | Float | 8 | |
BerechnEinheit | String | 6 | |
Preisgruppe | SmallInt | 2 | |
MietPreis_A_B | SmallInt | 2 | |
Preisart | SmallInt | 2 | |
Lieferdatum | DateTime | 8 | |
ProjektNr | Integer | 4 | |
Kostenstelle | Integer | 4 | |
Kopftext | Memo | 0 | |
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 | |
ProjektLeiterKurzzeichen | String | 20 | |
TechnLeiterKurzzeichen | String | 20 | |
ZuRepaAuftrNr | Integer | 4 | |
ZuRechnNr | Integer | 4 | |
ZuVersion | SmallInt | 2 |
3 Tabelle RechnungsFuss
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
RECHNR | Integer | 4 | |
SummeAlles | BCD | 34 | |
Pauschal_0_1 | SmallInt | 2 | |
PauschalBetrag | BCD | 34 | |
PauschalRabatt_0_1 | SmallInt | 2 | |
PauschalRabattProzent | BCD | 34 | |
NettoBetrag | BCD | 34 | |
MwstKennzch | SmallInt | 2 | |
MwstSatzProzent | BCD | 34 | |
MwstSatz2Prozent | BCD | 34 | |
MwstBetrag | BCD | 34 | |
PortoBetrag | BCD | 34 | |
VersicherungText | String | 50 | |
VersicherungProzent | BCD | 34 | |
VersicherungBetrag | BCD | 34 | |
GesamtBetragBrutto | BCD | 34 | |
Währung | String | 6 | |
Kurs | BCD | 34 | |
KalkSummeMiete | BCD | 34 | |
KalkSummeverkauf | BCD | 34 | |
KalkSummeGesamt | BCD | 34 | |
SelbstkostenGesamt | BCD | 34 | |
EinkaufskostenGesamt | BCD | 34 | |
SelbstkostenDienstlst | BCD | 34 | |
SelbstkostenArbZeit | BCD | 34 | |
SKSumme | BCD | 34 | |
SummeMiete | BCD | 34 | |
SummeVerkauf | BCD | 34 | |
SummeDienstlstg | BCD | 34 | |
SummeArbzeit | BCD | 34 | |
NettoBetrag2 | BCD | 34 | |
ZahlungsbedKurz | String | 30 | |
ZahlBedText | String | 200 | |
ZahlungBisDatum | DateTime | 8 | |
Skonto1BisDatum | DateTime | 8 | |
Skonto1Prozent | BCD | 34 |
4 Tabelle Positionen
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Kapitel | SmallInt | 2 | |
PosNr | SmallInt | 2 | |
StatusNr | SmallInt | 2 | |
StatusText | String | 4 | |
ZuAuftragNr | Integer | 4 | |
ArtikelNr | String | 20 | |
Typ | String | 40 | |
Bezeichnung | String | 255 | |
Menge | Float | 8 | |
Einheit | String | 10 | |
DatumVon | DateTime | 8 | |
ZeitVon | String | 5 | |
DatumBis | DateTime | 8 | |
ZeitBis | String | 5 | |
BerechnEinheit | String | 6 | |
BerechnenMenge | Float | 8 | |
Preisgruppe | SmallInt | 2 | |
Kennz_1M_2_VK_3MV | SmallInt | 2 | |
ArtikelArt_1M_2VK_3DL_4AZ | SmallInt | 2 | |
Mietpreis_A_B | SmallInt | 2 | |
Artikel_BerechnEinheit | Float | 8 | |
ZuschlagProzent | BCD | 34 | |
StdSoll | Float | 8 | |
Stdist | Float | 8 | |
FaktorMiete | Float | 8 | |
EinzelPreis | BCD | 34 | |
GesPreis | BCD | 34 | |
RabattProzent | BCD | 34 | |
RabattBetrag | BCD | 34 | |
GesBetrag | BCD | 34 | |
DruckKennzch_0Nein_1Normal | SmallInt | 2 | |
Seitenwechsel_0Nein_1Vorher_2Nachher | SmallInt | 2 | |
Set | SmallInt | 2 | |
SetKennzch | String | 10 | |
TextPosition | Memo | 0 | |
FreiText | Memo | 0 | |
Kennz1 | SmallInt | 2 | |
Kennz2 | SmallInt | 2 | |
Kennz3 | SmallInt | 2 | |
MwwstKennz | Integer | 4 | |
Kapitelpauschal_0_1 | Integer | 4 | |
AusAuftrNr | Integer | 4 | |
AusAuftrKapitel | Integer | 4 | |
AusAuftrPos | Integer | 4 | |
EinkaufKostenGesamt | BCD | 34 | |
Fremdkosten | BCD | 34 | |
AnzahlungsKennzch | SmallInt | 2 | |
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 | |
Artikel_Text | Memo | 0 | |
GesamtBruttoGewichtMiete | Float | 8 | |
GesamtNettttoGewichtMiete | Float | 8 | |
GesamtBruttoGewichtVK | Float | 8 | |
GesamtNettttoGewichtVK | Float | 8 | |
GesamtVolumenMiete | Float | 8 | |
GesamtVolumenVK | Float | 8 |
5 Tabelle RechStatistik
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
AnzahlRabattPos | Integer | 4 | |
SummeRabatt | BCD | 34 | |
AnzahlLieferscheine | Integer | 4 |
6 Tabelle Mahnungen
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
ID | Integer | 4 | |
RechnNr | Integer | 4 | |
VA-Name | String | 40 | |
VA-Ort | String | 30 | |
VA-Raum | String | 20 | |
VA-VonDatum | DateTime | 8 | |
VA-VonZeit | String | 5 | |
VA-BisDatum | DateTime | 8 | |
VA-BisZeit | String | 5 | |
DatumLetzteMahnung | DateTime | 8 | |
DatumZahlbatBis | DateTime | 8 | |
NeueMahnstufe | Integer | 4 | |
AdrNr | Integer | 4 | |
KundenNr | Integer | 4 | |
Bemerkung | String | 40 | |
ERFDATUM | DateTime | 8 | |
ERFUSER | String | 20 | |
ZinssatzProzent | Float | 8 | |
Mahngebühr | BCD | 34 | |
FälligerBetrag | BCD | 34 | |
Filiale | String | 5 | |
ZuAuftrNr | Integer | 4 | |
RechnDatum | DateTime | 8 |
7 Tabelle Mahnungstexte
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
Sprache | String | 1 | |
Mahnstufe | Integer | 4 | |
Kopftext | Memo | 0 |
8 Tabelle Kunde
Feld | Typ | Größe | Beschreibung |
---|---|---|---|
KundenLieferantenNr | String | 30 | |
Status | SmallInt | 2 | |
Kredlimit | BCD | 34 | |
Kennz1 | String | 1 | |
Kennz2 | String | 1 | |
Kennz3 | String | 1 | |
Kennz4 | String | 1 | |
Kennz5 | String | 1 | |
Kennz6 | String | 1 | |
Kennz7 | String | 1 | |
Kennz8 | String | 1 | |
Kennz9 | String | 1 | |
MwstKennz | SmallInt | 2 | |
Kundenart | SmallInt | 2 | |
Zahlkond | String | 30 | |
ZahlkondVerk | String | 30 | |
Versandart | String | 40 | |
VersandartVerk | String | 40 | |
Rabatt | BCD | 34 | |
RabattVerk | BCD | 34 | |
Preisgruppe | SmallInt | 2 | |
Bemerkungen | String | 255 | |
Mietpreis_A_B | SmallInt | 2 | |
Preisart | SmallInt | 2 | |
Erlkto | String | 10 | |
WunschKreditLimitBetrag | BCD | 34 | |
WunschKreditLimitVonUser | String | 20 | |
WunschKreditLimitVonDatum | DateTime | 8 | |
WunschKreditLimitGemachtUser | String | 20 | |
WunschKreditLimitGemachtDatum | DateTime | 8 | |
FaelligkeitsToleranz | Integer | 4 | |
ToleranzKREDLIMIT | BCD | 34 | |
RechnungPerMail | Integer | 4 | |
RechnungAnMail | String | 100 | |
USTID | String | 20 |