Technische Dokumentation Modul FIN

Inhaltsverzeichnis

Informationen
Tabellen
Sichten
Prozeduren

Informationen

Dokumentationstyp:	Vollständig (zur Endanwender Dokumentation)
Erstellt am:	19.04.2024
Modulversion:	31
Modultyp:	Basismodul
Beschreibung:	Modul für Finanzbuchhaltung und Kostenrechnung
Benötigt Administrator Rechte:	Nein
Ab OCT Version:	5.10.11

Tabellen

global.tFIN_Accounts

Table to store account masterdata. Table contains merged data from integration and planning.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	AccountKey	NVARCHAR(165)	highlight_off	highlight_off	check_circle
	Unique account key from the source system consisting of DataSourceKey \| CompanyID \| AccountID \| AccountGroupCODE.
3	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	DataSourceKey
4	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OCT identifier for the company. Part of AccountKey.
5	AccountGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for a group of accounts, e.g. SKTO=Sachkonto/GLAccount, KOART=Kostenart/CostType, PERSKTO = Personenkonto/PersonalAccount.
6	AccountID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier for the account within one type. Part of AccountKey.
7	AccountTypeCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for an account within a group of Accounts, e.g. GUV, BILANZ, DEBITOR, KREDITOR, STAT.
8	AccountName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name of the Account.
9	CustomValuesJSON	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	Custom field to store any customer individual informations.
10	CustomValuesJSONUser	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	CustomValuesJSONUser
11	OwnerCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OwnerCODE
12	MappingKey	INT	check_circle	highlight_off	highlight_off
	MappingKey
13	UpdatedFlag	INT	highlight_off	highlight_off	highlight_off
	UpdatedFlag

global.tFIN_ChartsOfAccounts

Table to store charts of accounts.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	INT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	ChartsOfAccountsID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier for chart of account.
3	AccountLength	INT	highlight_off	highlight_off	highlight_off
	Account length used in chart of accounts
4	StructureElementID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier of element within chart of accounts.
5	AccountFrom	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Start of account range.
6	AccountTo	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	End of account range.
7	AccountTypeCODE	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	AccountTypeCODE

Referenziert von

agent.vFIN_ChartsOfAccounts_HGBStructure

global.tFIN_CostObjects

Table to store masterdata of cost accounting (cost centers, cost units, ...). Table contains merged data from integration and planning.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	CostObjectKey	NVARCHAR(165)	highlight_off	highlight_off	check_circle
	Unique cost object key from the source system consisting of DataSourceKey \| CompanyID \| CostObjectGroup1CODE \| CostObject1ID.
3	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	DataSourceKey
4	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OCT identifier for the company.
5	CostObjectGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for a group of CostObjects, e.g. KST=Kostenstelle/cost center, KTR=Kostentraeger/cost unit, PC = ProfitCenter, OR=Auftrag/order.
6	CostObjectID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier for the CostObject within one type.
7	CostObjectName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name of the cost object.
8	CustomValuesJSON	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	Custom field to store any customer individual informations.
9	CustomValuesJSONUser	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	CustomValuesJSONUser
10	OwnerCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Owner of the CostObject. INTEGRATION=Integration, PLANNING=Planning or ORPHAN=Orphan - Integration will dominate Planning. Orphans arise if integration CostObjects are deleted.
11	MappingKey	INT	check_circle	highlight_off	highlight_off
	MappingKey
12	UpdatedFlag	INT	highlight_off	highlight_off	highlight_off
	UpdatedFlag

Referenziert von

agent.pPostBulkloadFIN
agent.vJSON_global_tFIN_CostObjects
result.vFIN_Kostenstellen
result.vFIN_Kostentraeger

integration.tFIN_AccountingJournal

Multi Facttable to store all facts of module Finance. Facts of different areas of accounting are in one table. Within one area, there are never duplicates, you can always sum / group all together.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OCT identifier for the company. Part of AccountKey.
4	AccountingAreaCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Posting classification by source (e.g. FIBU, KORE, PCA, ...). CODEs are defined in table global.tAttributesCODE.
5	AccountID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Identifier for the account within one group.
6	AccountGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for a group of accounts, e.g. SKTO=Sachkonto/GLAccount, KOART=Kostenart/CostType, PERSKTO = Personenkonto/PersonalAccount.
7	OffsetAccountID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Identifier for the offset account within one group.
8	OffsetAccountGroupCODE	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Classification for a group of offset accounts. CODEs are defined in table global.tAttributesCODE.
9	CostObject1ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Identifier for the fist cost object within one group. This will be usually cost centers.
10	CostObject1GroupCODE	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Classification for a group of the first cost object. CODEs are defined in table global.tCodes
11	CostObject2ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Identifier for the second cost object within one group. This will be usually cost units.
12	CostObject2GroupCODE	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Classification for a group of the second cost object. CODEs are defined in table global.tCodes.
13	FinancialYear	SMALLINT	highlight_off	highlight_off	highlight_off
	Fiscal year in which posting is made.
