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.