Quelltext der Seite REFLEX Datenbank-Beschreibung Buchhaltung, Kalkulation, Kostenrechnung

=== KONTEN ===

==== 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%;"|KONTO
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|KONTO
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|KATEGORIE
|style="width: 5%;"|Int
|style="width: 70%;"|KATEGORIE
|- valign="top"
|style="width: 25%;"|UNTERART
|style="width: 5%;"|Int
|style="width: 70%;"|UNTERART
|- valign="top"
|style="width: 25%;"|VST
|style="width: 5%;"|Float
|style="width: 70%;"|VST
|}

=== KOST ===

==== Beschreibung der Tabelle ====

==== Felder der Tabelle ====

{| class="wikitable" style="text-align: left;"
!Feld
!Typ
!Beschreibung
|- valign="top"
|style="width: 25%;"|KOSTNR
|style="width: 5%;"|Int
|style="width: 70%;"|KOSTNR
|- valign="top"
|style="width: 25%;"|KOSTBEZ
|style="width: 5%;"|varchar(50)
|style="width: 70%;"|KOSTBEZ
|- valign="top"
|style="width: 25%;"|ABTLEITER
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|ABTLEITER
|- valign="top"
|style="width: 25%;"|ANREDE
|style="width: 5%;"|varchar(30)
|style="width: 70%;"|ANREDE
|- valign="top"
|style="width: 25%;"|INAKTIV
|style="width: 5%;"|Int
|style="width: 70%;"|INAKTIV
|}

=== KOSTENART ===

==== 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%;"|KONTO
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|KONTO
|- valign="top"
|style="width: 25%;"|MWSTSCHL
|style="width: 5%;"|Int
|style="width: 70%;"|MWSTSCHL
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|KENNZ1
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ1
|- valign="top"
|style="width: 25%;"|KENNZ2
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ2
|- valign="top"
|style="width: 25%;"|KENNZ3
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ3
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|ERFDAT
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDAT
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|- valign="top"
|style="width: 25%;"|AENDDAT
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDAT
|}

=== KOSTENART_KATEGORIE ===

==== 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%;"|KONTO
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|KONTO
|- valign="top"
|style="width: 25%;"|KATEGORIE
|style="width: 5%;"|varchar(10)
|style="width: 70%;"|KATEGORIE
|- valign="top"
|style="width: 25%;"|MWSTSCHL
|style="width: 5%;"|Int
|style="width: 70%;"|MWSTSCHL
|- valign="top"
|style="width: 25%;"|BEZEICHNUNG
|style="width: 5%;"|varchar(100)
|style="width: 70%;"|BEZEICHNUNG
|- valign="top"
|style="width: 25%;"|KENNZ1
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ1
|- valign="top"
|style="width: 25%;"|KENNZ2
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ2
|- valign="top"
|style="width: 25%;"|KENNZ3
|style="width: 5%;"|Int
|style="width: 70%;"|KENNZ3
|- valign="top"
|style="width: 25%;"|ERFUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|ERFUSER
|- valign="top"
|style="width: 25%;"|ERFDAT
|style="width: 5%;"|DateTime
|style="width: 70%;"|ERFDAT
|- valign="top"
|style="width: 25%;"|AENDUSER
|style="width: 5%;"|varchar(20)
|style="width: 70%;"|AENDUSER
|- valign="top"
|style="width: 25%;"|AENDDAT
|style="width: 5%;"|DateTime
|style="width: 70%;"|AENDDAT
|}

=== 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]]