14	FinancialPeriod	TINYINT	highlight_off	highlight_off	highlight_off
	Financial period in which posting is made.
15	OpeningBalance	BIGINT	highlight_off	highlight_off	highlight_off
	Opening balance value. Decimal places are eliminated through multiplication with 100.
16	Debit	BIGINT	highlight_off	highlight_off	highlight_off
	Debit value. Decimal places are eliminated through multiplication with 100.
17	Credit	BIGINT	highlight_off	highlight_off	highlight_off
	Credit value. Decimal places are eliminated through multiplication with 100.
18	PostingDate	DATE	check_circle	highlight_off	highlight_off
	Posting date of the posting.
19	PostingText	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Posting text of the posting.
20	DocumentDate	DATE	check_circle	highlight_off	highlight_off
	Document date of the posting.
21	DocumentNumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Document number of the posting.
22	DocumentLine	INT	check_circle	highlight_off	highlight_off
	Line number of document.
23	ICPartnerID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Identifier for the intercompany partner.
24	SourceID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Identifier of dataset in source system (e.g. row number).
25	DeltaValue	BIGINT	check_circle	highlight_off	highlight_off
	Delta value to enable delta load. Should be the timestamp when dataset was inserted in source system or sequential number from source system.
26	CustomValuesJSON	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	Custom field to store any customer individual informations.

Referenziert von

agent.pDeleteIntegrationValuesFIN
agent.pPostBulkloadFIN
agent.vJSON_integration_tFIN_AccountingJournal
integration.pGetDeltaValuesFIN
integration.vFIN_AccountingJournalStats
result.vFIN_Buchungsjournal
result.vFIN_Mandanten

integration.tFIN_Accounts

Table to store account masterdata.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OCT identifier for the company.
4	AccountGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for a group of accounts, e.g. SKTO=Sachkonto/GLAccount, KOART=Kostenart/CostType, PERSKTO = Personenkonto/PersonalAccount.
5	AccountID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier for the account within one type.
6	AccountTypeCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for an account within a group of Accounts, e.g. GUV, BILANZ, DEBITOR, KREDITOR, STAT.
7	AccountName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name of the Account.
8	CustomValuesJSON	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	Custom field to store any customer individual informations.

Referenziert von

agent.pDeleteIntegrationValuesFIN
agent.pPostBulkloadFIN
agent.vJSON_integration_tFIN_Accounts
integration.vFIN_AccountsStats

integration.tFIN_CostObjects

Table to store masterdata of cost accounting (cost centers, cost units, ...).

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	Technical primary Key for row identity.
2	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	OCT identifier for the company.
4	CostObjectGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Classification for a group of CostObjects, e.g. KST=Kostenstelle/cost center, KTR=Kostentraeger/cost unit, PC = ProfitCenter, OR=Auftrag/order.
5	CostObjectID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Identifier for the CostObject within one type.
6	CostObjectName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name of the cost object.
7	CustomValuesJSON	NVARCHAR(4000)	check_circle	highlight_off	highlight_off
	Custom field to store any customer individual informations.

Referenziert von

agent.pDeleteIntegrationValuesFIN
agent.pPostBulkloadFIN
agent.vJSON_integration_tFIN_CostObjects
integration.vFIN_CostObjectsStats

result.tFIN_Buchungsjournal

Tabelle stellt das Buchungsjournal bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_Buchungsjournal materialisiert.

#	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	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenziert von

agent.pSyncFIN
result.vFIN_BuchungsjournalAggregated

result.tFIN_BuchungsjournalAggregated

Aggregiertes Buchungsjournal auf Periodensummen, gruppiert nache Mandant, Periode, Konto, Kostenstelle, Kostenträger, IC-Partner. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_BuchungsjournalAggregated materialisiert.

#	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	CostObject1Key	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObject1Key
20	KostenstellenID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	ID der Kostenstelle.
21	KostenstellenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name der Kostenstelle.
22	KostenstellenTyp	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Klassifizierung der Kostenstelle (z.B. KST, PC, ...).
23	Kostenstelle	NVARCHAR(513)	highlight_off	highlight_off	highlight_off
	Kombination aus KostenstellenID und KostenstellenName.
24	CostObject2Key	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObject2Key
25	KostentraegerID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	ID des Kostentraegers.
26	KostentraegerName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kostentraegers.
27	KostentraegerTyp	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kostentraegers (z.B. KTR, OR, ...).
28	Kostentraeger	NVARCHAR(513)	highlight_off	highlight_off	highlight_off
	Kombination aus KostentraegerID und KostentraegerName.
