Enel Brasil

ENEL CE · bi_brce_cus · objetos 1-20

Objetos e campos Redshift de ENEL CE, schema bi_brce_cus.
Base RCO / Objetos / ENEL CE / bi_brce_cus
20 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brce_cus.agg_brce_agingagrupbi_brce_cus.agg_brce_agingdet_parcbi_brce_cus.bt_brce_act_fechamento_contrato_cearabi_brce_cus.bt_brce_act_ordem_grandes_clientes_cearabi_brce_cus.bt_brce_arquivos_siase_2025bi_brce_cus.bt_brce_assetbi_brce_cus.bt_brce_asset_item_attribute_2003_1bi_brce_cus.bt_brce_asset_item_attribute_2003_2bi_brce_cus.bt_brce_asset_item_attribute_2003_3bi_brce_cus.bt_brce_asset_item_attribute_2003_4bi_brce_cus.bt_brce_asset_item_attribute_2003_5bi_brce_cus.bt_brce_base_kpi_qualidadebi_brce_cus.bt_brce_billing_profilebi_brce_cus.bt_brce_cad_cli_comp_id_2003__abi_brce_cus.bt_brce_cad_cli_comp_id_2003__bbi_brce_cus.bt_brce_clientes_sapbi_brce_cus.bt_brce_contactbi_brce_cus.bt_brce_contractbi_brce_cus.bt_brce_contract_linebi_brce_cus.bt_brce_contract_line_bkp
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.agg_brce_agingagrup

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cobrança, dívida e arrecadação
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, ORDENS, COMUNICACAO, CONTABIL, RISCO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: ref | dt_vencimento | dt_faturamento | anomes_ref · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (69)

#CampoTipoNuloConceito sugeridoUso temporal
1empresaintegerSIMOUTRONAO_TEMPORAL
2reftimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
4conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
5contrcoletivocharacter varyingSIMOUTRONAO_TEMPORAL
6doc_fat_coletivocharacter varyingSIMOUTRONAO_TEMPORAL
7contratocharacter varyingSIMCONTRATONAO_TEMPORAL
8clintegerSIMOUTRONAO_TEMPORAL
9ref_fatcharacter varyingSIMOUTRONAO_TEMPORAL
10n_parcelamentocharacter varyingSIMOUTRONAO_TEMPORAL
11dt_vencimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
12diasintegerSIMOUTRONAO_TEMPORAL
13dt_faturamentotimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
14a_vencernumericSIMOUTRONAO_TEMPORAL
15dias_1_30numericSIMOUTRONAO_TEMPORAL
16dias_31_60numericSIMOUTRONAO_TEMPORAL
17dias_61_90numericSIMOUTRONAO_TEMPORAL
18dias_91_120numericSIMOUTRONAO_TEMPORAL
19dias_121_150numericSIMOUTRONAO_TEMPORAL
20dias_151_180numericSIMOUTRONAO_TEMPORAL
21dias_181_210numericSIMOUTRONAO_TEMPORAL
22dias_211_240numericSIMOUTRONAO_TEMPORAL
23dias_241_270numericSIMOUTRONAO_TEMPORAL
24dias_271_300numericSIMOUTRONAO_TEMPORAL
25dias_301_330numericSIMOUTRONAO_TEMPORAL
26dias_331_360numericSIMOUTRONAO_TEMPORAL
27dias_361_390numericSIMOUTRONAO_TEMPORAL
28dias_391_420numericSIMOUTRONAO_TEMPORAL
29dias_421_450numericSIMOUTRONAO_TEMPORAL
30dias_451_480numericSIMOUTRONAO_TEMPORAL
31dias_481_510numericSIMOUTRONAO_TEMPORAL
32dias_511_540numericSIMOUTRONAO_TEMPORAL
33dias_541_570numericSIMOUTRONAO_TEMPORAL
34dias_571_600numericSIMOUTRONAO_TEMPORAL
35dias_601_630numericSIMOUTRONAO_TEMPORAL
36dias_631_660numericSIMOUTRONAO_TEMPORAL
37dias_661_690numericSIMOUTRONAO_TEMPORAL
38dias_691_720numericSIMOUTRONAO_TEMPORAL
39dias_721_1800numericSIMOUTRONAO_TEMPORAL
40maior_1800_diasnumericSIMOUTRONAO_TEMPORAL
41total_em_aberto_faturanumericSIMFATURAMENTONAO_TEMPORAL
42total_cont_faturanumericSIMFATURAMENTONAO_TEMPORAL
43total_g_terceironumericSIMOUTRONAO_TEMPORAL
44total_g_n_terceironumericSIMOUTRONAO_TEMPORAL
45total_q_imposto_retidonumericSIMCONTABILNAO_TEMPORAL
46total_a_estatisticonumericSIMOUTRONAO_TEMPORAL
47grupocharacter varyingSIMOUTRONAO_TEMPORAL
48segmentocharacter varyingSIMOUTRONAO_TEMPORAL
49desc_classecharacter varyingSIMOUTRONAO_TEMPORAL
50castigocharacter varyingSIMOUTRONAO_TEMPORAL
51xbnrcharacter varyingSIMOUTRONAO_TEMPORAL
52corr_faturaintegerSIMFATURAMENTONAO_TEMPORAL
53tipo_doccharacter varyingSIMOUTRONAO_TEMPORAL
54numero_clientebigintSIMCLIENTENAO_TEMPORAL
55castigo_2character varyingSIMOUTRONAO_TEMPORAL
56classeintegerSIMOUTRONAO_TEMPORAL
57despersonabooleanSIMOUTRONAO_TEMPORAL
58recoveryrateintegerSIMOUTRONAO_TEMPORAL
59tipo_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
60corte_restritobooleanSIMORDENSNAO_TEMPORAL
61pend_judicialbooleanSIMOUTRONAO_TEMPORAL
62pend_bancariabooleanSIMOUTRONAO_TEMPORAL
63toibooleanSIMPERDASNAO_TEMPORAL
64area_riscobooleanSIMRISCONAO_TEMPORAL
65antigcharacter varyingSIMOUTRONAO_TEMPORAL
66detalhe_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
67pddbooleanSIMCOBRANCANAO_TEMPORAL
68nomecharacter varyingSIMOUTRONAO_TEMPORAL
69anomes_refcharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.agg_brce_agingdet_parc

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cobrança, dívida e arrecadação
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, ORDENS, COMUNICACAO, RISCO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: ref | dt_contrato | dt_vencimento | ano_mes_selecao · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (69)

#CampoTipoNuloConceito sugeridoUso temporal
1empresaintegerSIMOUTRONAO_TEMPORAL
2reftimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
3parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
4conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
5contrcoletivocharacter varyingSIMOUTRONAO_TEMPORAL
6contratocharacter varyingSIMCONTRATONAO_TEMPORAL
7clcharacter varyingSIMOUTRONAO_TEMPORAL
8dt_contratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
9ref_fatcharacter varyingSIMOUTRONAO_TEMPORAL
10n_documentocharacter varyingSIMOUTRONAO_TEMPORAL
11repetcharacter varyingSIMOUTRONAO_TEMPORAL
12it_doccharacter varyingSIMOUTRONAO_TEMPORAL
13subitemcharacter varyingSIMOUTRONAO_TEMPORAL
14estcharacter varyingSIMOUTRONAO_TEMPORAL
15opercharacter varyingSIMOUTRONAO_TEMPORAL
16subopcharacter varyingSIMOUTRONAO_TEMPORAL
17dt_vencimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
18a_vencernumericSIMOUTRONAO_TEMPORAL
19aging_1_30_diasnumericSIMCOBRANCANAO_TEMPORAL
20aging_31_60_diasnumericSIMCOBRANCANAO_TEMPORAL
21aging_61_90_diasnumericSIMCOBRANCANAO_TEMPORAL
22aging_91_120_diasnumericSIMCOBRANCANAO_TEMPORAL
23aging_121_150_diasnumericSIMCOBRANCANAO_TEMPORAL
24aging_151_180_diasnumericSIMCOBRANCANAO_TEMPORAL
25aging_181_210_diasnumericSIMCOBRANCANAO_TEMPORAL
26aging_211_240_diasnumericSIMCOBRANCANAO_TEMPORAL
27aging_241_270_diasnumericSIMCOBRANCANAO_TEMPORAL
28aging_271_300_diasnumericSIMCOBRANCANAO_TEMPORAL
29aging_301_330_diasnumericSIMCOBRANCANAO_TEMPORAL
30aging_331_360_diasnumericSIMCOBRANCANAO_TEMPORAL
31aging_361_390_diasnumericSIMCOBRANCANAO_TEMPORAL
32aging_391_420_diasnumericSIMCOBRANCANAO_TEMPORAL
33aging_421_450_diasnumericSIMCOBRANCANAO_TEMPORAL
34aging_451_480_diasnumericSIMCOBRANCANAO_TEMPORAL
35aging_481_510_diasnumericSIMCOBRANCANAO_TEMPORAL
36aging_511_540_diasnumericSIMCOBRANCANAO_TEMPORAL
37aging_541_570_diasnumericSIMCOBRANCANAO_TEMPORAL
38aging_571_600_diasnumericSIMCOBRANCANAO_TEMPORAL
39aging_601_630_diasnumericSIMCOBRANCANAO_TEMPORAL
40aging_631_660_diasnumericSIMCOBRANCANAO_TEMPORAL
41aging_661_690_diasnumericSIMCOBRANCANAO_TEMPORAL
42aging_691_720_diasnumericSIMCOBRANCANAO_TEMPORAL
43aging_721_1800_diasnumericSIMCOBRANCANAO_TEMPORAL
44maior_1800_diasnumericSIMOUTRONAO_TEMPORAL
45grupocharacter varyingSIMOUTRONAO_TEMPORAL
46segmentocharacter varyingSIMOUTRONAO_TEMPORAL
47desc_classecharacter varyingSIMOUTRONAO_TEMPORAL
48castigocharacter varyingSIMOUTRONAO_TEMPORAL
49xbnrcharacter varyingSIMOUTRONAO_TEMPORAL
50corr_faturaintegerSIMFATURAMENTONAO_TEMPORAL
51tipo_doccharacter varyingSIMOUTRONAO_TEMPORAL
52numero_clientebigintSIMCLIENTENAO_TEMPORAL
53castigo_2character varyingSIMOUTRONAO_TEMPORAL
54classeintegerSIMOUTRONAO_TEMPORAL
55despersonabooleanSIMOUTRONAO_TEMPORAL
56recoveryrateintegerSIMOUTRONAO_TEMPORAL
57tipo_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
58corte_restritobooleanSIMORDENSNAO_TEMPORAL
59pend_judicialbooleanSIMOUTRONAO_TEMPORAL
60pend_bancariabooleanSIMOUTRONAO_TEMPORAL
61toibooleanSIMPERDASNAO_TEMPORAL
62area_riscobooleanSIMRISCONAO_TEMPORAL
63antigcharacter varyingSIMOUTRONAO_TEMPORAL
64detalhe_dividacharacter varyingSIMCOBRANCANAO_TEMPORAL
65pddbooleanSIMCOBRANCANAO_TEMPORAL
66nomecharacter varyingSIMOUTRONAO_TEMPORAL
67diasintegerSIMOUTRONAO_TEMPORAL
68total_em_aberto_faturadouble precisionSIMFATURAMENTONAO_TEMPORAL
69ano_mes_selecaocharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_act_fechamento_contrato_ceara

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTABIL, RISCO, TEMPORAL, ATUALIZACAO

