One moment please...
 
 
Exact Financials (v3)   
 

Business logic: debtors

Revised for version 3.42

As of version 3.42 an extra test type value has been added for the bank account type (primary giro). This should be used to set the primary giro account.

Revised for version 3.26.2

As of version 3.25 the maintenance of debtors has been altered to use IFALL4 business logic. This also means that import through IFALL4 offers extra functionality to users. If the IFALL import procedure (edis/interf/finance/eidebtor.p) is not altered to (edis/interf/finance/eidebtor4.p), import of debtors will still work the same. Below you will find a description of the changes which have been introduced for IFALL4.

Debtors

Table names: debtor, prdeb, boedeb

Bold = New
Italic = Obselete

Nr Field name Data type Field length Ref Description Remark 
1 ADM_NR Integer 6 admdat Company mandatory 
2 DEBTOR Integer 8 debtor Debtor mandatory 
3 SEARCH_CODE Character 15 - Search code mandatory 
4 NAME Character 30 - Name -
5 ADDRESS_1 Character 30 - Address line 1 -
6 ADDRESS_2 Character 30 - Address line 2 -
7 ADDRESS_3 Character 30 - Address line 3 -
8 POSTAL_CODE Character 8 - Postcode -
9 CITY Character 30 - City -
10 COUNTRY Character 3 countr Country code -
11 TELEPHONE Character 15 - Telephone number -
12 FAX_NR Character 15 - Fax number -
13 LANG_CODE Character 3 lang Language -
14 CAT Character 2 debcat Category -
15 CONTACT Character 30 - Contact -
16 SEX Integer 2 * Sex 1/2/3 
17 TITLE_CODE Character 4 titles Title -
18 INITIALS Character 10 - Initials -
19 FUNCTION Character 15 - Function -
20 TELEPHONE_CONTACT Character 15 - Telephone number -
21 E_MAIL Character 60 - E-Mail address -
22 CONTACT_WEBSITE Character 160 - Contact website -
23 PAY_METHOD Integer 2 * Payment method 1/2/3/4/5/6/7/8/9/10 
24 PAY_REMINDER Logical 1 - Payment Reminder -
25 PAY_CONDITION Character 4 paycon Payment condition -
26 ACC_NR_CONTRA Character 9 ledger Offset account -
27 CURR_CODE Character 3 curren Currency code -
28 JOURNAL_NR Integer 3 journl Journal -
29 VAT_NR Character 20 - VAT number -
30 CHECK_DATE Date 10 - Check date VAT -
31 VAT_CODE Character 3 vattrs VAT code -
32 CHANGE_VAT Logical 1 - Change vat -
33 PRINT_STAT Logical 1 - Print statment -
34 ATTENTION Logical 1 - Attention field -
35 DAY_OF_MONTH_1 Integer 2 - Day of month 1 (boe) -
36 DAY_OF_MONTH_2 Integer 2 - Day of month 2 (boe) -
37 DAY_OF_MONTH_3 Integer 2 - Day of month 3 (boe) -
38 DAY_OF_MONTH_4 Integer 2 - Day of month 4 (boe) -
39 DAY_OF_MONTH_5 Integer 2 - Day of month 5 (boe) -
40 BOE_LIMIT Decimal 21 - Boe limit -
41 GROUP_CHEQUE_BE Integer 2 - Group cheque boe -
42 INVOICE_DEBTOR Integer 8 debtor Invoice Debtor -
43 BLOCK Logical 1 - Block -
44 DISC_PERC Decimal 7 - Discount percentage -
45 SURCH Decimal 21 - Credit line -
46 REPRESENTATIVE Character 8 lsrep Representative -
47 PRICE_LIST Character 3 lplit Price list -
48 DELIV_METHOD Character 3 lldome Delivery method -
49 GROUPED_INVOICE Logical 1 - Group invoices -
50 COST_CODE Character 8 - Cost code -
51 RATE_CURR_CODE Character 3 curren Currency code rate -
52 INTERNAL_RATE Decimal 12 - Internal rate -
53 EXTERNAL_RATE Decimal 12 - External rate -
54 IFALL_BLOCK Logical 1 - Ifall block -
55 DATE_LAST_REMINDER Date 10 - Date last reminder
56 DATE_STAT Character 10 - Last date periodic overview
57 SEQ_STAT Integer 4 - Last sequence number periodic
58 NOTE Character 999 - Note -