29	ICPartnerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ICPartnerID
30	Saldovortrag	MONEY	highlight_off	highlight_off	highlight_off
	Saldovortrag der Buchung.
31	MonatSoll	MONEY	highlight_off	highlight_off	highlight_off
	Sollwert des Monats der Buchung.
32	MonatHaben	MONEY	highlight_off	highlight_off	highlight_off
	Habenwert des Monats der Buchung.
33	Saldo	MONEY	highlight_off	highlight_off	highlight_off
	Saldo des Monats der Buchung (Saldovortrag + Soll - Haben).

Referenziert von

agent.pSyncFIN
result.pPivot_Kostenstellenauswertung
result.pPivot_Kostentraegerauswertung
result.vFIN_FiBuSaldenliste

result.tFIN_ChartsOfAccounts_HGBStructure

Table to store charts of accounts.

#	Name	Datentyp	NULL	Identity	Berechnet
1	ChartsOfAccountsID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Identifier for chart of account.
2	AccountLength	INT	highlight_off	highlight_off	highlight_off
	Account length used in chart of accounts
3	LanguageID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	ID of the language of the structure descriptions.
4	AccountFrom	INT	check_circle	highlight_off	highlight_off
	Start of account range.
5	AccountTo	INT	check_circle	highlight_off	highlight_off
	End of account range.
6	Level0ID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Level0ID
7	Level0Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level0Desc
8	Level0	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level0
9	Level1ID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Level1ID
10	Level1Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level1Desc
11	Level1	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level1
12	Level2ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level2ID
13	Level2Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level2Desc
14	Level2	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level2
15	Level3ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level3ID
16	Level3Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level3Desc
17	Level3	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level3
18	Level4ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level4ID
19	Level4Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level4Desc
20	Level4	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level4
21	Level5ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level5ID
22	Level5Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level5Desc
23	Level5	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level5
24	Level6ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level6ID
25	Level6Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level6Desc
26	Level6	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level6

Referenziert von

result.vFIN_Konten

result.tFIN_FiBuSaldenliste

FiBu Saldenliste kummuliert auf Perioden. Mit Selektion einer Periode kann der kummlierte Saldo zum Zeitpunkt ermittelt werden. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_FiBuSaldenliste materialisiert.

#	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	ICPartnerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ICPartnerID
20	Saldovortrag_Monat	MONEY	highlight_off	highlight_off	highlight_off
	Saldovortrag der Buchung.
21	Soll_Monat	MONEY	highlight_off	highlight_off	highlight_off
	Sollwert des Monats der Buchung.
22	Haben_Monat	MONEY	highlight_off	highlight_off	highlight_off
	Habenwert des Monats der Buchung.
23	Saldo_Monat	MONEY	highlight_off	highlight_off	highlight_off
	Saldo des Monats der Buchung (Saldovortrag + Soll - Haben).
24	Saldovortrag_Jahr	MONEY	highlight_off	highlight_off	highlight_off
	Kummulierter Saldovortrag des Finanzjahres.
25	Soll_Jahr	MONEY	highlight_off	highlight_off	highlight_off
	Kummulierter Sollwert des Finanzjahres.
26	Haben_Jahr	MONEY	highlight_off	highlight_off	highlight_off
	Kummulierter Habenwert des Finanzjahres.
27	Saldo_Jahr	MONEY	highlight_off	highlight_off	highlight_off
	Kummulierter Saldo des Finanzjahres.

Referenziert von

agent.pSyncFIN
result.pPivot_FiBuSaldenliste

result.tFIN_Konten

Tabelle stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6). Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_Konten materialisiert.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	AccountKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	AccountKey
3	KontenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kontos
4	KontenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kontos
5	Konto	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KontenID und KontenName
6	KontenGruppe	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Gruppe welcher Konto zugeordnet ist. z.B. SKTO=Sachkonto/GLAccount, KOART=Kostenart/CostType, PERSKTO = Personenkonto/PersonalAccount, ...
7	KontenGruppeBeschreibung	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Beschreibung der Kontengruppe
8	KontenTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kontos innerhalb einer Gruppe. z.B. GUV, BILANZ, DEBITOR, KREDITOR, STAT, ...
9	KontenTypBeschreibung	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Beschreibung des KontenTyps
10	KontenrahmenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kontorahmens aus den Kontorahmenstammdaten
11	Level0	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Wurzel der Kontenhierarchie
12	Level1	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 1 der Kontenhierarchie
13	Level2	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 2 der Kontenhierarchie
14	Level3	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 3 der Kontenhierarchie
15	Level4	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 4 der Kontenhierarchie
16	Level5	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 5 der Kontenhierarchie
17	Level6	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Ebene 6 der Kontenhierarchie
18	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenziert von

agent.pSyncFIN
result.vFIN_Buchungsjournal
result.vFIN_FiBuSaldenliste

result.tFIN_Kostenstellen

Tabelle stellt Stammdaten zu Kostenstellen bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_Kostenstellen materialisiert.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	CostObjectKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObjectKey
3	KostenstellenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID der Kostenstelle
4	KostenstellenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name der Kostenstelle
5	Kostenstelle	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KostenstellenID und KostenstellenName
6	KostenstellenTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung der Kostenstelle. z.B. KST, PC, ...
7	KostenstellenTypBeschreibung	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Beschreibung des KostenstellenTyps
8	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenziert von

result.vFIN_Buchungsjournal

result.tFIN_Kostentraeger

Tabelle stellt Stammdaten zu Kostenträgern bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_Kostentraeger materialisiert.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	CostObjectKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObjectKey
3	KostentraegerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kostentraegers
4	KostentraegerName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kostentraegers
5	Kostentraeger	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KostentraegerID und KostentraegerName
6	KostentraegerTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kostentraegers. z.B. KTR, OR, ...
7	KostentraegerTypBeschreibung	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Beschreibung des KostentraegerTyps
8	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenziert von

result.vFIN_Buchungsjournal

result.tFIN_Mandanten

Tabelle stellt Stammdaten zu Mandanten bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vFIN_Mandanten materialisiert.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	MandantenID
2	MandantenName	NVARCHAR(255)	check_circle	highlight_off	highlight_off

3	Beschreibung	NVARCHAR(2000)	check_circle	highlight_off	highlight_off

4	FinanzjahrBeginn	INT	check_circle	highlight_off	highlight_off

5	Kontorahmen	NVARCHAR(50)	check_circle	highlight_off	highlight_off

6	Kontenlaenge	INT	check_circle	highlight_off	highlight_off

7	Waehrung	NVARCHAR(50)	check_circle	highlight_off	highlight_off

8	RowKey	BIGINT	check_circle	highlight_off	highlight_off

Referenziert von

agent.pSyncFIN
result.vFIN_FiBuSaldenliste

Sichten

agent.vFIN_ChartsOfAccounts_HGBStructure

This View combines the chart of accounts from FIN module with the HGB structure.

#	Name	Datentyp	NULL	Identity	Berechnet
1	ChartsOfAccountsID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ChartsOfAccountsID
2	AccountLength	INT	highlight_off	highlight_off	highlight_off
	AccountLength
3	LanguageID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	LanguageID
4	AccountFrom	INT	check_circle	highlight_off	highlight_off
	AccountFrom
5	AccountTo	INT	check_circle	highlight_off	highlight_off
	AccountTo
6	Level0ID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Level0ID
7	Level0Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level0Desc
8	Level0	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level0
9	Level1ID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Level1ID
10	Level1Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level1Desc
11	Level1	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level1
12	Level2ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level2ID
13	Level2Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level2Desc
14	Level2	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level2
15	Level3ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level3ID
16	Level3Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level3Desc
17	Level3	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level3
18	Level4ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level4ID
19	Level4Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level4Desc
20	Level4	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level4
21	Level5ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level5ID
22	Level5Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level5Desc
23	Level5	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level5
24	Level6ID	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level6ID
25	Level6Desc	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Level6Desc
26	Level6	NVARCHAR(513)	check_circle	highlight_off	highlight_off
	Level6

Referenzierte Objekte

global.tFIN_ChartsOfAccounts
global.tStructureDescriptions
global.tStructures

Referenziert von

agent.pPostBulkloadFIN

agent.vJSON_global_tFIN_Accounts

This view resolves the CustomValuesJSON column in table global.tFIN_Accounts to actual columns.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	RowKey

Referenzierte Objekte

global.tFIN_Accounts

Referenziert von

result.vFIN_Konten

agent.vJSON_global_tFIN_CostObjects

This view resolves the CustomValuesJSON column in table global.tFIN_CostObjects to actual columns.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	RowKey

Referenzierte Objekte

global.tFIN_CostObjects

Referenziert von

result.vFIN_Kostenstellen
result.vFIN_Kostentraeger

agent.vJSON_integration_tFIN_AccountingJournal

This view resolves the CustomValuesJSON column in table integration.tFIN_AccountingJournal to actual columns.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	RowKey

Referenzierte Objekte

integration.tFIN_AccountingJournal

Referenziert von

result.vFIN_Buchungsjournal

agent.vJSON_integration_tFIN_Accounts

This view resolves the CustomValuesJSON column in table integration.tFIN_Accounts to actual columns.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	RowKey

Referenzierte Objekte

integration.tFIN_Accounts

agent.vJSON_integration_tFIN_CostObjects

This view resolves the CustomValuesJSON column in table integration.tFIN_CostObjects to actual columns.

