|
|
Connectivity Manual - Debtor master data
Debtor master data
File name: debitr.csv
| 1 |
adm-nr |
INT |
N6 |
admdat |
Company |
* |
- |
| 2
| debtor
| INT
| A8
| -
| Debtor
| Mandatory
| -
|
| 3
| name
| CHAR
| A30
| -
| Name
| -
| -
|
| 4
| address-1
| CHAR
| A30
| -
| Address 1
| -
| -
|
| 5
| address-2
| CHAR
| A30
| -
| Address 2
| -
| -
|
| 6
| postal-code
| CHAR
| A8
| -
| Postal code
| -
| -
|
| 7
| city
| CHAR
| A30
| -
| City
| -
| -
|
| 8
| country
| CHAR
| A3
| countr
| Country code
| -
| -
|
| 9
| search-code
| CHAR
| A15
| -
| Search code
| Mandatory
| *
|
| 10
| curr-code
| CHAR
| A3
| curren
| Currency code
| -
| -
|
| 11
| telephone
| CHAR
| A15
| -
| Telephone
| -
| -
|
| 12
| fax-nr
| CHAR
| A15
| -
| Fax
| -
| -
|
| 13
| contact
| CHAR
| A30
| -
| Contact
| -
| -
|
| 14
| sex
| INT
| A1
| -
| Sex
| M/V/U
| Unknown
|
| 15
| title-code
| CHAR
| A4
| titles
| Title
| -
| -
|
| 16
| initials
| CHAR
| A10
| -
| Initials
| -
| -
|
| 17
| func_desc
| CHAR
| A30
| -
| Position
| -
| -
|
| 18
| telephone-contact
| CHAR
| A15
| -
| Telephone
| -
| -
|
| 19
| bank-acc-nr
| CHAR
| A34
| -
| Bank account
| -
| -
|
| 20
| bank-name
| CHAR
| A30
| -
| Bank name
| -
| -
|
| 21
| empty
| -
| -
| -
| -
| -
| -
|
| 22
| postbanknrd
| CHAR
| A34
| -
| Postbank
| -
| -
|
| 23
| pay-method
| CHAR
| A1
| -
| Payment method
| K/B/G/I/E/C/A/R/O/N
| *
|
| 24
| acc-nr-contra
| CHAR
| A9
| ledger
| Offset account
| -
| -
|
| 25
| journal-nr
| INT
| A3
| journl
| Journal
| -
| -
|
| 26
| attention
| LOG
| J/N
| -
| Attention field
| -
| No
|
| 27
| cat
| CHAR
| A2
| debcat
| Category
| -
| -
|
| 28
| invoice-debtor
| INT
| A8
| debtor
| Invoice debtor
| -
| Debtor
|
| 29
| surch
| DEC
| N15,2
| -
| Credit line
| -
| -
|
| 30
| pay-reminder
| LOG
| J/N
| -
| Reminder
| -
| Yes (J)
|
| 31
| pay-condition
| CHAR
| A4
| paycon
| Payment condition
| -
| -
|
| 32
| block
| LOG
| J/N
| -
| Block
| -
| No
|
| 33
| representative
| CHAR
| A8
| lsrep
| Sales representative
| -
| -
|
| 34
| pricelist_code
| CHAR
| A3
| llplst
| Price list
| -
| -
|
| 35
| empty
| -
| -
| -
| -
| -
| -
|
| 36
| delivery_method
| CHAR
| A8
| lldome
| Delivery method
| -
| -
|
| 37
| disc-perc
| DEC
| N3,2
| -
| Discount percentage
| -
| -
|
| 38
| empty
| -
| -
| -
| -
| -
| -
|
| 39
| empty
| -
| -
| -
| -
| -
| -
|
| 40
| lang-code
| CHAR
| A3
| lang
| Language
| -
| -
|
| 41
| empty
| -
| -
| -
| -
| -
| -
|
| 42
| empty
| -
| -
| -
| -
| -
| -
|
| 43
| empty
| -
| -
| -
| -
| -
| -
|
| 44
| empty
| -
| -
| -
| -
| -
| -
|
| 45
| empty
| -
| -
| -
| -
| -
| -
|
| 46
| empty
| -
| -
| -
| -
| -
| -
|
| 47
| empty
| -
| -
| -
| -
| -
| -
|
| 48
| empty
| -
| -
| -
| -
| -
| -
|
| 49
| empty
| -
| -
| -
| -
| -
| -
|
| 50
| empty
| -
| -
| -
| -
| -
| -
|
| 51
| empty
| -
| -
| -
| -
| -
| -
|
| 52
| empty
| -
| -
| -
| -
| -
| -
|
| 53
| vat-nr
| CHAR
| A20
| -
| VAT number
| -
| -
|
| 54
| check-date
| DATE
| DDMMYYYY
| -
| Check date
|
| Current date
|
| 55
| bank-type
| CHAR
| A3
| bnktpe
| Bank account type
| Setting
| *
|
| 56
| bank_curr_code
| CHAR
| A3
| curren
| Bank account currency code
| -
| *
|
Clarification of the fields
| 1 |
This field is only a part of the import format, when the option
'Company number' is enabled. When this option is not enabled, this field
should be skipped. |
| 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.
|
| 9
| If the field 'Search code' is left empty, the first 15 characters of the debtor's name will be used.
|
| 14
| 'M' for Male, 'V' for Female, and if this field is left empty, Unknown will be entered during import.
|
| 19,22
| These fields will be checked using the bank account type entered in field 54. If one of these fields contains an illegal value, the whole record will be rejected. If no bank account type is entered, the check of the bank account types defined in the settings in [File, Company settings, General settings] on the 'General' tab in the System menu, will be used. If the bank account numbers entered do not meet these checks, the whole record will be rejected.
|
| 23
| K = Cash
B = Bank
G = Giro
I =
Collect
E = Acceptgiro
C = Cheques
A = BACS
R =
Remittance
O = Bill of exchange
N = Bill of exchange bank
If this field is left empty, the payment method defined in [File, Company settings, Financial preferences] will be used as default.
|
| 25
| The journal selected, should be a sales journal.
|
| 55
| If this field is left empty, the default bank account type defined in [File, Company settings, Financial preferences] will be used. |
Connectivity Manual - Contents
> Data import > Finance
> Debtor master data
| 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: |
01.642.816 |
| Assortment: |
Exact Financials (v3)
|
Date: |
18-01-2007 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|