DEBCRED-CPCASH - OCT Modul Dokumentation

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

2	FactoryID	NVARCHAR(255)	check_circle	highlight_off	highlight_off

3	ProductLineID	NVARCHAR(255)	check_circle	highlight_off	highlight_off

4	ProductID	NVARCHAR(255)	check_circle	highlight_off	highlight_off

5	TimeID	INT	check_circle	highlight_off	highlight_off

6	MDT	NVARCHAR(4000)	check_circle	highlight_off	highlight_off

7	KTO	NVARCHAR(4000)	check_circle	highlight_off	highlight_off

8	MAIN	NVARCHAR(4000)	check_circle	highlight_off	highlight_off

9	BIC	NVARCHAR(4000)	check_circle	highlight_off	highlight_off

10	KTO_Name	NVARCHAR(4000)	check_circle	highlight_off	highlight_off

Referenziert von

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

Sichten

dbo.vCM_Bankkonten

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(150)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	accountnumber	NVARCHAR(200)	check_circle	highlight_off	highlight_off
	Sachkontonummer des Bankkontos.
3	accountname	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Bankkontos.
4	bankcode	NVARCHAR(150)	check_circle	highlight_off	highlight_off
	BIC / BLZ des Bankkontos.
5	datebankbalance	DATE	check_circle	highlight_off	highlight_off
	Stichtag des Bankkontesaldos.
6	bankbalance	MONEY	check_circle	highlight_off	highlight_off
	Saldo des Bankkontos.

Referenzierte Objekte

dbo.vCM_Debitoren

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	debnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontonummer des Debitors.
3	name	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Debitors.
4	postcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Postleitzahl.
5	city	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Stadt.
6	pob	NVARCHAR(255)	check_circle	highlight_off	highlight_off

7	country	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Land.
8	contact	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontaktperson.
9	phone	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Telefonnummer der Kontatkperson.
10	fax	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Faxnummer der Kontatkperson.
11	email	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	E-Mail der Kontatkperson.
12	notice	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Notiz zum Debitor.
13	meanpaymenttarget	INT	check_circle	highlight_off	highlight_off
	Zahlungsziel.
14	discountdays1	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 1.
15	discountdays2	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 2.
16	discountpercent2	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 2.
17	discountdays3	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 3.
18	discountpercent3	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 3.
19	debaccountnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Sachkontonummer des Bankkontos, welches dem Debitor zugeordnet ist.
20	debbankcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Bankleitzahl des Bankkontos, welches dem Debitor zugeordnet ist.

Referenzierte Objekte

dbo.vCM_Gesellschaft

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(150)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	clientname	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Mandanten.
3	clientaccountnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Standard Sachkontonummer des Bankkontos, welches dem Mandanten zugeordnet ist.
4	clientbankcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Bankleitzahl des Bankkontos, welches dem Mandanten zugeordnet ist.
5	clientaccountname	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Bankkontos, welches dem Mandanten zugeordnet ist.
6	clientdiscountdays1	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Tage Stufe 1.
7	clientdiscountpercent1	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Prozent Stufe 1.
8	clientdiscountdays2	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Tage Stufe 2.
9	clientdiscountpercent2	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Prozent Stufe 2.
10	clientdiscountdays3	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Tage Stufe 3.
11	clientdiscountpercent3	INT	check_circle	highlight_off	highlight_off
	Standard Skonto Prozent Stufe 3.

Referenzierte Objekte

dbo.vCM_Kreditoren

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	debnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontonummer des Kreditors.
3	name	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Name des Kreditors.
4	postcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Postleitzahl.
5	city	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Stadt.
6	pob	NVARCHAR(255)	check_circle	highlight_off	highlight_off

7	country	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Land.
8	contact	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontaktperson.
9	phone	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Telefonnummer der Kontatkperson.
10	fax	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Faxnummer der Kontatkperson.
11	email	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	E-Mail der Kontatkperson.
12	notice	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Notiz zum Kreditor.
13	meanpaymenttarget	INT	check_circle	highlight_off	highlight_off
	Zahlungsziel.
14	discountdays1	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 1.
15	discountdays2	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 2.
16	discountpercent2	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 2.
17	discountdays3	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 3.
18	discountpercent3	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 3.
19	debaccountnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Sachkontonummer des Bankkontos, welches dem Kreditor zugeordnet ist.
20	debbankcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Bankleitzahl des Bankkontos, welches dem Kreditor zugeordnet ist.

Referenzierte Objekte

dbo.vCM_Offene_Posten_Debitoren

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	debnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontonummer des Debitors.
3	documentnumber	NVARCHAR(1277)	check_circle	highlight_off	highlight_off
	Belegnummer aufbereitet für CP-Cash. Setzt sich zusammen aus PersonenkontenID, Belegnummer und Belegdatum.
4	documentdate	DATETIME	check_circle	highlight_off	highlight_off
	Belegdatum der Buchung.