Clarification of the fields

2 If a '?' is entered here, the last used debtor number will be increased with the increment factor defined in [File, Company settings, Financial preferences] on the 'Subadmin.' Tab. Debtor number 0 cannot be used.
16 '1' for Male, '2' for Female, and if this field is left empty, Unknown will be entered during import.
23

1 = Cash
2 = Bank
3 = Giro
4 = Collect
5 = Acceptgiro
6 = Cheques
7 = BACS
8 = Remittance
9 = Bill of exchange
10 = Bill of exchange bank
11 = Collection in installments

If this field is left empty, the payment method defined in [File, Company settings, Financial preferences] will be used as default.

28 The journal selected, should be a sales journal.
 51 If currency is filled an entry in Prdeb will be created.

Bank accounts

Table name: bnklnkd

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company mandatory 
2 DEBTOR Integer 8 debtor Debtor mandatory  
3 BANK_ACC_NR Character 34 - Bank account mandatory 
4 CURR_CODE Character 3 curren Currency mandatory 
5 ACCNCD Character 3 bnktpe Bank type mandatory 
6 BNKACCMSK Character 50 - Bankaccount
7 NAME Character 30 - name -
8 SWIFT_ADDRESS Character 11 - Swift address -
9 COUNTRY Character 3 countr Country -
10 ADDRESS_1 Character 30 - Address line 1 -
11 ADDRESS_2 Character 30 - Address line 2 -
12 ADDRESS_3 Character 30 - Address line 3 -
13 POSTAL_CODE Character 8 - Postal code -
14 CITY Character 30 - City -
15 TELEPHONE Character 15 - Telephone -
16 FAX Character 15 - Fax -
17 TITLE_CODE Character 4 title Title code -
18 INITIALS Character 10 - Initials -
19 CONTACT Character 30 - Contact -
20 SEX Integer 2 - sex 1/2/3 
21 FUNC_DESC Character 30 - Function description -
22 E_MAIL Character 60 - E-mail -
23 PRIMARY Integer 6 * Primary -
24 CODE_DC Character 1 - debtor/creditor "D"

Clarification of the fields

Bankmask will be automatically filled based on the bank account type.
23  203301 = Primary
203302 = Normal
203303 = Primary (giro)
24 Value should always be "D" for debtor

Debtor addresses

Table name: delnac

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company mandatory 
2 DEBTOR Integer 8 debtor Debtor mandatory 
3 CODE Character 8 delnac Addess mandatory 
4 NAME Character 30 - Name -
5 ADDRESS_1 Character 30 - Address line 1 -
6 ADDRESS_2 Character 30 - Address line 2 -
7 ADDRESS_LINE_3 Character 30 - Address line 3 -
8 POSTAL_CODE Character 8 - Postal code -
9 CITY Character 30 - City -
10 COUNTRY Character 3 countr Country -
11 TELEPHONE Character 15 - Telephone -
12 FAX Character 15 - Fax -
13 TITLE_CODE Character 4 titles Title code -
14 INITIALS Character 10 - Initials -
15 CONTACT Character 30 - Contact -
16 FUNC_DESC Character 30 - Function description -
17 SEX Integer 2 - Sex 1/2/3
18 E_MAIL Character 60 E-mail -
19 LANG_CODE Character 3 lang Language

17 '1' for Male, '2' for Female, and if this field is left empty, Unknown will be entered during import.

     
 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: 05.861.955
 Assortment:  Date: 10-07-2007
 Release: 3.25  Attachment:
 Disclaimer