Technische Dokumentation Modul DEBCRED
Inhaltsverzeichnis
Dokumentationstyp: |
Endanwender (zur vollständigen Dokumentation) |
Erstellt am: |
16.04.2024 |
Modulversion: |
12 |
Modultyp: |
Basismodul |
Beschreibung: |
Modul für Offene Posten |
Benötigt Administrator Rechte: |
Nein |
Ab OCT Version: |
5.10.11 |
Tabellen
result.tDEBCRED_Buchungsjournal
Journal aller offenen und ausgeglichenen Posten.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
2 |
MandantenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
Mandant |
NVARCHAR(308) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
FinanzJahr |
SMALLINT |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
FinanzPeriode |
TINYINT |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Perioden_Key |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
AccountKey |
NVARCHAR(165) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
PersonenkontenID |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
PersonenkontenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Personenkonto |
NVARCHAR(513) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
KontenTyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
KontenTypBeschreibung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Status |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
StatusBeschreibung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Buchungsdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Buchungstext |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Belegdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Belegnummer |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Belegzeile |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Ausgleichdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
21 |
Faelligkeitsdatum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
22 |
DokumentenTyp |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
23 |
ExterneRechnungsnummer |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
24 |
Saldovortrag |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
25 |
Soll |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
26 |
Haben |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
27 |
Saldo_Buchung |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
28 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
- result.spVAL_DEBCRED_AbgleichFiBu
result.tDEBCRED_Personenkonten
Journal aller offenen und ausgeglichenen Posten.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
2 |
AccountKey |
NVARCHAR(165) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
PersonenkontenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
PersonenkontenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Personenkonto |
NVARCHAR(306) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
KontenTyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
KontenTypBeschreibung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Straße |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
PLZ |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Stadt |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
LandIsoCode |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
LandBeschreibung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
ICPartnerID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
|