Class Ad Renewal Sample Import

AD ID (external key) Customer ID Customer Phone Customer Billing Name Customer Last Name Customer First Name Customer Account # Customer Address 1 Customer Address 2 Customer City Customer State Customer ZIP Customer Email Classified Category # Classified Category Name Ad Rate Code AE Territory ID Sales Rep Full Name Sales Rep Email Sales Rep First Name Sales Rep Last Name Sales Rep Title Sales Rep Phone Sales Rep FAX Edition ID Ad Start Date Ad Stop Date Total Ad Cost Payment Type Payment Amount Ad Text HTML Status Campaign Date
2512528 415138357 7722156167 Jackson Kennels Jackson Scott 5612156167 1960 17th Street SW Suite 113 Anytown State 12345 sjackson@somewhere.com 1484 DOGS NT 121 Cindy Jones cjones@dailynews.com Cindy Jones Classified Sales Representative 555-555-5555 555-221-4126 ABC 9/13/2002 9/17/2002 15.89 BL 0 PIT BULL PUPPIES, 3m-3f, 4wks $100.00 215-6167 1 10/5/2002
2512916 390070220 7723375353 Top Notch Realty Smith Mary 1503896 1764 SE Jones Blvd.   Anytown State 12345 msmith@somewhere.com 1638 SEASONAL RENTALS AC 63 Diane Gibson dgibson@dailynews.com Diane Gibson Classified Sales Representative 555-223-4739 555-978-2366 DEF 9/4/2002 9/17/2002 107.29 BL 0 The Grove 55+, 2/2. No pets. Non Smkr $1500/Month. Top Notch Realty, Inc. 555-337-5353 0 10/5/2002
2515629 415137912 7724658934 Sampson Used Cars Sampson Roger 5614658934 2603 Gray Twig Ln   Anytown State 12345 rsampson@somewhere.com 1950 DOMESTIC AUTOMOBILES WD 121 Cindy Jones cjones@dailynews.com Cindy Jones Classified Sales Representative 555-555-5555 555-221-4126 ABC 9/8/2002 9/17/2002 0 CC 0 FORD Crown Victoria LX, '93, tan, 56K mi., $5,500. 465-8934 1 10/5/2002
2515631 415138067 7724734162 Elite Imports Gregory Andy 5614734162 2705 Whipoorwill Ln   Anytown State 12345 agregory@somewhere.com 1955 IMPORT AUTOMOBILES WD 121 Cindy Jones cjones@dailynews.com Cindy Jones Classified Sales Representative 555-555-5555 555-221-4126 GHI 9/8/2002 9/17/2002 0 BL 0 VOLVO 850 Turbo Wagon '94, $7,500. 555-473-4162 0 10/5/2002
2516550 415138670 7724868741 Advantage Marine Peters Janet 5614868741 10 SE Taho Terrace   Anytown State 12345 jpeters@somewhere.com 1805 BOATS WD 125 Brenda Smith bsmith@dailynews.com Brenda Smith Classified Sales Representative 555-978-2218 555-978-2366 GHI 9/8/2002 9/17/2002 42.99 BL 0 20' QUEST '90 w/trlr. CC, hydrolic steering, saltwater washdown. $2600 OBO 486-8741 1 10/5/2002
2518113 155026173 7722200100 ACL Transportation Ford Becky 21073 4251 SE Commerce Ave.   Anytown State 12345 bford@somewhere.com 1224 DRIVERS/TRANSPORTATION EO 127 Julie Henderson jhenderson@dailynews.com Julie Henderson Classified Sales Representative 555-692-8964 555-221-4126 ABC 9/11/2002 9/17/2002 245.33 CC 0 DRIVER Class B CDL -Local deliveries,Mon-Sat. Male/female, DFWP/EOE. Apply in person: Earthwise Mulch, 4251 SE Commerce Ave, Anytown, State. 0 10/5/2002
2518216 12279 7722345665 Top Notch Realty Smith Bob 31956 1764 SE Port St. Peter Blvd.   Anytown State 12345 bsmith@somewhere.com 1656 CONDOS-BEACH AREA FOR SALE AE 128 Terry Gold tgold@dailynews.com Terry Gold Classified Sales Representative 555-978-2212 555-978-2366 ABC 9/11/2002 9/17/2002 130.03 CC 0 Park Shores Rare 3bd Townhouse Garage, Courtyard $259K (555) 234-5665 www.TopNotchRealEstate.com 1 10/5/2002
2518246 415139062 7725698359 Margie Reynolds Reynolds Margie 5615698359 5659 West 1st Square SW Suite 200 Anytown State 12345 mreynolds@somewhere.com 1436 HOUSEHOLD ITEMS NF 4 Dorothy Peters dpeters@dailynews.com Dorothy Peters Classified Sales Representative 555-692-8950 555-221-4126 GHI 9/12/2002 9/17/2002 12.89 BL 0 ARMOIRE -and Curio, Whitewash $500 for Both. 555-569-8359 0 10/5/2002
2518431 380041476 7725694087 Lake & Shore Realty Engels Roseann 32109 PO Box 650099   Anytown State 12345 rengels@somewhere.com 1672 HOMES FOR SALE AD 128 Terry Gold tgold@dailynews.com Terry Gold Classified Sales Representative 555-978-2212 555-978-2366 ABC 9/11/2002 9/17/2002 49.24 CC 0 Medina -New 3/2/2 in country club setting. 15ft high vaulted ceilings. $165K Realtor/Owner 555-633-4004 1 10/5/2002
2518437 380041476 7725694087 Lake & Shore Realty Barton Sam 32109 PO Box 650099   Anytown State 12345 sbarton@somewhere.com 1672 HOMES FOR SALE AD 128 Terry Gold tgold@dailynews.com Terry Gold Classified Sales Representative 555-978-2212 555-978-2366 DEF 9/11/2002 9/17/2002 58.39 CC 0 Hamilton -Oslo Park, 3/2 home. Large shade tree, new paint, carpet, tile, fenced yard. $78K Realtor/Owner 555-633-4004 0 10/5/2002
2518470 380041476 7725694087 Top Notch Realty Smith Mary 32109 1764 SE Port St. Jones Blvd.   Anytown State 12345 msmith@somewhere.com 1672 HOMES FOR SALE AD 128 Brenda Smith bsmith@dailynews.com Brenda Smith Classified Sales Representative 555-978-2212 555-978-2366 DEF 9/11/2002 9/17/2002 67.54 CC 0 Medina - NEW 3/2/1 CBS HOME ON YOUR LOT FOR $79,900 555-569-4087 1 10/5/2002
2518481 380041476 7725694087 Harris Financial Harris Cindy 32109 1845 N. Armor Blvd, Suite 200   Anytown State 12345 charris@somewhere.com 1110 INVESTMENT OPPORTUNITIES AD 128 Bob Johnson bjohnson@dailynews.com Bob Johnson Classified Sales Representative 555-978-2212 555-978-2366 DEF 9/11/2002 9/17/2002 308.55 CC 0 EARN HIGH RETURNS Local Realtor/Builder/ Investor seeks private lender or Joint venture partner who wants to make a nice return on your money. Serious inquiries only. 555-633-4004 1 10/5/2002
2518501 380041476 7725694087 Windham Real Estate Logan Bruce 32109 450 Realty Lane #321 Anytown State 12345 blogan@somewhere.com 1672 HOMES FOR SALE AD 128 Larry Seller lseller@dailynews.com Larry Seller Classified Sales Representative 555-978-2212 555-978-2366 ABC 9/11/2002 9/17/2002 134.85 CC 0 Dayton, FREE 24 HR PRE-RECORDED INFORMATION A BETTER WAY WWW.SELLAHOUSEFAST.COM 800-555-5555 EXT 500 0 10/5/2002