Temporal: True · Colunas temporais: dte_asset_start_date | dte_asset_end_date | dte_ebill_activation_date | dte_ebill_deactivation_date | dte_row_last_update_date | dte_validity_start_date | dte_last_update_asset · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (61)

#CampoTipoNuloConceito sugeridoUso temporal
1pk_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
2pk_contract_idcharacter varyingSIMCONTRATONAO_TEMPORAL
3cdc_pod_idcharacter varyingSIMOUTRONAO_TEMPORAL
4fk_external_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
5fk_local_customer_idcharacter varyingSIMCLIENTENAO_TEMPORAL
6sds_aggregate_cluster_localcharacter varyingSIMOUTRONAO_TEMPORAL
7lds_local_segmentcharacter varyingSIMOUTRONAO_TEMPORAL
8sds_classe_localcharacter varyingSIMOUTRONAO_TEMPORAL
9fk_external_local_customer_idcharacter varyingSIMCLIENTENAO_TEMPORAL
10sds_marketcharacter varyingSIMOUTRONAO_TEMPORAL
11sds_voltage_levelcharacter varyingSIMOUTRONAO_TEMPORAL
12qty_voltagecharacter varyingSIMOUTRONAO_TEMPORAL
13sds_aggregate_clustercharacter varyingSIMOUTRONAO_TEMPORAL
14qty_declared_yearly_consumptionbigintSIMOUTRONAO_TEMPORAL
15sds_origin_marketcharacter varyingSIMOUTRONAO_TEMPORAL
16sds_use_typecharacter varyingSIMOUTRONAO_TEMPORAL
17sds_global_segmentcharacter varyingSIMOUTRONAO_TEMPORAL
18lds_economic_sectorcharacter varyingSIMOUTRONAO_TEMPORAL
19lds_local_economic_sectorcharacter varyingSIMOUTRONAO_TEMPORAL
20sds_contracted_powercharacter varyingSIMCONTRATONAO_TEMPORAL
21sds_contracted_power_peakcharacter varyingSIMCONTRATONAO_TEMPORAL
22sds_meter_classcharacter varyingSIMMEDIDORNAO_TEMPORAL
23mds_companycharacter varyingSIMOUTRONAO_TEMPORAL
24lds_acquisition_channelcharacter varyingSIMOUTRONAO_TEMPORAL
25cdc_counter_serial_numbercharacter varyingSIMOUTRONAO_TEMPORAL
26dte_asset_start_datetimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
27dte_asset_end_datetimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
28lds_asset_citycharacter varyingSIMMEDIDORNAO_TEMPORAL
29cdc_asset_postal_codecharacter varyingSIMMEDIDORNAO_TEMPORAL
30lds_asset_provincecharacter varyingSIMMEDIDORNAO_TEMPORAL
31lds_asset_regioncharacter varyingSIMMEDIDORNAO_TEMPORAL
32dte_ebill_activation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
33dte_ebill_deactivation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
34mds_ebill_deactivation_reasoncharacter varyingSIMORDENSNAO_TEMPORAL
35fln_is_residentbigintSIMOUTRONAO_TEMPORAL
36lds_activation_modecharacter varyingSIMORDENSNAO_TEMPORAL
37mds_termination_modecharacter varyingSIMOUTRONAO_TEMPORAL
38lds_activation_sub_modecharacter varyingSIMORDENSNAO_TEMPORAL
39mds_termination_sub_modecharacter varyingSIMOUTRONAO_TEMPORAL
40fln_fiber_in_bundlebooleanSIMOUTRONAO_TEMPORAL
41fln_bundled_enelxbooleanSIMOUTRONAO_TEMPORAL
42fln_risk_areasbooleanSIMRISCONAO_TEMPORAL
43lds_concession_areacharacter varyingSIMOUTRONAO_TEMPORAL
44lds_distributorcharacter varyingSIMCONTABILNAO_TEMPORAL
45mds_billing_frequencycharacter varyingSIMFATURAMENTONAO_TEMPORAL
46fln_customer_disconnectivitybooleanSIMCLIENTENAO_TEMPORAL
47fln_smart_meterbooleanSIMMEDIDORNAO_TEMPORAL
48fln_automatic_debitbooleanSIMOUTRONAO_TEMPORAL
49dte_row_last_update_datetimestamp without time zoneSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
50dte_validity_start_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
51sds_subclassecharacter varyingSIMOUTRONAO_TEMPORAL
52sds_generation_capabilitycharacter varyingSIMGDNAO_TEMPORAL
53sds_tension_groupcharacter varyingSIMOUTRONAO_TEMPORAL
54sds_tariff_subgroupcharacter varyingSIMOUTRONAO_TEMPORAL
55sds_tariff_modecharacter varyingSIMOUTRONAO_TEMPORAL
56fln_top_largebooleanSIMOUTRONAO_TEMPORAL
57sds_top_large_segmentationcharacter varyingSIMOUTRONAO_TEMPORAL
58qty_average_consumptionnumericSIMOUTRONAO_TEMPORAL
59lds_countrycharacter varyingSIMOUTRONAO_TEMPORAL
60dte_last_update_assettimestamp without time zoneSIMMEDIDORATUALIZACAO_FISICA
61dte_fech_refcharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_act_ordem_grandes_clientes_ceara

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, MEDIDOR, ORDENS, REDE_GEO, TEMPORAL, ATUALIZACAO

Temporal: True · Colunas temporais: dte_ordem_ingresso_data | dte_estado_ordem_data | dte_visita_data | dte_exec_visita_data | dte_activation_date | dte_sap_validation_date | dte_caso_criacao_data | dte_caso_status_data | dte_insert_lake | dte_last_update | dte_data_fim_regulada · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (49)

