Table Stock_In

Purpose

No.	Used	Name	Type	Reqd.	Description
1		INVOICE	VARCHAR(50)	Y
2		ARTCODE	VARCHAR(50)	Y
3		QTY	DOUBLE	N
4		LOCATION	VARCHAR(50)	N
5	N	COLOR	VARCHAR(50)	N	No longer used
6	N	AMBALAJ	VARCHAR(20)	N	No longer used
7		STOCKCODE	VARCHAR(50)	Y
8		FILLDATE	TIMESTAMP	N
9		ID	INT	Y
10		MyPRIORITY	INT	Y
11		EXPIRYDATE	TIMESTAMP	N
12		LotPriority	VARCHAR(1)	N
13		HighPrSQ	INT	Y
14		LocationLevelPriority	INT	Y
15		ExpirySQ	INT	Y
16		MonthsBeforeExpiry	NUMERIC(0,18)	N
17		SessionID	VARCHAR(50)	N
18		RSystemDate	TIMESTAMP	N
19		UserName	VARCHAR(100)	N