One moment please...
 
Exact Globe+   
 

XML-Server: CSV import definition for Accounts payable

Issue:

This document describes the CSV import definition for Accounts payable in Exact Globe 2003

Solution:

No. Field name Description Type Remarks Form.
1 crdcode Creditor code Numstr   A20
2 naam Name Text   A30
3 adres1 Address line 1 Text   A30
4 adres2 Address line 2 Text   A30
5 postcode Postcode Text   A8
6 woonpl City Text   A30
7 landcode Country Text   A3
8 crdzk Search code Text Obsolete A6
9 valcode Currencies Text   A3
10 telnr Telephone number Text   A15
11 faxnr Telefax Text   A15
12 cntpers1 Contact Text   A30
13 mv1 Man/Woman/Unknown Text   A1
14 prdcode1 Title code Text   A4
15 vrlttrs1 Initials Text   A10
16 functie1 Job specification Text   A15
17 telnrcp1 Telephone number Text   A15
18 banknr1 Bank account 1 Text   A10
19 banknr2 Blocked account Text   A10
20 banknaam Bank name Text Obsolete A20
21 Empty -     A10
22 pstbanknrc Postbank account creditor. Numstr Not supported A10
23 betwijze Payment method Text   A1
24 tegreknr offset account Numstr   A9
25 dagbknr Journal Numstr   A2
26 aandacht Attention field Y/N   A1
27 categorie Category Text   A2
28 kredlimiet Credit line Number   N8,2
29 bether Reminder Y/N   A1
30 betcond Payment condition Text   A2
31 blokkeer Block N/Y   A1
32 klantcode Customer code Text   A10
33 prijslijst Price list Text   A3
34 ex_artcode Extra item code Text   A2
35 korting Discount percentage Number   N3,2
36 layoutcode Layout code Text   A1
37 taalcode Language Text   A3
38 Empty -     A10
39 debsaldolj Debit balance current financial year Number Obsolete N8,2
40 crdsaldolj Credit balance current financial year Number Obsolete N8,2
41 debsaldosj Debit balance secondary financial year Number Obsolete N8,2
42 crdsaldosj Credit balance secondary financial year Number Obsolete N8,2
43 saldontvwd debit balance to be posted. Number Obsolete N8,2
44 saldontvwc credit balance to be posted Number Obsolete N8,2
45 omz_ex_lj Revenue excluding VAT current financial year Number Obsolete N8,2
46 omz_in_lj Revenue including VAT current financial year Number Obsolete N8,2
47 omz_ex_vj Revenue excluding VAT previous financial year Number Obsolete N8,2
48 omz_in_vj Revenue including VAT previous financial year Number Obsolete N8,2
49 bedrbest Amount on order Number   N8,2
50 btw_nummer VAT number Text   A20
51 Datectrl Check date Date   A8

Explanation about the datatypes can be found in document 01.081.509 .

Related topics

 

     
 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: 10.623.296
 Assortment:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer