One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Debtors

File name: debitr.csv

No. Field name Type Format Ref Description Remarks Default
1 adm-nr INT N6 admdat Company * -
2 debtor INT N10 - 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 N10 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:

Field Clarification
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 [Finance: 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 [System: File, Company settings, General settings] on the 'General' tab, 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 [Finance: 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 [Finance: File, Company settings, Financial preferences] will be used.

Connectivity > Data import > Available import formats > Finance > Debtors - 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: 18.324.065
 Assortment: Exact Financials  Date: 02-10-2015
 Release:  Attachment:
 Disclaimer

Attachments
debitr.csv 645 B Download