Exact Globe+

XML-Server: CSV import definition for Sales invoices

Issue:

This document describes the CSV import definition for sales invoices in Exact Globe 2003.

Headline

No.	Fieldname	Description	Type	Remarks	Format
1	regelnumber	Line number	number	mandatory	N4
2	fakt_code	Invoice code	text	mandatory	A3
3	debnr	Debtor number	number	mandatory	A6
4	refer	Reference	text		A20
5	refer1	Reference 1	text		A20
6	refer2	Reference 2	text		A20
7	refer3	Reference 3	text		A20
8	ordernr	Order number	number		N8
9	orddat	Order date	date		A8
10	magcode	Warehouse	text		A4
11	ex_artcode	Extra item description	text		A2
12	verteg	Representative	number		A3
13	kstplcode	Cost center	text		A8
14	selcode	Selection code	text		A2
15	inv_in_vv	Amount in foreign currency	N/J		A1
16	nettoprijs	Net price	N/J		A1
17	valcode	Currency code	text		A3
18	koers	Exchange rate	number		N5,6
19	betcond	Payment condition	text		A2
20	levwijze	Shipping method	text		A3
21	vrachtkost	Freight cost	number		N5,2
22	orderkost	Order cost	number		N5,2
23	fakt_kort	Invoice discount	number		N3,2
24	tot_bdr	Total amount	number		N8,3
25	colli	Packages	number		N5
26	bruto_gew	Gross weight	number		N6,2
27	netto_gew	Net weight	number		N6,2
28	afldat	Delivery date	date		A8
29	adr_code	-	text	not used	A2
30	-	-
31	bruto/netto	Gross/Net	text		A1
32	-	-
33	-	-
34	-	-
35	-	-
36	-	-
37	-	-
38	-	-
39	-	-
40	-	-
41	-	-
42	fak_soort	Invoice type	text		A1
43	ord_fakt	Order debtor is invoice debtor	N/J		A1
44	deb_id	Debtor type	text		A1
45	fiattering	Authorized		Not used
46	fakdebnr	Invoice debtor	text	mandatory	A6
47	-	-
48	faknr	Invoice number	number		A8
49	kstplcode	Cost Center	text		A8

Sublines

Explanation about the datatypes can be found in document 01.081.509 .