SGI Database Sales Rep Data Fields

 

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.
  


 

©2017 Sporting Goods Intelligence, Inc.