| # |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
| 1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
Mandanten ID aus OCT. |
| 2 |
MandantenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
Name des Mandanten. |
| 3 |
Mandant |
NVARCHAR(308) |
check_circle |
highlight_off |
highlight_off |
|
Kombination aus MandantenID und MandantenName. |
| 4 |
FinanzJahr |
INT |
check_circle |
highlight_off |
highlight_off |
|
FinanzJahr, zu welcher die Buchung zugeordnet ist. |
| 5 |
FinanzPeriode |
INT |
check_circle |
highlight_off |
highlight_off |
|
Periode im FinanzJahr, zu welcher die Buchung zugeordnet ist. |
| 6 |
Perioden_Key |
INT |
check_circle |
highlight_off |
highlight_off |
|
Kombination aus FinanzJahr, Geschäftsjahresbegin und FinanzPeriode. |
| 7 |
KalenderJahr |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
| 8 |
KalenderMonat |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
| 9 |
Buchungskreis |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Klassifizierung der Buchung nach Herkunft (z.B. FIBU, KORE, PCA, ...). |
| 10 |
BuchungskreisName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Bezeichung des Buchungskreises. |
| 11 |
AccountKey |
NVARCHAR(165) |
highlight_off |
highlight_off |
highlight_off |
|
AccountKey |
| 12 |
KontenID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
ID des Kontos. |
| 13 |
KontenName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Name des Kontos. |
| 14 |
KontenTyp |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Klassifizierung des Kontos innerhalb einer Gruppe (z.B. GUV, BILANZ, DEBITOR, KREDITOR, STAT, ...). |
| 15 |
KontenTypBeschreibung |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
KontenTypBeschreibung |
| 16 |
KontenGruppe |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 17 |
KontenGruppeBeschreibung |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 18 |
Konto |
NVARCHAR(513) |
highlight_off |
highlight_off |
highlight_off |
|
Kombination aus KontenID und KontenName. |
| 19 |
OffsetAccountKey |
NVARCHAR(165) |
highlight_off |
highlight_off |
highlight_off |
|
OffsetAccountKey |
| 20 |
GegenkontenID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
ID des Gegenkontos. |
| 21 |
GegenkontenName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Name des Gegenkontos. |
| 22 |
GegenkontenTyp |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Klassifizierung des Gegenkontos innerhalb einer Gruppe (z.B. GUV, BILANZ, DEBITOR, KREDITOR, STAT, ...). |
| 23 |
Gegenkonto |
NVARCHAR(513) |
highlight_off |
highlight_off |
highlight_off |
|
Kombination aus GegenkontenID und GegenkontenName. |
| 24 |
CostObject1Key |
NVARCHAR(165) |
highlight_off |
highlight_off |
highlight_off |
|
CostObject1Key |
| 25 |
KostenstellenID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
ID der Kostenstelle. |
| 26 |
KostenstellenName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Name der Kostenstelle. |
| 27 |
KostenstellenTyp |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Klassifizierung der Kostenstelle (z.B. KST, PC, ...). |
| 28 |
Kostenstelle |
NVARCHAR(513) |
highlight_off |
highlight_off |
highlight_off |
|
Kombination aus KostenstellenID und KostenstellenName. |
| 29 |
CostObject2Key |
NVARCHAR(165) |
highlight_off |
highlight_off |
highlight_off |
|
CostObject2Key |
| 30 |
KostentraegerID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
ID des Kostentraegers. |
| 31 |
KostentraegerName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Name des Kostentraegers. |
| 32 |
KostentraegerTyp |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Klassifizierung des Kostentraegers (z.B. KTR, OR, ...). |
| 33 |
Kostentraeger |
NVARCHAR(513) |
highlight_off |
highlight_off |
highlight_off |
|
Kombination aus KostentraegerID und KostentraegerName. |
| 34 |
ICPartnerID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
ID des IC Partners. |
| 35 |
Buchungsdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
Buchungsdatum der Buchung. |
| 36 |
Belegdatum |
DATE |
highlight_off |
highlight_off |
highlight_off |
|
Belegdatum der Buchung. |
| 37 |
Belegnummer |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Belegnummer des Buchungsbelegs. |
| 38 |
Belegzeile |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Belegzeile des Buchungsbelegs. |
| 39 |
Buchungstext |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
Buchungstext der Buchung. |
| 40 |
Saldovortrag |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
Saldovortrag der Buchung. |
| 41 |
Soll |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
Sollwert der Buchung. |
| 42 |
Haben |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
Habenwert der Buchung. |
| 43 |
Saldo_Buchung |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
Der Saldo der Buchung (Saldovortrag + Soll - Haben). |
| 44 |
SourceID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 45 |
CPKeyFIBU |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 46 |
CPKeyKST |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 47 |
CPKeyKTR |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 48 |
CPYearPeriod |
NVARCHAR(6) |
highlight_off |
highlight_off |
highlight_off |
|
|
| 49 |
RowKey |
BIGINT |
check_circle |
highlight_off |
highlight_off |
|
RowKey |