Table 1: Partial contents from the NewProducts table

ProdName

ProdNumber

ProdCategory

ProdSize

ProdType

ML Road Frame-W - Yellow, 42

FR-R72Y-42

R72Y

42

Frame

ML Road Frame-W - Yellow, 44

FR-R72Y-44

R72Y

44

Frame

ML Road Frame-W - Yellow, 48

FR-R72Y-48

R72Y

48

Frame

ML Road Front Wheel

FW-R762

R762

 

Misc

ML Road Handlebars

HB-R720

R720

 

Misc

ML Road Pedal

PD-R563

R563

 

Misc

ML Road Rear Wheel

RW-R762

R762

 

Misc

ML Road Rim

RM-R600

R600

 

Misc

ML Road Seat Assembly

SA-R430

R430

 

Misc

ML Road Seat/Saddle

SE-R908

R908

 

Misc

ML Road Tire

TI-R628

R628

 

Misc

ML Touring Seat Assembly

SA-T612

T612

 

Misc

ML Touring Seat/Saddle

SE-T762

T762

 

Misc

Mountain Bike Socks, L

SO-B909-L

B909

L

Clothes

Mountain Bike Socks, M

SO-B909-M

B909

M

Clothes

Mountain Bottle Cage

BC-M005

M005

 

Misc

Mountain End Caps

EC-M092

M092

 

Misc

Mountain Pump

PU-M044

M044

 

Misc

Mountain Tire Tube

TT-M928

M928

 

Misc

Mountain-100 Black, 38

BK-M82B-38

M82B

38

Bike

Mountain-100 Black, 42

BK-M82B-42

M82B

42

Bike

Mountain-100 Black, 44

BK-M82B-44

M82B

44

Bike

Mountain-100 Black, 48

BK-M82B-48

M82B

48

Bike