td>

1018

302

KAR

3

15.00

3

1018

110

PRC

1

236.00

4

1018

5

SMT

4

100.00

5

1018

304

HRO

1

280.00

1

1019

111

SHM

3

1499.97

1

1020

204

KAR

2

90.00

2

1020

301

KAR

4

348.00

1

1021

201

NKL

2

75.00

2

1021

201

ANZ

3

225.00

3

1021

202

KAR

3

690.00

4

1021

205

ANZ

2

624.00

1

1022

309

HRO

1

40.00

2

1022

303

PRC

2

96.00

3

1022

6

ANZ

2

96.00

1

1023

103

PRC

2

40.00

2

1023

104

PRC

2

116.00

3

1023

105

SHM

1

80.00

4

1023

110

SHM

1

228.00

5

1023

304

ANZ

1

170.00

6

1023

306

SHM

1

190.00

call_type Table

call_code code_descr

B

billing error

D

damaged goods

I

incorrect merchandise sent

L

late shipment

O

other

orders Table

(1 of 2)

order_num order_date customer_num ship_instruct backlog po_num ship_date ship_weight ship_charge paid_date

1001

05/20/1994

104

express

n

B77836

06/01/1994

20.40

10.00

07/22/1994

1002

05/21/1994

101

PO on box; deliver back door only

n

9270

05/26/1994

50.60

15.30

06/03/1994

1003

05/22/1994

104

express

n

B77890

05/23/1994

35.60

10.80

06/14/1994

1004

05/22/1994

106

ring bell twice

y

8006

05/30/1994

95.80

19.20

1005

05/24/1994

116

call before delivery

n

2865

06/09/1994

80.80

16.20

06/21/1994

1006

05/30/1994

112

after 10AM

y

Q13557

70.80

14.20

1007

05/31/1994

117

n

278693

06/05/1994

125.90

25.20

1008

06/07/1994

110

closed Monday

y

LZ230

07/06/1994

45.60

13.80

07/21/1994

1009

06/14/1994

111

door next to
grocery

n

4745

06/21/1994

20.40

10.00

08/21/1994

1010

06/17/1994

115

deliver 776 King St. if no answer

n

429Q

06/29/1994

40.60

12.30

08/22/1994

1011

06/18/1994

104

express

n

B77897

07/03/1994

10.40

5.00

08/29/1994

1012

06/18/1994

117

n

278701

06/29/1994

70.80

14.20

1013

06/22/1994

104

express

n

B77930

07/10/1994

60.80

12.20

07/31/1994

1014

06/25/1994

106

ring bell, kick door loudly

n

8052

07/03/1994

40.60

12.30

07/10/1994

1015

06/27/1994

110

closed Mondays

n

MA003

07/16/1994

20.60

6.30

08/31/1994

1016

06/29/1994

119

delivery entrance off Camp St.

n

PC6782

07/12/1994

35.00

11.80

1017

07/09/1994

120

North side of clubhouse

n

DM354331

07/13/1994

60.00

18.00

1018

07/10/1994

121

SW corner of Biltmore Mall

n

S22942

07/13/1994

70.50

20.00

08/06/1994

1019

07/11/1994

122

closed til noon Mondays

n

Z55709

07/16/1994

90.00

23.00

08/06/1994

1020

07/11/1994

123

express

n

W2286

07/16/1994

14.00

8.50

09/20/1994

1021

07/23/1994

124

ask for Elaine

n

C3288

07/25/1994

40.00

12.00

08/22/1994

1022

07/24/1994

126

express

n

W9925

07/30/1994

15.00

13.00

09/02/1994

1023

07/24/1994

127

no deliveries after 3 p.m.

n

KF2961

07/30/1994

60.00

18.00

08/22/1994

stock Table

(1 of 4)

stock_num manu_code description unit_price unit unit_descr

1

HRO

baseball gloves

250.00

case

10 gloves/case

1

HSK