#	Name	Datentyp	NULL	Identity	Berechnet
1	RowKey	BIGINT	highlight_off	check_circle	highlight_off
	RowKey

Referenzierte Objekte

integration.tFIN_CostObjects

integration.vFIN_AccountingJournalStats

View liefert Statistiken zu den Daten im Ingtegration Shema.

#	Name	Datentyp	NULL	Identity	Berechnet
1	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	DataSourceKey
2	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	CompanyID
3	CompanyName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	CompanyName
4	AccountingAreaCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	AccountingAreaCODE
5	MinPeriod	NVARCHAR(33)	check_circle	highlight_off	highlight_off
	MinPeriod
6	MaxPeriod	NVARCHAR(33)	check_circle	highlight_off	highlight_off
	MaxPeriod
7	MinPostingDate	DATE	check_circle	highlight_off	highlight_off
	MinPostingDate
8	MaxPostingDate	DATE	check_circle	highlight_off	highlight_off
	MaxPostingDate
9	RowsCount	INT	check_circle	highlight_off	highlight_off
	RowsCount

Referenzierte Objekte

global.tCompanies
integration.tFIN_AccountingJournal

Referenziert von

result.pHTML_ZV_FIN_Start

integration.vFIN_AccountsStats

View liefert Statistiken zu den Daten im Ingtegration Shema.

#	Name	Datentyp	NULL	Identity	Berechnet
1	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	DataSourceKey
2	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	CompanyID
3	AccountGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	AccountGroupCODE
4	AccountTypeCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	AccountTypeCODE
5	RowsCount	INT	check_circle	highlight_off	highlight_off
	RowsCount

Referenzierte Objekte

integration.tFIN_Accounts

Referenziert von

result.pHTML_ZV_FIN_Start

integration.vFIN_CostObjectsStats

View liefert Statistiken zu den Daten im Ingtegration Shema.

#	Name	Datentyp	NULL	Identity	Berechnet
1	DataSourceKey	INT	highlight_off	highlight_off	highlight_off
	DataSourceKey
2	CompanyID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	CompanyID
3	CostObjectGroupCODE	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	CostObjectGroupCODE
4	RowsCount	INT	check_circle	highlight_off	highlight_off
	RowsCount

Referenzierte Objekte

integration.tFIN_CostObjects

Referenziert von

result.pHTML_ZV_FIN_Start

result.vFIN_Buchungsjournal

View stellt das Buchungsjournal bereit. Es sind bereits alle Stammdaten gejoint um diese View einfach in nachfolgenden System verwenden zu können

#	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	highlight_off	highlight_off	highlight_off

8	KalenderMonat	INT	highlight_off	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)	check_circle	highlight_off	highlight_off
	Bezeichung des Buchungskreises.
