Table: Items

Table: SNITEM
View: SN0002
Record length: 1141
Flags: A R

Keys: 1

Field	Type	Title

ITEMNUM	String*24	Item Number Unformatted
AUDTDATE	Date
AUDTTIME	Time
AUDTUSER	String*8
AUDTORG	String*6
ITEMNUMF	String*24	Item Number
DESC	String*75	Description
COMMENT1	String*75	Comment 1
COMMENT2	String*75	Comment 2
COMMENT3	String*75	Comment 3
COMMENT4	String*75	Comment 4
ODATE1	Integer	Optional Date 1
ODATE2	Integer	Optional Date 2
ODATE3	Integer	Optional Date 3
ODATE4	Integer	Optional Date 4
OAMT1	BCD*10.6	Optional Amount 1
OAMT2	BCD*10.6	Optional Amount 2
OAMT3	BCD*10.6	Optional Amount 3
OAMT4	BCD*10.6	Optional Amount 4
OTEXT1	String*2	Optional Text 1
OTEXT2	String*4	Optional Text 2
OTEXT3	String*6	Optional Text 3
OTEXT4	String*15	Optional Text 4
OTEXT5	String*30	Optional Text 5
OTEXT6	String*75	Optional Text 6
CUSTWAR1	Integer	Days in Warranty Period 1
CUSTWAR2	Integer	Days in Warranty Period 2
CUSTWAR3	Integer	Days in Warranty Period 3
SUPPWAR1	Integer	Days in Contract Period 1
SUPPWAR2	Integer	Days in Contract Period 2
SUPPWAR3	Integer	Days in Contract Period 3
CWDESC1	String*75	Warranty Period 1
CWDESC2	String*75	Warranty Period 2
CWDESC3	String*75	Warranty Period 3
SWDESC1	String*75	Contract Period 1
SWDESC2	String*75	Contract Period 2
SWDESC3	String*75	Contract Period 3
ONWAR	Boolean	On Warranty when Sold
ONCTT	Boolean	On Contract when Received
ONREG	Boolean	On Warranty when Reg Received
AUTOREC	Boolean	Auto Receive Serial Nums in PO?
STARTSER	String*40	Starting Serial Number
AUTOSHIP	Boolean	Auto Ship Serial Nums in OE?
EXPIRYDATE	Integer	Number of days to expire or 999

This page was generated on 2006-Sep-07