Table ADM

Purpose

Field definitions in table ADM

No.	Used	Name	Type	Reqd.	Description
1	Y	PCNAME	VARCHAR(100)	Y	User login name
2	Y	NAME	VARCHAR(100)	N	User full name
3		EMAIL	VARCHAR(100)	N	User Email
4		PHONE	VARCHAR(100)	N	User Phone
5		FAX	VARCHAR(100)	N	User fax
6	N	BLEVEL	VARCHAR(10)	N
7	Y	X1	VARCHAR(1)	N	User can do scanner receptions
8	Y	X2	VARCHAR(1)	N	user can do scanner deliveries
9	Y	x3	VARCHAR(1)	N	User can do scanner stock/code
10	Y	x4	VARCHAR(1)	N	user can do scanner barcodes
11	Y	X5	VARCHAR(1)	N	User can do scanner inventory
12	Y	X6	VARCHAR(1)	N	User can do scanner moves
13	Y	X7	VARCHAR(1)	N	User can do scanner kits
14	Y	X8	VARCHAR(1)	N	User can do scanner stock/location
15	Y	X9	VARCHAR(1)	N	User can do scanner Checkings
16	Y	X10	VARCHAR(1)	N	User can do scanner returns
17	N	X11	VARCHAR(1)	N
18	N	X12	VARCHAR(1)	N
19	Y	O1	VARCHAR(1)	N	User can do Office users
20	Y	O2	VARCHAR(1)	N	User can do Office receptions
21	Y	O3	VARCHAR(1)	N	User can do Office settings
22	Y	O4	VARCHAR(1)	N	User can do Office deliveries
23	Y	O5	VARCHAR(1)	N	User can do Office suppliers
24	Y	O6	VARCHAR(1)	N	User can do Office clients
25	Y	O7	VARCHAR(1)	N	User can do Office stock
26	Y	O8	VARCHAR(1)	N	User can do Office Import files
27	Y	O9	VARCHAR(1)	N	User can do Office other
28	Y	O10	VARCHAR(1)	N	User can do Office kitting (groupage)
29	Y	O11	VARCHAR(1)	N	User can do Office labels
30	Y	O12	VARCHAR(1)	N	User can do Office export files
31	N	O13	VARCHAR(1)	Y
32	N	O14	VARCHAR(1)	N
33	N	O15	VARCHAR(1)	N
34	Y	Admin	VARCHAR(1)	N	Y if the user is an administrator
35	N	UserType	VARCHAR(1)	Y
36	N	STPRINT	VARCHAR(1)	N
37	Y	UserPrinter	VARCHAR(100)	N	Name of printer for the user
38	Y	UserLabelPrinter	VARCHAR(100)	N	Name of the label printer for the user
39	Y	MSUPPLIER	VARCHAR(50)	N	Mini warta supplier
40	Y	MSUPPLIER_ID	INT	N	Mini Warta supplier ID
41	Y	USERID	NUMERIC(0,18)	N	Unique ID, shown in main form caption

Indexes