Exact Financials

 

Connectivity Manual - IFALL - Debtor outstanding items

Debtor outstanding items

As of version 3.28 a limited number of debtor outstanding item fields can be updated using the Exact Data Interface System. Records cannot be created to preserve consistency between the outstanding items and the financial entries / transactions.

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.

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	cannot be updated
2	DEBTOR	Integer	8	debtor	Debtor	cannot be updated
3	ENTRY_NR_TYPE	Integer	2	1	Entry type	cannot be updated
4	ENTRY_NR	Integer	8	-	Entry number	cannot be updated
5	DATE	Date	8	-	Date	cannot be updated
6	JOURNAL_NR	Integer	3	journl	Journal	cannot be updated
7	DESCR	Character	25	-	Description	-
8	AMT_AFTER_ENTRY	Decimal	17	-	Amount after entry	cannot be updated
9	AMT_AFTER_POSTING	Decimal	17	-	Amount after posting	cannot be updated
10	CURR_CODE	Character	3	curren	Currency	cannot be updated
11	EXCH_RATE	Decimal	11	-	Exchange rate	cannot be updated
12	AMT_CURR_AFTER_ENTRY	Decimal	17	-	FC amount after entry	cannot be updated
13	AMT_CURR_AFTER_POSTING	Decimal	17	-	FC amount after posting	cannot be updated
14	AMT_ORIGINAL	Decimal	17	-	Original amount	cannot be updated
15	DUE_DATE_SURCH_1	Date	8	-	Due date PayCh/Disc 1	cannot be updated
16	DUE_DATE_SURCH_2	Date	8	-	Due date PayCh/Disc 2	cannot be updated
17	DUE_DATE_SURCH_3	Date	8	-	Due date PayCh/Disc 3	cannot be updated
18	DUE_DATE_SURCH_4	Date	8	-	Due date PayCh/Disc 4	cannot be updated
19	DUE_DATE_SURCH_5	Date	8	-	Due date PayCh/Disc 5	cannot be updated
20	DUE_DATE_INVOICE	Date	8	-	Due date invoice	cannot be updated
21	SURCH_DISC	Integer	2	2	Payment charge/discount	cannot be updated
22	AMT_CREDIT_SURCH_1	Decimal	17	-	Amount PayCh/Disc 1	cannot be updated
23	AMT_CREDIT_SURCH_2	Decimal	17	-	Amount PayCh/Disc 2	cannot be updated
24	AMT_CREDIT_SURCH_3	Decimal	17	-	Amount PayCh/Disc 3	cannot be updated
25	AMT_CREDIT_SURCH_4	Decimal	17	-	Amount PayCh/Disc 4	cannot be updated
26	AMT_CREDIT_SURCH_5	Decimal	17	-	Amount PayCh/Disc 5	cannot be updated
27	BLOCK	Logical	1	-	Block	-
28	LAST_ENTRY_DATE	Date	8	-	Last entry date	cannot be updated
29	NR_REMINDERS	Integer	2	-	Reminders	cannot be updated
30	DATE_LAST_REMINDER	Date	8	-	Last reminder	cannot be updated
31	LAYOUTCODE	Character	1	-	Layout	cannot be updated
32	WEEK_NR	Integer	2	-	Week	cannot be updated
33	FIN_YR	Integer	4	-	Financial year	cannot be updated
34	ACC_NR_SUB_ADM	Character	9	ledger	Subsidiary G/L account	cannot be updated
35	PAY_CONDITION	Character	4	paycon	Payment condition	cannot be updated
36	PAY_REF	Character	20	-	Payment reference	cannot be updated
37	PAY_METHOD	Integer	2	3	Payment method	cannot be updated
38	AMT_ACC_NR_BLOCKED	Decimal	17	-	Amount blocked bank account	cannot be updated

1. 1: normal
   3: prepayment
2. 1: surcharge
   2: discount
3. 1: cash
   2: bank
   3: giro
   4: collection

---

Connectivity Manual > Contents > IFALL > Finance > Debtor outstanding items

---

     

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.891
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer