Identification

0

A

6

Always: GBAO10

Order number

1

B

9

Numerical

Customer number

2

C

9

Numeric (no decimals). If 0, a new customer is created.

Customer name

3

D

50

Text (Customer name or number must be completed)

Invoice address

4

E

150

Text (colon represents a line shift)

Delivery address

5

F

150

Text (colon represents a line shift)

Reference

6

G

30

Text

Your Reference

7

H

30

Text

Our reference (employee)

8

I

3

Numeric (StdReg_xxx.xls)

Fixed text

9

J

200

Text

Packing list text

10

K

200

Text

Payment terms

11

L

3

Numeric (StdReg_xxx.xls)

Response type

12

M

3

Numeric (StdReg_xxx.xls)

Department

13

N

3

Numeric (StdReg_xxx.xls)

Project

14

O

6

Numeric (StdReg_xxx.xls) or blank for none

Delivery type

15

P

3

Numeric (StdReg_xxx.xls)

Product number

16

Q

50

Text (Product number or description must be completed)

Description

17

R

60

Text

Quantity ordered

18

S

12

Numeric (2 decimals)

Total order sum

19

T

15

Numeric (3 decimals)

Discount (in %)

20

U

6

Numeric (2 decimals)

VAT code

21

V

9

Numeric:

0: Fetch from product

1: Zero VAT

Or: Table (StdReg_xxx.xls)

Warehouse number

22

W

2

Numeric (StdReg_xxx.xls)

Warehouse must be connected to product.

Delivery date

23

X

8

Date (format YYYYMMDD)

<Not used>

24

Y

The space/field must be used but the value can be blank

Excise duty

25

Z

12

Numeric, 2 decimals (Export only)

Order discount (amount)

26

AA

12

Numeric, 2 decimals (Export only)

Order VAT amount

27

AB

12

Numeric, 2 decimals (Export only)

Total Order Sum

28

AC

12

Numeric, 2 decimals (Export only)

External order number

29

AD

20

Text

<Not used>

30

AE

25

Text (Export only)