MX (Mexico)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/MX
Jump to navigation Jump to search
Property Value
A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code MX
Language-specific name. Monolingual name México (es), 墨西哥 (zh), Mexico (en), Mexiko (de), Mexique (fr)
Language-specific short name. Monolingual short name Mexique (fr), Mexico (en), Mexiko (de), 墨西哥 (zh), México (es)
The offical langauge of a country. Official language es
Language used in a country, beside the administrative languages. other language es
Continent a country belongs to. Part of North America

Regions

Region (controlled vocabulary) A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code Language-specific name. Monolingual name
MX-AGU (Aguascalientes) MX-AGU Aguascalientes (de), Aguascalientes (en), Aguascalientes (es), Aguascalientes (fr), 阿瓜斯卡連特斯州 (zh)
MX-BCN (Baja California) MX-BCN Baja California (de), Baja California (en), Baja California (es), Basse-Californie (fr), 下加利福尼亞州 (zh)
MX-BCS (Baja California Sur) MX-BCS Baja California Sur (de), Baja California Sur (en), Baja California Sur (es), Basse-Californie du Sud (fr), 南下加利福尼亞州 (zh)
MX-CAM (Campeche) MX-CAM Campeche (de), Campeche (en), Campeche (es), Campeche (fr), 坎佩切州 (zh)
MX-CHH (Chihuahua) MX-CHH Chihuahua (de), Chihuahua (en), Chihuahua (es), Chihuahua (fr), 奇瓦瓦州 (zh)
MX-CHP (Chiapas) MX-CHP Chiapas (de), Chiapas (en), Chiapas (es), Chiapas (fr), 恰帕斯州 (zh)
MX-CMX (Mexico City) MX-CMX Ciudad de México (es), Mexico (fr), Mexico City (en), Mexiko-Stadt (de), 墨西哥城 (zh)
MX-COA (Coahuila) MX-COA Coahuila (de), Coahuila (en), Coahuila (fr), Coahuila de Zaragoza (es), 科阿韋拉州 (zh)
MX-COL (Colima) MX-COL Colima (de), Colima (en), Colima (es), Colima (fr), 科利馬州 (zh)
MX-DUR (Durango) MX-DUR Durango (de), Durango (en), Durango (es), Durango (fr), 杜蘭戈州 (zh)
MX-GRO (Guerrero) MX-GRO Guerrero (de), Guerrero (en), Guerrero (es), Guerrero (fr), 格雷羅州 (zh)
MX-GUA (Guanajuato) MX-GUA Guanajuato (de), Guanajuato (en), Guanajuato (es), Guanajuato (fr), 瓜納華托州 (zh)
MX-HID (Hidalgo) MX-HID Estado de Hidalgo (es), Hidalgo (de), Hidalgo (en), Hidalgo (fr), 伊達爾戈州 (zh)
MX-JAL (Jalisco) MX-JAL Jalisco (de), Jalisco (en), Jalisco (es), Jalisco (fr), 哈利斯科州 (zh)
MX-MEX (State of Mexico) MX-MEX Estado de México (es), México (de), State of Mexico (en), État de Mexico (fr), 墨西哥州 (zh)
MX-MIC (Michoacán) MX-MIC Michoacán (de), Michoacán (en), Michoacán (es), Michoacán (fr), 米却肯州 (zh)
MX-MOR (Morelos) MX-MOR Morelos (de), Morelos (en), Morelos (es), Morelos (fr), 莫雷洛斯州 (zh)
MX-NAY (Nayarit) MX-NAY Nayarit (de), Nayarit (en), Nayarit (es), Nayarit (fr), 納亞里特州 (zh)
MX-NLE (Nuevo León) MX-NLE Nuevo León (de), Nuevo León (en), Nuevo León (es), Nuevo León (fr), 新萊昂州 (zh)
MX-OAX (Oaxaca) MX-OAX Oaxaca (de), Oaxaca (en), Oaxaca (es), Oaxaca (fr), 瓦哈卡州 (zh)
MX-PUE (Puebla) MX-PUE Puebla (de), Puebla (en), Puebla (es), Puebla (fr), 普埃布拉州 (zh)
MX-QUE (Querétaro) MX-QUE Querétaro (de), Querétaro (en), Querétaro (es), Querétaro (fr), 克雷塔羅州 (zh)
MX-ROO (Quintana Roo) MX-ROO Quintana Roo (de), Quintana Roo (en), Quintana Roo (es), Quintana Roo (fr), 金塔納羅奧州 (zh)
MX-SIN (Sinaloa) MX-SIN Sinaloa (de), Sinaloa (en), Sinaloa (es), Sinaloa (fr), 锡那罗亚州 (zh)
MX-SLP (San Luis Potosí) MX-SLP San Luis Potosí (de), San Luis Potosí (en), San Luis Potosí (es), San Luis Potosí (fr), 圣路易斯波托西州 (zh)
MX-SON (Sonora) MX-SON Sonora (de), Sonora (en), Sonora (es), Sonora (fr), 索諾拉州 (zh)
MX-TAB (Tabasco) MX-TAB Tabasco (de), Tabasco (en), Tabasco (es), Tabasco (fr), 塔巴斯科州 (zh)
MX-TAM (Tamaulipas) MX-TAM Tamaulipas (de), Tamaulipas (en), Tamaulipas (es), Tamaulipas (fr), 塔毛利帕斯州 (zh)
MX-TLA (Tlaxcala) MX-TLA Tlaxcala (de), Tlaxcala (en), Tlaxcala (es), Tlaxcala (fr), 特拉斯卡拉州 (zh)
MX-VER (Veracruz) MX-VER Veracruz (de), Veracruz (en), Veracruz (es), Veracruz (fr), 韋拉克魯斯州 (zh)
MX-YUC (Yucatán) MX-YUC Yucatán (de), Yucatán (en), Yucatán (es), Yucatán (fr), 尤卡坦州 (zh)
MX-ZAC (Zacatecas) MX-ZAC Zacatecas (de), Zacatecas (en), Zacatecas (es), Zacatecas (fr), 薩卡特卡斯州 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
MX_2521Sociedad en Comandita Simple (es)S. en C. (es)
MX_4949Sociedad en Comandita por Acciones (es)S.C.p.A (es)
MX_5522Sociedad limitada unipersonal (es)S.L.U. (es)
MX_5787Anonymous Society (es)SA (es)
MX_5866Sociedad Anónima Promotora de Inversión (es)S.A.P.I. (es)
MX_6543Sociedad Civil (es)S.C. (es)
MX_6743Sociedad Anonima de Capital Variable (es)S.A. de C.V. (es)
MX_6756Sociedad de Responsabilidad Limitada (es)Cía. Ltda (es)
MX_8018Sociedades por acciones simplificada (es)S.A.S (es)
MX_8194Sociedad en Nombre Colectivo (es)y compañía (es)
MX_9161Sociedad Anónima Bursátil (es)S.A.B. (es)
MX_9287Sociedad Anónima (es)S.A. (es)
MX_9288Sociedad de Responsabilidad Limitada de Capital Variable (es)S. de R.L. de C.V. (es)
MX_9289Sociedad Anónima Promotora de Inversión de Capital Variable (es)S.A.P.I. de C.V. (es)
MX_9290Sociedad Anónima de Responsabilidad Limitada (es)S.A. de R.L. (es)
MX_9291Sociedad Anónima Bursátil de Capital Variable (es)S.A.B. de C.V. (es)
MX_9292Sociedad Civil de Responsabilidad Limitada (es)S.C. de R.L. (es)
MX_9293Sociedad en Nombre Colectivo de Sociedad Anónima de Capital Variable (es)S. en N.C. de S.A. de C.V. (es)
MX_9294Sociedad en Nombre Colectivo de Sociedad Anónima (es)S. en N.C. de S.A. (es)
MX_9295Sociedad en Nombre Colectivo de Responsabilidad Limitada (es)S. en N.C. de R.L. (es)
MX_9296Sociedad en Nombre Colectivo de de Capital Variable (es)S. en N.C. de C.V. (es)
MX_9297Sociedad en Nombre Colectivo de Responsabilidad Limitada de de Capital Variable (es)S. en N.C. de R.L. de C.V. (es)
MX_9298Sociedad de Producción Rural de Responsabilidad Limitada (es)S.P.R. de R.L. (es)
MX_9299Sociedad de Producción Rural (es)S.P.R. (es)
MX_9300Asociación Civil (es)A.C. (es)
MX_9301Institución de Asistencia Privada (es)I.A.P. (es)
MX_9302Sociedad cooperativa limitada (es)S.C.L. (es)
MX_9303Asociación religiosa (es)A.R. (es)

Identifiers

IdentifierNameRegistration authority
MX_CDQ_ID (Mexican Business Information System identifier)Sistema de Información Empresarial Mexicano (es)
Mexican Business Information System identifier (en)
CDQ
MX_CURP (Unique Population Registry Code)Clave Única de Registro de Población (es)
Unique Population Registry Code (en)
MX_RFC (Federal Taxpayer Registry Code)Registro Federal de Contribuyentes (es)
Federal Taxpayer Registry Code (en)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (MX)Regular expression/Not available post code
Regular expression/One digit multiplied several times post code
Regular expression/Ordinal sequence of numbers
Regular expression/Single digit post code
Regular expression/Very long digits post code.
This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for MX (Mexico) are the following: Regular expression/Mononumerical post code with delimeter
ERROR
Identifier format inaccurate (CURP number (Mexico))CURP number (Mexico) consists of 18 characters. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated. This rule checks the syntax, i.e. format of the CURP number (Mexico) with respect to the CURP number (Mexico)INFO
Identifier format invalid (CURP number (Mexico))CURP number (Mexico) is an individual registration number. It is a unique alphanumeric 18-character string. This rule checks presence of exactly 18 characters corresponding to the format of the CURP number (Mexico) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digits characters then the rule is violated.ERROR
Identifier format invalid (RFC number (Mexico))The Mexican tax identification number consists of 3 letters followed by a delimiting hyphen("-") + a 6-digit number + "-" followed by a 3-character string. The rule does check whether exactly 3 letters are followed by 6 numerical digits and 3 characters without considering the delimiting hyphen nor whitespaces or other delimiters such as dots.

