Table Sugested_Stock_List

Purpose

No.	Used	Name	Type	Reqd.	Description
1	Y	INVOICE	VARCHAR(50)	Y	Invoice number
2	Y	ARTCODE	VARCHAR(50)	Y	Article code
3	Y	QTY	DOUBLE	N	Quantity
4	Y	LOCATION	VARCHAR(50)	N	Location code
5	N	COLOR	VARCHAR(50)	N	No longer used.
6	N	AMBALAJ	VARCHAR(20)	N	No longer used.
7	Y	STOCKCODE	VARCHAR(50)	Y	Stock type code
8	Y	FILLDATE	TIMESTAMP	N
9		ID	INT	Y
10	Y	MyPRIORITY	INT	Y
11	Y	EXPIRYDATE	TIMESTAMP	N
12	Y	LotPriority	VARCHAR(1)	N
13	Y	HighPrSQ	INT	Y
14	Y	LocationLevelPriority	INT	Y	Location level priority
15		ExpirySQ	INT	Y
16		SessionID	VARCHAR(50)	N
17		RSystemDate	TIMESTAMP	N
18		UserName	VARCHAR(100)	N