Gevitas: Die Seite wurde neu angelegt: „=== BLZBANK === ==== Beschreibung der Tabelle ==== ==== Felder der Tabelle ==== {| class="wikitable" style="text-align: left;" !Feld !Typ !Beschreibung |- v…“

2012-11-22T20:34:10Z

Die Seite wurde neu angelegt: „=== BLZBANK === ==== Beschreibung der Tabelle ==== ==== Felder der Tabelle ==== {| class="wikitable" style="text-align: left;" !Feld !Typ !Beschreibung |- v…“

Neue Seite

=== BLZBANK ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|BLZ
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|BLZ
|- valign="top"
|style="width: 25%;"|BANKNAME
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|BANKNAME
|- valign="top"
|style="width: 25%;"|KURZNAME
|style="width: 5%;"|varchar(15)
|style="width: 70%;"|KURZNAME
|- valign="top"
|style="width: 25%;"|CODE
|style="width: 5%;"|varchar(3)
|style="width: 70%;"|CODE
|- valign="top"
|style="width: 25%;"|NIEDERLASSUNG
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|NIEDERLASSUNG
|- valign="top"
|style="width: 25%;"|PLZ
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|PLZ
|- valign="top"
|style="width: 25%;"|ORT
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ORT
|- valign="top"
|style="width: 25%;"|STRASSE
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|STRASSE
|- valign="top"
|style="width: 25%;"|ANSPPARTNER
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|ANSPPARTNER
|- valign="top"
|style="width: 25%;"|TELEFON
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|TELEFON
|- valign="top"
|style="width: 25%;"|FAX
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|FAX
|- valign="top"
|style="width: 25%;"|EMAIL
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|EMAIL
|- valign="top"
|style="width: 25%;"|WEBADRESSE
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|WEBADRESSE
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(200)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|ERFDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDATUM
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|AENDDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDATUM
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|}

=== FILIALEN ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|FILIALE
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|FILIALE
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|ADRESSE
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|ADRESSE
|- valign="top"
|style="width: 25%;"|STRASSE
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|STRASSE
|- valign="top"
|style="width: 25%;"|LANDKENNZ
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|LANDKENNZ
|- valign="top"
|style="width: 25%;"|PLZ
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|PLZ
|- valign="top"
|style="width: 25%;"|ORT
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ORT
|- valign="top"
|style="width: 25%;"|LAND
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|LAND
|- valign="top"
|style="width: 25%;"|ANSPRPART
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ANSPRPART
|- valign="top"
|style="width: 25%;"|TELEFON
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|TELEFON
|- valign="top"
|style="width: 25%;"|TELEFAX
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|TELEFAX
|- valign="top"
|style="width: 25%;"|MAILADR
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|MAILADR
|- valign="top"
|style="width: 25%;"|WWW
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|WWW
|- valign="top"
|style="width: 25%;"|KOST
|style="width: 5%;"|Int
|style="width: 70%;"|KOST
|- valign="top"
|style="width: 25%;"|KOTR
|style="width: 5%;"|Int
|style="width: 70%;"|KOTR
|- valign="top"
|style="width: 25%;"|SPRACHE
|style="width: 5%;"|varchar(1)
|style="width: 70%;"|SPRACHE
|- valign="top"
|style="width: 25%;"|KENNZ1
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ1
|- valign="top"
|style="width: 25%;"|KENNZ2
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ2
|- valign="top"
|style="width: 25%;"|KENNZ3
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ3
|- valign="top"
|style="width: 25%;"|KENNZ4
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ4
|- valign="top"
|style="width: 25%;"|KENNZ5
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ5
|- valign="top"
|style="width: 25%;"|KENNZ6
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ6
|- valign="top"
|style="width: 25%;"|KENNZ7
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ7
|- valign="top"
|style="width: 25%;"|KENNZ8
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ8
|- valign="top"
|style="width: 25%;"|KENNZ9
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ9
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|ADRNR
|style="width: 5%;"|Int
|style="width: 70%;"|ADRNR
|- valign="top"
|style="width: 25%;"|STATUSNR
|style="width: 5%;"|SmallInt
|style="width: 70%;"|STATUSNR
|- valign="top"
|style="width: 25%;"|MAIL_STATUS_AUFTR
|style="width: 5%;"|varchar(250)
|style="width: 70%;"|MAIL_STATUS_AUFTR
|}

=== LAGORT ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|LAGERORT
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|LAGERORT
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|LAGERNR
|style="width: 5%;"|SmallInt
|style="width: 70%;"|LAGERNR
|- valign="top"
|style="width: 25%;"|ADRESSE
|style="width: 5%;"|varchar(60)
|style="width: 70%;"|ADRESSE
|- valign="top"
|style="width: 25%;"|STRASSE
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|STRASSE
|- valign="top"
|style="width: 25%;"|LANDKENNZ
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|LANDKENNZ
|- valign="top"
|style="width: 25%;"|PLZ
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|PLZ
|- valign="top"
|style="width: 25%;"|ORT
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ORT
|- valign="top"
|style="width: 25%;"|LAND
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|LAND
|- valign="top"
|style="width: 25%;"|ANSPRPART
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ANSPRPART
|- valign="top"
|style="width: 25%;"|TELEFON
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|TELEFON
|- valign="top"
|style="width: 25%;"|TELEFAX
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|TELEFAX
|- valign="top"
|style="width: 25%;"|MAILADR
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|MAILADR
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|FILIALE
|style="width: 5%;"|varchar(5)
|style="width: 70%;"|FILIALE
|}

=== MPSNAME ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|STAFFELNR
|style="width: 5%;"|SmallInt
|style="width: 70%;"|STAFFELNR
|- valign="top"
|style="width: 25%;"|NAME
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|NAME
|}

=== MPSSTAFF ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|STAFFELNR
|style="width: 5%;"|SmallInt
|style="width: 70%;"|STAFFELNR
|- valign="top"
|style="width: 25%;"|EINHEIT
|style="width: 5%;"|varchar(7)
|style="width: 70%;"|EINHEIT
|- valign="top"
|style="width: 25%;"|EINHEITNR
|style="width: 5%;"|Int
|style="width: 70%;"|EINHEITNR
|- valign="top"
|style="width: 25%;"|PROZENT
|style="width: 5%;"|Float
|style="width: 70%;"|PROZENT
|}

=== POSTLEITZAHL ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|LANDZEICHEN
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|LANDZEICHEN
|- valign="top"
|style="width: 25%;"|PLZ
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|PLZ
|- valign="top"
|style="width: 25%;"|ORT
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|ORT
|- valign="top"
|style="width: 25%;"|KURZNAME
|style="width: 5%;"|varchar(15)
|style="width: 70%;"|KURZNAME
|- valign="top"
|style="width: 25%;"|STRASSE
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|STRASSE
|- valign="top"
|style="width: 25%;"|POSTFACH
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|POSTFACH
|- valign="top"
|style="width: 25%;"|HAUSNUMMER
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|HAUSNUMMER
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|ERFDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDATUM
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|AENDDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDATUM
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|}

=== TEXTBAUSTEIN ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|KURZNAME
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|KURZNAME
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(200)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|LFDNR
|style="width: 5%;"|Int
|style="width: 70%;"|LFDNR
|- valign="top"
|style="width: 25%;"|BAUSTTEXT
|style="width: 5%;"|Memo
|style="width: 70%;"|BAUSTTEXT
|- valign="top"
|style="width: 25%;"|SPRACHE
|style="width: 5%;"|varchar(2)
|style="width: 70%;"|SPRACHE
|- valign="top"
|style="width: 25%;"|KENNZ1
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ1
|- valign="top"
|style="width: 25%;"|KENNZ2
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ2
|- valign="top"
|style="width: 25%;"|KENNZ3
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ3
|- valign="top"
|style="width: 25%;"|KENNZ4
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ4
|- valign="top"
|style="width: 25%;"|KENNZ5
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ5
|- valign="top"
|style="width: 25%;"|KENNZ6
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ6
|- valign="top"
|style="width: 25%;"|KENNZ7
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ7
|- valign="top"
|style="width: 25%;"|KENNZ8
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ8
|- valign="top"
|style="width: 25%;"|KENNZ9
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ9
|- valign="top"
|style="width: 25%;"|KENNZ10
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KENNZ10
|- valign="top"
|style="width: 25%;"|ERFDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDATUM
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|AENDDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDATUM
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|}

