Exact Globe+

XML-Server: CSV import definition for Sales orders

Issue:

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

Headline

Subline

No.	Field name	Description	Type	Remarks	Form.
1	regelnummer	Line number	Number		N4
2	ordernr	Order number	Number		A8
3	afldat	Delivery date	Date		A8
4	afl_week	-	Number	Not used	A2
5	magcode	Warehouse	Text		A4
6	debnr	Debtor number	Number		A6
7	cmp_name	Debtor name	Text		A6
8	nal_adrcd	-	Text	Not used	A6
9	refer	Reference	Text		A20
10	refer1	Reference 1	Text		A20
11	refer2	Reference 2	Text		A20
12	refer3	Reference 3	Text		A20
13	orddat	Order date	Date		A8
14	ordbv_afdr	Print sales order confirmation	N/J		A1
15	selcode	Selection code	Text		A2
16	ex_artcode	Extra item description	Text		A2
17	verteg	Representative	Number		A3
18	kstplcode	Costcenter	Text		A8
19	routecode	Route code	Text		A2
20	adr_code	-	Text		A2
21	nettoprijs	Net price	N/J		A1
22	tot_bdr	Total amount	Number		N8,3
23	inv_in_w	Amount in foreign currency	N/J		A1
24	valcode	Currency	Text		A3
25	koers	Exchange rate	Number		N5,6
26	betcond	Payment condition	Text		A2
27	levwijze	Shipping method	Text		A3
28	stat_code	Statistical code	Text		A1
29	verzdebnr	Delivery debtor	Number		A6
30	empty	-
31	empty
32	empty
33	colli	Packages	Number		N5
34	bruto_gew	Bruto weight	Number		N6,2
35	netto_gew	Net weight	Number		N6,2
36	empty	-
37	empty	-
38	empty	-
39	empty	-
40	empty	-
41	btw_code	VAT code	Text		A3
42	empty	-
43	empty	-
44	empty	-
45	empty	-
46	empty	-
47	empty	-
48	empty	-
49	empty	-
50	fiattering	Approved	N/J	Not used	A1
51	fakdebnr	Invoice debtor	Number		A6
52	ord_soort	Order type	Text		A1

Explanation about the datatypes can be found in document 01.081.509 .

No.	Field name	Description	Type	Remarks	Form
1	regelnummer	Line number	Number		N3
2	ordernr	Order number	Number		A8
3	afldat	Delivery date	Date		A8
4	afl_week	-	Number	Not used	A2
5	magcode	Warehouse	Text		A4
6	empty	-
7	empty	-
8	empty	-
9	empty	-
10	empty	-
11	empty	-
12	empty	-
13	empty	-
14	empty	-
15	empty	-
16	empty	-
17	empty	-
18	empty	-
19	empty	-
20	empty	-
21	empty	-
22	empty	-
23	empty	-
24	empty	-
25	empty	-
26	empty	-
27	empty	-
28	empty	-
29	empty	-
30	empty	-
31	empty	-
32	empty	-
33	empty	-
34	empty	-
35	empty	-
36	artcode	Item	Text		A30
37	ar_soort	Item type	Text		A1
38	oms45	Description	Text		A45
39	esr_aantal	Quantity in order	Number		N6,3
40	empty
41	btw_code	VAT code	Text		A3
42	prijslijst	Price list	Text		A3
43	kosting	Discount	Number		N3,2
44	prijs83	Price	Number		N8,3
45	prijs_n	Net Price	Number		N8,3
46	kstdrcode	Cost unit	Text		A8
47	tekst	Text for text lines	Text		A160
48	empty	-
49	empty	-
50	empty	-
51	empty	-
52	empty	-

Tags	Support Product Know How-On-line help files-Details