Base RCO / Objetos / ENEL RJ / bi_brrj_act_ad
6 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brrj_act_ad.vw_agg_brrj_debito_automaticobi_brrj_act_ad.vw_agg_brrj_conv_afc_negbi_brrj_act_ad.vw_agg_brrj_cort_afc_negbi_brrj_act_ad.vw_agg_brrj_debito_auto_afc_negbi_brrj_act_ad.vw_agg_brrj_deu_cast_afc_negbi_brrj_act_ad.vw_agg_brrj_deuda_afc_neg
bi_brrj_act_ad.vw_agg_brrj_debito_automatico
Tags semânticas: CLIENTE, FATURAMENTO, COBRANCA, PERDAS, REDE_GEO, SOCIAL, COMUNICACAO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: fecha_referencia | fecha_dato | fecha_ejecucion | periodo · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (31)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | dia | integer | SIM | OUTRO | NAO_TEMPORAL |
| 2 | mes | integer | SIM | OUTRO | NAO_TEMPORAL |
| 3 | anio | integer | SIM | OUTRO | NAO_TEMPORAL |
| 4 | nombre_mes | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | fecha_referencia | timestamp without time zone | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 6 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | segmento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | negocio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | can_facturas | integer | SIM | COMUNICACAO | NAO_TEMPORAL |
| 12 | can_clientes | integer | SIM | CLIENTE | NAO_TEMPORAL |
| 13 | monto_recaudo_facturado | double precision | SIM | COBRANCA | NAO_TEMPORAL |
| 14 | fecha_dato | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 15 | segmento_neg | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 18 | clase_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 19 | sector | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 21 | comuna | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | tipo_doc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | ejecutivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 25 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 26 | nivel_tension | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | cnr | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 28 | fecha_ejecucion | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 29 | periodo | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 30 | sistema | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | generacion | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brrj_act_ad.vw_agg_brrj_conv_afc_neg
Tags semânticas: COBRANCA, REDE_GEO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: timestamp | periodo_comercial · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (36)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | source_system | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | country_geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | np_legal_entity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | market | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | counter | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 8 | year_month_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 9 | quantity | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | unit_measure | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | amount_gc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 12 | currency_gc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | amount_lc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 14 | currency_lc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | timestamp | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | scenario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | segment_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | segment_l2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | year | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | month | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | day | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | periodo_comercial | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 23 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | departamento_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | municipio_l2 | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 26 | localidad_l3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | barrio_l4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | ciclo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 30 | zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | estrato | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | clase_servicio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | activity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | year_month_issue | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | commodity_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brrj_act_ad.vw_agg_brrj_cort_afc_neg
Tags semânticas: COBRANCA, PERDAS, ORDENS, REDE_GEO, SOCIAL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: timestamp | periodo_comercial | fecha_solicitud | fecha_ejecucion | fecha_processo | fecha_dato · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (47)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | country_geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | market | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | counter | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 6 | year_month_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 7 | quantity | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 8 | unit_measure | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | amount_gc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | currency_gc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | amount_lc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 12 | currency_lc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | timestamp | double precision | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | scenario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | segment_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | segment_l2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | commodity_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | year | integer | SIM | OUTRO | NAO_TEMPORAL |
| 19 | month | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | day | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | periodo_comercial | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 22 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | departamento_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | municipio_l2 | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 25 | localidad_l3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | barrio_l4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | ciclo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 29 | zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | estrato | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | clase_servicio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | source_system | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | np_legal_entity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | numero_ordem_corte | integer | SIM | ORDENS | NAO_TEMPORAL |
| 36 | segmento_pais | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | segmento_global | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | tipo_corte_accion | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 39 | geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | cnr | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 41 | fecha_solicitud | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 42 | fecha_ejecucion | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 43 | fecha_processo | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 44 | fecha_dato | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 45 | suministro | bigint | SIM | SOCIAL | NAO_TEMPORAL |
| 46 | activity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | year_month_issue | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brrj_act_ad.vw_agg_brrj_debito_auto_afc_neg
Tags semânticas: COBRANCA, REDE_GEO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: timestamp | periodo_comercial · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (36)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | country_geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | market | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | counter | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 6 | year_month_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 7 | quantity | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 8 | unit_measure | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | amount_gc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | currency_gc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | amount_lc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 12 | currency_lc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | timestamp | bigint | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | scenario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | segment_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | segment_l2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | commodity_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | year | integer | SIM | OUTRO | NAO_TEMPORAL |
| 19 | month | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | day | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | periodo_comercial | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 22 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | departamento_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | municipio_l2 | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 25 | localidad_l3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | barrio_l4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | ciclo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 29 | zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | estrato | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | clase_servicio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | source_system | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | np_legal_entity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | activity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | year_month_issue | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brrj_act_ad.vw_agg_brrj_deu_cast_afc_neg
Tags semânticas: COBRANCA, REDE_GEO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: timestamp | periodo_comercial · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (36)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | source_system | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | country_geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | np_legal_entity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | market | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | counter | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 8 | year_month_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 9 | quantity | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | unit_measure | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | amount_gc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 12 | currency_gc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | amount_lc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 14 | currency_lc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | timestamp | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | scenario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | segment_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | segment_l2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | year | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | month | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | day | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | periodo_comercial | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 23 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | departamento_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | municipio_l2 | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 26 | localidad_l3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | barrio_l4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | ciclo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 30 | zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | estrato | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | clase_servicio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | commodity_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | activity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | year_month_issue | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brrj_act_ad.vw_agg_brrj_deuda_afc_neg
Tags semânticas: COBRANCA, REDE_GEO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: timestamp | periodo_comercial · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (36)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | source_system | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | country_geography | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | np_legal_entity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | market | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | commodity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | segment | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | counter | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 8 | year_month_payment | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 9 | quantity | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 10 | unit_measure | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | amount_gc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 12 | currency_gc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | amount_lc | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 14 | currency_lc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | timestamp | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 16 | scenario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | segment_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | segment_l2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | year | integer | SIM | OUTRO | NAO_TEMPORAL |
| 20 | month | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | day | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | periodo_comercial | integer | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 23 | sociedad | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | departamento_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | municipio_l2 | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 26 | localidad_l3 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | barrio_l4 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | ciclo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 30 | zona | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | estrato | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | mercado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | clase_servicio | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | commodity_l1 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | activity | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | year_month_issue | integer | SIM | OUTRO | NAO_TEMPORAL |