Table 03 - Cities
- This article presents the fields of the City Table integration layout. To better understand our city registry, see our article on Registering Cities.
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=03 (2) | Yes | 1.0 | |
| 2 | Code (codigo) | Integer (10) | Yes | 1.0 | City identifier in the company. It can be the IBGE code or a custom code. |
| 3 | Description (descricao) | Text (100) | Yes | 1.0 | |
| 4 | UF (uf) | Text (2) | Yes | 1.0 | EX: RS (Do not send the name of the State) |
| 5 | Active (ativo) | Integer (1) | Yes | 1.1 | (1 = Active / 0 = Inactive) Inactive records do not appear to the seller |
| 6 | Country code (codigoPais) | Text (2) | No | 5.29 | ISO-2. If omitted, Demander stores BR. Files without this field remain valid. |
| 7 | IBGE code (codigoIbge) | Integer (11) | No | 5.32 | Municipality code from the IBGE database. CEP and CNPJ lookup use this field first to find the city. Send it after codigoPais. |
Record example:
03|54|LAJEADO|RS|1|BR|4311403|
A file without country and without IBGE remains valid: 03|54|LAJEADO|RS|1|