baseball gloves

800.00

case

10 gloves/case

1

SMT

baseball gloves

450.00

case

10 gloves/case

2

HRO

baseball

126.00

case

24/case

3

HSK

baseball bat

240.00

case

12/case

3

SHM

baseball bat

280.00

case

12/case

4

HSK

football

960.00

case

24/case

4

HRO

football

480.00

case

24/case

5

NRG

tennis racquet

28.00

each

each

5

SMT

tennis racquet

25.00

each

each

5

ANZ

tennis racquet

19.80

each

each

6

SMT

tennis ball

36.00

case

24 cans/case

6

ANZ

tennis ball

48.00

case

24 cans/case

7

HRO

basketball

600.00

case

24/case

8

ANZ

volleyball

840.00

case

24/case

9

ANZ

volleyball net

20.00

each

each

101

PRC

bicycle tires

88.00

box

4/box

101

SHM

bicycle tires

68.00

box

4/box

102

SHM

bicycle brakes

220.00

case

4 sets/case

102

PRC

bicycle brakes

480.00

case

4 sets/case

103

PRC

front derailleur

20.00

each

each

104

PRC

rear derailleur

58.00

each

each

105

PRC

bicycle wheels

53.00

pair

pair

105

SHM

bicycle wheels

80.00

pair

pair

106

PRC

bicycle stem

23.00

each

each

107

PRC

bicycle saddle

70.00

pair

pair

108

SHM

crankset

45.00

each

each

109

PRC

pedal binding

30.00

case

6 pairs/case

109

SHM

pedal binding

200.00

case

4 pairs/case

110

PRC

helmet

236.00

case

4/case

110

ANZ

helmet

244.00

case

4/case

110

SHM

helmet

228.00

case

4/case

110

HRO

helmet

260.00

case

4/case

110

HSK

helmet

308.00

case

4/case

111

SHM

10-spd, assmbld

499.99

each

each

112

SHM

12-spd, assmbld

549.00

each

each

113

SHM

18-spd, assmbld

685.90

each

each

114

PRC

bicycle gloves

120.00

case

10 pairs/case

201

NKL

golf shoes

37.50

each

each

201

ANZ

golf shoes

75.00

each

each

201

KAR

golf shoes

90.00

each

each

202

NKL

metal woods

174.00

case

2 sets/case

202

KAR

std woods

230.00

case

2 sets/case

203

NKL

irons/wedges

670.00

case

2 sets/case

204

KAR

putter

45.00

each

each

205

NKL

3 golf balls

312.00

case

24/case

205

ANZ

3 golf balls

312.00

case

24/case

205

HRO

3 golf balls

312.00

case

24/case

301

NKL

running shoes

97.00

each

each

301

HRO

running shoes

42.50

each

each

301

SHM

running shoes

102.00

each

each

301

PRC

running shoes

75.00

each

each

301

KAR

running shoes

87.00

each

each

301

ANZ

running shoes

95.00

each

each

302

HRO

ice pack

4.50

each

each

302

KAR

ice pack

5.00

each

each

303

PRC

socks

48.00

box

24 pairs/box

303

KAR

socks

36.00

box

24 pair/box

304

ANZ

watch

170.00

box

10/box

304

HRO

watch

280.00

box

10/box

305

HRO

first-aid kit

48.00

case

4/case

306

PRC

tandem adapter

160.00

each

each

306

SHM

tandem adapter

190.00

each

each

307

PRC

infant jogger

250.00

each

each

308

PRC

twin jogger

280.00

each

each

309

HRO

ear drops

40.00

case

20/case

309

SHM

ear drops

40.00

case

20/case

310

SHM

kick board

80.00

case

10/case

310

ANZ

kick board

89.00

case

12/case

311

SHM

water gloves

48.00

box

4 pairs/box

312

SHM

racer goggles

96.00

box

12/box

312

HRO

racer goggles

72.00

box

12/box

313

SHM

swim cap

72.00

box

12/box

313

ANZ

swim cap

60.00

box

12/box

catalog Table

(1 of 11)

catalog_num stock_num manu_code cat_descr cat_picture cat_advert

10001

1

HRO

Brown leather. Specify first baseman's or infield/outfield style. Specify right- or left-handed.

<BYTE value>

Your First Season's Baseball Glove

10002

1

HSK

Babe Ruth signature glove. Black leather. Infield/outfield style. Specify right- or left-handed.

<BYTE value>

All-Leather, Hand-Stitched, Deep-Pockets, Sturdy Webbing that Won't Let Go

10003

1

SMT

Catcher's mitt. Brown leather. Specify right- or left-handed.

<BYTE value>

A Sturdy Catcher's Mitt With the Perfect Pocket

10004

2

HRO

Jackie Robinson signature glove. Highest Professional quality, used by National League.

<BYTE value>

Highest Quality Ball Available, from the Hand-Stitching to the Robinson Signature

10005

3

HSK

Pro-style wood. Available in sizes: 31, 32, 33, 34, 35.

<BYTE value>

High-Technology Design Expands the Sweet Spot

10006

3

SHM

Aluminum. Blue with black tape. 31", 20 oz or 22 oz; 32", 21 oz or 23 oz; 33", 22 oz or 24 oz.

<BYTE value>

Durable Aluminum for High School and Collegiate Athletes

10007

4

HSK

Norm Van Brocklin signature style.

<BYTE value>

Quality Pigskin with Norm Van Brocklin Signature

10008

4

HRO

NFL-Style pigskin.

<BYTE value>

Highest Quality Football for High School and Collegiate Competitions

10009

5

NRG

Graphite frame. Synthetic strings.

<BYTE value>

Wide Body Amplifies Your Natural Abilities by Providing More Power Through Aerodynamic Design

10010

5

SMT

Aluminum frame. Synthetic strings.

<BYTE value>

Mid-Sized Racquet For the Improving Player

10011

5

ANZ

Wood frame, cat-gut strings.

<BYTE value>

Antique Replica of Classic Wooden Racquet Built with
Cat-Gut Strings

10012

6

SMT

Soft yellow color for easy visibility in sunlight or artificial light.

<BYTE value>

High-Visibility Tennis, Day or Night

10013

6

ANZ

Pro-core. Available in neon yellow, green, and pink.

<BYTE value>

Durable Construction Coupled with the Brightest Colors Available

10014

7

HRO

Indoor. Classic NBA style. Brown leather.

<BYTE value>

Long-Life Basketballs for Indoor Gymnasiums

10015

8

ANZ

Indoor. Finest leather. Professional quality.

<BYTE value>

Professional Volleyballs for Indoor Competitions

10016

9

ANZ

Steel eyelets. Nylon cording. Double-stitched. Sanctioned by the National Athletic Congress.

<BYTE value>

Sanctioned Volleyball Netting for Indoor Professional and Collegiate Competition

10017

101

PRC

Reinforced, hand-finished tubular. Polyurethane belted. Effective against punctures. Mixed tread for super wear and road grip.

<BYTE value>

Ultimate in Puncture Protection, Tires Designed for In-City Riding

10018

101

SHM

Durable nylon casing with butyl tube for superior air retention. Center-ribbed tread with herringbone side. Coated sidewalls resist abrasion.

<BYTE value>

The Perfect Tire for Club Rides or Training

10019

102

SHM

Thrust bearing and coated pivot washer/ spring sleeve for smooth
action. Slotted levers with soft gum hoods. Two-tone paint treatment. Set includes calipers, levers, and cables.

<BYTE value>

Thrust-Bearing and Spring-Sleeve Brake Set Guarantees Smooth Action

10020

102

PRC

Computer-aided design with low-profile pads. Cold-forged alloy calipers and beefy caliper bushing. Aero levers. Set includes calipers, levers, and cables.

<BYTE value>

Computer Design Delivers Rigid Yet Vibration-Free Brakes

10021

103

PRC

Compact leading-action design enhances shifting. Deep cage for
super-small granny gears. Extra strong construction to resist off-road abuse.

<BYTE value>

Climb Any Mountain: ProCycle's Front Derailleur Adds Finesse to Your ATB

10022

104

PRC

Floating trapezoid geometry with
extra thick parallelogram arms.
100-tooth capacity. Optimum alignment with any freewheel.

<BYTE value>

Computer-Aided Design Engineers 100-Tooth Capacity Into
ProCycle's Rear Derailleur

10023

105

PRC

Front wheels laced with 15g spokes in a 3-cross pattern. Rear wheels laced with 14g spikes in a 3-cross pattern.

<BYTE value>

Durable Training Wheels That Hold True Under Toughest Conditions

10024

105

SHM

Polished alloy. Sealed-bearing, quick-release hubs. Double-butted. Front wheels are laced 15g/2-cross. Rear wheels are laced 15g/3-cross.

<BYTE value>

Extra Lightweight Wheels for Training or High-Performance Touring

10025

106

PRC

Hard anodized alloy with pearl finish. 6mm hex bolt hardware. Available in lengths of 90-140mm in 10mm increments.

<BYTE value>

ProCycle Stem with Pearl Finish

10026

107

PRC

Available in three styles: Men's racing; Men's touring; and Women's. Anatomical gel construction with
lycra cover. Black or black/hot pink.

<BYTE value>

The Ultimate In Riding Comfort, Lightweight With Anatomical Support

10027

108

SHM

Double or triple crankset with choice of chainrings. For double crankset, chainrings from 38-54 teeth. For triple crankset, chainrings from 24-48 teeth.

<BYTE value>

Customize Your Mountain Bike With Extra-Durable Crankset

10028

109

PRC

Steel toe clips with nylon strap. Extra wide at buckle to reduce pressure.

<BYTE value>

Classic Toeclip Improved To Prevent Soreness At Clip Buckle

10029

109

SHM

Ingenious new design combines
button on sole of shoe with slot on a pedal plate to give riders new options in riding efficiency. Choose full or partial locking. Four plates mean both top and bottom of pedals are slotted-no fishing around when you want to engage full power. Fast unlocking ensures safety when maneuverability is paramount.

<BYTE value>

Ingenious Pedal/Clip Design Delivers Maximum Power And Fast Unlocking

10030

110

PRC

Super-lightweight. Meets both ANSI and Snell standards for impact protection. 7.5 oz. Quick-release shadow buckle.

<BYTE value>

Feather-Light, Quick-Release, Maximum Protection Helmet

10031

110

ANZ

No buckle so no plastic touches your chin. Meets both ANSI and Snell standards for impact protection. 7.5 oz. Lycra cover.

<BYTE value>

Minimum Chin Contact, Feather-Light, Maximum Protection Helmet

10032

110

SHM

Dense outer layer combines with softer inner layer to eliminate the mesh cover, no snagging on brush. Meets both ANSI and Snell standards for impact protection. 8.0 oz.

<BYTE value>

Mountain Bike Helmet: Smooth Cover Eliminates the Worry of Brush Snags But Delivers
Maximum Protection

10033

110

HRO

Newest ultralight helmet uses plastic shell. Largest ventilation channels of any helmet on the market. 8.5 oz.

<BYTE value>

Lightweight Plastic with Vents Assures Cool Comfort Without Sacrificing Protection

10034

110

HSK

Aerodynamic (teardrop) helmet
covered with anti-drag fabric. Credited with shaving 2 seconds/mile from winner's time in Tour de France time-trial. 7.5 oz.

<BYTE value>

Teardrop Design Used by Yellow Jerseys, You Can Time the Difference

10035

111

SHM

