Customer: GBAC15
The fields are separated by a semicolon and not by a fixed column width. The figures specified under Max length indicate the maximum number of characters allowed in each field. Detailed customer format, semicolon separated.
‘StdReg_xxx.xls’:‘StdReg_xxx.xls’: Read more in Default Values in Mamut Business Software.
Description | Column no. | Column in Excel | Max length | Comments | Required |
---|---|---|---|---|---|
Identification |
0 |
A |
6 |
Always: GBAC15 |
Yes |
Customer number |
1 |
B |
9 |
Numeric (no decimals) |
Yes |
Customer name |
2 |
C |
50 |
Text |
|
Invoice address |
3 |
D |
100 |
Text |
|
Postcode |
4 |
E |
10 |
Text |
|
City |
5 |
F |
20 |
Text |
|
Contact person, first name |
6 |
G |
30 |
Text |
|
Contact person, surname |
7 |
H |
30 |
Text |
|
Telephone |
8 |
I |
15 |
Text |
|
Fax |
9 |
J |
15 |
Text |
|
|
10 |
K |
70 |
Text |
|
Our ref. (employee) |
11 |
L |
4 |
Numeric (StdReg_xxx.xls) |
|
Status |
12 |
M |
4 |
Numeric (StdReg_xxx.xls) |
|
Category |
13 |
N |
4 |
Numeric (StdReg_xxx.xls) |
|
Branch |
14 |
O |
4 |
Numeric (StdReg_xxx.xls) |
|
Group |
15 |
P |
100 |
Text (comma to separate groups) |
|
Response type (for order) |
16 |
Q |
4 |
Numeric (StdReg_xxx.xls) |
|
Project |
17 |
R |
4 |
Numeric (StdReg_xxx.xls) or blank for none |
|
Department |
18 |
S |
4 |
Numeric (StdReg_xxx.xls) |
|
Notice of payment |
19 |
T |
4 |
Numeric (StdReg_xxx.xls) |
|
Terms of delivery |
20 |
U |
4 |
Numeric (StdReg_xxx.xls) |
|
Form of delivery |
21 |
V |
4 |
Numeric (StdReg_xxx.xls) |
|
Rounding |
22 |
W |
1 |
Numeric: |
|
Batch Invoicing |
23 |
X |
1 |
Numeric: 1=Yes, 2=No |
|
Country |
24 |
Y |
4 |
Numeric (See Country.xls/ country.txt) |
|
Contact person, tel. |
25 |
Z |
18 |
Text |
|
Contact person, e-mail |
26 |
AA |
70 |
Text |
|
County (from address) |
27 |
AB |
30 |
Text |
|
Company reg. No. |
28 |
AC |
50 |
Text |
|
VAT no. |
29 |
AD |
50 |
Text |
|
Read more about: