Technische Dokumentation Modul DEBCRED

Inhaltsverzeichnis

Informationen

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.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