User talk:Indianwikimahesh

Select * From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.ProductClient000010 SC(nolock) On S.SubmitID = SC.SubmitID Where BatchID = 6992355

Select * From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000010 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000010 P on S.SubmitID = P.SubmitID WHERE BatchID = 6992355

Select * From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitPOSClient000417 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductPOSClient000417 P(nolock) on S.SubmitID = P.SubmitID WHERE BatchID = 6958404

Select Description From GFS.dbo.OfferError Where OfferID = 53132

Select BatchID, BatchKey, OfferID, ImportDate, ProcessID, Exception, CreatedBy From GFS.dbo.Batch Where OfferID IN (53653, 53485, 52246) and BatchType = 3

USE GFSOffer Go SP_HELP Submission

Select * From GFS.dbo.Product Where (Description Like '%Alice%White%' Or Brand Like '%Alice%White%') And ClientID = 10 Order By UPC Desc

Select * From GFS.dbo.Offer Where Description Like '%bottle%' And OfferNum Like 'P%' Order By OfferID Desc

Update GFS.dbo.Product Set UPC = '898110010446' Where ProductID = 338206

SELECT *, S.PaidAmount, P.SKU, SP.QtyProd1, SP.QtyProd2, P.InvoiceNum, SP.QtyCombo1, PaidCombo1 FROM GFSOffer..Submission             S (NOLOCK) JOIN GFSOffer..SubmitPOSClient000417 SP (NOLOCK) ON S.SubmitID = SP.SubmitID     LEFT JOIN GFSOffer..ProductPOSClient000417 P (NOLOCK) ON S.SubmitID = P.SubmitID      --JOIN --GFSOffer..SubmissionError       SE (NOLOCK) ON S.SubmitID = SE.SubmitID     JOIN --GFS..OfferError                 OE (NOLOCK) ON SE.OfferID = OE.OfferID AND --                                               SE.ErrorID = OE.ErrorID WHERE S.OfferID = 50866 ORDER BY S.SubmitID

-- Sony Creative

Select PostmarkDate, Address1, PostalCode, FormType, RcptDate, RcptProd, Retailer, RcptDate, Receipt, prodUPCDE, prodUPCType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000241 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000241 p on S.SubmitID=p.SubmitID WHERE BatchID = 6640497

-- Trendware

Select PostmarkDate, Address1, PostalCode, RcptDate, RcptProd, Retailer, Receipt, UPC, UPCType, SerialNum, SerialType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000245 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000245 p on S.SubmitID=p.SubmitID WHERE BatchID = 6582618

-- Tst Kmart Select PostmarkDate, Address1, PostalCode, ProgramNum, OrderForm, ReceiptType, RcptQty, StoreNumDE, StoreNumVF, RcptDate, UPCDE, UPCType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000368 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000368 p on S.SubmitID=p.SubmitID WHERE BatchID = 6565120

-- Tst Rlt Brown Forman Select PostmarkDate, Address1, PostalCode, Receipt, RcptProd1, RcptProd2, RcptQty,FormType, Birthdate, Gender, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000440 SC(nolock) On S.SubmitID = SC.SubmitID WHERE BatchID = 6609472

-- Tst Rlt RadioShack Select PostmarkDate, Address1, PostalCode, RcptDate, StoreNum, Retailer,RcptProd,FormType, RcptType, UPC, UPCType, DebitCardPaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000401 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000401 p on S.SubmitID=p.SubmitID WHERE BatchID = 6592221

-- Tst Rlt Office Depot Select PostmarkDate, Address1, PostalCode, ReceiptSP, FormStyleSP, StoreNumSP,TransDateSP,ShipDateSP, RegNumSP, TransNumSP, InvoiceNumSP, SubInvoiceNumSP, RetailerSP,ReceiptSP, UPCDE, UPCType, PaidAmount, FormType, ReceiptBarcodeSP, RegNum, TransNum, Retailer, Receipt, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitPOSClient000417 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductPOSClient000417 p on S.SubmitID=p.SubmitID WHERE BatchID = 6614166

- Diageo Select PostmarkDate, FirstName, LastName, Address1, PostalCode, Birthdate, FormType, RcptProd1, RcptProd2,TotalProdPrice, RcptQty, RcptType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000332 SC(nolock) On S.SubmitID = SC.SubmitID WHERE BatchID = 6614069

