IV00104 - Item Kit Master

Defines kit components - which items make up each kit and their quantities.

SQL Query Builder

SELECT * FROM IV00104

Select all

Column	Description	Type	Length	Shared With
ITEMNMBR	Item Number	String	32	87 tables
SEQNUMBR	Sequence Number	Long Integer	4	86 tables
CMPTITNM	Component Item Number	String	32	1 tables
CMPITUOM	Component Item U Of M	String	10	-
CMPITQTY	Component Item QTY	Currency	10	-
CMPSERNM	Component Serial Numbered	Boolean	2	3 tables

Tables that share columns with IV00104. Click "Join" to add to your query.

ITEMNMBR

SEQNUMBR

CMPSERNM

CMPTITNM