Add Errno_ Definition field

ON ERROR com_Mesg=MESSAGE() SET SAFETY OFF ALTER TABLE ALIAS() ADD COLUMN errno_desc C(30) Replace all errno_desc with "State Not Found" FOR "1.1" $ LEFT(errno_,3) Replace all errno_desc with "City not found " FOR "2.1" $ LEFT(errno_,3) Replace all errno_desc with "Street not found " FOR "3.1" $ LEFT(errno_,3) Replace all errno_desc with "Address not found" FOR "4.1" $ LEFT(errno_,3) Replace all errno_desc with "Incomputable +4 range" FOR "5.1" $ LEFT(errno_,3) Replace all errno_desc with "+4 unavailable" FOR "5.2" $ LEFT(errno_,3) Replace all errno_desc with "Multiple streets match" FOR "6.1" $ LEFT(errno_,3) Replace all errno_desc with "Multiple addresses match" FOR "6.2" $ LEFT(errno_,3) Replace all errno_desc with "Time ran out" FOR "7.1" $ LEFT(errno_,3) Replace all errno_desc with "Output too long" FOR "7.2" $ LEFT(errno_,3) Replace all errno_desc with "Company phonetic match used" FOR "8.1" $ LEFT(errno_,3) Replace all errno_desc with "First company match used" FOR "8.2" $ LEFT(errno_,3) Replace all errno_desc with "State determined from city" FOR "9.1" $ LEFT(errno_,3) Replace all errno_desc with "State determined from ZIP" FOR "9.2" $ LEFT(errno_,3) Replace all errno_desc with "City phonetic match used" FOR "10.1" $ LEFT(errno_,4) Replace all errno_desc with "City determined from ZIP" FOR "10.2" $ LEFT(errno_,4) Replace all errno_desc with "Acceptable city name used" FOR "10.3" $ LEFT(errno_,4) Replace all errno_desc with "Address component Chg/Del/Add" FOR "11.1" $ LEFT(errno_,4) Replace all errno_desc with "Street phonetic match used" FOR "11.1" $ LEFT(errno_,4) Replace all errno_desc with "Pre-direction dropped" FOR "11.2" $ LEFT(errno_,4) Replace all errno_desc with "Pre-direction added" FOR "11.3" $ LEFT(errno_,4) Replace all errno_desc with "Suffix dropped" FOR "11.4" $ LEFT(errno_,4) Replace all errno_desc with "Suffix added" FOR "11.5" $ LEFT(errno_,4) Replace all errno_desc with "Post direction dropped" FOR "11.6" $ LEFT(errno_,4) Replace all errno_desc with "Post direction added" FOR "11.7" $ LEFT(errno_,4) Replace all errno_desc with "Pre-direction standardized" FOR "11.8" $ LEFT(errno_,4) Replace all errno_desc with "Street standardized" FOR "11.9" $ LEFT(errno_,4) Replace all errno_desc with "Suffix standardized" FOR "11.10" $ LEFT(errno_,5) Replace all errno_desc with "Post direction standardized" FOR "11.11" $ LEFT(errno_,5) Replace all errno_desc with "Street missing" FOR "11.12" $ LEFT(errno_,5) Replace all errno_desc with "Alternate address used" FOR "11.13" $ LEFT(errno_,5) Replace all errno_desc with "Address Standardized" FOR "11.14" $ LEFT(errno_,5) Replace all errno_desc with "Dual address-Used PO Box" FOR "11.15" $ LEFT(errno_,5) Replace all errno_desc with "Dual address-Used Non-PO Box" FOR "11.16" $ LEFT(errno_,5) Replace all errno_desc with "Street Alias match-Better delivery address exists" FOR "11.17" $ LEFT(errno_,5) Replace all errno_desc with "Unit standardized" FOR "12.1" $ LEFT(errno_,4) Replace all errno_desc with "Unit missing" FOR "12.2" $ LEFT(errno_,4) Replace all errno_desc with "Unit not found" FOR "12.3" $ LEFT(errno_,4) Replace all errno_desc with "Unit unverified" FOR "12.4" $ LEFT(errno_,4) Replace all errno_desc with "Rural box not found" FOR "12.5" $ LEFT(errno_,4) Replace all errno_desc with "Leftovers found" FOR "13.1" $ LEFT(errno_,4) Replace all errno_desc with "No ZIP Code Available" FOR "14.1" $ LEFT(errno_,4) Replace all errno_desc with "Incorrect ZIP Code was changed to correct ZIP" FOR "14.2" $ LEFT(errno_,4) Replace all errno_desc with "+4 changed" FOR "14.3" $ LEFT(errno_,4) Replace all errno_desc with "Route changed" FOR "14.4" $ LEFT(errno_,4) Replace all errno_desc with "+4 added" FOR "14.5" $ LEFT(errno_,4) Replace all errno_desc with "Route added" FOR "14.6" $ LEFT(errno_,4) Replace all errno_desc with "ZIP assigned for Multi-matched address" FOR "14.7" $ LEFT(errno_,4) Replace all errno_desc with "Unique ZIP match" FOR "14.8" $ LEFT(errno_,4) Replace all errno_desc with "Small town default match" FOR "14.9" $ LEFT(errno_,4) Replace all errno_desc with "ZIP Code Changed" FOR "15.0" $ LEFT(errno_,4) Replace all errno_desc with "Highrise Default" FOR "15.1" $ LEFT(errno_,4) Replace all errno_desc with "Highrise Exact" FOR "15.2" $ LEFT(errno_,4) Replace all errno_desc with "Rural Route Default" FOR "15.3" $ LEFT(errno_,4) Replace all errno_desc with "Rural Route Exact" FOR "15.4" $ LEFT(errno_,4) Replace all errno_desc with "Early Warning System match." FOR "15.5" $ LEFT(errno_,4) Replace all errno_desc with "LACSLink Conversion Match" FOR "15.6" $ LEFT(errno_,4) Replace all errno_desc with "SuiteLink Match - Suite Returned" FOR "15.7" $ LEFT(errno_,4) Replace all errno_desc with "SuiteLink Match - No Suite Returned" FOR "15.8" $ LEFT(errno_,4) Replace all errno_desc with "Address used for coding" FOR "A1" $ LEFT(errno_,2) Replace all errno_desc with "Address not found in DPV Database" FOR "N N" $ LEFT(dpv_,3)

ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
ALTER TABLE ALIAS() ADD COLUMN errno_desc C(30)
Replace all errno_desc with "State Not Found" FOR "1.1" $ LEFT(errno_,3)
Replace all errno_desc with "City not found " FOR "2.1" $ LEFT(errno_,3)
Replace all errno_desc with "Street not found " FOR "3.1" $ LEFT(errno_,3)
Replace all errno_desc with "Address not found" FOR "4.1" $ LEFT(errno_,3)
Replace all errno_desc with "Incomputable +4 range" FOR "5.1" $ LEFT(errno_,3)
Replace all errno_desc with "+4 unavailable" FOR "5.2" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple streets match" FOR "6.1" $ LEFT(errno_,3)
Replace all errno_desc with "Multiple addresses match" FOR "6.2" $ LEFT(errno_,3)
Replace all errno_desc with "Time ran out" FOR "7.1" $ LEFT(errno_,3)
Replace all errno_desc with "Output too long" FOR "7.2" $ LEFT(errno_,3)
Replace all errno_desc with "Company phonetic match used" FOR "8.1" $ LEFT(errno_,3)
Replace all errno_desc with "First company match used" FOR "8.2" $ LEFT(errno_,3)
Replace all errno_desc with "State determined from city" FOR "9.1" $ LEFT(errno_,3)
Replace all errno_desc with "State determined from ZIP" FOR "9.2" $ LEFT(errno_,3)
Replace all errno_desc with "City phonetic match used" FOR "10.1" $ LEFT(errno_,4)
Replace all errno_desc with "City determined from ZIP" FOR "10.2" $ LEFT(errno_,4)
Replace all errno_desc with "Acceptable city name used" FOR "10.3" $ LEFT(errno_,4)
Replace all errno_desc with "Address component Chg/Del/Add" FOR "11.1" $ LEFT(errno_,4)
Replace all errno_desc with "Street phonetic match used" FOR "11.1" $ LEFT(errno_,4)
Replace all errno_desc with "Pre-direction dropped" FOR "11.2" $ LEFT(errno_,4)
Replace all errno_desc with "Pre-direction added" FOR "11.3" $ LEFT(errno_,4)
Replace all errno_desc with "Suffix dropped" FOR "11.4" $ LEFT(errno_,4)
Replace all errno_desc with "Suffix added" FOR "11.5" $ LEFT(errno_,4)
Replace all errno_desc with "Post direction dropped" FOR "11.6" $ LEFT(errno_,4)
Replace all errno_desc with "Post direction added" FOR "11.7" $ LEFT(errno_,4)
Replace all errno_desc with "Pre-direction standardized" FOR "11.8" $ LEFT(errno_,4)
Replace all errno_desc with "Street standardized" FOR "11.9" $ LEFT(errno_,4)
Replace all errno_desc with "Suffix standardized" FOR "11.10" $ LEFT(errno_,5)
Replace all errno_desc with "Post direction standardized" FOR "11.11" $ LEFT(errno_,5)
Replace all errno_desc with "Street missing" FOR "11.12" $ LEFT(errno_,5)
Replace all errno_desc with "Alternate address used" FOR "11.13" $ LEFT(errno_,5)
Replace all errno_desc with "Address Standardized" FOR "11.14" $ LEFT(errno_,5)
Replace all errno_desc with "Dual address-Used PO Box" FOR "11.15" $ LEFT(errno_,5)
Replace all errno_desc with "Dual address-Used Non-PO Box" FOR "11.16" $ LEFT(errno_,5)
Replace all errno_desc with "Street Alias match-Better delivery address exists" FOR "11.17" $ LEFT(errno_,5)
Replace all errno_desc with "Unit standardized" FOR "12.1" $ LEFT(errno_,4)
Replace all errno_desc with "Unit missing" FOR "12.2" $ LEFT(errno_,4)
Replace all errno_desc with "Unit not found" FOR "12.3" $ LEFT(errno_,4)
Replace all errno_desc with "Unit unverified" FOR "12.4" $ LEFT(errno_,4)
Replace all errno_desc with "Rural box not found" FOR "12.5" $ LEFT(errno_,4)
Replace all errno_desc with "Leftovers found" FOR "13.1" $ LEFT(errno_,4)
Replace all errno_desc with "No ZIP Code Available" FOR "14.1" $ LEFT(errno_,4)
Replace all errno_desc with "Incorrect ZIP Code was changed to correct ZIP" FOR "14.2" $ LEFT(errno_,4)
Replace all errno_desc with "+4 changed" FOR "14.3" $ LEFT(errno_,4)
Replace all errno_desc with "Route changed" FOR "14.4" $ LEFT(errno_,4)
Replace all errno_desc with "+4 added" FOR "14.5" $ LEFT(errno_,4)
Replace all errno_desc with "Route added" FOR "14.6" $ LEFT(errno_,4)
Replace all errno_desc with "ZIP assigned for Multi-matched address" FOR "14.7" $ LEFT(errno_,4)
Replace all errno_desc with "Unique ZIP match" FOR "14.8" $ LEFT(errno_,4)
Replace all errno_desc with "Small town default match" FOR "14.9" $ LEFT(errno_,4)
Replace all errno_desc with "ZIP Code Changed" FOR "15.0" $ LEFT(errno_,4)
Replace all errno_desc with "Highrise Default" FOR "15.1" $ LEFT(errno_,4)
Replace all errno_desc with "Highrise Exact" FOR "15.2" $ LEFT(errno_,4)
Replace all errno_desc with "Rural Route Default" FOR "15.3" $ LEFT(errno_,4)
Replace all errno_desc with "Rural Route Exact" FOR "15.4" $ LEFT(errno_,4)
Replace all errno_desc with "Early Warning System match." FOR "15.5" $ LEFT(errno_,4)
Replace all errno_desc with "LACSLink Conversion Match" FOR "15.6" $ LEFT(errno_,4)
Replace all errno_desc with "SuiteLink Match - Suite Returned" FOR "15.7" $ LEFT(errno_,4)
Replace all errno_desc with "SuiteLink Match - No Suite Returned" FOR "15.8" $ LEFT(errno_,4)
Replace all errno_desc with "Address used for coding" FOR "A1" $ LEFT(errno_,2)
Replace all errno_desc with "Address not found in DPV Database" FOR "N N" $ LEFT(dpv_,3)

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

We have been processing mail for about 10 or 12 years now after focusing on just printing since 1988. I must say that it has been a worthwhile addition to our business model. Our franchisor has always pitched the right vendors for their franchises and they sure knocked one out of the park with Accuzip. In those 10 or 12 years we have processed mail, not a lot, or high volume by all means, but a decent amount, we have come across some real doosies when it comes to list submission from our clients. Last year I received 3 lists from one of our better school districts that was formatted for an Avery label template in Excel, Word, and a PDF, that had to be merged together...a true mess for us, but then I called Geoff. He said he would try to make some sense of the situation. Well, he did just that. He merged those 3 disaster files, fixed the formatting issue, and saved them to a much more usable csv file. Now we were golden. Well, the same damn thing happened this year, and Geoff was there to save the day again. I had proposed to him sending us an invoice, or my issuing him a nice Starbucks Gift card, but he merely said that it was part of the superior customer service that Accuzip offers. I had mentioned this situation last year to Dave Belmonte while at our Minuteman Press convention and he had said that the Technical Support crew at Accuzip is extremely committed to their clients...as displayed by Geoff Cooke. In closing, I would like to say "Hats Off" to Geoff, Donna, and all of the technical support team at Accuzip. They are the greatest. Please accept my email as 5 Star +++++ review for Geoff and the support team at Accuzip.

S.P., Lafayette, CA