- Const

Select PostmarkDate, FirstName, LastName, Address1, PostalCode, Birthdate, FormType,, RcptProd, RcptProd2, RcptQty, UPC, UPCType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000010 SC(nolock) On S.SubmitID = SC.SubmitID Join GFSOffer.dbo.ProductClient000010 P (NOLOCK) ON Sc.Submitid = P.Submitid WHERE BatchID = 6516205

--- Samsung---

Select PostmarkDate, FirstName, LastName, Address1, PostalCode, Business, RcptProd, RcptDate, Retailer, Receipt, UPC, UPCType, SerialNum, SerialType, PaidAmount From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000191 SC(nolock) On S.SubmitID = SC.SubmitID Join GFSOffer.dbo.ProductClient000191 P (NOLOCK) ON Sc.Submitid = P.Submitid WHERE BatchID = 6495049

My Qry1 - ODCDA
select a.OfferID,b.CrossOfferFieldName from OfferClient as a, OfferDictionary as b where a.ClientID=417 and a.OfferID=b.OfferID and b.FieldName='ReceiptBarcodeSP' and b.CrossOfferFieldName='OfficeDepotReceiptBarcode'

Select (ROW_NUMBER OVER (ORDER BY FirstName)) as RowNumber, FirstName, LastName, Address1, PostalCode, RcptDate, StoreNum, OrderNumber, Retailer, RcptProd, FormType, RcptType, WirelessPhone,UPC, UPCType, Valid, PaidQuantity From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitClient000401 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductClient000401 p on S.SubmitID=p.SubmitID Where offerid = 51711 select db_name

select * from Offer where OfferNum='OD1202374'

--- batch process status ---

SELECT b.ProcessID,o.Description, b.BatchID, b.BatchKey, o.OfferID, b.Processed, b.ImportDate, b.Exception, b.Priority, b.void, b.InProcess, b.ByPassQA, b.EstCount, b.BatchType, b.BypassHolds, b.createdby FROM Batch b(NOLOCK) JOIN Offer o(NOLOCK) ON b.OfferID = o.OfferID WHERE b.BatchID IN (7065162) ORDER BY b.Priority DESC, b.ProcessID, b.void, b.ImportDate, o.OfferID -- sp_help Submission

---

Select (ROW_NUMBER OVER (ORDER BY FirstName)) as RowNumber, * From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitPOSClient000417 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductPOSClient000417 p on S.SubmitID=p.SubmitID WHERE offerid=53868

-ODCDA-

Select (ROW_NUMBER OVER (ORDER BY FirstName)) as RowNumber, FirstName,LastName,Address1,City,State,Country,PostalCode,Retailer1,PostmarkDate,Valid,InvoiceNumConfSP,InvoiceNumSP,ReceiptBarcodeSP,RegNumSP,RetailerSP,StoreNumSP,SubInvoiceNumConfSP,SubInvoiceNumSP,TransNumSP,TransDateSP,ShipDateSP,RegNumConfSP,StoreNumConfSP,TransNumConfSP,TransDateConfSP,ReceiptBarcode	,StoreNum,TransDate,RegNum,TransNum,InvoiceNum,InvoiceNumConf,SubInvoiceNum,SubInvoiceNumConf,Retailer,Receipt,InStorePurchase,SKU	UPC,ProdError,ProdPaid,PaidQty,RcptInfo,UPCDE	,UPCConf From GFSOffer.dbo.Submission S(nolock) Join GFSOffer.dbo.SubmitPOSClient000417 SC(nolock) On S.SubmitID = SC.SubmitID join GFSOffer.dbo.ProductPOSClient000417 p on S.SubmitID=p.SubmitID WHERE offerid=54229

Postal codes Canada
T0A 0A0, Alberta, AB V0K 2K0, 70 Mile House, BC R0K 0A0, Alexander, MB E4Y 1R3, Acadie Siding, NB A0N 1A0, Aguathuna, NL B0M 1A0, Advocate Harbour, NS X0E 0A0, Aklavik, NT X0A 0A0, Arctic Bay, NU L7J 0A1, Acton, ON C0B 1A0, Albany, PE J0E 1A0, Abbotsford, QC S0N 0A0, Abbey, SK Y0B 1A0, Beaver Creek, YT