=== TEXTEINSATZ ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|TEXTEINSATZ_ID
|style="width: 5%;"|Int
|style="width: 70%;"|TEXTEINSATZ_ID
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|ERFDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDATUM
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|AENDDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDATUM
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|}

=== TEXTZUORDNUNG ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|TEXTBAUSTEIN_ID
|style="width: 5%;"|Int
|style="width: 70%;"|TEXTBAUSTEIN_ID
|- valign="top"
|style="width: 25%;"|TEXTEINSATZ_ID
|style="width: 5%;"|Int
|style="width: 70%;"|TEXTEINSATZ_ID
|- valign="top"
|style="width: 25%;"|ERFDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDATUM
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|AENDDATUM
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDATUM
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|}

=== URLAND ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|KURZNAME
|style="width: 5%;"|varchar(6)
|style="width: 70%;"|KURZNAME
|- valign="top"
|style="width: 25%;"|NAME
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|NAME
|- valign="top"
|style="width: 25%;"|IN_ADR_VERWENDEN
|style="width: 5%;"|Int
|style="width: 70%;"|IN_ADR_VERWENDEN
|}

=== VERSART ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(40)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|PORTO
|style="width: 5%;"|Float
|style="width: 70%;"|PORTO
|- valign="top"
|style="width: 25%;"|VERSWERTMAX
|style="width: 5%;"|Float
|style="width: 70%;"|VERSWERTMAX
|- valign="top"
|style="width: 25%;"|BEMERKUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEMERKUNG
|- valign="top"
|style="width: 25%;"|RTFTEXT
|style="width: 5%;"|Memo
|style="width: 70%;"|RTFTEXT
|}

=== WARENGRUPPEN ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|ID
|style="width: 5%;"|Int
|style="width: 70%;"|ID
|- valign="top"
|style="width: 25%;"|ID_STRING
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|ID_STRING
|- valign="top"
|style="width: 25%;"|WARENGRUPPEN_NR
|style="width: 5%;"|Int
|style="width: 70%;"|WARENGRUPPEN_NR
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|PROVPROZ
|style="width: 5%;"|Float
|style="width: 70%;"|PROVPROZ
|}

=== ZAHLKOND ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|KURZNAME
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|KURZNAME
|- valign="top"
|style="width: 25%;"|TEXT
|style="width: 5%;"|varchar(200)
|style="width: 70%;"|TEXT
|- valign="top"
|style="width: 25%;"|NETTOTAGE
|style="width: 5%;"|SmallInt
|style="width: 70%;"|NETTOTAGE
|- valign="top"
|style="width: 25%;"|SKONTOTAGE
|style="width: 5%;"|SmallInt
|style="width: 70%;"|SKONTOTAGE
|- valign="top"
|style="width: 25%;"|SKONTOPROZ
|style="width: 5%;"|Float
|style="width: 70%;"|SKONTOPROZ
|- valign="top"
|style="width: 25%;"|RTFTEXT
|style="width: 5%;"|Memo
|style="width: 70%;"|RTFTEXT
|- valign="top"
|style="width: 25%;"|SKONTOTAGE2
|style="width: 5%;"|SmallInt
|style="width: 70%;"|SKONTOTAGE2
|- valign="top"
|style="width: 25%;"|SKONTOPROZ2
|style="width: 5%;"|Float
|style="width: 70%;"|SKONTOPROZ2
|- valign="top"
|style="width: 25%;"|TEXT2
|style="width: 5%;"|varchar(200)
|style="width: 70%;"|TEXT2
|- valign="top"
|style="width: 25%;"|TEXT3
|style="width: 5%;"|varchar(200)
|style="width: 70%;"|TEXT3
|}

== Links ==

* [[REFLEX Datenbank-Beschreibung]]

REFLEX Datenbank-Beschreibung diverse Stammdaten - Versionsgeschichte

Gevitas: Die Seite wurde neu angelegt: „=== BLZBANK === ==== Beschreibung der Tabelle ==== ==== Felder der Tabelle ==== {| class="wikitable" style="text-align: left;" !Feld !Typ !Beschreibung |- v…“