#CampoTipoNuloConceito sugeridoUso temporal
1pk_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
2dte_ordem_ingresso_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
3lds_tipo_ordem_idcharacter varyingSIMORDENSNAO_TEMPORAL
4sds_descricao_tipo_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
5lds_servico_idcharacter varyingSIMORDENSNAO_TEMPORAL
6lds_descricao_servicocharacter varyingSIMORDENSNAO_TEMPORAL
7dte_estado_ordem_datatimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
8lds_estado_idcharacter varyingSIMOUTRONAO_TEMPORAL
9sds_status_estado_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
10lds_etapa_idcharacter varyingSIMOUTRONAO_TEMPORAL
11lds_descricao_etapacharacter varyingSIMOUTRONAO_TEMPORAL
12lds_retorno_idcharacter varyingSIMOUTRONAO_TEMPORAL
13lds_descricao_retornocharacter varyingSIMOUTRONAO_TEMPORAL
14dte_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15dte_exec_visita_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16qty_seq_idintegerSIMOUTRONAO_TEMPORAL
17cdc_ordem_relacionadacharacter varyingSIMORDENSNAO_TEMPORAL
18fk_nr_orc_gomnetcharacter varyingSIMOUTRONAO_TEMPORAL
19cdc_instalacao_idcharacter varyingSIMINSTALACAONAO_TEMPORAL
20sds_razao_socialcharacter varyingSIMOUTRONAO_TEMPORAL
21fk_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
22pk_external_asset_idcharacter varyingSIMMEDIDORNAO_TEMPORAL
23sds_cluster_localcharacter varyingSIMOUTRONAO_TEMPORAL
24lds_segmento_localcharacter varyingSIMOUTRONAO_TEMPORAL
25sds_tipo_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
26qty_temp_max_servicointegerSIMORDENSNAO_TEMPORAL
27sds_ind_tempocharacter varyingSIMOUTRONAO_TEMPORAL
28lds_municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
29sds_voltage_levelcharacter varyingSIMOUTRONAO_TEMPORAL
30sds_mercadocharacter varyingSIMOUTRONAO_TEMPORAL
31dte_activation_datetimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
32dte_sap_validation_datetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
33sds_dispersioncharacter varyingSIMOUTRONAO_TEMPORAL
34lds_distribuicao_areacharacter varyingSIMOUTRONAO_TEMPORAL
35fk_caso_idcharacter varyingSIMOUTRONAO_TEMPORAL
36lds_caso_status_localcharacter varyingSIMOUTRONAO_TEMPORAL
37lds_companycharacter varyingSIMOUTRONAO_TEMPORAL
38dte_caso_criacao_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
39dte_caso_status_datatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40lds_suspension_cause_localcharacter varyingSIMOUTRONAO_TEMPORAL
41dte_insert_laketimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
42dte_last_updatetimestamp without time zoneSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
43qty_diasintegerSIMOUTRONAO_TEMPORAL
44dte_data_fim_reguladatimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
45lds_situacaocharacter varyingSIMOUTRONAO_TEMPORAL
46sds_status_prazocharacter varyingSIMOUTRONAO_TEMPORAL
47lds_ind_procedentecharacter varyingSIMOUTRONAO_TEMPORAL
48sds_causa_suspensaocharacter varyingSIMOUTRONAO_TEMPORAL
49lds_sucursalcharacter varyingSIMREDE_GEONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_arquivos_siase_2025

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, LEITURA, FATURAMENTO, COBRANCA, ORDENS, GD, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: dataemissaofatura | datavencimento | dataleituraatual | dataleituraanterior | dataligacaouc | dataencerramentocontrato | dataconcbentarifario | datarevisaocadastral | dataatualizacaomultifamiliar | mesreferencia | saldoatualizadocreditos · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (131)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturacharacter varyingSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualcharacter varyingSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriorcharacter varyingSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratocharacter varyingSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariocharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastralcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliarcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontacharacter varyingSIMOUTRONAO_TEMPORAL
35demativacontratforapontacharacter varyingSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
37demativafatpontacharacter varyingSIMOUTRONAO_TEMPORAL
38demativafatforapontacharacter varyingSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
40consativofattepontacharacter varyingSIMOUTRONAO_TEMPORAL
41consativofatteforapontacharacter varyingSIMOUTRONAO_TEMPORAL
42consativofatteintermcharacter varyingSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
44consativofattepontarescharacter varyingSIMOUTRONAO_TEMPORAL
45consativofatteforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
47consativofattusdpontacharacter varyingSIMOUTRONAO_TEMPORAL
48consativofattusdforapontacharacter varyingSIMOUTRONAO_TEMPORAL
49consativofattusdintermcharacter varyingSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
51consativofattusdpontarescharacter varyingSIMOUTRONAO_TEMPORAL
52consativofattusdforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditoscharacter varyingSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatcharacter varyingSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditoscharacter varyingSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadoscharacter varyingSIMCOBRANCANAO_TEMPORAL
59multacharacter varyingSIMOUTRONAO_TEMPORAL
60juroscharacter varyingSIMOUTRONAO_TEMPORAL
61encargosconexaocharacter varyingSIMOUTRONAO_TEMPORAL
62valorcompensacaocharacter varyingSIMGDNAO_TEMPORAL
63multaencerramentocharacter varyingSIMOUTRONAO_TEMPORAL
64servicoscobraveischaracter varyingSIMORDENSNAO_TEMPORAL
65valortotalfaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
66icmscharacter varyingSIMCONTABILNAO_TEMPORAL
67pischaracter varyingSIMCONTABILNAO_TEMPORAL
68cofinscharacter varyingSIMCONTABILNAO_TEMPORAL
69basecalculoicmscharacter varyingSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinscharacter varyingSIMCONTABILNAO_TEMPORAL
71cipcharacter varyingSIMOUTRONAO_TEMPORAL
72demativaregpontacharacter varyingSIMOUTRONAO_TEMPORAL
73demativaregforapontacharacter varyingSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
75demativaultpontacharacter varyingSIMOUTRONAO_TEMPORAL
76demativaultforapontacharacter varyingSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
78demativacomppontacharacter varyingSIMOUTRONAO_TEMPORAL
79demativacompforapontacharacter varyingSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
81rcpontacharacter varyingSIMOUTRONAO_TEMPORAL
82rcforapontacharacter varyingSIMOUTRONAO_TEMPORAL
83rcnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
84consativomedtepontacharacter varyingSIMOUTRONAO_TEMPORAL
85consativomedteforapontacharacter varyingSIMOUTRONAO_TEMPORAL
86consativomedteintermcharacter varyingSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
88consativomedtepontarescharacter varyingSIMOUTRONAO_TEMPORAL
89consativomedteforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
91enelativainjpontacharacter varyingSIMOUTRONAO_TEMPORAL
92enelativainjforapontacharacter varyingSIMOUTRONAO_TEMPORAL
93enelativainjintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
94enelativainjreservadocharacter varyingSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
96subscarficharacter varyingSIMOUTRONAO_TEMPORAL
97subsgerficharacter varyingSIMOUTRONAO_TEMPORAL
98subsdistcharacter varyingSIMOUTRONAO_TEMPORAL
99subsaguaesgotocharacter varyingSIMOUTRONAO_TEMPORAL
100subsruralcharacter varyingSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaocharacter varyingSIMOUTRONAO_TEMPORAL
102subsbaixarendacharacter varyingSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontacharacter varyingSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontacharacter varyingSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontacharacter varyingSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontacharacter varyingSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontarescharacter varyingSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
113receitatepontacharacter varyingSIMOUTRONAO_TEMPORAL
114receitateforapontacharacter varyingSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
116receitateintermediariocharacter varyingSIMOUTRONAO_TEMPORAL
117receitatepontarescharacter varyingSIMOUTRONAO_TEMPORAL
118receitateforapontarescharacter varyingSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicarescharacter varyingSIMOUTRONAO_TEMPORAL
120receitabandeirascharacter varyingSIMOUTRONAO_TEMPORAL
121receitaultdemativacharacter varyingSIMOUTRONAO_TEMPORAL
122erecharacter varyingSIMOUTRONAO_TEMPORAL
123drecharacter varyingSIMOUTRONAO_TEMPORAL
124consreativopontacharacter varyingSIMOUTRONAO_TEMPORAL
125consreativoforapontacharacter varyingSIMOUTRONAO_TEMPORAL
126consreativointermediariocharacter varyingSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
128demreativapontacharacter varyingSIMOUTRONAO_TEMPORAL
129demreativaforapontacharacter varyingSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicacharacter varyingSIMOUTRONAO_TEMPORAL
131arquivo_nomecharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, COBRANCA, ORDENS, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | installdate | purchasedate | usageenddate | lastvieweddate | lastreferenceddate | ne__activation_date__c | ne__commitment_expiration_date__c | ne__commitment_period__c | ne__dated_base_one_time_fee__c | ne__dated_recurring_charge__c | ne__delivery_date__c | ne__enddate__c | ne__startdate__c | allows_the_use_of_data__c | ne__reservation_date__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (155)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2contactidcharacter varyingSIMCONTATONAO_TEMPORAL
3accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
4accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
5parentidcharacter varyingSIMOUTRONAO_TEMPORAL
6rootassetidcharacter varyingSIMMEDIDORNAO_TEMPORAL
7product2idcharacter varyingSIMOUTRONAO_TEMPORAL
8iscompetitorproductdouble precisionSIMOUTRONAO_TEMPORAL
9createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
11lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
12lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
14isdeleteddouble precisionSIMOUTRONAO_TEMPORAL
15currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
16namecharacter varyingSIMOUTRONAO_TEMPORAL
17serialnumbercharacter varyingSIMOUTRONAO_TEMPORAL
18installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
19purchasedatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
20usageenddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
21statuscharacter varyingSIMOUTRONAO_TEMPORAL
22pricedouble precisionSIMOUTRONAO_TEMPORAL
23quantitydouble precisionSIMOUTRONAO_TEMPORAL
24descriptioncharacter varyingSIMOUTRONAO_TEMPORAL
25owneridcharacter varyingSIMOUTRONAO_TEMPORAL
26recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
27lastvieweddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
28lastreferenceddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
29pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
30type__ccharacter varyingSIMOUTRONAO_TEMPORAL
31company__ccharacter varyingSIMOUTRONAO_TEMPORAL
32country__ccharacter varyingSIMOUTRONAO_TEMPORAL
33externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
34indice__cdouble precisionSIMOUTRONAO_TEMPORAL
35ne__action__ccharacter varyingSIMOUTRONAO_TEMPORAL
36ne__activation_date__ctimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
37ne__address_line1__ccharacter varyingSIMOUTRONAO_TEMPORAL
38ne__address_line2__ccharacter varyingSIMOUTRONAO_TEMPORAL
39ne__address_line3__ccharacter varyingSIMOUTRONAO_TEMPORAL
40ne__assetitementerpriseid__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
41ne__assetpromoid__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
42ne__asset_item_account__ccharacter varyingSIMCLIENTENAO_TEMPORAL
43ne__baseonetimefee__cdouble precisionSIMOUTRONAO_TEMPORAL
44ne__baserecurringcharge__cdouble precisionSIMOUTRONAO_TEMPORAL
45ne__billingprof__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
46ne__billing_account_asset_item__ccharacter varyingSIMCLIENTENAO_TEMPORAL
47ne__billing_account__ccharacter varyingSIMCLIENTENAO_TEMPORAL
48ne__billing_description__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
49ne__billing_profile_asset_item__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
50ne__cart_description__ccharacter varyingSIMOUTRONAO_TEMPORAL
51ne__catalogitem__ccharacter varyingSIMOUTRONAO_TEMPORAL
52ne__catalog__ccharacter varyingSIMOUTRONAO_TEMPORAL
53ne__city__ccharacter varyingSIMOUTRONAO_TEMPORAL
54ne__commitment_expiration_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55ne__commitment_period__cdouble precisionSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
56ne__commitment_uom__ccharacter varyingSIMOUTRONAO_TEMPORAL
57ne__commitment__cdouble precisionSIMOUTRONAO_TEMPORAL
58ne__contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
59ne__country_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
60ne__country__ccharacter varyingSIMOUTRONAO_TEMPORAL
61ne__currency_extension_1__cdouble precisionSIMOUTRONAO_TEMPORAL
62ne__currency_extension_2__cdouble precisionSIMOUTRONAO_TEMPORAL
63ne__currency_extension_3__cdouble precisionSIMOUTRONAO_TEMPORAL
64ne__currency_extension_4__cdouble precisionSIMOUTRONAO_TEMPORAL
65ne__currency_extension_5__cdouble precisionSIMOUTRONAO_TEMPORAL
66ne__dated_base_one_time_fee__cdouble precisionSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
67ne__dated_recurring_charge__cdouble precisionSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
68ne__delivery_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
69ne__description__ccharacter varyingSIMOUTRONAO_TEMPORAL
70ne__discountid__ccharacter varyingSIMOUTRONAO_TEMPORAL
71ne__discount_one_time__cdouble precisionSIMOUTRONAO_TEMPORAL
72ne__discount__cdouble precisionSIMOUTRONAO_TEMPORAL
73ne__dynamic_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
74ne__enddate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
75ne__fulfilmentstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
76ne__generate_asset_item__cdouble precisionSIMMEDIDORNAO_TEMPORAL
77ne__geolocalization__latitude__sdouble precisionSIMREDE_GEONAO_TEMPORAL
78ne__geolocalization__longitude__sdouble precisionSIMREDE_GEONAO_TEMPORAL
79ne__hidden_in_cart__cdouble precisionSIMOUTRONAO_TEMPORAL
80ne__ispromo__cdouble precisionSIMOUTRONAO_TEMPORAL
81ne__item_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
82ne__multiply_asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
83ne__multiply_configuration_item__ccharacter varyingSIMCOMUNICACAONAO_TEMPORAL
84ne__onetimefeecode__ccharacter varyingSIMOUTRONAO_TEMPORAL
85ne__onetimefeeov__cdouble precisionSIMOUTRONAO_TEMPORAL
86ne__onetimefeepb__cdouble precisionSIMOUTRONAO_TEMPORAL
87ne__one_time_cost__cdouble precisionSIMOUTRONAO_TEMPORAL
88ne__one_time_tax_free__cdouble precisionSIMOUTRONAO_TEMPORAL
89ne__optional__cdouble precisionSIMOUTRONAO_TEMPORAL
90ne__orderitempromoid__ccharacter varyingSIMORDENSNAO_TEMPORAL
91ne__order_config__ccharacter varyingSIMORDENSNAO_TEMPORAL
92ne__parameters__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
93ne__parent_order_item__ccharacter varyingSIMORDENSNAO_TEMPORAL
94ne__penalty_activated__cdouble precisionSIMOUTRONAO_TEMPORAL
95ne__penalty_fee__cdouble precisionSIMOUTRONAO_TEMPORAL
96ne__penalty_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
97ne__penalty__cdouble precisionSIMOUTRONAO_TEMPORAL
98ne__picked_by__ccharacter varyingSIMOUTRONAO_TEMPORAL
99ne__postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
100ne__prodid__ccharacter varyingSIMOUTRONAO_TEMPORAL
101ne__promotionid__ccharacter varyingSIMOUTRONAO_TEMPORAL
102ne__province__ccharacter varyingSIMOUTRONAO_TEMPORAL
103ne__recurringchargecode__ccharacter varyingSIMOUTRONAO_TEMPORAL
104ne__recurringchargefrequency__ccharacter varyingSIMOUTRONAO_TEMPORAL
105ne__recurringchargeov__cdouble precisionSIMOUTRONAO_TEMPORAL
106ne__recurringchargepb__cdouble precisionSIMOUTRONAO_TEMPORAL
107ne__recurring_charge_tax_free__cdouble precisionSIMOUTRONAO_TEMPORAL
108ne__recurring_cost_frequency__ccharacter varyingSIMOUTRONAO_TEMPORAL
109ne__recurring_cost__cdouble precisionSIMOUTRONAO_TEMPORAL
110ne__remove_from_total__cdouble precisionSIMOUTRONAO_TEMPORAL
111ne__reservation_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
112ne__root_order_item__ccharacter varyingSIMORDENSNAO_TEMPORAL
113ne__serialnum__ccharacter varyingSIMOUTRONAO_TEMPORAL
114ne__service_account_asset_item__ccharacter varyingSIMCLIENTENAO_TEMPORAL
115ne__service_account__ccharacter varyingSIMCLIENTENAO_TEMPORAL
116ne__service_point__ccharacter varyingSIMORDENSNAO_TEMPORAL
117ne__shipped_qty__cdouble precisionSIMOUTRONAO_TEMPORAL
118ne__smartpartnumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
119ne__smartpart__ccharacter varyingSIMOUTRONAO_TEMPORAL
120ne__sourcelineitemid__ccharacter varyingSIMOUTRONAO_TEMPORAL
121ne__startdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
122ne__state_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
123ne__state__ccharacter varyingSIMOUTRONAO_TEMPORAL
124ne__status__ccharacter varyingSIMOUTRONAO_TEMPORAL
125ne__street__ccharacter varyingSIMOUTRONAO_TEMPORAL
126ne__tax_models_applied__ccharacter varyingSIMOUTRONAO_TEMPORAL
127ne__tax_for_canal__cdouble precisionSIMOUTRONAO_TEMPORAL
128ne__text_extension_1__ccharacter varyingSIMOUTRONAO_TEMPORAL
129ne__text_extension_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
130ne__text_extension_3__ccharacter varyingSIMOUTRONAO_TEMPORAL
131ne__text_extension_4__ccharacter varyingSIMOUTRONAO_TEMPORAL
132ne__text_extension_5__ccharacter varyingSIMOUTRONAO_TEMPORAL
133ne__unitcreditcode__ccharacter varyingSIMCOBRANCANAO_TEMPORAL
134ne__unitcreditdescription__ccharacter varyingSIMCOBRANCANAO_TEMPORAL
135ne__usagecode__ccharacter varyingSIMOUTRONAO_TEMPORAL
136ne__usagedescription__ccharacter varyingSIMOUTRONAO_TEMPORAL
137ne__zip_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
138allows_the_use_of_data__cdouble precisionSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
139contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
140asset_id__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
141oldaccountid__ccharacter varyingSIMCLIENTENAO_TEMPORAL
142olddocumenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
143sendtobill__cdouble precisionSIMOUTRONAO_TEMPORAL
144senttobill__cdouble precisionSIMOUTRONAO_TEMPORAL
145ne__bundle_configuration__ccharacter varyingSIMCOMUNICACAONAO_TEMPORAL
146ne__bundle__ccharacter varyingSIMOUTRONAO_TEMPORAL
147ne__bundle_element__ccharacter varyingSIMOUTRONAO_TEMPORAL
148ne__magnitude__ccharacter varyingSIMOUTRONAO_TEMPORAL
149ne__parent_logic__ccharacter varyingSIMOUTRONAO_TEMPORAL
150ne__reservation_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
151psva_partneraux__cdouble precisionSIMCLIENTENAO_TEMPORAL
152hiredpowerfp__ccharacter varyingSIMOUTRONAO_TEMPORAL
153hiredpowerhp__ccharacter varyingSIMOUTRONAO_TEMPORAL
154installedpower__ccharacter varyingSIMOUTRONAO_TEMPORAL
155pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset_item_attribute_2003_1

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (6)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3idcharacter varyingSIMOUTRONAO_TEMPORAL
4ne__asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
6lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset_item_attribute_2003_2

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (6)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3idcharacter varyingSIMOUTRONAO_TEMPORAL
4ne__asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
6lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset_item_attribute_2003_3

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (6)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3idcharacter varyingSIMOUTRONAO_TEMPORAL
4ne__asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
6lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset_item_attribute_2003_4

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate | carga_kw_br · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (6)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3idcharacter varyingSIMOUTRONAO_TEMPORAL
4ne__asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
6lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_asset_item_attribute_2003_5

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (6)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3idcharacter varyingSIMOUTRONAO_TEMPORAL
4ne__asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
6lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_base_kpi_qualidade

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Qualidade de dados e cadastro
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, CONTATO, REDE_GEO, TEMPORAL, ATUALIZACAO, COMPETENCIA

