Using QMF


Q.PARTS

This table provides information about parts. The columns are as follows:

SUPPNO
Number of the supplier

PARTNAME
Name of the part

PRODUCT
Product for which the part is needed

PRODNO
Number of the product

PROJNO
Number of the project

SUPPNO
PARTNAME
PRODUCT
PRODNO
PROJNO
------
--------
---------
------
------
1100P
PLASTIC
RELAY
30
1501
1100P
STEEL
WRENCHSET
509
1520
1200S
WIRE
GENERATOR
10
1401
1200S
BEARINGS
MOTOR
50
1402
1300S
COPPER
RELAY
30
1501
1300S
BLADES
SAW
205
1510
1400P
MAGNETS
GENERATOR
10
1409
1400P
VALVES
MOTOR
50
1407
1400P
OIL
GEAR
160
1405


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]