Light-action shifting 10 speed. Designed for the city commuter with shock-absorbing front fork and drilled eyelets for carry-all racks or bicycle trailers. Internal wiring for generator lights. 33 lbs.

<BYTE value>

Fully Equipped Bicycle Designed for the Serious Commuter Who Mixes Business With Pleasure

10036

112

SHM

Created for the beginner enthusiast. Ideal for club rides and light touring. Sophisticated triple-butted frame construction. Precise index shifting. 28 lbs.

<BYTE value>

We Selected the Ideal Combination of Touring Bike Equipment, Then Turned It Into This Package Deal: High-Performance on the Roads, Maximum Pleasure Everywhere

10037

113

SHM

Ultra-lightweight. Racing frame geometry built for aerodynamic handlebars. Cantilever brakes. Index shifting. High-performance gearing. Quick-release hubs. Disk wheels. Bladed spokes.

<BYTE value>

Designed for the Serious Competitor, The Complete Racing Machine

10038

114

PRC

Padded leather palm and stretch mesh merged with terry back; Available in tan, black, and cream. Sizes S, M, L, XL.

<BYTE value>

Riding Gloves For Comfort and Protection

10039

201

NKL

Designed for comfort and stability. Available in white & blue or white & brown. Specify size.

<BYTE value>

Full-Comfort, Long-Wearing Golf Shoes for Men and Women

10040

201

ANZ

Guaranteed waterproof. Full leather upper. Available in white, bone, brown, green, and blue. Specify size.

<BYTE value>

Waterproof Protection Ensures Maximum Comfort and Durability In All Climates

10041

201

KAR

Leather and leather mesh for maximum ventilation. Waterproof lining to keep feet dry. Available in white & gray or white & ivory. Specify size.

<BYTE value>

Karsten's Top Quality Shoe Combines Leather and Leather Mesh

10042

202

NKL

Complete starter set utilizes gold shafts. Balanced for power.

<BYTE value>

Starter Set of Woods, Ideal for High School and Collegiate Classes

10043

202

KAR

Full set of woods designed for precision control and power performance.

<BYTE value>

High-Quality Woods Appropriate for High School Competitions or Serious Amateurs

10044

203

NKL

Set of eight irons includes 3 through 9 irons and pitching wedge. Originally priced at $489.00.

<BYTE value>

Set of Irons Available From Factory at Tremendous Savings: Discontinued Line

10045

204

KAR

Ideally balanced for optimum control. Nylon-covered shaft.

<BYTE value>

High-Quality Beginning Set of Irons Appropriate for High School Competitions

10046

205

NKL

Fluorescent yellow.

<BYTE value>

Long Drive Golf Balls: Fluorescent Yellow

10047

205

ANZ

White only.

<BYTE value>

Long Drive Golf Balls: White

10048

205

HRO

Combination fluorescent yellow and standard white.

<BYTE value>

HiFlier Golf Balls: Case Includes Fluorescent Yellow and Standard White

10049

301

NKL

Super shock-absorbing gel pads disperse vertical energy into a horizontal plane for extraordinary cushioned comfort. Great motion control. Men's only. Specify size.

<BYTE value>

Maximum Protection For High-Mileage Runners

10050

301

HRO

Engineered for serious training with exceptional stability. Fabulous shock absorption. Great durability. Specify men's/women's, size.

<BYTE value>

Pronators and Supinators Take Heart: A Serious Training Shoe For Runners Who Need Motion Control

10051

301

SHM

For runners who log heavy miles and need a durable, supportive, stable platform. Mesh/synthetic upper gives excellent moisture dissipation. Stability system uses rear antipronation platform and forefoot control plate for extended protection during high-intensity training. Specify men's/women's size.

<BYTE value>

The Training Shoe Engineered for Marathoners and Ultra-Distance Runners

10052

301

PRC

Supportive, stable racing flat. Plenty of forefoot cushioning with added motion control. Women's only.
D widths available. Specify size.

<BYTE value>