Temporal: True · Colunas temporais: dt_nascimento | dt_processamento_yyyymm · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (51)

#CampoTipoNuloConceito sugeridoUso temporal
1seqidbigintSIMOUTRONAO_TEMPORAL
2distribuidoracharacter varyingSIMOUTRONAO_TEMPORAL
3instalacaocharacter varyingSIMINSTALACAONAO_TEMPORAL
4assetidcharacter varyingSIMMEDIDORNAO_TEMPORAL
5conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
6parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
7nomecharacter varyingSIMOUTRONAO_TEMPORAL
8nome_maecharacter varyingSIMOUTRONAO_TEMPORAL
9dt_nascimentotimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
10cpfcharacter varyingSIMOUTRONAO_TEMPORAL
11cpf_ncharacter varyingSIMOUTRONAO_TEMPORAL
12cnpjcharacter varyingSIMOUTRONAO_TEMPORAL
13cnpj_ncharacter varyingSIMOUTRONAO_TEMPORAL
14inscricao_estadualcharacter varyingSIMOUTRONAO_TEMPORAL
15isentocharacter varyingSIMOUTRONAO_TEMPORAL
16emailcharacter varyingSIMCONTATONAO_TEMPORAL
17email_ncharacter varyingSIMCONTATONAO_TEMPORAL
18tel_celularcharacter varyingSIMCONTATONAO_TEMPORAL
19tel_celular_ncharacter varyingSIMCONTATONAO_TEMPORAL
20tel_fixocharacter varyingSIMOUTRONAO_TEMPORAL
21tel_fixo_ncharacter varyingSIMOUTRONAO_TEMPORAL
22logradourocharacter varyingSIMOUTRONAO_TEMPORAL
23logradouro_altcharacter varyingSIMOUTRONAO_TEMPORAL
24numerocharacter varyingSIMOUTRONAO_TEMPORAL
25numero_altcharacter varyingSIMOUTRONAO_TEMPORAL
26complementocharacter varyingSIMOUTRONAO_TEMPORAL
27complemento_altcharacter varyingSIMOUTRONAO_TEMPORAL
28bairrocharacter varyingSIMOUTRONAO_TEMPORAL
29bairro_altcharacter varyingSIMOUTRONAO_TEMPORAL
30municipiocharacter varyingSIMREDE_GEONAO_TEMPORAL
31municipio_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
32municipio_altcharacter varyingSIMREDE_GEONAO_TEMPORAL
33municipio_alt_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
34ufcharacter varyingSIMOUTRONAO_TEMPORAL
35uf_altcharacter varyingSIMOUTRONAO_TEMPORAL
36cepcharacter varyingSIMREDE_GEONAO_TEMPORAL
37cep_obscharacter varyingSIMREDE_GEONAO_TEMPORAL
38cep_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
39cep_altcharacter varyingSIMREDE_GEONAO_TEMPORAL
40cep_alt_obscharacter varyingSIMREDE_GEONAO_TEMPORAL
41cep_alt_ncharacter varyingSIMREDE_GEONAO_TEMPORAL
42cnaecharacter varyingSIMOUTRONAO_TEMPORAL
43cnae_ncharacter varyingSIMOUTRONAO_TEMPORAL
44subclasse_codigocharacter varyingSIMOUTRONAO_TEMPORAL
45classe_ncharacter varyingSIMOUTRONAO_TEMPORAL
46subclasse_ncharacter varyingSIMOUTRONAO_TEMPORAL
47grupocharacter varyingSIMOUTRONAO_TEMPORAL
48entrega_altbooleanSIMOUTRONAO_TEMPORAL
49delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
50dt_processamentocharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
51dt_processamento_yyyymmcharacter varyingSIMATUALIZACAO_CARGAATUALIZACAO_FISICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_billing_profile

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Faturamento e consumo
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, RECLAMACAO, ORDENS, CONTATO, TEMPORAL

Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | changeinvoiceaddressrestrictiondate__c | changenamerestrictiondate__c | documenttypechangerestrictiondate__c | activationdate__c | ederestrictiondate__c | rejecteddate__c | suscriptiondate__c | cnt_due_date__c | datenodeliverypostal__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (78)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2isdeleteddouble precisionSIMOUTRONAO_TEMPORAL
3namecharacter varyingSIMOUTRONAO_TEMPORAL
4currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
5recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
6createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
7createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
8lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
9lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
11lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
12account__ccharacter varyingSIMCLIENTENAO_TEMPORAL
13address__ccharacter varyingSIMOUTRONAO_TEMPORAL
14type__ccharacter varyingSIMOUTRONAO_TEMPORAL
15pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
16agreestoterms__cdouble precisionSIMOUTRONAO_TEMPORAL
17attachmentsdocumenttype__cdouble precisionSIMOUTRONAO_TEMPORAL
18ballotname__ccharacter varyingSIMOUTRONAO_TEMPORAL
19bankcards__cdouble precisionSIMOUTRONAO_TEMPORAL
20bank__ccharacter varyingSIMOUTRONAO_TEMPORAL
21billingaddress__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
22changeinvoiceaddressrestrictreason__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
23changeinvoiceaddressrestrictiondate__ctimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
24changeinvoiceaddressrestriction__cdouble precisionSIMFATURAMENTONAO_TEMPORAL
25changenamerestrictiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
26changenamerestrictionreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
27changenamerestriction__cdouble precisionSIMOUTRONAO_TEMPORAL
28creditline__cdouble precisionSIMCOBRANCANAO_TEMPORAL
29currentaccountnumber__cdouble precisionSIMCLIENTENAO_TEMPORAL
30currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
31documenttypechangerestrictiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
32documenttypechangerestrictionreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
33documenttypechangerestriction__cdouble precisionSIMOUTRONAO_TEMPORAL
34documenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
35edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
36externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
37netincome__cdouble precisionSIMOUTRONAO_TEMPORAL
38quotacreditline__cdouble precisionSIMCOBRANCANAO_TEMPORAL
39totalquotabankcards__cdouble precisionSIMOUTRONAO_TEMPORAL
40totalquotatradinghousecards__cdouble precisionSIMOUTRONAO_TEMPORAL
41tradinghousecard__cdouble precisionSIMOUTRONAO_TEMPORAL
42deliverytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
43delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
44accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
45activationdate__ctimestamp without time zoneSIMORDENSEVENTO_OU_VIGENCIA
46agency__ccharacter varyingSIMOUTRONAO_TEMPORAL
47bankbr__ccharacter varyingSIMOUTRONAO_TEMPORAL
48bankdocumentowner__ccharacter varyingSIMOUTRONAO_TEMPORAL
49cbu_arg__ccharacter varyingSIMOUTRONAO_TEMPORAL
50cardnumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
51cardtype__ccharacter varyingSIMOUTRONAO_TEMPORAL
52contact__ccharacter varyingSIMCONTATONAO_TEMPORAL
53delivery_document_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
54ederestrictiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55ederestrictionreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
56ederestriction__cdouble precisionSIMOUTRONAO_TEMPORAL
57event__ccharacter varyingSIMOUTRONAO_TEMPORAL
58lowincomedoc__ccharacter varyingSIMOUTRONAO_TEMPORAL
59mailemail2__ccharacter varyingSIMCONTATONAO_TEMPORAL
60mainemail1__ccharacter varyingSIMCONTATONAO_TEMPORAL
61main_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
62rejectreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
63rejecteddate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
64secondaryemail1__ccharacter varyingSIMCONTATONAO_TEMPORAL
65secondaryemail2__ccharacter varyingSIMCONTATONAO_TEMPORAL
66shipping_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
67suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
68virtualinvoicetype__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
69monthly_charge__cdouble precisionSIMOUTRONAO_TEMPORAL
70cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
71edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
72publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
73lowamount__cbooleanSIMOUTRONAO_TEMPORAL
74company__ccharacter varyingSIMOUTRONAO_TEMPORAL
75nodeliverypostal__ccharacter varyingSIMOUTRONAO_TEMPORAL
76datenodeliverypostal__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
77case__ccharacter varyingSIMRECLAMACAONAO_TEMPORAL
78currentaccountnum__ccharacter varyingSIMCLIENTENAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_cad_cli_comp_id_2003__a

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate_pointofdelivery | lastmodifieddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (91)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5lastmodifieddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
6companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
7billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
8connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
9connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
10cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
11electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
12pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
13rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
14route__ccharacter varyingSIMOUTRONAO_TEMPORAL
15segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
16servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
17company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
18country__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
19vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
20cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
21cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
22distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
23notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
24cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
25zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
26blacklist__cbooleanSIMOUTRONAO_TEMPORAL
27cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
28municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
29network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
30detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
31id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
32contactidcharacter varyingSIMCONTATONAO_TEMPORAL
33accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
34accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
35createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
36lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
38installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
39status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
40description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
46name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47phonecharacter varyingSIMOUTRONAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
50lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
52additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
53birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
54businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
55companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
56identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
57identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
58mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
59primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
60secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
61secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
62company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
63externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
64ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
65countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
66accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
67phonetype__ccharacter varyingSIMOUTRONAO_TEMPORAL
68pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
69tertiary_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
70executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
76cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
79recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
80cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
81cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
82cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
83cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
84cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
85cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
86cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
87acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
88cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
89feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
90transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
91transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_cad_cli_comp_id_2003__b

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, TEMPORAL

