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
| 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
| 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
| 6
| 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
| 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: |
Exact Financials (v3)
|
Date: |
10-07-2007 |
| Release: |
3.25 |
Attachment: |
|
| Disclaimer |