CO (Colombia)
DataModel:CDQ/Business Partner/Address/Country/CO
| Property | Value |
|---|---|
| A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | CO
|
| Language-specific name. Monolingual name | Colombia (es), Kolumbien (de), Colombia (en), Colombie (fr), 哥伦比亚 (zh) |
| Language-specific short name. Monolingual short name | Colombia (en), Colombia (es), 哥伦比亚 (zh), Kolumbien (de), Colombie (fr) |
| 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 | South 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 |
|---|---|---|
| CO-AMA (Amazonas Department) | CO-AMA
|
Amazonas (es), Amazonas (fr), Amazonas Department (en), Departamento del Amazonas (de), 亚马孙省 (zh) |
| CO-ANT (Antioquia Department) | CO-ANT
|
Antioquia (es), Antioquia (fr), Antioquia Department (en), Departamento de Antioquia (de), 安蒂奥基亚省 (zh) |
| CO-ARA (Arauca Department) | CO-ARA
|
Arauca (es), Arauca (fr), Arauca Department (en), Departamento del Arauca (de), 阿劳卡省 (zh) |
| CO-ATL (Atlántico Department) | CO-ATL
|
Atlántico (es), Atlántico (fr), Atlántico Department (en), Departamento del Atlántico (de), 大西洋省 (zh) |
| CO-BOL (Bolívar Department) | CO-BOL
|
Bolívar (es), Bolívar (fr), Bolívar Department (en), Departamento de Bolívar (de), 玻利瓦尔省 (zh) |
| CO-BOY (Boyacá Department) | CO-BOY
|
Boyacá (es), Boyacá (fr), Boyacá Department (en), Departamento de Boyacá (de), 博亚卡省 (zh) |
| CO-CAL (Caldas Department) | CO-CAL
|
Caldas (es), Caldas (fr), Caldas Department (en), Departamento de Caldas (de), 卡尔达斯省 (zh) |
| CO-CAQ (Caquetá Department) | CO-CAQ
|
Caquetá (es), Caquetá (fr), Caquetá Department (en), Departamento de Caquetá (de), 卡克塔省 (zh) |
| CO-CAS (Casanare Department) | CO-CAS
|
Casanare (es), Casanare (fr), Casanare Department (en), Departamento de Casanare (de), 卡萨纳雷省 (zh) |
| CO-CAU (Cauca Department) | CO-CAU
|
Cauca (es), Cauca (fr), Cauca Department (en), Departamento del Cauca (de), 考卡省 (zh) |
| CO-CES (Cesar Department) | CO-CES
|
Cesar (es), Cesar (fr), Cesar Department (en), Departamento del Cesar (de), 塞萨尔省 (zh) |
| CO-CHO (Chocó Department) | CO-CHO
|
Chocó (es), Chocó (fr), Chocó Department (en), Departamento del Chocó (de), 乔科省 (zh) |
| CO-COR (Córdoba Department) | CO-COR
|
Córdoba (es), Córdoba (fr), Córdoba Department (en), Departamento de Córdoba (de), 科爾多瓦省 (哥倫比亞) (zh) |
| CO-CUN (Cundinamarca Department) | CO-CUN
|
Cundinamarca (de), Cundinamarca (es), Cundinamarca (fr), Cundinamarca Department (en), 昆迪納馬卡省 (zh) |
| CO-DC (Bogota) | CO-DC
|
Bogota (en), Bogotá (de), Bogotá (es), Bogotá (fr), 波哥大 (zh) |
| CO-GUA (Guainía Department) | CO-GUA
|
Guainía (de), Guainía (es), Guainía (fr), Guainía Department (en), 瓜伊尼亚省 (zh) |
| CO-GUV (Guaviare Department) | CO-GUV
|
Guaviare (de), Guaviare (es), Guaviare (fr), Guaviare Department (en), 瓜维亚雷省 (zh) |
| CO-HUI (Huila Department) | CO-HUI
|
Departamento de Huila (de), Huila (es), Huila (fr), Huila Department (en), 乌伊拉省 (zh) |
| CO-LAG (La Guajira Department) | CO-LAG
|
La Guajira (de), La Guajira (es), La Guajira (fr), La Guajira Department (en), 瓜希拉省 (zh) |
| CO-MAG (Magdalena Department) | CO-MAG
|
Departamento del Magdalena (de), Magdalena (es), Magdalena (fr), Magdalena Department (en), 马格达莱纳省 (zh) |
| CO-MET (Meta) | CO-MET
|
Meta (de), Meta (en), Meta (es), Meta (fr), 梅塔省 (zh) |
| CO-NAR (Nariño Department) | CO-NAR
|
Departamento de Nariño (de), Nariño (es), Nariño (fr), Nariño Department (en), 纳里尼奥省 (zh) |
| CO-NSA (Norte de Santander Department) | CO-NSA
|
Departamento de Norte de Santander (de), Norte de Santander (es), Norte de Santander (fr), Norte de Santander Department (en), 北桑坦德省 (zh) |
| CO-PUT (Putumayo Department) | CO-PUT
|
Departamento de Putumayo (de), Putumayo (es), Putumayo (fr), Putumayo Department (en), 普图马约省 (zh) |
| CO-QUI (Quindío Department) | CO-QUI
|
Departamento del Quindío (de), Quindío (es), Quindío (fr), Quindío Department (en), 金迪奥省 (zh) |
| CO-RIS (Risaralda Department) | CO-RIS
|
Departamento de Risaralda (de), Risaralda (es), Risaralda (fr), Risaralda Department (en), 里萨拉尔达省 (zh) |
| CO-SAN (Santander Department) | CO-SAN
|
Departamento de Santander (de), Santander (es), Santander (fr), Santander Department (en), 桑坦德省 (zh) |
| CO-SAP (Archipelago of Saint Andréws, Providence and Saint Catalina) | CO-SAP
|
Archipel de San Andrés, Providencia et Santa Catalina (fr), Archipelago of Saint Andréws, Providence and Saint Catalina (en), Archipiélago de San Andrés, Providencia y Santa Catalina (es), San Andrés und Providencia (de), 聖安德列斯-普羅維登西亞和聖卡塔利娜群島省 (zh) |
| CO-SUC (Sucre Department) | CO-SUC
|
Departamento de Sucre (de), Sucre (es), Sucre (fr), Sucre Department (en), 苏克雷省 (zh) |
| CO-TOL (Tolima Department) | CO-TOL
|
Tolima (de), Tolima (es), Tolima (fr), Tolima Department (en), 托利马省 (zh) |
| CO-VAC (Valle del Cauca Department) | CO-VAC
|
Valle del Cauca (de), Valle del Cauca (es), Valle del Cauca (fr), Valle del Cauca Department (en), 考卡山谷省 (zh) |
| CO-VAU (Vaupés Department) | CO-VAU
|
Departamento del Vaupés (de), Vaupés (es), Vaupés (fr), Vaupés Department (en), 沃佩斯省 (zh) |
| CO-VID (Vichada Department) | CO-VID
|
Vichada (de), Vichada (es), Vichada (fr), Vichada Department (en), 比查达省 (zh) |
Legal forms
| Legal form | ELF code | Name | Main abbreviation |
|---|---|---|---|
| CO_0113 (CDQ) | CO_0113 | Company (es) | Co. (es) |
| CO_0156 (CDQ) | CO_0156 | Sociedad de Responsabilidad Limitada (Colombia) (es) | Ltda (es) |
| CO_0637 (CDQ) | CO_0637 | Empresa unipersonal (es) | E.U. (es) |
| CO_1371 (CDQ) | CO_1371 | Sociedades por acciones simplificada (es) | S.A.S (es) SAS (en) |
| CO_1828 (CDQ) | CO_1828 | Comandita simple (es) | S. en C (es) |
| CO_3496 (CDQ) | CO_3496 | Comandita por acciones (es) | SCA (es) |
| CO_7651 (CDQ) | CO_7651 | Sociedad Anónima (es) | S.A. (es) |
Identifiers
| Identifier | Name | Registration authority |
|---|---|---|
| CO_NIT (NIT number) | Número de Identificación Tributaria (es) NIT number (en) | Dirección de Impuestos y Aduanas Nacionales (Colombia) |
Data quality rules
| Data quality rule | Description | Criticality |
|---|---|---|
| Dummy post code detected (CO) | 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 CO (Colombia) are the following: Regular expression/Mononumerical post code with delimeter | ERROR |
| Identifier checkdigit invalid (NIT number (Colombia)) | This rule checks the checkdigit of NIT number (Colombia). | ERROR |
| Identifier format inaccurate (NIT number (Columbia)) | The NIT number consists of : 9 digits, one dash, 1 check digit (0-9). This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots situated in the places where they are not expected to be then the rule is violated. This rule checks the syntax, i.e. format of the NIT number (Columbia) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. | INFO |
| Identifier format invalid (NIT number (Columbia)) | In colombia the NIT number is aunique number assigned by the DIAN (Dirección de Impuestos y Aduanas Nacionales de Colombia) when the entity is registered in the RUT (Registro Único Tributario). It consists of 10 digits where the last one is a check digit This rule checks presence of exactly 10 digits 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 |
| Legal form invalid (Colombia) | Each record should have legal form appropriate for the country. | INFO |
| Length of national bank Id invalid (Colombia) | This rule checks whether the domestic bank id exceeds the maximum possible length in Colombia | ERROR |
| Mandatory administrative area missing (Colombia) | 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 Colombia | INFO |
| Mandatory locality missing (Colombia) | The locality is mandatory for street addresses in Colombia. | ERROR |
| Mandatory post code missing (Colombia) | The post code is mandatory for street addresses in Colombia | ERROR |
| Mandatory thoroughfare missing (Colombia) | The thoroughfare is mandatory for street addresses in Colombia. | ERROR |
| Post code format invalid (Colombia) | This rule checks the post code format of Colombia. The format of the Colombian postal code is as follows: XXXXXX
| ERROR |
| Unallowed pattern in name detected (CO) | 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/Deletion 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 CO (Colombia) are the following: Regular expression/One time vendor | WARNING |
Data sources
No data sources maintained for Colombia.
Banking metadata
| Property | Value |
|---|---|
| Full metadata | Bank accounts in Colombia |
| Local name of the national bank ID. Bank ID name | Código de Compensacion |
| The provider (national authorities in most cases) of the national bank ID. Bank ID provider | Superintendencia Financiera de Colombia |
| Currency code for accounting in the given country. Currency code | COP
|
| Maximum length of the national bank ID. Maximum bank ID length | 22 |