Table:
SALESREP
This table
contains information regarding sales representatives and sales rep groups.
- "First"
(Text): First name.
- "Last"
(Text): Last name.
- "HeadRep?"
(Yes/No): Is this person the head rep of the rep group?
- "Affiliation"
(Text): Name of sales rep company, if any.
- "Directional"
(Text): Suite or other address information.
- "Street"
(Text)
- "City"
(Text)
- "State"
(Text)
- "Zip"
(Text)
- "Phone"
(Text)
- "Free"
(Text): ‘800’ phone number.
- "Fax"
(Text)
- "Mobile"
(Text)
- "Pager"
(Text)
- "E-Mail"
(Text) internet mail address
- "WWW"
(Text) World Wide Web URL
The following 31
fields refer to product categories represented by the sales rep.
- "CATAppNLic"
(Yes/No) Apparel, Non-licensed including branded, performance, swimwear, cycling,
underwear, "sportswear" & "activewear."
- "CATAppLic"
(Yes/No) Apparel & Caps, Licensed, including anything with a team, league,
or otherwise licensed name on it that goes on your body.
- "CATAppUrb"
(Yes/No) Apparel, Urban, including apparel whose styling is inspired by hip-hop
culture and intended for an urban or urban-influenced customer.
- "CATAppFas"
(Yes/No) Apparel, Fashion, including sportswear or sports influenced apparel
designed for non-athletic wear.
- "CATSkiRugAp"
(Yes/No) Ski & Rugged Apparel, Outerwear, includes apparel for ski, hiking,
camping, climbing, from casual to technical, including jackets, hats.
- "CATOthLic"
(Yes/No) Other Licensed Products, including team collectibles.
- "CATAthFW"
(Yes/No) Athletic Footwear, including aerobics/ fitness, basketball, bowling,
golf, tennis/ court, running, x-training, walking, wrestling, volleyball,
cleated (baseball, softball,
football, lacrosse, field hockey, soccer, track & field) cycling, sport
casual, etc.
- "CATRugFW"
(Yes/No) Rugged/ Outdoor Footwear, including hiking, climbing, work boots,
sport sandals, boat shoes, moccasins & outdoor x-training/trail running,
etc.
- "CATTeamEq"
(Yes/No) Team Athletic Equipment, including all equipment for "ball sports,"
(foot, base, soft, basket, volley), soccer, lacrosse, field hockey track &
field.
- "CATBicycle"
(Yes/No) Bicycle Equipment & Accessories, including bikes, components.
- "CATBowlBilGame"
(Yes/No) Bowling, Billards & Games Equipment & Accessories.
- "CATCampHike"
(Yes/No) Camping, Climbing & Hiking Equipment & Accessories, including
tents, sleeping bags, backpacks, ropes, bug repellant, pitons & carabiners.
- "CATCheer"
(Yes/No) Cheerleading Apparel, Footwear, Equipment & Accessories.
- "CATExerTrain"
(Yes/No) Exercise/ Weight Training Equipment & Accessories, includes exercise
bikes, steppers, treadmills, racks, barbells, dumbells, lifting belts, steps,
slides, universals,
nautilus, boxing, gymnastics.
- "CATGolf"
(Yes/No) Golf Equipment & Accessories, including clubs, balls, bags.
- "CATFish"
(Yes/No) Fishing Equipment & Accessories, including rods, bait, tackle,
waders, etc.
- "CATHuntShoot"
(Yes/No) Hunting, Shooting & Archery Equipment & Accessories, including
guns, scopes, ammo, bows, arrows, targets, etc.
- "CATIceHock"
(Yes/No) Ice Hockey & Skating Equipment & Accessories, including skates,
components, sticks, pads, goals, pucks (also everything for street hockey
except the skates).
- "CATImpEmb"
(Yes/No) Imprinted or Embroidered Apparel, includes custom store-made apparel
only.
- "CATOthSpt"
(Yes/No) Other Sports & Games, including billiards tables, cues &
balls; bowling balls, pins, & lane equipment; darts & boards; bocce
balls, horseshoes, shuffleboard, curling,
frisbees, hula hoops, etc.
- "CATInLine"
(Yes/No) In-line Skating, Roller Skating & Skateboarding Equipment &
Accessories, including protective gear.
- "CATSki"
(Yes/No) Ski Equipment & Accessories (Alpine & Nordic), including
skis, boots, bindings, poles, goggles, snowshoes.
- "CATSnowboard"
(Yes/No) Snowboard Equipment & Accessories, including boards, boots, bindings.
- "CATSoccer"
(Yes/No) Soccer Equipment & Accessories including balls, cleats, protective
gear.
- "CATLacrosse"
(Yes/No) Lacrosse Equipment & Accessories including sticks, balls, cleats,
protective gear.
- "CATAcces"
(Yes/No) Sports Accessories, eyewear, hosiery, watches, videos, books, sport
bags, jewelry, trinkets, geegaws, etc.
- "CATMedTA"
(Yes/No) Sports Medicine & Training Aids, includes nutrition supplements,
vitamins, support garments, theraputic aids, etc.
- "CATTenRacq"
(Yes/No) Tennis/Racquet Sports Equipment & Accessories, including racquets,
balls & accessories for squash, racquetball, badminton, paddle/platform
tennis.
- "CATWater"
(Yes/No) Water Sports Equipment & Accessories, including swimming, scuba,
boating, surfing, sailboarding, kneeboards, boogieboards, kayak, water ski,
canoe, water safety/flotation
devices.
- "CATTrophy"
(Yes/No) Trophies & Awards.
- "CATTailgating"
(Yes/No) Tailgating Equipment & Accessories.
The following 53
fields refer to the territory covered by the rep.
- "INAL"
(Yes/No): Does business in all or any part of Alabama.
- "INAK"
(Yes/No): Does business in all or any part of Alaska.
- "INAZ"
(Yes/No): (continues as above)
- "INAR"
(Yes/No)
- "INCA"
(Yes/No)
- "INCO"
(Yes/No)
- "INCT"
(Yes/No)
- "INDE"
(Yes/No)
- "INDC"
(Yes/No): Does business in all or any part of District of Columbia.
- "INFL"
(Yes/No)
- "INGA"
(Yes/No)
- "INHI"
(Yes/No)
- "INID"
(Yes/No)
- "INIL"
(Yes/No)
- "ININ"
(Yes/No)
- "INIA"
(Yes/No)
- "INKS"
(Yes/No)
- "INKY"
(Yes/No)
- "INLA"
(Yes/No)
- "INME"
(Yes/No)
- "INMD"
(Yes/No)
- "INMA"
(Yes/No)
- "INMI"
(Yes/No)
- "INMN"
(Yes/No)
- "INMS"
(Yes/No)
- "INMO"
(Yes/No)
- "INMT"
(Yes/No)
- "INNE"
(Yes/No)
- "INNV"
(Yes/No)
- "INNH"
(Yes/No)
- "INNJ"
(Yes/No)
- "INNM"
(Yes/No)
- "INNY"
(Yes/No)
- "INNC"
(Yes/No)
- "INND"
(Yes/No)
- "INOH"
(Yes/No)
- "INOK"
(Yes/No)
- "INOR"
(Yes/No)
- "INPA"
(Yes/No)
- "INRI"
(Yes/No)
- "INSC"
(Yes/No)
- "INSD"
(Yes/No)
- "INTN"
(Yes/No)
- "INTX"
(Yes/No)
- "INUT"
(Yes/No)
- "INVT"
(Yes/No)
- "INVA"
(Yes/No)
- "INWA"
(Yes/No)
- "INWV"
(Yes/No)
- "INWI"
(Yes/No)
- "INWY"
(Yes/No)
- "AllStates"
(Yes/No): Does business nationally.
- "INPosNTr"
(Yes/No): Does business in any of the US possessions and territories (Puerto
Rico, etc.).
- "MilAccts"
(Yes/No): Military accounts.
- "Other"
(Text): Other accounts.