RFC stands for Registro Federal de Contribuyentes, and the clave RFC (RFC number) is a Mexican tax identification number. It’s issued by the Mexican Tax Administration Service (Servicio de Administración Tributaria). The structure of the RFC varies depending on the type of taxpayer.

  • For individuals, it consists of 13 characters: 4 letters followed by 6 digits and 3 alphanumeric characters.
  • For legal entities (and certain legal arrangements), it consists of 12 characters (3 letters followed by 6 digits

and 3 alphanumeric characters).

RFC for Legal Entity is structured as follows:

  • First 3 letters - comes from the company’s legal name that depend on the length of the company name (excluding the corporation type at the end of the name and the stop words de, del, los, las, el, la, en, y, and e),
  - If the company name is three words or greater, the three-letter string will comprise the first letter of each word. For example, if the company’s name is El Gato Azul Restaurante, S.A. de C.V., the RFC would start with GAR.
  - If the company name is two words, the three-letter string will comprise the first letter of the first word and the first two letters of the second word. For example, if the company’s name is Gato Azul, S.A. DE C.V., the RFC would start with GAZ.
  - If the company name is one word, the three-letter string will comprise the first three letters of the word. For example, if the company’s name is Gato, S.A. de C.V., the RFC would start with GAT.
  • Next 6 digits - company’s incorporation date in YYMMDD format
  • Last 3 characters - check value assigned by the Tax Administration Service.

RFC for individuals is structured as follows:

  • First 4 letters - comes from the person’s legal name following rules
  - First letter and first internal vowel of the paternal surname: If the paternal surname does not have a first internal vowel, the second letter of the paternal surname is used, and If the person does not have a second surname, first two letters of the paternal surname are used.
  - First letter of the maternal surname: If the person does not have a second surname, the first letter of the given name is used.
  - First letter of the given name: If the person does not have a second surname, the second letter of the given name is used.
  • Following 6-digit - birth date in YYMMDD format
  • 3-digit checksum - assigned by the Tax Administration Service
ERROR
Legal form invalid (Mexico)Each record should have legal form appropriate for the country.INFO
Mandatory administrative area missing (Mexico)The administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in MexicoINFO
Mandatory locality missing (Mexico)The locality is mandatory for street addresses in Mexico.ERROR
Mandatory post code missing (Mexico)The post code is mandatory for street addresses in Mexico.ERROR
Mandatory thoroughfare missing (Mexico)The thoroughfare is mandatory for street addresses in Mexico.ERROR
Post code format invalid (Mexico)This rule checks the post code format of Mexico. Mexican postal codes (Código Postal or CP) consist of a block of 5 digits. Each digit is associated to a geographical area of the country. The first two digits refer to the federal entity, or, in the case of the Distrito Federal (Mexico City), to a neighbourhood. The third digit indicates an important town or city, a municipality or one of the ten areas into which the Distrito Federal is divided. The fourth digit indicates a municipality or suburb or estate within a town. The final digit indicates a group of blocks or the specific street address of a large-user. The postal code format is NNNNN.ERROR
Unallowed pattern in name detected (MX)Regular expression/Aggregated payments
Regular expression/No new orders
Regular expression/Do not use duplicates note
Regular expression/Reference to other record
Regular expression/No use note
Regular expression/Reference to new record
Regular expression/Reference the former name
Regular expression/Long number in name
Regular expression/Duplicate record note
Regular expression/Dummy record note
Regular expression/Sequence of digits
Regular expression/Unsorted keywords
Regular expression/Length of name .
This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for MX (Mexico) are the following: Regular expression/One time vendor
WARNING

Data sources

Data quality ruleNameContent
MX.POST (data source)Mexican authority post code file (Mexico) (en)ADDRESS
MX.SBI (data source)Mexican Digital Business Information System (en)
Sistema de Información Empresarial Mexicano Digital (de)
BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata DataModel:CDQ/Business_Partner/Bank_Account_Model/MX