Temporal: True · Colunas temporais: lastmodifieddate_asset | createddate_billing_profile | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | cnt_due_date__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (34)

#CampoTipoNuloConceito sugeridoUso temporal
1id_asset_ccharacter varyingSIMMEDIDORNAO_TEMPORAL
2accountid_ccharacter varyingSIMCLIENTENAO_TEMPORAL
3lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
4name_asset_ccharacter varyingSIMMEDIDORNAO_TEMPORAL
5ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
6id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
7id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
8id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
9account__ccharacter varyingSIMCLIENTENAO_TEMPORAL
10pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
11accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
12currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
13createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
14name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
15edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
16delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
17cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
18edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
19publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
20lowamount__cbooleanSIMOUTRONAO_TEMPORAL
21type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
22suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
23id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
24startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
25activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
26createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
27lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
28enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
29status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
30description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
31statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
32contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
33contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
34cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_clientes_sap

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Cliente, instalação e contrato
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, FATURAMENTO, COMUNICACAO, TEMPORAL

Temporal: True · Colunas temporais: mov_in | mov_out · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (10)

#CampoTipoNuloConceito sugeridoUso temporal
1parceirobigintSIMCLIENTENAO_TEMPORAL
2conta_contratobigintSIMCONTRATONAO_TEMPORAL
3mov_intimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
4mov_outtimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
5setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
6zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
7categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
8instalacaobigintSIMINSTALACAONAO_TEMPORAL
9local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
10ruacharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_contact

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Contato, consentimento e canais
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, FATURAMENTO, COBRANCA, PERDAS, RECLAMACAO, ORDENS, CONTATO, REDE_GEO, PESQUISA, COMUNICACAO, TEMPORAL, COMPETENCIA

Temporal: True · Colunas temporais: birthdate | createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | lastcurequestdate | lastcuupdatedate | emailbounceddate | validated_email__c | sf4twitter__twitter_creation_date__c | sf4twitter__twitter_last_tweet__c | allows_the_use_of_personal_data__c | lastactivitydate__c | updatedbyprotocol__c | habeas_data__c | cjagreementcutoffdate__c | cjlastinvoicedate__c | cjmodelexecutiondate__c | cjagreementexecutiondate__c | cjmodelrecommendedperiod__c | cjenergycutoffdate__c | deathdate__c | date_registration_update__c | cjduedate__c | record_removal_date__c | registration_date__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (241)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2isdeletedcharacter varyingSIMOUTRONAO_TEMPORAL
3masterrecordidcharacter varyingSIMOUTRONAO_TEMPORAL
4accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
5salutationcharacter varyingSIMOUTRONAO_TEMPORAL
6firstnamecharacter varyingSIMOUTRONAO_TEMPORAL
7lastnamecharacter varyingSIMOUTRONAO_TEMPORAL
8middlenamecharacter varyingSIMOUTRONAO_TEMPORAL
9recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
10otherstreetcharacter varyingSIMOUTRONAO_TEMPORAL
11othercitycharacter varyingSIMOUTRONAO_TEMPORAL
12otherstatecharacter varyingSIMOUTRONAO_TEMPORAL
13otherpostalcodecharacter varyingSIMOUTRONAO_TEMPORAL
14othercountrycharacter varyingSIMOUTRONAO_TEMPORAL
15otherlatitudedouble precisionSIMREDE_GEONAO_TEMPORAL
16otherlongitudedouble precisionSIMREDE_GEONAO_TEMPORAL
17othergeocodeaccuracycharacter varyingSIMCOMUNICACAONAO_TEMPORAL
18mailingstreetcharacter varyingSIMOUTRONAO_TEMPORAL
19mailingcitycharacter varyingSIMOUTRONAO_TEMPORAL
20mailingstatecharacter varyingSIMOUTRONAO_TEMPORAL
21mailingpostalcodecharacter varyingSIMOUTRONAO_TEMPORAL
22mailingcountrycharacter varyingSIMOUTRONAO_TEMPORAL
23mailinglatitudedouble precisionSIMREDE_GEONAO_TEMPORAL
24mailinglongitudedouble precisionSIMREDE_GEONAO_TEMPORAL
25mailinggeocodeaccuracycharacter varyingSIMCOMUNICACAONAO_TEMPORAL
26phonecharacter varyingSIMOUTRONAO_TEMPORAL
27faxcharacter varyingSIMOUTRONAO_TEMPORAL
28mobilephonecharacter varyingSIMOUTRONAO_TEMPORAL
29homephonecharacter varyingSIMOUTRONAO_TEMPORAL
30otherphonecharacter varyingSIMOUTRONAO_TEMPORAL
31assistantphonecharacter varyingSIMOUTRONAO_TEMPORAL
32reportstoidcharacter varyingSIMPERDASNAO_TEMPORAL
33emailcharacter varyingSIMCONTATONAO_TEMPORAL
34titlecharacter varyingSIMOUTRONAO_TEMPORAL
35departmentcharacter varyingSIMOUTRONAO_TEMPORAL
36assistantnamecharacter varyingSIMOUTRONAO_TEMPORAL
37leadsourcecharacter varyingSIMOUTRONAO_TEMPORAL
38birthdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
39descriptioncharacter varyingSIMOUTRONAO_TEMPORAL
40currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
41owneridcharacter varyingSIMOUTRONAO_TEMPORAL
42hasoptedoutofemaildouble precisionSIMCONTATONAO_TEMPORAL
43hasoptedoutoffaxdouble precisionSIMOUTRONAO_TEMPORAL
44donotcalldouble precisionSIMCOMUNICACAONAO_TEMPORAL
45createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
46createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
47lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
48lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
49systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
50lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
51lastcurequestdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
52lastcuupdatedatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53emailbouncedreasoncharacter varyingSIMCONTATONAO_TEMPORAL
54emailbounceddatetimestamp without time zoneSIMCONTATOEVENTO_OU_VIGENCIA
55jigsawcharacter varyingSIMOUTRONAO_TEMPORAL
56jigsawcontactidcharacter varyingSIMCONTATONAO_TEMPORAL
57additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
58validated_email__cdouble precisionSIMCONTATOEVENTO_OU_VIGENCIA
59companyid__ccharacter varyingSIMOUTRONAO_TEMPORAL
60contactaddress__ccharacter varyingSIMCONTATONAO_TEMPORAL
61contacttype__ccharacter varyingSIMCONTATONAO_TEMPORAL
62identifycertificatenumberseries__cdouble precisionSIMOUTRONAO_TEMPORAL
63identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
64identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
65jobemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
66motherslastname__ccharacter varyingSIMOUTRONAO_TEMPORAL
67personsegment__ccharacter varyingSIMOUTRONAO_TEMPORAL
68preferredchannelcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
69relationshipdetail__ccharacter varyingSIMOUTRONAO_TEMPORAL
70repeatedcases__cdouble precisionSIMRECLAMACAONAO_TEMPORAL
71secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
72secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
73twittertest__ccharacter varyingSIMOUTRONAO_TEMPORAL
74typepointofdeliveryrelationship__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
75vip__cdouble precisionSIMOUTRONAO_TEMPORAL
76sf4twitter__contact_source__ccharacter varyingSIMCONTATONAO_TEMPORAL
77sf4twitter__fcbk_image_url__ccharacter varyingSIMOUTRONAO_TEMPORAL
78sf4twitter__fcbk_profile_url__ccharacter varyingSIMOUTRONAO_TEMPORAL
79sf4twitter__fcbk_user_id__ccharacter varyingSIMOUTRONAO_TEMPORAL
80sf4twitter__fcbk_username__ccharacter varyingSIMOUTRONAO_TEMPORAL
81sf4twitter__influencer_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
82sf4twitter__influencer__ccharacter varyingSIMOUTRONAO_TEMPORAL
83sf4twitter__klout_number__cdouble precisionSIMOUTRONAO_TEMPORAL
84sf4twitter__languages__ccharacter varyingSIMOUTRONAO_TEMPORAL
85sf4twitter__level__ccharacter varyingSIMOUTRONAO_TEMPORAL
86sf4twitter__origin__ccharacter varyingSIMOUTRONAO_TEMPORAL
87sf4twitter__twitter_bio__ccharacter varyingSIMOUTRONAO_TEMPORAL
88sf4twitter__twitter_creation_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
89sf4twitter__twitter_follower_count__cdouble precisionSIMOUTRONAO_TEMPORAL
90sf4twitter__twitter_following_count__cdouble precisionSIMOUTRONAO_TEMPORAL
91sf4twitter__twitter_image_url__ccharacter varyingSIMOUTRONAO_TEMPORAL
92sf4twitter__twitter_last_tweet__ctimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
93sf4twitter__twitter_location__ccharacter varyingSIMOUTRONAO_TEMPORAL
94sf4twitter__twitter_status_count__cdouble precisionSIMOUTRONAO_TEMPORAL
95sf4twitter__twitter_user_id__ccharacter varyingSIMOUTRONAO_TEMPORAL
96sf4twitter__twitter_username__ccharacter varyingSIMOUTRONAO_TEMPORAL
97sf4twitter__followed__cdouble precisionSIMOUTRONAO_TEMPORAL
98company__ccharacter varyingSIMOUTRONAO_TEMPORAL
99country__ccharacter varyingSIMOUTRONAO_TEMPORAL
100alias__ccharacter varyingSIMOUTRONAO_TEMPORAL
101externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
102gender__ccharacter varyingSIMOUTRONAO_TEMPORAL
103password__ccharacter varyingSIMOUTRONAO_TEMPORAL
104receive_adverts__cdouble precisionSIMOUTRONAO_TEMPORAL
105receive_push_notifications__cdouble precisionSIMCOMUNICACAONAO_TEMPORAL
106userfacebookimageurl__ccharacter varyingSIMOUTRONAO_TEMPORAL
107user_facebook_id__ccharacter varyingSIMOUTRONAO_TEMPORAL
108user_facebook_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
109user_picture__ccharacter varyingSIMOUTRONAO_TEMPORAL
110username__ccharacter varyingSIMOUTRONAO_TEMPORAL
111verification_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
112indice__cdouble precisionSIMOUTRONAO_TEMPORAL
113active__cdouble precisionSIMOUTRONAO_TEMPORAL
114ia_extension__ccharacter varyingSIMOUTRONAO_TEMPORAL
115ia_relationlevel__ccharacter varyingSIMOUTRONAO_TEMPORAL
116ismigrated__cdouble precisionSIMOUTRONAO_TEMPORAL
117ne__languages__ccharacter varyingSIMOUTRONAO_TEMPORAL
118ne__level__ccharacter varyingSIMOUTRONAO_TEMPORAL
119allows_the_use_of_personal_data__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
120civil_status__ccharacter varyingSIMOUTRONAO_TEMPORAL
121education_level__ccharacter varyingSIMOUTRONAO_TEMPORAL
122pos__ccharacter varyingSIMOUTRONAO_TEMPORAL
123notreceivesms__cdouble precisionSIMCOMUNICACAONAO_TEMPORAL
124occupation__ccharacter varyingSIMOUTRONAO_TEMPORAL
125profession__ccharacter varyingSIMOUTRONAO_TEMPORAL
126socioeconomic_level__ccharacter varyingSIMOUTRONAO_TEMPORAL
127stage_of_the_customer_lifecycle__ccharacter varyingSIMCLIENTENAO_TEMPORAL
128et4ae5__hasoptedoutofmobile__cdouble precisionSIMOUTRONAO_TEMPORAL
129et4ae5__mobile_country_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
130exid__ccharacter varyingSIMOUTRONAO_TEMPORAL
131agreestoreceivesurveys__cdouble precisionSIMPESQUISANAO_TEMPORAL
132countrycodemain__ccharacter varyingSIMOUTRONAO_TEMPORAL
133countrycodesecondary__ccharacter varyingSIMOUTRONAO_TEMPORAL
134createcase__cdouble precisionSIMRECLAMACAONAO_TEMPORAL
135donotmail__cdouble precisionSIMOUTRONAO_TEMPORAL
136donotmobilecall__cdouble precisionSIMCOMUNICACAONAO_TEMPORAL
137donotsms__cdouble precisionSIMCOMUNICACAONAO_TEMPORAL
138extension__ccharacter varyingSIMOUTRONAO_TEMPORAL
139infomail__cdouble precisionSIMOUTRONAO_TEMPORAL
140infomobile__cdouble precisionSIMOUTRONAO_TEMPORAL
141infosms__cdouble precisionSIMCOMUNICACAONAO_TEMPORAL
142lastactivitydate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
143maritalstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
144nationality__ccharacter varyingSIMOUTRONAO_TEMPORAL
145nowishgivemailphone__cdouble precisionSIMCONTATONAO_TEMPORAL
146nowishtogivemail__cdouble precisionSIMCONTATONAO_TEMPORAL
147nowishtogiverut__cdouble precisionSIMOUTRONAO_TEMPORAL
148secondarychannelcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
149typespecialattention__cdouble precisionSIMOUTRONAO_TEMPORAL
150updatedbyprotocol__cdouble precisionSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
151cantidad_servicio_producto__cdouble precisionSIMOUTRONAO_TEMPORAL
152hobbies__ccharacter varyingSIMOUTRONAO_TEMPORAL
153document_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
154producto__ccharacter varyingSIMOUTRONAO_TEMPORAL
155scoring__cdouble precisionSIMOUTRONAO_TEMPORAL
156xid_os__ccharacter varyingSIMOUTRONAO_TEMPORAL
157descripcion_producto__ccharacter varyingSIMOUTRONAO_TEMPORAL
158habeas_data__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
159cjagreementcutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
160cjagreementinvoicesdue__cdouble precisionSIMFATURAMENTONAO_TEMPORAL
161cjcustomerrating__cdouble precisionSIMCLIENTENAO_TEMPORAL
162cantidad_beneficiarios_afiliados__cdouble precisionSIMOUTRONAO_TEMPORAL
163cjenergyinvoicesdue__cdouble precisionSIMFATURAMENTONAO_TEMPORAL
164cjlastinvoicedate__ctimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
165cjmodelexecutiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166cjpsvainvoicesdue__cdouble precisionSIMFATURAMENTONAO_TEMPORAL
167cjpaymentprobability__cdouble precisionSIMCOBRANCANAO_TEMPORAL
168cjsuggestion1__ccharacter varyingSIMOUTRONAO_TEMPORAL
169cjsuggestion2__ccharacter varyingSIMOUTRONAO_TEMPORAL
170cjtotaldebt__cdouble precisionSIMOUTRONAO_TEMPORAL
171cjtotalinvoicesdue__cdouble precisionSIMFATURAMENTONAO_TEMPORAL
172cjtotaloverduedebt__cdouble precisionSIMOUTRONAO_TEMPORAL
173cjagreementexecutiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
174cjfinalscore__cdouble precisionSIMOUTRONAO_TEMPORAL
175cjmodelrecommendedperiod__cdouble precisionSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
176cjrecommendedcontactchannel__ccharacter varyingSIMCONTATONAO_TEMPORAL
177cjsenioritydebtdays__cdouble precisionSIMOUTRONAO_TEMPORAL
178cjtotalexpireddebt_c__cdouble precisionSIMOUTRONAO_TEMPORAL
179electrodependent__ccharacter varyingSIMOUTRONAO_TEMPORAL
180cjenergycutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
181cjexceptionablecontact__cdouble precisionSIMCONTATONAO_TEMPORAL
182countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
183lastnameb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
184nowishgiverut__cdouble precisionSIMOUTRONAO_TEMPORAL
185position__ccharacter varyingSIMOUTRONAO_TEMPORAL
186rut__ccharacter varyingSIMOUTRONAO_TEMPORAL
187secondlastname__ccharacter varyingSIMOUTRONAO_TEMPORAL
188is_colombia__ccharacter varyingSIMOUTRONAO_TEMPORAL
189deathdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
190typeofvalidation__ccharacter varyingSIMOUTRONAO_TEMPORAL
191is_peru__ccharacter varyingSIMOUTRONAO_TEMPORAL
192not_useful_contact__cdouble precisionSIMCONTATONAO_TEMPORAL
193cjclaiminprogress__cdouble precisionSIMRECLAMACAONAO_TEMPORAL
194cjpayment__ccharacter varyingSIMCOBRANCANAO_TEMPORAL
195cjsuspendedservice__cdouble precisionSIMORDENSNAO_TEMPORAL
196adviser__cdouble precisionSIMOUTRONAO_TEMPORAL
197autonomy_machine__ccharacter varyingSIMOUTRONAO_TEMPORAL
198cargo__ccharacter varyingSIMOUTRONAO_TEMPORAL
199cluster__cdouble precisionSIMOUTRONAO_TEMPORAL
200contactelectrodependent__ccharacter varyingSIMCONTATONAO_TEMPORAL
201date_registration_update__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
202disease__ccharacter varyingSIMOUTRONAO_TEMPORAL
203documenttype2__ccharacter varyingSIMOUTRONAO_TEMPORAL
204electrodependant_tutor__cdouble precisionSIMOUTRONAO_TEMPORAL
205ggcc__cdouble precisionSIMOUTRONAO_TEMPORAL
206hasfacebook__ccharacter varyingSIMOUTRONAO_TEMPORAL
207hastwitter__ccharacter varyingSIMOUTRONAO_TEMPORAL
208identitynumber2__ccharacter varyingSIMOUTRONAO_TEMPORAL
209identitynumberaux__ccharacter varyingSIMOUTRONAO_TEMPORAL
210identitytypeaux__ccharacter varyingSIMOUTRONAO_TEMPORAL
211people_in_the_house__cdouble precisionSIMOUTRONAO_TEMPORAL
212preocupado_con_el_medio_ambiente__ccharacter varyingSIMOUTRONAO_TEMPORAL
213travel__ccharacter varyingSIMOUTRONAO_TEMPORAL
214type_of_house__ccharacter varyingSIMOUTRONAO_TEMPORAL
215dependency__ccharacter varyingSIMOUTRONAO_TEMPORAL
216cjajuste__ccharacter varyingSIMOUTRONAO_TEMPORAL
217cjats__ccharacter varyingSIMOUTRONAO_TEMPORAL
218cjprocesoespecial__ccharacter varyingSIMOUTRONAO_TEMPORAL
219cjduedate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
220reason_of_removal__ccharacter varyingSIMOUTRONAO_TEMPORAL
221record_removal_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
222registration_date__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
223used_machine__ccharacter varyingSIMOUTRONAO_TEMPORAL
224treating_doctor__ccharacter varyingSIMOUTRONAO_TEMPORAL
225externalusercategory__ccharacter varyingSIMOUTRONAO_TEMPORAL
226email_laboral__ccharacter varyingSIMCONTATONAO_TEMPORAL
227tertiaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
228telefono_laboral_principal__ccharacter varyingSIMOUTRONAO_TEMPORAL
229telefono_laboral_secundario__ccharacter varyingSIMOUTRONAO_TEMPORAL
230movil_laboral__ccharacter varyingSIMOUTRONAO_TEMPORAL
231namecharacter varyingSIMOUTRONAO_TEMPORAL
232phonetype__ccharacter varyingSIMOUTRONAO_TEMPORAL
233concatenatecontacaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
234mcstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
235contact_id__ccharacter varyingSIMCONTATONAO_TEMPORAL
236verification_laboral_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
237verification_principal_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
238verification_secondary_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
239uniqueid__ccharacter varyingSIMOUTRONAO_TEMPORAL
240consentimiento_psva__ccharacter varyingSIMCONTATONAO_TEMPORAL
241uniqueid_status__ccharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_contract

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, REDE_GEO, COMUNICACAO, TEMPORAL

Temporal: True · Colunas temporais: startdate | companysigneddate | customersigneddate | activateddate | lastapproveddate | createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | unsuscribedate__c | enddate | cnt_enddate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (71)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
3currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
4pricebook2idcharacter varyingSIMOUTRONAO_TEMPORAL
5ownerexpirationnoticecharacter varyingSIMOUTRONAO_TEMPORAL
6startdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
7billingstreetcharacter varyingSIMFATURAMENTONAO_TEMPORAL
8billingcitycharacter varyingSIMFATURAMENTONAO_TEMPORAL
9billingstatecharacter varyingSIMFATURAMENTONAO_TEMPORAL
10billingpostalcodecharacter varyingSIMFATURAMENTONAO_TEMPORAL
11billingcountrycharacter varyingSIMFATURAMENTONAO_TEMPORAL
12billinglatitudedouble precisionSIMFATURAMENTONAO_TEMPORAL
13billinglongitudedouble precisionSIMFATURAMENTONAO_TEMPORAL
14billinggeocodeaccuracycharacter varyingSIMFATURAMENTONAO_TEMPORAL
15shippingstreetcharacter varyingSIMOUTRONAO_TEMPORAL
16shippingcitycharacter varyingSIMOUTRONAO_TEMPORAL
17shippingstatecharacter varyingSIMOUTRONAO_TEMPORAL
18shippingpostalcodecharacter varyingSIMOUTRONAO_TEMPORAL
19shippingcountrycharacter varyingSIMOUTRONAO_TEMPORAL
20shippinglatitudedouble precisionSIMREDE_GEONAO_TEMPORAL
21shippinglongitudedouble precisionSIMREDE_GEONAO_TEMPORAL
22shippinggeocodeaccuracycharacter varyingSIMCOMUNICACAONAO_TEMPORAL
23contracttermdouble precisionSIMCONTRATONAO_TEMPORAL
24owneridcharacter varyingSIMOUTRONAO_TEMPORAL
25statuscharacter varyingSIMOUTRONAO_TEMPORAL
26companysignedidcharacter varyingSIMOUTRONAO_TEMPORAL
27companysigneddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
28customersignedidcharacter varyingSIMCLIENTENAO_TEMPORAL
29customersignedtitlecharacter varyingSIMCLIENTENAO_TEMPORAL
30customersigneddatetimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
31specialtermscharacter varyingSIMOUTRONAO_TEMPORAL
32activatedbyidcharacter varyingSIMOUTRONAO_TEMPORAL
33activateddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
34statuscodecharacter varyingSIMOUTRONAO_TEMPORAL
35descriptioncharacter varyingSIMOUTRONAO_TEMPORAL
36recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
37namecharacter varyingSIMOUTRONAO_TEMPORAL
38isdeleteddouble precisionSIMOUTRONAO_TEMPORAL
39contractnumbercharacter varyingSIMCONTRATONAO_TEMPORAL
40lastapproveddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
41createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
42createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
43lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
44lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
45systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
46lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
47contract_type__ccharacter varyingSIMCONTRATONAO_TEMPORAL
48b2wassetid__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
49company_id__ccharacter varyingSIMOUTRONAO_TEMPORAL
50externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
51companyid__ccharacter varyingSIMOUTRONAO_TEMPORAL
52quantity__cdouble precisionSIMOUTRONAO_TEMPORAL
53cdunsuscribe__ccharacter varyingSIMOUTRONAO_TEMPORAL
54ordernumber__ccharacter varyingSIMORDENSNAO_TEMPORAL
55unsuscribedate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
56unsuscribedreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
57enddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
58ismigrated__ccharacter varyingSIMOUTRONAO_TEMPORAL
59loaded_in_billing__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
60opportunity__ccharacter varyingSIMOUTRONAO_TEMPORAL
61automaticunsuscribedreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
62cnt_economical_activity__ccharacter varyingSIMOUTRONAO_TEMPORAL
63cnt_enddate__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
64cnt_externalcontract_id__ccharacter varyingSIMCONTRATONAO_TEMPORAL
65cnt_externalcontract_id_2__ccharacter varyingSIMCONTRATONAO_TEMPORAL
66cnt_generation_capability__ccharacter varyingSIMGDNAO_TEMPORAL
67cnt_tipo_de_fonte_geradora__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_generation_type__ccharacter varyingSIMGDNAO_TEMPORAL
69cnt_luz_provisoria__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_generation_sources__ccharacter varyingSIMGDNAO_TEMPORAL
71cnt_numero_documento_beneficio__ccharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_contract_line

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, RECLAMACAO, ORDENS, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | ederestrictiondate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (34)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2namecharacter varyingSIMOUTRONAO_TEMPORAL
3currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
4recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
5createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
6createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
7lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
8lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
9systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
10lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
11contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
12asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
13billing_profile__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
14quantity__cdouble precisionSIMOUTRONAO_TEMPORAL
15externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
16apportionmentnature__ccharacter varyingSIMOUTRONAO_TEMPORAL
17apportionmentpercentage__cdouble precisionSIMOUTRONAO_TEMPORAL
18associatedcase__ccharacter varyingSIMRECLAMACAONAO_TEMPORAL
19contractlineitem__ccharacter varyingSIMCONTRATONAO_TEMPORAL
20distributiontype__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21documentsattached__cdouble precisionSIMOUTRONAO_TEMPORAL
22ederestrictiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
23ederestrictionreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
24ederestriction__cdouble precisionSIMOUTRONAO_TEMPORAL
25hasapportionment__cdouble precisionSIMOUTRONAO_TEMPORAL
26orderstatus__ccharacter varyingSIMORDENSNAO_TEMPORAL
27pointofdeliveryname__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
28status__ccharacter varyingSIMOUTRONAO_TEMPORAL
29accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
30cnt_status__ccharacter varyingSIMOUTRONAO_TEMPORAL
31cnt_contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
32fecha_de_fin_de_contrato__ccharacter varyingSIMCONTRATONAO_TEMPORAL
33fecha_de_inicio_de_contrato__ccharacter varyingSIMCONTRATONAO_TEMPORAL
34isdeleteddouble precisionSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brce_cus.bt_brce_contract_line_bkp

