Technische Dokumentation Modul DEBCRED-CPCASH

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Endanwender (zur vollständigen Dokumentation)
Erstellt am: 14.01.2025
Modulversion: 6
Modultyp: Erweiterung für das Modul DEBCRED
Beschreibung: Modul für den Import von Offenen Posten in CP-Cash
Benötigt Administrator Rechte: Ja
Ab OCT Version: 5.10.11

Tabellen

result.tFIN_FiBuSaldenliste

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
3 MandantenName NVARCHAR(255) check_circle highlight_off highlight_off
4 Mandant NVARCHAR(308) check_circle highlight_off highlight_off
5 FinanzJahr INT check_circle highlight_off highlight_off
6 FinanzPeriode INT check_circle highlight_off highlight_off
7 Perioden_Key INT check_circle highlight_off highlight_off
8 KalenderJahr INT check_circle highlight_off highlight_off
9 KalenderMonat INT check_circle highlight_off highlight_off
10 Buchungskreis NVARCHAR(50) highlight_off highlight_off highlight_off
11 BuchungskreisName NVARCHAR(255) highlight_off highlight_off highlight_off
12 AccountKey NVARCHAR(165) highlight_off highlight_off highlight_off
13 KontenID NVARCHAR(255) highlight_off highlight_off highlight_off
14 KontenName NVARCHAR(255) highlight_off highlight_off highlight_off
15 KontenTyp NVARCHAR(50) highlight_off highlight_off highlight_off
16 KontenTypBeschreibung NVARCHAR(255) highlight_off highlight_off highlight_off
17 Konto NVARCHAR(513) highlight_off highlight_off highlight_off
18 ICPartnerID NVARCHAR(50) highlight_off highlight_off highlight_off
19 Saldovortrag_Monat MONEY highlight_off highlight_off highlight_off
20 Soll_Monat MONEY highlight_off highlight_off highlight_off
21 Haben_Monat MONEY highlight_off highlight_off highlight_off
22 Saldo_Monat MONEY highlight_off highlight_off highlight_off
23 Saldovortrag_Jahr MONEY highlight_off highlight_off highlight_off
24 Soll_Jahr MONEY highlight_off highlight_off highlight_off
25 Haben_Jahr MONEY highlight_off highlight_off highlight_off
26 Saldo_Jahr MONEY highlight_off highlight_off highlight_off
27 CPKeyFIBU NVARCHAR(255) highlight_off highlight_off highlight_off
28 CPYearPeriod NVARCHAR(6) highlight_off highlight_off highlight_off

Referenziert von

result.tFIN_Konten

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
2 AccountKey NVARCHAR(165) highlight_off highlight_off highlight_off
3 KontenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 KontenName NVARCHAR(255) highlight_off highlight_off highlight_off
5 Konto NVARCHAR(306) highlight_off highlight_off highlight_off
6 KontenGruppe NVARCHAR(50) highlight_off highlight_off highlight_off
7 KontenGruppeBeschreibung NVARCHAR(255) highlight_off highlight_off highlight_off
8 KontenTyp NVARCHAR(50) highlight_off highlight_off highlight_off
9 KontenTypBeschreibung NVARCHAR(255) highlight_off highlight_off highlight_off
10 KontenrahmenID NVARCHAR(50) highlight_off highlight_off highlight_off
11 Level0 NVARCHAR(255) highlight_off highlight_off highlight_off
12 Level1 NVARCHAR(255) highlight_off highlight_off highlight_off
13 Level2 NVARCHAR(255) highlight_off highlight_off highlight_off
14 Level3 NVARCHAR(255) highlight_off highlight_off highlight_off
15 Level4 NVARCHAR(255) highlight_off highlight_off highlight_off
16 Level5 NVARCHAR(255) highlight_off highlight_off highlight_off
17 Level6 NVARCHAR(255) highlight_off highlight_off highlight_off
18 CPKey NVARCHAR(255) highlight_off highlight_off highlight_off
19 RowKey BIGINT check_circle highlight_off highlight_off

Referenziert von