5	invoiceamount	MONEY	check_circle	highlight_off	highlight_off
	Wert des Belegs.
6	credit	MONEY	check_circle	highlight_off	highlight_off
	Habenwert der Buchung.
7	debit	MONEY	check_circle	highlight_off	highlight_off
	Sollwert der Buchung.
8	dunninglevel	INT	check_circle	highlight_off	highlight_off
	Mahnstufe.
9	dunningdate	INT	check_circle	highlight_off	highlight_off
	Mahndatum.
10	valuedate	DATETIME	check_circle	highlight_off	highlight_off
	Faelligkeitsdatum.
11	accountnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Sachkontonummer des Bankkontos.
12	bankcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Bankleitzahl des Bankkontos.
13	currencyiso	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	ISO Code der Währung.
14	documentnumber2	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Belegnummer 2.
15	paymentdate	DATETIME	check_circle	highlight_off	highlight_off
	Ausgleichsdatum.
16	diffdiscountdays1	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 1.
17	diffdiscountpercent1	INT	check_circle	highlight_off	highlight_off

18	diffdiscountdays2	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 2.
19	diffdiscountpercent2	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 2.
20	diffdiscountdays3	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 3.
21	diffdiscountpercent3	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 3.
22	dateclosed	DATETIME	check_circle	highlight_off	highlight_off
	Ausgleichsdatum.
23	blocked	INT	highlight_off	highlight_off	highlight_off

Referenzierte Objekte

dbo.vCM_Offene_Posten_Kreditoren

#	Name	Datentyp	NULL	Identity	Berechnet
1	clientid	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	MandantenID aus OCT.
2	debnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Kontonummer des Debitors.
3	documentnumber	NVARCHAR(1277)	check_circle	highlight_off	highlight_off
	Belegnummer aufbereitet für CP-Cash. Setzt sich zusammen aus PersonenkontenID, Belegnummer und Belegdatum.
4	documentdate	DATETIME	check_circle	highlight_off	highlight_off
	Belegdatum der Buchung.
5	invoiceamount	MONEY	check_circle	highlight_off	highlight_off
	Wert des Belegs.
6	credit	MONEY	check_circle	highlight_off	highlight_off
	Habenwert der Buchung.
7	debit	MONEY	check_circle	highlight_off	highlight_off
	Sollwert der Buchung.
8	dunninglevel	INT	check_circle	highlight_off	highlight_off
	Mahnstufe.
9	dunningdate	INT	check_circle	highlight_off	highlight_off
	Mahndatum.
10	valuedate	DATETIME	check_circle	highlight_off	highlight_off
	Faelligkeitsdatum.
11	accountnumber	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Sachkontonummer des Bankkontos.
12	bankcode	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	Bankleitzahl des Bankkontos.
13	currencyiso	NVARCHAR(255)	check_circle	highlight_off	highlight_off
	ISO Code der Währung.
14	documentnumber2	NVARCHAR(50)	check_circle	highlight_off	highlight_off
	Belegnummer 2.
15	paymentdate	DATETIME	check_circle	highlight_off	highlight_off
	Ausgleichsdatum.
16	diffdiscountdays1	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 1.
17	diffdiscountpercent1	INT	check_circle	highlight_off	highlight_off

18	diffdiscountdays2	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 2.
19	diffdiscountpercent2	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 2.
20	diffdiscountdays3	INT	check_circle	highlight_off	highlight_off
	Skonto Tage Stufe 3.
21	diffdiscountpercent3	INT	check_circle	highlight_off	highlight_off
	Skonto Prozent Stufe 3.
22	dateclosed	DATETIME	check_circle	highlight_off	highlight_off
	Ausgleichsdatum.
23	blocked	INT	highlight_off	highlight_off	highlight_off

Dokumentationstyp:	Vollständig (zur Endanwender 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

Inhaltsverzeichnis

Informationen

Tabellen

param.tPivotCPCASH_MAP_BKTO

Referenziert von

result.tFIN_FiBuSaldenliste

Referenziert von

result.tFIN_Konten

Referenziert von

Sichten

dbo.vCM_Bankkonten

View stellt Bankkontenstammdaten und -salden aus FIN bereit. Definition der relevanten Bankkonten über Tabelle global.tDEBCRED_CPCASH_BankAccounts

Referenzierte Objekte

dbo.vCM_Debitoren

View stellt Stammdaten zu Debitoren bereit.

Referenzierte Objekte

dbo.vCM_Gesellschaft

View stellt Stammdaten zu den Mandanten bereit.

Referenzierte Objekte

dbo.vCM_Kreditoren

View stellt Stammdaten zu Kreditoren bereit.

Referenzierte Objekte

dbo.vCM_Offene_Posten_Debitoren

View stellt die offenen Posten der Debitoren bereit.

Referenzierte Objekte

dbo.vCM_Offene_Posten_Kreditoren

View stellt die offenen Posten der Debitoren bereit.

Referenzierte Objekte