A Woman's Racing Flat That Combines Extra Forefoot Protection With a Slender Heel

10053

301

KAR

Anatomical last holds your foot firmly in place. Feather-weight
cushioning delivers the responsiveness of a racing flat. Specify men's/women's size.

<BYTE value>

Durable Training Flat That Can Carry You Through Marathon Miles

10054

301

ANZ

Cantilever sole provides shock absorption and energy rebound. Positive traction shoe with ample toe box. Ideal for runners who need a wide shoe. Available in men's and women's. Specify size.

<BYTE value>

Motion Control, Protection, and Extra Toebox Room

10055

302

KAR

Reusable ice pack with velcro strap. For general use. Velcro strap allows easy application to arms or legs.

<BYTE value>

Finally, An Ice Pack for Achilles Injuries and Shin Splints that You Can Take to the Office

10056

303

PRC

Neon nylon. Perfect for running or aerobics. Indicate color: Fluorescent pink, yellow, green, and orange.

<BYTE value>

Knock Their Socks Off With YOUR Socks

10057

303

KAR

100% nylon blend for optimal wicking and comfort. We've taken out the cotton to eliminate the risk of blisters and reduce the opportunity for infection. Specify men's or women's.

<BYTE value>

100% Nylon Blend Socks - No Cotton

10058

304

ANZ

Provides time, date, dual display of lap/cumulative splits, 4-lap memory, 10 hr count-down timer, event timer, alarm, hour chime, waterproof to 50m, velcro band.

<BYTE value>

Athletic Watch w/4-Lap Memory

10059

304

HRO

Split timer, waterproof to 50m. Indicate color: Hot pink, mint green, space black.

<BYTE value>

Waterproof Triathlete Watch In Competition Colors

10060

305

HRO

Contains ace bandage, anti-bacterial cream, alcohol cleansing pads, adhesive bandages of assorted sizes, and instant-cold pack.

<BYTE value>

Comprehensive First-Aid Kit Essential for Team Practices, Team Traveling

10061

306

PRC

Converts a standard tandem bike into an adult/child bike. User-tested assembly instructions

<BYTE value>

Enjoy Bicycling With Your Child On a Tandem; Make Your Family Outing Safer

10062

306

SHM

Converts a standard tandem bike into an adult/child bike. Lightweight model.

<BYTE value>

Consider a Touring Vacation For the Entire Family: A Lightweight, Touring Tandem for Parent and Child

10063

307

PRC

Allows mom or dad to take the baby out too. Fits children up to 21 pounds. Navy blue with black trim.

<BYTE value>

Infant Jogger Keeps A Running Family Together

10064

308

PRC

Allows mom or dad to take both children! Rated for children up to 18 pounds.

<BYTE value>

As Your Family Grows, Infant Jogger Grows With You

10065

309

HRO

Prevents swimmer's ear.

<BYTE value>

Swimmers Can Prevent Ear Infection All Season Long

10066

309

SHM

Extra-gentle formula. Can be used every day for prevention or treatment of swimmer's ear.

<BYTE value>

Swimmer's Ear Drops Specially Formulated for Children

10067

310

SHM

Blue heavy-duty foam board with Shimara or team logo.

<BYTE value>

Exceptionally Durable, Compact Kickboard for Team Practice

10068

310

ANZ

White. Standard size.

<BYTE value>

High-Quality Kickboard

10069

311

SHM

Swim gloves. Webbing between fingers promotes strengthening of arms. Cannot be used in competition.

<BYTE value>

Hot Training Tool - Webbed Swim Gloves Build Arm Strength and Endurance

10070

312

SHM

Hydrodynamic egg-shaped lens. Ground-in anti-fog elements; Available in blue or smoke.

<BYTE value>

Anti-Fog Swimmer's Goggles: Quantity Discount

10071

312

HRO

Durable competition-style goggles. Available in blue, grey, or white.

<BYTE value>