11	AccountKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	AccountKey
12	KontenID	NVARCHAR(50)	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(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KontenID und KontenName.
19	OffsetAccountKey	NVARCHAR(165)	check_circle	highlight_off	highlight_off
	OffsetAccountKey
20	GegenkontenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	ID des Gegenkontos.
21	GegenkontenName	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Gegenkontos.
22	GegenkontenTyp	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Klassifizierung des Gegenkontos innerhalb einer Gruppe (z.B. GUV, BILANZ, DEBITOR, KREDITOR, STAT, ...).
23	Gegenkonto	NVARCHAR(306)	check_circle	highlight_off	highlight_off
	Kombination aus GegenkontenID und GegenkontenName.
24	CostObject1Key	NVARCHAR(165)	check_circle	highlight_off	highlight_off
	CostObject1Key
25	KostenstellenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	ID der Kostenstelle.
26	KostenstellenName	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name der Kostenstelle.
27	KostenstellenTyp	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Klassifizierung der Kostenstelle (z.B. KST, PC, ...).
28	Kostenstelle	NVARCHAR(306)	check_circle	highlight_off	highlight_off
	Kombination aus KostenstellenID und KostenstellenName.
29	CostObject2Key	NVARCHAR(165)	check_circle	highlight_off	highlight_off
	CostObject2Key
30	KostentraegerID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	ID des Kostentraegers.
31	KostentraegerName	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Kostentraegers.
32	KostentraegerTyp	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Klassifizierung des Kostentraegers (z.B. KTR, OR, ...).
33	Kostentraeger	NVARCHAR(306)	check_circle	highlight_off	highlight_off
	Kombination aus KostentraegerID und KostentraegerName.
34	ICPartnerID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	ID des IC Partners.
35	Buchungsdatum	DATE	check_circle	highlight_off	highlight_off
	Buchungsdatum der Buchung.
36	Belegdatum	DATE	check_circle	highlight_off	highlight_off
	Belegdatum der Buchung.
37	Belegnummer	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Belegnummer des Buchungsbelegs.
38	Belegzeile	INT	check_circle	highlight_off	highlight_off
	Belegzeile des Buchungsbelegs.
39	Buchungstext	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Buchungstext der Buchung.
40	Saldovortrag	MONEY	check_circle	highlight_off	highlight_off
	Saldovortrag der Buchung.
41	Soll	MONEY	check_circle	highlight_off	highlight_off
	Sollwert der Buchung.
42	Haben	MONEY	check_circle	highlight_off	highlight_off
	Habenwert der Buchung.
43	Saldo_Buchung	MONEY	check_circle	highlight_off	highlight_off
	Der Saldo der Buchung (Saldovortrag + Soll - Haben).
44	SourceID	NVARCHAR(255)	check_circle	highlight_off	highlight_off

45	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenzierte Objekte

agent.vJSON_integration_tFIN_AccountingJournal
global.tCodes
global.tCompanies
global.tPeriods
integration.tFIN_AccountingJournal
result.tFIN_Konten
result.tFIN_Kostenstellen
result.tFIN_Kostentraeger

Referenziert von

agent.pSyncFIN

result.vFIN_BuchungsjournalAggregated

Die View aggregiert das Buchungsjournal auf Periodensummen, gruppiert nache Mandant, Periode, Konto, Kostenstelle, Kostenträger, IC-Partner.

#	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(511)	highlight_off	highlight_off	highlight_off
	Kombination aus KontenID und KontenName.
19	CostObject1Key	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObject1Key
20	KostenstellenID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	ID der Kostenstelle.
21	KostenstellenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name der Kostenstelle.
22	KostenstellenTyp	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Klassifizierung der Kostenstelle (z.B. KST, PC, ...).
23	Kostenstelle	NVARCHAR(511)	highlight_off	highlight_off	highlight_off
	Kombination aus KostenstellenID und KostenstellenName.
24	CostObject2Key	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObject2Key
25	KostentraegerID	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	ID des Kostentraegers.
26	KostentraegerName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kostentraegers.
27	KostentraegerTyp	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kostentraegers (z.B. KTR, OR, ...).
28	Kostentraeger	NVARCHAR(511)	highlight_off	highlight_off	highlight_off
	Kombination aus KostentraegerID und KostentraegerName.
29	ICPartnerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ICPartnerID
30	Saldovortrag	MONEY	check_circle	highlight_off	highlight_off
	Saldovortrag der Buchung.
31	MonatSoll	MONEY	check_circle	highlight_off	highlight_off
	Sollwert des Monats der Buchung.
32	MonatHaben	MONEY	check_circle	highlight_off	highlight_off
	Habenwert des Monats der Buchung.
33	Saldo	MONEY	check_circle	highlight_off	highlight_off
	Saldo des Monats der Buchung (Saldovortrag + Soll - Haben).

Referenzierte Objekte

result.tFIN_Buchungsjournal

Referenziert von

agent.pSyncFIN

result.vFIN_FiBuSaldenliste

Die View kummuliert das Buchungsjournal auf Perioden. Mit Selektion einer Periode kann der kummlierte Saldo zum Zeitpunkt ermittelt werden.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	highlight_off	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	highlight_off	highlight_off	highlight_off
	FinanzJahr, zu welcher die Buchung zugeordnet ist.
5	FinanzPeriode	INT	highlight_off	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	highlight_off	highlight_off	highlight_off

8	KalenderMonat	INT	highlight_off	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)	check_circle	highlight_off	highlight_off
	Bezeichung des Buchungskreises.
