Customer (SAP Library - Reference Manual 7.2 (BC))

Customer

The customer table contains a list of customers with the following information:

CNO	TITLE	NAME	FIRSTNAME	ZIP	CITY	ACCOUNT
3000	Mrs	Porter	Jenny	10580	New York	100.00
3100	Comp	DATASOFT	?	75243	Dallas	4813.50
3200	Mr	Randolph	Martin	90018	Los Angeles	0.00
3300	Mrs	Smith	Sally	90011	Los Angeles	0.00
3400	Mr	Brown	Peter	90029	Hollywood	0.00
3500	Mr	Jackson	Michael	20037	Washington	0.00
3600	Mr	Howe	George	10019	New York	-315.40
3700	Mr	Miller	Frank	60601	Chicago	0.00
3800	Mr	Peters	Joseph	90013	Los Angeles	650.00
3900	Mrs	Baker	Susan	90008	Los Angeles	-4167.79
4000	Mr	Jenkins	Anthony	90005	Los Angeles	0.00
4100	Mr	Adams	Thomas	90014	Los Angeles	-416.88
4200	Mr	Griffith	Mark	10575	New York	0.00
4300	Comp	TOOLware	?	90002	Los Angeles	3770.50
4400	Mrs	Brown	Rose	90025	Hollywood	440.00

SQL statement for creating the table structure

CREATE TABLE customer
(cno      FIXED(4) KEY CONSTRAINT cno BETWEEN 1 AND 9999,
title   CHAR(5) CONSTRAINT title IN ('MR','MRS,'COMP'),
name CHAR(7) NOT NULL,
firstname  CHAR(7),
zip      CHAR(5) CONSTRAINT zip like '(0-9)(0-9)(0-9)(0-9)(0-9)',
city      CHAR(12) NOT NULL,
account    FIXED(7,2) CONSTRAINT account BETWEEN –10000 AND 10000)