Postal Codes US
United States:

AK:

99501 ANCHORAGE 99502 ANCHORAGE 99503 ANCHORAGE 99504 ANCHORAGE 99505 FORT RICHARDSON 99506 ELMENDORF AFB 99507 ANCHORAGE 99508 ANCHORAGE 99509 ANCHORAGE 99510 ANCHORAGE 99511 ANCHORAGE

AL:

35004 MOODY 35005 ADAMSVILLE 35006 ADGER 35007 ALABASTER 35010 ALEXANDER CITY 35011 ALEXANDER CITY 35013 ALLGOOD 35014 ALPINE 35015 ALTON 35016 ARAB 35019 BAILEYTON 35020 BESSEMER 35021 BESSEMER 35022 BESSEMER

AR:

71601 PINE BLUFF 71602 WHITE HALL 71603 PINE BLUFF 71611 PINE BLUFF 71612 WHITE HALL 71613 PINE BLUFF 71630 ARKANSAS CITY 71631 BANKS 71635 CROSSETT 71638 DERMOTT 71639 DUMAS

AZ:

85001 PHOENIX 85002 PHOENIX 85003 PHOENIX 85004 PHOENIX 85005 PHOENIX 85006 PHOENIX 85007 PHOENIX 85008 PHOENIX 85009 PHOENIX 85010 PHOENIX

CA:

90001 LOS ANGELES 90002 LOS ANGELES 90003 LOS ANGELES 90004 LOS ANGELES 90005 LOS ANGELES 90006 LOS ANGELES 90007 LOS ANGELES 90008 LOS ANGELES 90009 LOS ANGELES 90010 LOS ANGELES 90011 LOS ANGELES

CO:

80001 ARVADA 80002 ARVADA 80003 ARVADA 80004 ARVADA 80005 ARVADA 80006 ARVADA 80007 ARVADA 80010 AURORA 80011 AURORA 80012 AURORA

CT:

06001 AVON 06002 BLOOMFIELD 06006 WINDSOR 06010 BRISTOL 06011 BRISTOL 06013 BURLINGTON 06016 BROAD BROOK 06018 CANAAN 06019 CANTON 06020 CANTON CENTER

DC:

20001 WASHINGTON 20002 WASHINGTON 20003 WASHINGTON 20004 WASHINGTON 20005 WASHINGTON 20006 WASHINGTON 20007 WASHINGTON 20008 WASHINGTON 20009 WASHINGTON 20010 WASHINGTON

DE:

19701 BEAR 19702 NEWARK 19703 CLAYMONT 19934 CAMDEN-WYOMING 19893 CHASE MANHATTAN BANK N A 19936  CHESWOLD 19702 CHRISTIANA 19721 CITIBANK 19892 CITIBANK

FL:

32003 ORANGE PARK 32004 PONTE VEDRA BEACH 32006 FLEMING ISLAND 32007 BOSTWICK 32716 ALTAMONTE SPRINGS 32421 ALTHA 32702 ALTOONA 33820 ALTURAS 33920 ALVA

GA:

30003 NORCROSS 30004 ALPHARETTA 30005 ALPHARETTA 30006 MARIETTA 30102 ACWORTH 30103 ADAIRSVILLE 31620 ADEL 30320 AIRPORT MAIL CENTER 30415 AKIN

HI:

96707 KAPOLEI 96708 HAIKU 96709 KAPOLEI 96710 HAKALAU 96712 HALEIWA 96713 HANA 96714 HANALEI 96715 HANAMAULU 96716 HANAPEPE 96717 HAUULA 96718 HAWAII NATIONAL PARK

IA:

50006 ALDEN 50007 ALLEMAN 50008 ALLERTON 50009 ALTOONA 50510 ALBERT CITY 52531 ALBIA 50005 ALBION 52202 ALBURNETT 50006 ALDEN 50420 ALEXANDER

ID:

83210 ABERDEEN 83211 AMERICAN FALLS 83212 ARBON 83213 ARCO 83214 ARIMO 83610 ALPINE 83211 AM FALLS 83211 AMERICAN FALLS 83211 AMERICAN FLS

IL:

60001 ALDEN 60002 ANTIOCH 60004 ARLINGTON HEIGHTS 60013 CARY 60014 CRYSTAL LAKE 60015 DEERFIELD 62601 ALEXANDER 61412 ALEXIS 60102 ALGONQUIN

IN:

46018 ANDERSON 46030 ARCADIA 46031 ATLANTA 46032 CARMEL 47283 ALERT 46001 ALEXANDRIA 47567 ALFORD 47553 ALFORDSVILLE

KS:

66002 ATCHISON 66006 BALDWIN CITY 66007 BASEHOR 66008 BENDENA 66010 BLUE MOUND 66012 BONNER SPRINGS 67511 ALBERT 67512 ALDEN 67513 ALEXANDER

KY:

40003 BAGDAD 40004 BARDSTOWN 40006 BEDFORD 40007 BETHLEHEM 40008 BLOOMFIELD 41201 ADAMS 42120 ADOLPHUS 41514 AFLEX 40801 AGES 40801 AGES BROOKSDE 41773 ALLOCK 42020 ALMO 42020 ALMO HEIGHTS

LA:

70011 METAIRIE 70030 DES ALLEMANDS 70031 AMA 70032 ARABI 70033 METAIRIE 70036 BARATARIA 71409 ALFALFA 70114 ALGIERS 70360 ALLEMAND 71469 ALLEN 71417 ALOHA

MA:

01004 AMHERST 01005 BARRE 01007 BELCHERTOWN 01008 BLANDFORD 01009 BONDSVILLE 01010 BRIMFIELD 01011 CHESTER 01012 CHESTERFIELD 01013 CHICOPEE 02134 ALLSTON 01913 AMESBURY

MD:

20606 ABELL 20607 ACCOKEEK 20608 AQUASCO 20609 AVENUE 20610 BARSTOW 20611 BEL ALTON 20612 BENEDICT 20613 BRANDYWINE 20615 BROOMES ISLAND 20616 BRYANS ROAD 20617 BRYANTOWN 20618 BUSHWOOD 20619 CALIFORNIA 20620 CALLAWAY 20621 CHAPTICO 20622 CHARLOTTE HALL 20623 CHELTENHAM

ME:

03901 BERWICK 03902 CAPE NEDDICK 03903 ELIOT 03904 KITTERY 03905 KITTERY POINT 03906 NORTH BERWICK 03907 OGUNQUIT 03908 SOUTH BERWICK 03909 YORK 03910 YORK BEACH 03911 YORK HARBOR 04001 ACTON 04002 ALFRED 04003 BAILEY ISLAND 04004 BAR MILLS 04005 BIDDEFORD

MI:

48001 ALGONAC 48002 ALLENTON 48003 ALMONT 48004 ANCHORVILLE 48005 ARMADA 48006 AVOCA 48007 TROY 48009 BIRMINGHAM 48015 CENTER LINE 48017 CLAWSON 48021 EASTPOINTE 48022 EMMETT 48023 FAIR HAVEN 48025 FRANKLIN 48026 FRASER 48027 GOODELLS

MN:

55001 AFTON 55002 ALMELUND 55003 BAYPORT 55005 BETHEL 55006 BRAHAM 55007 BROOK PARK 55008 CAMBRIDGE 55009 CANNON FALLS 55010 CASTLE ROCK 55011 CEDAR 55012 CENTER CITY 56433 AKELEY 55703 ALANGO 56667 ALASKA 56307 ALBANY

MO:

63012 BARNHART 63013 BEAUFORT 63014 BERGER 63015 CATAWISSA 63016 CEDAR HILL 63017 CHESTERFIELD 63019 CRYSTAL CITY 63020 DE SOTO 63021 BALLWIN 65466 ALLEY SPRINGS 64001 ALMA 64620 ALTAMONT 63732 ALTENBURG 65606 ALTON 64421 AMAZONIA

MS:

38603 ASHLAND 38606 BATESVILLE 38609 BELEN 38610 BLUE MOUNTAIN 38611 BYHALIA 38614 CLARKSDALE 38617 COAHOMA 38618 COLDWATER 38619 COMO 38620 COURTLAND 38621 CRENSHAW 38622 CROWDER 38623 DARLING 38625 DUMAS 38626 DUNDEE 38627 ETTA 38628 FALCON 38629 FALKNER

MT:

59004 ASHLAND 59006 BALLANTINE 59007 BEARCREEK 59008 BELFRY 59010 BIGHORN 59011 BIG TIMBER 59012 BIRNEY 59013 BOYD 59014 BRIDGER 59015 BROADVIEW 59016 BUSBY 59018 CLYDE PARK 59019 COLUMBUS 59020 COOKE CITY 59022 CROW AGENCY 59024 CUSTER

NC:

27022 LAWSONVILLE 27023 LEWISVILLE 27024 LOWGAP 27025 MADISON 27027 MAYODAN 27028 MOCKSVILLE 27030 MOUNT AIRY 27031 WHITE PLAINS 27040 PFAFFTOWN 27041 PILOT MOUNTAIN 27042 PINE HALL 27043 PINNACLE 27045 RURAL HALL 27046 SANDY RIDGE 27047 SILOAM 27048 STONEVILLE 27049 TOAST 27050 TOBACCOVILLE 27051 WALKERTOWN

ND:

58008 BARNEY 58009 BLANCHARD 58011 BUFFALO 58012 CASSELTON 58013 CAYUGA 58015 CHRISTINE 58016 CLIFFORD 58017 COGSWELL 58018 COLFAX 58021 DAVENPORT 58027 ENDERLIN 58029 ERIE 58030 FAIRMOUNT 58031 FINGAL 58032 FORMAN 58033 FORT RANSOM 58035 GALESBURG

NE:

68016 CEDAR CREEK 68017 CERESCO 68018 COLON 68019 CRAIG 68020 DECATUR 68022 ELKHORN 68023 FORT CALHOUN 68025 FREMONT 68026 FREMONT 68028 GRETNA 68029 HERMAN 68030 HOMER 68031 HOOPER 68033 ITHACA 68034 KENNARD 68036 LINWOOD 68037 LOUISVILLE

NH:

03036 CHESTER 03037 DEERFIELD 03038 DERRY 03040 EAST CANDIA 03041 EAST DERRY 03042 EPPING 03043 FRANCESTOWN 03810 ALTON BAY 03031 AMHERST 03216 ANDOVER 03440 ANTRIM 03217 ASHLAND 03441 ASHUELOT 03811 ATKINSON

NJ:

07007 CALDWELL 07008 CARTERET 07009 CEDAR GROVE 07010 CLIFFSIDE PARK 08865 ALPHA 07620 ALPINE 07017 AMPERE 08037 ANCORA 07821 ANDOVER 08260 ANGLESEA 08801 ANNANDALE 07032 ARLINGTON 08802 ASBURY

NM:

87004 BERNALILLO 87005 BLUEWATER 87006 BOSQUE 87007 CASA BLANCA 87008 CEDAR CREST 87009 CEDARVALE 87010 CERRILLOS 87011 CLAUNCH 87012 COYOTE 87013 CUBA 87014 CUBERO 87015 EDGEWOOD 87016 ESTANCIA 87017 GALLINA 87018 COUNSELOR 87020 GRANTS 87021 MILAN 87022 ISLETA 87023 JARALES 87024 JEMEZ PUEBLO

NV:

89001 ALAMO 89002 HENDERSON 89003 BEATTY 89004 BLUE DIAMOND 89005 BOULDER CITY 89444 AURORA 89310 AUSTIN 89415 BABBITT 89311 BAKER 89820 BATTLE MOUNTAIN 89820 BATTLE MTN 89003 BEATTY 89821 BEOWAWE 89506 BLACK SPRINGS 89004 BLUE DIAMOND 89506 BORDERTOWN 89445 BOTTLE CREEK

NY:

00501 HOLTSVILLE 00544 HOLTSVILLE 06390 FISHERS ISLAND 10001  N NEW YORK 10002 NEW YORK 12808 ADIRONDACK 13730 AFTON 13730 AFTON LAKE 10901 AIRMONT 10952 AIRMONT 14241 AIRPORT MAIL FACILITY 14001 AKRON 13655 AKWESASNE 14013 ALABAMA 14592 YORK 11451 YORK COLLEGE 14173 YORKSHIRE 10598 YORKTOWN

OH:

43001 ALEXANDRIA 43002 AMLIN 43003 ASHLEY 43004 BLACKLICK 43005 BLADENSBURG 43006 BRINKHAVEN 43007 BROADWAY 43008 BUCKEYE LAKE 43009 CABLE 43010 CATAWBA 43011 CENTERBURG 43013 CROTON 43014 DANVILLE 43015 DELAWARE 43016 DUBLIN 43802 ADAMSVILLE 45631 ADDISON 45001 ADDYSTON 43101 ADELPHI 43901 ADENA 43316 ADRIAN

OK:

73001 ALBERT 73002 ALEX 73003 EDMOND 73004 AMBER 73005 ANADARKO 73006 APACHE 73007 ARCADIA 73008 BETHANY 73009 BINGER 73010 BLANCHARD 73011 BRADLEY 73013 EDMOND 73014 CALUMET 73015 CARNEGIE 73016 CASHION 74521 ALBION 74522 ALDERSON 73002 ALEX 73716 ALINE 74825 ALLEN 73521 ALTUS

OR:

97001 ANTELOPE 97002 AURORA 97004 BEAVERCREEK 97005 BEAVERTON 97013 CANBY 97014 CASCADE LOCKS 97015 CLACKAMAS 97016 CLATSKANIE 97017 COLTON 97018 COLUMBIA CITY 97019 CORBETT 97020 DONALD 97021 DUFUR 97022 EAGLE CREEK 97023 ESTACADA 97024 FAIRVIEW

PA:

15001 ALIQUIPPA 15003 AMBRIDGE 15004 ATLASBURG 15005 BADEN 15006 BAIRDFORD 15007 BAKERSTOWN 15009 BEAVER 15010 BEAVER FALLS 15012 BELLE VERNON 15014 BRACKENRIDGE 15015 BRADFORDWOODS 18010 ACKERMANVILLE 15610 ACME 15520 ACOSTA 15410 ADAH 15611 ADAMSBURG 17972 ADAMSDALE 19501 ADAMSTOWN 16110 ADAMSVILLE

RI:

02801 ADAMSVILLE 02802 ALBION 02804 ASHAWAY 02806 BARRINGTON 02807 BLOCK ISLAND 02808 BRADFORD 02809 BRISTOL 02812 CAROLINA 02813 CHARLESTOWN 02814 CHEPACHET 02815 CLAYVILLE 02816 COVENTRY 02817 WEST GREENWICH 02812 CAROLINA 02911 CENTERDALE 02863 CENTRAL FALLS 02911 CENTREDALE 02911 CENTREDALE FINANCE BRANCH

SC:

29001 ALCOLU 29002 BALLENTINE 29003 BAMBERG 29006 BATESBURG 29009 BETHUNE 29010 BISHOPVILLE 29014 BLACKSTOCK 29015 BLAIR 29016 BLYTHEWOOD 29018 BOWMAN 29626 ANDERSON 29510 ANDREWS 29020 ANTIOCH 29021 ANTIOCH 29320 ARCADIA 29206 ARCADIA LAKES 29010 ASHLAND 29929 ASHTON

SD:

57007 BROOKINGS 57010 BURBANK 57012 CANISTOTA 57013 CANTON 57014 CENTERVILLE 57015 CHANCELLOR 57016 CHESTER 57017 COLMAN 57018 COLTON 57020 CROOKS 57021 DAVIS 57022 DELL RAPIDS 57024 EGAN 57025 ELK POINT 57026 ELKTON 57314 ARTESIAN 57424 ASHTON 57213 ASTORIA 57644 ATHBOY 57424 ATHOL 57626 AUANCE 57197 AUGUSTANA COLLEGE 57002 AURORA

TN:

37015 ASHLAND CITY 37016 AUBURNTOWN 37018 BEECHGROVE 37019 BELFAST 37020 BELL BUCKLE 37022 BETHPAGE 37023 BIG ROCK 37024 BRENTWOOD 37025 BON AQUA 37026 BRADYVILLE 37027 BRENTWOOD 37028 BUMPUS MILLS 37029 BURNS 37030 CARTHAGE 37031 CASTALIAN SPRINGS 37032 CEDAR HILL 37033 CENTERVILLE 37034 CHAPEL HILL 37035 CHAPMANSBORO 37237 AMSOUTH BANK 37705 ANDERSONVILLE 37011 ANTIOCH

TX:

75017 IRVING 75019 COPPELL 75020 DENISON 75021 DENISON 75022 FLOWER MOUND 75023 PLANO 76049 ACTON 78550 ADAMS GARDENS 77079 ADDICKS 77084 ADDICKS BARKER 76008 ALEDO 75973 ALEXANDERS STORE 78332 ALFRED 76597 ALFRED P HUGHES UNIT 76877 ALGERITA 78332 ALICE

UT:

84001 ALTAMONT 84002 ALTONAH 84003 AMERICAN FORK 84004 ALPINE 84005 EAGLE MOUNTAIN 84006 BINGHAM CANYON 84007 BLUEBELL 84008 BONANZA 84010 BOUNTIFUL 84021 ARCADIA 84532 ARCHES 84015 ARSENAL 84620 AURORA 84754 AUSTIN 84328 AVON 84621 AXTELL 84066 BALLARD 84071 BAUER

VA:

20105 ALDIE 20106 AMISSVILLE 20107 ARCOLA 20108 MANASSAS 23250 AIR MAIL FACILITY 20186 AIRLIE 23003 AKK 23004 AKUNIA 23821 ALBERTA 20105 ALDIE 22301 ALEXANDRIA 23002 AMELIA CH 23002  AMELIA COURT HOUSE 23002 AMELIA CT HSE 24521 AMHERST 20106 AMISSVILLE

VT:

05035 BRIDGEWATER CORNERS 05036 BROOKFIELD 05037 BROWNSVILLE 05038 CHELSEA 05039 CORINTH 05040 EAST CORINTH 05041 EAST RANDOLPH 05042 EAST RYEGATE 05043 EAST THETFORD 05045 FAIRLEE 05046 GROTON 05047 HARTFORD 05875 BARTON 05143 BARTONSVILLE 05491 BASIN HARBOR 05459 BEAULIEUS CORNER 05823 BEEBE PLAIN 05902 BEECHER FALLS

WA:

98001 AUBURN 98002 AUBURN 98003 FEDERAL WAY 98004 BELLEVUE 98015 BELLEVUE 98019 DUVALL 98020 EDMONDS 98021 BOTHELL 98022 ENUMCLAW 98023 FEDERAL WAY 98024 FALL CITY 98025 HOBART 98026 EDMONDS 98027 ISSAQUAH 98028 KENMORE 98029 ISSAQUAH 98068 ALPENTAL 98570 ALPHA 98526 AMANDA PARK 98170 AMAZON.COM 99004 AMBER 98601 AMBOY 98498 AMERICAN LAKE 98052 AMES LAKE 98221 ANACORTES

WI:

53001 ADELL 53002 ALLENTON 53003 ASHIPPUN 53004 BELGIUM 53005 BROOKFIELD 53006 BROWNSVILLE 53007 BUTLER 53008 BROOKFIELD 53010 CAMPBELLSPORT 53011 CASCADE 53012 CEDARBURG 53013 CEDAR GROVE 54805 ALMENA 54909 ALMOND 54489 ALTDORF 54720 ALTOONA 54542 ALVIN 54102 AMBERG 53777 AMERICAN FAMILY INS CO

WV:

24701 BLUEFIELD 24712 ATHENS 24714 BEESON 24715 BRAMWELL 24716 BUD 24719 COVEL 24724 FREEMAN 24726 HERNDON 24729 HIAWATHA 24731 KEGLEY 24732 KELLYSVILLE 24733 LASHMEET 24736 MATOAKA 24737 MONTCALM 24738 NEMOURS 24739 OAKVALE 25060 AMEAGLE 25160 AMELIA 25607 AMHERSTDALE 25811 AMIGO 25005 AMMA 24808 ANAWALT

WY:

82010 CHEYENNE 82050 ALBIN 82051 BOSLER 82052 BUFORD 82053 BURNS 82054 CARPENTER 82055 CENTENNIAL 82058 GARRETT 82059 GRANITE CANON 82060 HILLSDALE 82061 HORSE CREEK 82063 JELM 82070 LARAMIE 82322 BAIROIL 82832 BANNER 82601 BAR NUNN 82609 BAR NUNN 82410 BASIN 82930 BEAR RIVER 83112 BEDFORD 82712 BEULAH 82833 BIG HORN 83113 BIG PINEY