Empresa
ENEL CE
Tipo
BASE TABLE
Taxonomia
Outros / transversal
Prioridade TI
P1
Família de schema
bi_brxx_cus
Replicação
REPLICA_3_EMPRESAS

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, RECLAMACAO, ORDENS, CONTABIL, TEMPORAL

Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | ederestrictiondate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA

Campos (34)

#CampoTipoNuloConceito sugeridoUso temporal
1idcharacter varyingSIMOUTRONAO_TEMPORAL
2isdeleteddouble precisionSIMOUTRONAO_TEMPORAL
3namecharacter varyingSIMOUTRONAO_TEMPORAL
4currencyisocodecharacter varyingSIMOUTRONAO_TEMPORAL
5recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
6createddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
7createdbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
8lastmodifieddatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
9lastmodifiedbyidcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10systemmodstamptimestamp without time zoneSIMOUTROEVENTO_OU_VIGENCIA
11lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
12contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
13asset__ccharacter varyingSIMMEDIDORNAO_TEMPORAL
14billing_profile__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
15quantity__cdouble precisionSIMOUTRONAO_TEMPORAL
16externalid__ccharacter varyingSIMOUTRONAO_TEMPORAL
17apportionmentnature__ccharacter varyingSIMOUTRONAO_TEMPORAL
18apportionmentpercentage__cdouble precisionSIMOUTRONAO_TEMPORAL
19associatedcase__ccharacter varyingSIMRECLAMACAONAO_TEMPORAL
20contractlineitem__ccharacter varyingSIMCONTRATONAO_TEMPORAL
21distributiontype__ccharacter varyingSIMCONTABILNAO_TEMPORAL
22documentsattached__cdouble precisionSIMOUTRONAO_TEMPORAL
23ederestrictiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
24ederestrictionreason__ccharacter varyingSIMOUTRONAO_TEMPORAL
25ederestriction__cdouble precisionSIMOUTRONAO_TEMPORAL
26hasapportionment__cdouble precisionSIMOUTRONAO_TEMPORAL
27orderstatus__ccharacter varyingSIMORDENSNAO_TEMPORAL
28pointofdeliveryname__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
29status__ccharacter varyingSIMOUTRONAO_TEMPORAL
30accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
31cnt_status__ccharacter varyingSIMOUTRONAO_TEMPORAL
32cnt_contract__ccharacter varyingSIMCONTRATONAO_TEMPORAL
33fecha_de_fin_de_contrato__ccharacter varyingSIMCONTRATONAO_TEMPORAL
34fecha_de_inicio_de_contrato__ccharacter varyingSIMCONTRATONAO_TEMPORAL