11	AccountKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	AccountKey
12	KontenID	NVARCHAR(50)	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(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KontenID und KontenName.
19	ICPartnerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ICPartnerID
20	Saldovortrag_Monat	MONEY	check_circle	highlight_off	highlight_off
	Saldovortrag der Buchung.
21	Soll_Monat	MONEY	check_circle	highlight_off	highlight_off
	Sollwert des Monats der Buchung.
22	Haben_Monat	MONEY	check_circle	highlight_off	highlight_off
	Habenwert des Monats der Buchung.
23	Saldo_Monat	MONEY	check_circle	highlight_off	highlight_off
	Saldo des Monats der Buchung (Saldovortrag + Soll - Haben).
24	Saldovortrag_Jahr	MONEY	check_circle	highlight_off	highlight_off
	Kummulierter Saldovortrag des Finanzjahres.
25	Soll_Jahr	MONEY	check_circle	highlight_off	highlight_off
	Kummulierter Sollwert des Finanzjahres.
26	Haben_Jahr	MONEY	check_circle	highlight_off	highlight_off
	Kummulierter Habenwert des Finanzjahres.
27	Saldo_Jahr	MONEY	check_circle	highlight_off	highlight_off
	Kummulierter Saldo des Finanzjahres.

Referenzierte Objekte

global.tCodes
global.tPeriods
result.tFIN_BuchungsjournalAggregated
result.tFIN_Konten
result.tFIN_Mandanten

Referenziert von

agent.pSyncFIN

result.vFIN_Konten

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird eine Kontenhierarchie zu den Konten zugeordnet (Level0 - Level6)

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	AccountKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	AccountKey
3	KontenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kontos
4	KontenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kontos
5	Konto	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KontenID und KontenName
6	KontenGruppe	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Gruppe, welcher das Konto zugeordnet ist. z.B. SKTO=Sachkonto/GLAccount, KOART=Kostenart/CostType, PERSKTO = Personenkonto/PersonalAccount, ...
7	KontenGruppeBeschreibung	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Beschreibung der Kontengruppe
8	KontenTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kontos innerhalb einer Gruppe. z.B. GUV, BILANZ, DEBITOR, KREDITOR, STAT, ...
9	KontenTypBeschreibung	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Beschreibung des KontenTyps
10	KontenrahmenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kontorahmens aus den Kontorahmenstammdaten
11	Level0	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Wurzel der Kontenhierarchie
12	Level1	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 1 der Kontenhierarchie
13	Level2	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 2 der Kontenhierarchie
14	Level3	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 3 der Kontenhierarchie
15	Level4	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 4 der Kontenhierarchie
16	Level5	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 5 der Kontenhierarchie
17	Level6	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Ebene 6 der Kontenhierarchie
18	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenzierte Objekte

agent.vJSON_global_tFIN_Accounts
global.tCodes
global.tCompanies
global.tFIN_Accounts
result.tFIN_ChartsOfAccounts_HGBStructure

Referenziert von

agent.pSyncFIN

result.vFIN_Kostenstellen

View stellt Stammdaten zu Kostenstellen bereit.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	CostObjectKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObjectKey
3	KostenstellenID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID der Kostenstelle
4	KostenstellenName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name der Kostenstelle
5	Kostenstelle	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KostenstellenID und KostenstellenName
6	KostenstellenTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung der Kostenstelle. z.B. KST, PC, ...
7	KostenstellenTypBeschreibung	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Beschreibung des KostenstellenTyps
8	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenzierte Objekte

agent.vJSON_global_tFIN_CostObjects
global.tCodes
global.tCompanies
global.tFIN_CostObjects

Referenziert von

agent.pSyncFIN

result.vFIN_Kostentraeger

View stellt Stammdaten zu Kostentraegern bereit.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Mandanten ID aus OCT.
2	CostObjectKey	NVARCHAR(165)	highlight_off	highlight_off	highlight_off
	CostObjectKey
3	KostentraegerID	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	ID des Kostentraegers
4	KostentraegerName	NVARCHAR(255)	highlight_off	highlight_off	highlight_off
	Name des Kostentraegers
5	Kostentraeger	NVARCHAR(306)	highlight_off	highlight_off	highlight_off
	Kombination aus KostentraegerID und KostentraegerName
6	KostentraegerTyp	NVARCHAR(50)	highlight_off	highlight_off	highlight_off
	Klassifizierung des Kostentraegers. z.B. KTR, OR, ...
7	KostentraegerTypBeschreibung	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Beschreibung des KostentraegerTyps
8	RowKey	BIGINT	check_circle	highlight_off	highlight_off
	RowKey

Referenzierte Objekte

agent.vJSON_global_tFIN_CostObjects
global.tCodes
global.tCompanies
global.tFIN_CostObjects

Referenziert von

agent.pSyncFIN

result.vFIN_Mandanten

View stellt Stammdaten zu Mandanten bereit.

#	Name	Datentyp	NULL	Identity	Berechnet
1	MandantenID	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	MandantenID
2	MandantenName	NVARCHAR(255)	check_circle	highlight_off	highlight_off

3	Beschreibung	NVARCHAR(2000)	highlight_off	highlight_off	highlight_off

4	FinanzjahrBeginn	INT	highlight_off	highlight_off	highlight_off

5	Kontorahmen	NVARCHAR(50)	highlight_off	highlight_off	highlight_off

6	Kontenlaenge	INT	highlight_off	highlight_off	highlight_off

7	Waehrung	NVARCHAR(50)	highlight_off	highlight_off	highlight_off

8	RowKey	INT	check_circle	highlight_off	highlight_off

Referenzierte Objekte

agent.vJSON_global_tCompanies
global.tCompanies
integration.tFIN_AccountingJournal

Referenziert von

agent.pSyncFIN

Prozeduren

agent.pDeleteIntegrationValuesFIN

This stored procedure is used to delete data from all tables of the module "FIN".

#	Parameter	Datentyp
1	@DataSourceKey	INT
	DataSourceKey
2	@CompanyID	NVARCHAR(50)
	OCT identifier for the company. Part of AccountKey.
3	@PeriodFrom	INT
	PeriodFrom
4	@PeriodTo	INT
	PeriodTo
5	@Username	NVARCHAR(255)
	Username
6	@IsDeltaloadBool	BIT
	IsDeltaloadBool
7	@Module	NVARCHAR(255)
	Module

Referenzierte Objekte

dbo.sx_pf_pPOST_API_LogEntry
integration.tFIN_AccountingJournal
integration.tFIN_Accounts
integration.tFIN_CostObjects
system.spGET_ParameterString
system.spGET_TransactUsername
system.spSEND_Message

agent.pPostBulkloadFIN

This the post bulkload procedure of module "FIN". The procedure triggers the sync of master data from integration to global schema including foster parent handling.

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@CompanyKeys	NVARCHAR(MAX)
	List of CompanyKeys, semicolon separated.

Referenzierte Objekte

agent.pSyncDimensionToGlobal
agent.vFIN_ChartsOfAccounts_HGBStructure
dbo.sx_pf_pPOST_API_LogEntry
global.tFIN_Accounts
global.tFIN_CostObjects
integration.tFIN_AccountingJournal
integration.tFIN_Accounts
integration.tFIN_CostObjects
system.spGET_ParameterString
system.spGET_TransactUsername
system.spSEND_Message

agent.pSyncFIN

Procedure to transfer data of module FIN to result schema.

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@CompanyKeys	NVARCHAR(MAX)
	CompanyKeys
3	@FullRebuild	BIT
	Force full rebuild of fact tables.

Referenzierte Objekte

dbo.sx_pf_pPOST_API_LogEntry
global.tCompanies
result.tFIN_Buchungsjournal
result.tFIN_BuchungsjournalAggregated
result.tFIN_FiBuSaldenliste
result.tFIN_Konten
result.tFIN_Mandanten
result.vFIN_Buchungsjournal
result.vFIN_BuchungsjournalAggregated
result.vFIN_FiBuSaldenliste
result.vFIN_Konten
result.vFIN_Kostenstellen
result.vFIN_Kostentraeger
result.vFIN_Mandanten
system.spGET_ParameterString
system.spGET_TransactUsername
system.spSEND_Message

integration.pGetDeltaValuesFIN

Procedure to get DeltaValues from module FIN.

#	Parameter	Datentyp
1	@DataSourceKey	INT
	DataSourceKey
2	@CompanyID	NVARCHAR(50)
	CompanyID
3	@Username	NVARCHAR(255)
	Username

Referenzierte Objekte

dbo.sx_pf_pPOST_API_LogEntry
integration.tFIN_AccountingJournal
system.spGET_ParameterString
system.spGET_TransactUsername
system.spSEND_Message

result.pHTML_ZV_FIN_Start

Procedure to provide HTML start page for FIN validation module

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@FactoryID	NVARCHAR(255)
	FactoryID
3	@ProductlineID	NVARCHAR(255)
	ProductlineID

Referenzierte Objekte

dbo.sx_pf_pPOST_API_LogEntry
integration.vFIN_AccountingJournalStats
integration.vFIN_AccountsStats
integration.vFIN_CostObjectsStats

result.pPivot_FiBuSaldenliste

Procedure to provide balance list data for FIN validation module

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@FactoryID	NVARCHAR(255)
	FactoryID
3	@ProductlineID	NVARCHAR(255)
	ProductlineID

Referenzierte Objekte

dbo.sx_pf_Determine_TransactionUsername
dbo.sx_pf_pPOST_API_LogEntry
planning.tdValueSeries
planning.tfValues
result.tFIN_FiBuSaldenliste

result.pPivot_Kostenstellenauswertung

Procedure to provide cost center data for FIN validation module

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@FactoryID	NVARCHAR(255)
	FactoryID
3	@ProductlineID	NVARCHAR(255)
	ProductlineID

Referenzierte Objekte

dbo.sx_pf_Determine_TransactionUsername
dbo.sx_pf_pPOST_API_LogEntry
planning.tdValueSeries
planning.tfValues
result.tFIN_BuchungsjournalAggregated

result.pPivot_Kostentraegerauswertung

Procedure to provide cost unit data for FIN validation module

#	Parameter	Datentyp
1	@Username	NVARCHAR(255)
	Username
2	@FactoryID	NVARCHAR(255)
	FactoryID
3	@ProductlineID	NVARCHAR(255)
	ProductlineID

Referenzierte Objekte

dbo.sx_pf_Determine_TransactionUsername
dbo.sx_pf_pPOST_API_LogEntry
planning.tdValueSeries
planning.tfValues
result.tFIN_BuchungsjournalAggregated