DFP — Mutações do patrimônio líquido individual
Stable ID: cvm.cia_aberta.cia_aberta_dfp/dmpl_ind
Contexto semântico
Nome: DFP — Mutações do patrimônio líquido individual
O que contém: Movimentações das contas de patrimônio líquido da companhia em apresentação individual.
Por que consultar: Use para acompanhar reservas, resultados distribuídos e demais mudanças no capital próprio da entidade.
Escopo e limitações: Preserve coluna patrimonial, conta e ordem do exercício na leitura da demonstração.
Aliases e nomes oficiais: DMPL_IND, dmpl_ind, Mutações do PL individual
Evidências:
catalogo/cvm.yml — cia_aberta_dfp/dmpl_indhttps://dados.cvm.gov.br/dataset/cia_aberta-doc-dfp
Comece aqui: guia de acesso aos dados
Readiness (label, not a promise): declared:tolerada_com_residuo · materialized:none · queryable:unknown
Declared (catalog YAML)
| field | value |
|---|---|
dataset |
cia_aberta_dfp |
| parte unica layout | zip_multi_tabela |
parte unica vigencia |
ate=(unknown — not declared anywhere), de=(unknown — not declared anywhere) |
chave (parte unica) |
cnpj_cia, dt_refer, versao, cd_conta, ds_conta, ordem_exerc, coluna_df |
chave_status (parte unica, declared) |
tolerada_com_residuo |
max_linhas_excedentes (parte unica) |
10000 |
max_grupos_residuais (parte unica) |
500 |
politica_dedup_silver (parte unica) |
keep_first |
source URL (parte unica) |
https://dados.cvm.gov.br/dados/CIA_ABERTA/DOC/DFP/DADOS/dfp_cia_aberta_{aaaa}.zip |
Operator notes (verbatim from the catalog comments)
parte unica
# TOLERADA_COM_RESIDUO (re-medido 2026-09-08 noite, zip 2023 no
# servidor — numeros do GATE, autoritativos para o cap exato:
# 8.538 linhas excedentes exatas em 2023; grupos residuais
# distintos = 6.360 - 5.977 = 383 (probe conta grupos, gate conta
# linhas — ver licao groups-vs-rows no artefato bucket-c). O cap
# 7.000/350 anterior usou grupos no lugar de linhas. Caps
# 10.000/500.
# TOLERADA_COM_RESIDUO (re-medido 2026-09-08, zips atuais 2022/2023
# no servidor): 2022 = 5.016 excess (3.644 exatos + 16 residuais
# VL_CONTA); 2023 = 8.970 (5.977 + 312 grupos com DT_INI_EXERC
# distinto + 71 VL_CONTA). Cap residual 350: os pares DT_INI_EXERC
# medidos carregam o mesmo VL_CONTA (correcao de metadado, E3 do
# artefato bucket-c) — cap, nao re-chave. Status saiu de tolerada.
# Caps 7.000/350.
# TOLERADA (medido 2024/2025 com +ds_conta): 2024 = 2.052 excess,
# excess_excl_null_keys=2.052 (100% byte-idênticos); 2025 = 1.068 excess,
# excess_excl_null_keys=1.068 (100% byte-idênticos). ds_conta resolve
# divergências de rótulo — validado: 100% dos grupos com rótulo divergente
# têm ST_CONTA_FIXA='N' (conta definida pela empresa). Cap 2.500.
Observed runs (from meta/runs manifests)
Last good run:
| field | value |
|---|---|
timestamp |
20260820T030134 |
outcome |
written |
exit_code |
0 |
rows_written |
1174173 |
source_sha256 |
|
manifest_path |
C:\Users\plini\Repos\ciano-lake\data\meta\runs\cia_aberta_dfp\20260820T030134.json |
competencia (scoped) |
(unscoped — not period-specific proof) |
Latest failed attempt (kept distinct from the last good run):
| field | value |
|---|---|
timestamp |
20260818T141221 |
outcome |
error |
exit_code |
1 |
error |
bpa_con: Quality check failed: [PASS] row_count: 59,262 rows (validates > 0) |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/59,262 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/59,262 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/59,262 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/59,262 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/59,262 null/empty (0.00%) | |
| [FAIL] uniqueness: 446 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (59,262 total, 58,816 distinct); bpa_ind: Quality check failed: [PASS] row_count: 88,897 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/88,897 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/88,897 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/88,897 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/88,897 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/88,897 null/empty (0.00%) | |
| [FAIL] uniqueness: 440 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (88,897 total, 88,457 distinct); bpp_con: Quality check failed: [PASS] row_count: 101,380 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/101,380 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/101,380 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/101,380 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/101,380 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/101,380 null/empty (0.00%) | |
| [FAIL] uniqueness: 736 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (101,380 total, 100,644 distinct); bpp_ind: Quality check failed: [PASS] row_count: 150,064 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/150,064 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/150,064 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/150,064 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/150,064 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/150,064 null/empty (0.00%) | |
| [FAIL] uniqueness: 736 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (150,064 total, 149,328 distinct); dfc_mi_con: Quality check failed: [PASS] row_count: 48,500 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/48,500 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/48,500 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/48,500 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/48,500 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/48,500 null/empty (0.00%) | |
| [FAIL] uniqueness: 320 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (48,500 total, 48,180 distinct); dfc_mi_ind: Quality check failed: [PASS] row_count: 65,449 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/65,449 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/65,449 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/65,449 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/65,449 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/65,449 null/empty (0.00%) | |
| [FAIL] uniqueness: 332 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (65,449 total, 65,117 distinct); dmpl_con: Quality check failed: [PASS] row_count: 225,735 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/225,735 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/225,735 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/225,735 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/225,735 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/225,735 null/empty (0.00%) | |
| [FAIL] uniqueness: 197,764 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (225,735 total, 27,971 distinct); dmpl_ind: Quality check failed: [PASS] row_count: 246,495 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/246,495 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/246,495 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/246,495 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/246,495 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/246,495 null/empty (0.00%) | |
| [FAIL] uniqueness: 205,806 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (246,495 total, 40,689 distinct); dra_con: Quality check failed: [PASS] row_count: 6,520 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/6,520 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/6,520 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/6,520 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/6,520 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/6,520 null/empty (0.00%) | |
| [FAIL] uniqueness: 30 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (6,520 total, 6,490 distinct); dra_ind: Quality check failed: [PASS] row_count: 6,702 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/6,702 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/6,702 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/6,702 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/6,702 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/6,702 null/empty (0.00%) | |
| [FAIL] uniqueness: 18 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (6,702 total, 6,684 distinct); dre_con: Quality check failed: [PASS] row_count: 30,786 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/30,786 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/30,786 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/30,786 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/30,786 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/30,786 null/empty (0.00%) | |
| [FAIL] uniqueness: 210 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (30,786 total, 30,576 distinct); dre_ind: Quality check failed: [PASS] row_count: 43,367 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/43,367 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/43,367 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/43,367 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/43,367 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/43,367 null/empty (0.00%) | |
| [FAIL] uniqueness: 202 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (43,367 total, 43,165 distinct); dva_con: Quality check failed: [PASS] row_count: 38,554 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/38,554 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/38,554 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/38,554 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/38,554 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/38,554 null/empty (0.00%) | |
| [FAIL] uniqueness: 252 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (38,554 total, 38,302 distinct); dva_ind: Quality check failed: [PASS] row_count: 56,070 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/56,070 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/56,070 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/56,070 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/56,070 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/56,070 null/empty (0.00%) | |
| [FAIL] uniqueness: 238 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (56,070 total, 55,832 distinct) | |
manifest_path |
C:\Users\plini\Repos\ciano-lake\data\meta\runs\cia_aberta_dfp\20260818T141221.json |
competencia (scoped) |
(unscoped) |
Observed residuals (tolerada_com_residuo evidence)
(none observed — either the table has no residual tolerance, or the coverage inventory has not run; absence is not proof of absence)
Materialized (coverage inventory, per environment)
(no coverage inventory available — run tools/coverage_inventory.py collect and pass the JSONL to the publisher; without it nothing is claimed about what physically exists)
Postgres-queryable
(unknown — publication state is a publisher fact, filled at publication time; it is never inferred from materialization)