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