Exact Financials

 

Connectivity Manual - IFALL - Recurring entries

Recurring entries

As of version 3.28 recurring entries can be imported using the Exact Data Interface System.

The table below documents the fields available in application 'EXACT'. To use this functionality you need to update your EDIS script, information can be found here.

Recurring entries - FIREH

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	JOURNAL_NR	Integer	3	journl	Journal	-
3	ENTRY_CODE	Character	8	-	Code	-
4	DESCR	Character	25	-	Description	-
5	DEBTOR	Integer	8	debtor	Debtor	-
6	CREDITOR	Integer	8	credit	Creditor	-
7	PAY_CONDITION	Character	4	paycon	Payment condition	-
8	CURR_CODE	Character	3	curren	Currency	-
9	AMOUNT_INC_VAT	Decimal	17	-	Amount	-
10	AMOUNT_INC_VAT_BLOCKED	Decimal	17	-	Amount blocked account	-
11	PAY_METHOD	Integer	2	1	Payment method	-
12	PAY_REFERENCE	Character	20	-	Payment reference	-
13	PERCENTAGE_1	Decimal	5	-	Percentage	-
14	AMOUNT_1	Decimal	17	-	Amount	-
15	PERCENTAGE_2	Decimal	5	-	Percentage	-
16	AMOUNT_2	Decimal	17	-	Amount	-
17	PERCENTAGE_3	Decimal	5	-	Percentage	-
18	AMOUNT_3	Decimal	17	-	Amount	-
19	PERCENTAGE_4	Decimal	5	-	Percentage	-
20	AMOUNT_4	Decimal	17	-	Amount	-
21	PERCENTAGE_5	Decimal	5	-	Percentage	-
22	AMOUNT_5	Decimal	17	-	Amount	-
23	REVERSAL_ENTRY	Logical	1	-	Reversal entry	-

1. 1: cash
   2: bank
   3: giro
   4: collect

Recurring entry lines - FIREL

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	LINENR_FIREL	Integer	4	-	Line	-
2	DESCR	Character	25	-	Description	-
3	ACC_NR	Character	9	ledger	Account	-
4	QUANTITY	Decimal	12	-	Quantity	-
5	DEBTOR	Integer	8	debtor	Debtor	-
6	CREDITOR	Integer	8	credit	Creditor	-
7	VAT_CODE	Character	3	vattrs	VAT code	-
8	AMOUNT_DEBIT	Decimal	17	-	Amount	-
9	AMOUNT_CREDIT	Decimal	17	-	Amount	-
10	AMOUNT_VAT_DEBIT	Decimal	17	-	VAT amount	-
11	AMOUNT_VAT_CREDIT	Decimal	17	-	VAT amount	-
12	COST_CENTER	Character	8	ccent	Cost center	-
13	COST_UNIT	Character	8	cunit	Cost unit	-
14	MDIM_CODE_1	Character	8	-	Mdim	-
15	MDIM_CODE_2	Character	8	-	Mdim	-
16	MDIM_CODE_3	Character	8	-	Mdim	-
17	MDIM_CODE_4	Character	8	-	Mdim	-
18	MDIM_CODE_5	Character	8	-	Mdim	-
19	PROJECT_CODE	Character	10	prmst	Project	-
20	COST_CAT_CODE	Character	8	prccat	Cost category	-
21	PROJECT_COST_CENTER	Character	8	ccent	Cost center	-
22	PROJECT_DESCR	Character	30	-	Description	-
23	RESULT_TYPE	Integer	6	1	Result type	-
24	IC_ACC_NR	Character	9	ledger	Account	-
25	IC_QUANTITY	Decimal	12	-	Quantity	-
26	IC_COST_CENTER	Character	8	ccent	Cost center	-
27	IC_COST_UNIT	Character	8	cunit	Cost unit	-
28	IC_DEBTOR	Integer	8	debtor	Debtor	-
29	IC_CREDITOR	Integer	8	credit	Creditor	-

 

1. 400501: expenses
   400502: revenues

---

Connectivity Manual > Contents > IFALL > Finance > Recurring entries

---

     

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security  level:	All - 0
Sub category:	Details	Document ID:	18.329.975
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer