[EDI-L Mailing List Archive Home] [Message List] [Reply To This Message]

RE: Mexico - State Codes

RE: [EDI-L] Mexico - State Codes

Actually, in the 4060 manual, N407 (elmt 1715: Country Subdivision Code,
size 1/3) would be a good place to put the Mexican subdivision code (CHH,
etc.). (Comment 02: "N402 is required only if city name (N401) is in the
U.S. or Canada.") So, for Mexico, you would put the country code for Mexico
in N404 and the province code in N407. That way you don't have to mess with
the qualifier stuff.

Best regards,
Bill Chessman
Inovis(tm), Inc.
(though the standard version you choose is strictly up to you, not me, nor
my employer)

-----Original Message-----
From: William J. Kammerer [mailto: Sent: Tuesday, July 01, 2003 1:32 PM
To: Subject: Re: [EDI-L] Mexico - State Codes


Addresses in countries other than Canada and the U.S. must use the
Location Qualifier and identifier in N405 and N406, specifying an ISO
3166-2 Country Subdivision Code (e.g., CHH for Chihuahua). The
country and sub-division codes are available on the UN/LOCODE page at
http://www.unece.org/cefact/locode/service/main.htm.

William J. Kammerer
Novannet, LLC.
Columbus, US-OH 43221-3859
+1 (614) 487-0320
+1 (614) 638-4384 (c)
+1 928-396-6310 (FAX)

----- Original Message -----
From: "Bill Chessman" < To: < Sent: Tuesday, July 01, 2003 4:20 PM
Subject: RE: [EDI-L] Mexico - State Codes



Oops. That first sentence was incomplete. It should have read,

According to X12 4060, the 156 element uses a code source of 22 which,
it turns out is the ISO 3166-2 codes, but as you say, the Mexican
provinces are shown to be 3-character alpha codes...and they won't fit.

Just a little cleanup. 8-(


Bill Chessman
Inovis(tm), Inc.
(though typographical errors within are my own and do not necessarily
reflect the typing skills of my employers)

-----Original Message-----
From: Bill Chessman
Sent: Tuesday, July 01, 2003 1:03 PM
To: Subject: RE: [EDI-L] Mexico - State Codes


Gunnar,


According to X12 4060, the 156 element uses a code source of 22 which,
it turns out is the ISO 3166-2 codes, but as you say, the Mexican
provinces. According to the code source reference information, there is
a Non-Normative Note that suggests that you might want to contact the
Servicio Postal Mexicano (Mexican Postal Service) for information on the
Mexican area codes...perhaps they use 2-character codes like the US and
Canadian postal systems do.

Hope that helps.

Best regards,
Bill Chessman
Inovis(tm), Inc.

-----Original Message-----
From: ghillert [mailto: Sent: Tuesday, July 01, 2003 11:51 AM
To: Subject: [EDI-L] Mexico - State Codes


Hi,

I have a quick question. How are you dealing with Mexican state codes
in ANSI X12?

The official ISO 3166-2 standard has 3 characters but ANSI X12 allows
2 characters only (N4:156, State or Province Code).

I've found a two letter system for Mexico as well but I could not
find the standard which that system is based on.

How is it commonly handled in ANSI X12?

With best regards,

Gunnar




To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Tue Jul 1, 2003 8:42 pm


Bill Chessman <bill.chessman@...>
bill.chessman@...


EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools Simplify EDI Data Integration with Stylus Studio XML Enterprise Suite - Free Download!
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.