Customer: GBAC20

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. The only difference from the GBAC15 format is that GBAC20 supports two address lines. 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: GBAC20	Yes
Customer number	1	B	9	Numeric (no decimals)	Yes
Customer name	2	C	50	Text
Invoice address line 1	3	D	100	Text (the address lines can have a combined total of 100 characters)
Invoice address line 2	4	E	100	Text (the address lines can have a combined total of 100 characters)
Postcode	5	F	10	Text
City	6	G	20	Text
Contact person, first name	7	H	30	Text
Contact person, surname	8	I	30	Text
Telephone	9	J	15	Text
Fax	10	K	15	Text
E-mail	11	L	70	Text
Our ref. (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 (for order)	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: 1=(None) 2= To nearest whole unit 3= Up to whole unit 4= Down to whole unit 5= To nearest half unit
Batch invoicing	24	Y	1	Numeric: 1=Yes, 2=No
Country	25	Z	4	Numeric (See Country.xls/country.txt)
Contact person, tel.	26	AA	18	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	AF	50	Text