XML-Server: CSV import definition for Items

No.

Field

Description

Field type

Refer.

Form.

1

artcode

'Item code'

Text

-

A20

2

ar_soort

'Item type'

Text

-

A1

3

samengest

'Assembled'

N/Y

-

A1

4

kort_oms

'Brief item description'

Text

-

A13

5

oms30

'Description'

Text

-

A30

6

artgrp

'Item group'

Text

artgrp

A4

7

magcode

'Warehouse code'

Text

magaz

A4

8

voorrart

'Stock item'

Y/N

-

A1

9

eenh_verk

'Sales unit'

Text

-

A5

10

aant_verp

'Qty./sls. pkg.'

Digit

-

N8,3

11

verkp_verp

'Sales price'

Digit

-

N8,3

12

lev_crdnr

'Supplier's code'

No.

credit

A6

13

bestadvc

'Purchase order advice code'

Text          

bstadf

A1

14

btw_verk

'Sales VAT code'

BTW

btwtrs

A3

15

btw_ink

'Purchase VAT code'

BTW

btwtrs

A3

16

statistnr

'Statistical factor code'

Text

intnr

A9

17

omzstat_jn

'Rev. stats.'

Y/N

-

A1

18

inkstat_jn

'PurStat'

Y/N

-

A1

19

backordart

'Back order item'

Y/N

-

A1

20

verp_oms

'Sales package description'

Text

A8

21

emballaant

'Packaging quantity'

Digit

N2

22

vwrd1

'Free value 1'

Digit

-

N8,3

23

vwrd2

'Free value 2'

Digit

-

N8,3

24

gip

'Average purchase price'

Digit

-

N8,3

25

vvp

'Standard cost price'

Digit

-

N8,3

26

maglok

'Warehouse location'

Text

-

A10

27

*minvrd

'Minimum stock'

Digit

-

N8,3

28

*maxvrd

'Maximum stock'

Digit

-

N8,3

29

*veilvrd

'Safety stock'

Digit

-

N8,3

30

bestniv

'Purchase order level'

Digit

-

N8,3

31

*werkvrd

'Real stock'

Digit

-

N8,3

32

*o_resvrd

'Reserved for sales orders'

Digit

-

N8,3

33

*b_resvrd

'Reserved stock on back order'

Digit

-

N8,3

34

*vrd_bew

'Stock being processed'

Digit

-

N8,3

35

in_bstvrd

'Quantity ordered entered'

Digit

-

N8,3

36

bstvvd

'Ordered stock to be received'

Digit

-

N8,3

37

*in_prod

'In production'

Digit

-

N8,3

38

nontv

'Quantity received'

Digit

-

N8,3

39

nof

'Invoices to be received'

Digit

-

N8,3

40

o_resprod

'Reserved stock on order'

Digit

-

N8,3

41

b_resprod

'Reserved production back order'

Digit

-

N8,3

42

ntf

'To be invoiced'

Digit

-

N8,3

43

artcodlev

'Supplier's item code'

Text

-

A13

44

eenh_ink

'Purchase unit'

Text

-

A5

45

aant_verpi

'Qty./pur. pkg.'

Digit

-

N8,3

46

inkp_verp

'Purchase price per package'

Digit

-

N8,3

47

gip_lev

'Average purchase price'

Digit

-

N8,3

48

tot_nontv

'Total received'

Digit

-

N8,3

49

omr_fact

'Conversion'

Digit

-

N4,4

50

levt

'Delivery term'

Digit

-

N3

51

levb

'Deliverable from stock'

Y/N

-

A1

52

bestgr

'Purchase order size'

Digit

-

N6,2

53

verp_oms_1

'Sales package description'

Text

-

A8

54

bestn_l

'Last PO number'

No.

-

A8

55

bestdatl

'Last purchase order date'

Date

-

A6/8

56

ontvdatl

'Last rec. date'

Date

-

A6/8

57

serie_art

'Serial/batch item'

Text

-

A1

58

tekst

'Text item'

Text

txtart

A160

59

orderink

'Back to back order'

N/Y

-

A1