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 .

XML-Server: CSV import definition for Accounts payable

Issue:

Solution:

Related topics