Table CLIENTI

Purpose

Clients table (client: client or customer of LCW)

No.	Used	Name	Type	Reqd.	Description
1	Y	ID	NUMERIC(0,18)	Y	Unique(?) ID generated from timestamp
2	Y	COMPANY	VARCHAR(30)	N	Company name
3	Y	STREET	VARCHAR(100)	N	Address: street
4	Y	TOWN	VARCHAR(50)	N	Address: Town
5	Y	TOWNCODE	VARCHAR(50)	N	Address: zip
6	Y	FAX	VARCHAR(100)	N	Contact: fax
7	Y	PERSON	VARCHAR(50)	N	Contact person
8		PCNAME	VARCHAR(50)	N
9		FILLDATE	VARCHAR(20)	N
10	Y	CONT	VARCHAR(50)	N	Bank account
11	Y	BANCA	VARCHAR(50)	N	Bank name
12	Y	CF	VARCHAR(50)	N	VAT number (?)
13	Y	EMAIL	VARCHAR(100)	N	Contact Email
14	Y	TEL	VARCHAR(100)	N	Contact email
15		RUTA	VARCHAR(20)	N
16	Y	JUDET	VARCHAR(50)	N	Area
17	Y	NRREGCOM	VARCHAR(50)	N	Commercial number (account)
18		EXPORTF	VARCHAR(1)	N
19	Y	DONOTPRINTLABEL	VARCHAR(1)	N	Do not print a label.
20	N	AdvicePick	VARCHAR(50)	N	Not found in code