Swim Goggles: Traditional Rounded Lens For Greater Comfort

10072

313

SHM

Silicone swim cap. One size. Available in white, silver, or navy. Team Logo Imprinting Available.

<BYTE value>

Team Logo Silicone Swim Cap

10073

314

ANZ

Silicone swim cap. Squared-off top. One size. White

<BYTE value>

Durable Squared-off Silicone Swim Cap

10074

315

HRO

Re-usable ice pack. Store in the freezer for instant first-aid. Extra capacity to accommodate water and ice.

<BYTE value>

Water Compartment Combines With Ice to Provide Optimal Orthopedic Treatment

cust_calls Table

(1 of 2)

customer_num call_dtime user_id call_code call_descr res_dtime res_descr

106

1994-06-12 8:20

maryj

D

Order was received, but two of the cans of ANZ tennis balls within the case were empty.

1994-06-12 8:25

Authorized credit for two cans to customer, issued apology. Called ANZ buyer to report the QA problem.

110

1994-07-07 10:24

richc

L

Order placed one month ago (6/7) not received.

1994-07-07 10:30

Checked with shipping (Ed Smith). Order sent yesterday- we were waiting for goods from ANZ. Next time will call with delay if necessary.

119

1994-07-01 15:00

richc

B

Bill does not reflect credit from previous order.

1994-07-02 8:21

Spoke with Jane Akant in Finance. She found the error and is sending new bill to customer.

121

1994-07-10 14:05

maryj

O

Customer likes our merchandise. Requests that we stock more types of infant joggers. Will call back to place order.

1994-07-10 14:06

Sent note to marketing group of interest in infant joggers.

127

1994-07-31 14:30

maryj

I

Received Hero watches (item # 304) instead of ANZ watches.

Sent memo to shipping to send ANZ item 304 to customer and pickup HRO watches. Should be done tomorrow, 8/1.

116

1993-11-28 13:34

mannyn

I

Received plain white swim caps (313 ANZ) instead of navy with team logo (313 SHM).

1993-11-28 16:47

Shipping found correct case in warehouse and express mailed it in time for swim meet.

116

1993-12-21 11:24

mannyn

I

Second complaint from this customer! Received two cases right-handed outfielder gloves

(1 HRO) instead of one case lefties.

1993-12-27 08:19

Memo to shipping (Ava Brown) to send case of left-handed gloves, pick up wrong case; memo to billing requesting 5% discount to placate customer due to second offense and lateness of resolution because of holiday.

manufact Table

manu_code manu_name lead_time

ANZ

Anza

5

HSK

Husky

5

HRO

Hero

4

NRG

Norge

7

SMT

Smith

3

SHM

Shimara

30

KAR

Karsten

21

NKL

Nikolus

8

PRC

ProCycle

9

state Table

(1 of 2)

code sname code sname

AK

Alaska

MT

Montana

AL

Alabama

NE

Nebraska

AR

Arkansas

NC

North Carolina

AZ

Arizona

ND

North Dakota

CA

California

NH

New Hampshire

CT

Connecticut

NJ

New Jersey

CO

Colorado

NM

New Mexico

DC

D.C.

NV

Nevada

DE

Delaware

NY

New York

FL

Florida

OH

Ohio

GA

Georgia

OK

Oklahoma

HI

Hawaii

OR

Oregon

IA

Iowa

PA

Pennsylvania

ID

Idaho

PR

Puerto Rico

IL

Illinois

RI

Rhode Island

IN

Indiana

SC

South Carolina

KY

Kentucky

TN

Tennessee

LA

Louisiana

TX

Texas

MA

Massachusetts

UT

Utah

MD

Maryland

VA

Virginia

ME

Maine

VT

Vermont

MI

Michigan

WA

Washington

MN

Minnesota

WI

Wisconsin

MO

Missouri

WV

West Virginia

MS

Mississippi

WY

Wyoming



Informix Guide to SQL: Reference, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.