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.bt_brce_contratobi_brce_cus.bt_brce_dados_contato_cruzamentobi_brce_cus.bt_brce_despersonalizadobi_brce_cus.bt_brce_despersonalizado_bk20220531bi_brce_cus.bt_brce_dim_cr_faturabi_brce_cus.bt_brce_efatura_gabi_brce_cus.bt_brce_efatura_gbbi_brce_cus.bt_brce_equipamentobi_brce_cus.bt_brce_gd_instalacaobi_brce_cus.bt_brce_implantados_mesbi_brce_cus.bt_brce_indicadores_cadastrobi_brce_cus.bt_brce_instalacaobi_brce_cus.bt_brce_kpis_qualidade_osbi_brce_cus.bt_brce_mega_base_follow_upbi_brce_cus.bt_brce_mj_ruraisbi_brce_cus.bt_brce_orderbi_brce_cus.bt_brce_padronizacao_ucbi_brce_cus.bt_brce_pointofdeliverybi_brce_cus.bt_brce_relatorio_de_cadastrobi_brce_cus.bt_brce_relatorio_de_cadastro_add
bi_brce_cus.bt_brce_contrato
Tags semânticas: INSTALACAO, CONTRATO, FATURAMENTO, COMUNICACAO, TEMPORAL
Temporal: True · Colunas temporais: data_ligacao | data_criacao | data_modificacao | data_desligamento · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (30)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | contrato | bigint | SIM | CONTRATO | NAO_TEMPORAL |
| 2 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | conta_contrato | bigint | SIM | CONTRATO | NAO_TEMPORAL |
| 4 | data_ligacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 5 | data_desligamento | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | empresa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | empresa_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | carac_det_ctas | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | carac_det_ctas_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | contrato_conjunto | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 11 | contrato_conjunto_texto | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 12 | domicilio_fiscal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | domicilio_fiscal_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | exclusao_calculo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | exclusao_calculo_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | divisao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | divisao_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | classe_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 19 | classe_contrato_texto | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 20 | procedimento_advertencia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | procedimento_advertencia_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | motivo_bloqueio_adv | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | motivo_bloqueio_adv_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | motivo_bloqueio_calculo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | motivo_bloqueio_calculo_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | fatura_osb | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 27 | data_criacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 28 | nome_criacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | data_modificacao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 30 | nome_modificacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_dados_contato_cruzamento
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, CONTATO, TEMPORAL
Temporal: True · Colunas temporais: dataprocess · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (10)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 3 | asset_id | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 4 | account_id | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | cnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | cpf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | tel_fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | tel_celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 9 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 10 | dataprocess | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
bi_brce_cus.bt_brce_despersonalizado
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | 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 (181)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cpnj_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 178 | classe_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 179 | subclasse_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 180 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 181 | dica_localizacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_despersonalizado_bk20220531
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | cnt_due_date__c | 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 (176)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cpnj_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_dim_cr_fatura
Tags semânticas: CLIENTE, CONTRATO, FATURAMENTO, COBRANCA, PERDAS, COMUNICACAO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: ref | dt_faturamento | 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 (24)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | empresa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | ref | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 3 | numero_cliente | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 4 | no_nota_fiscal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | corr_fatura | integer | SIM | FATURAMENTO | NAO_TEMPORAL |
| 6 | tipo_doc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | contrcoletivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | doc_fat_coletivo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 10 | ref_fat | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | dt_faturamento | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 12 | dt_vencimento | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 13 | pend_judicial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | pend_bancaria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | toi | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 16 | pdd | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 17 | castigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | total_fatura | numeric | SIM | FATURAMENTO | NAO_TEMPORAL |
| 19 | cota_parcelamento | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 20 | total_toi | numeric | SIM | PERDAS | NAO_TEMPORAL |
| 21 | total_terceiros | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 22 | detalhe_divida | integer | SIM | COBRANCA | NAO_TEMPORAL |
| 23 | antig | integer | SIM | OUTRO | NAO_TEMPORAL |
| 24 | ano_mes_selecao | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_efatura_ga
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, LEITURA, FATURAMENTO, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: data_de_abertura | data_do_clique | data_de_vencimento | data_de_emissao | referencia_da_fatura | data_contato_atualizado | data_disparo | referencia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (34)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | grupo_de_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 3 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | nome_do_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 7 | enviado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | abertura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 9 | data_de_abertura | character varying | SIM | COMUNICACAO | EVENTO_OU_VIGENCIA |
| 10 | nome_do_executivo_da_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | clique | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | data_do_clique | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | bounce_categoria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | bounce_subcategoria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 16 | data_de_vencimento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | data_de_emissao | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 18 | valor_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 19 | numero_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 20 | url_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 21 | referencia_da_fatura | character varying | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 22 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 23 | bp_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | invoice_id | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 25 | pointofdelivery_id | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 26 | bpc_id | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 27 | data_contato_atualizado | character varying | SIM | CONTATO | EVENTO_OU_VIGENCIA |
| 28 | data_disparo | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 29 | lote | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | unidadeleitura | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 31 | bounces_3meses | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | status_mc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | status_email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | referencia | bigint | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_efatura_gb
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, LEITURA, FATURAMENTO, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: data_de_abertura | data_do_clique | data_de_vencimento | data_de_emissao | referencia_da_fatura | data_contato_atualizado | data_disparo | referencia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (34)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | grupo_de_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 3 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | nome_do_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 5 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 7 | enviado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | abertura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 9 | data_de_abertura | character varying | SIM | COMUNICACAO | EVENTO_OU_VIGENCIA |
| 10 | nome_do_executivo_da_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | clique | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | data_do_clique | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | bounce_categoria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | bounce_subcategoria | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 16 | data_de_vencimento | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 17 | data_de_emissao | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 18 | valor_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 19 | numero_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 20 | url_da_fatura | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 21 | referencia_da_fatura | character varying | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 22 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 23 | bp_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | invoice_id | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 25 | pointofdelivery_id | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 26 | bpc_id | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 27 | data_contato_atualizado | character varying | SIM | CONTATO | EVENTO_OU_VIGENCIA |
| 28 | data_disparo | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 29 | lote | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | unidadeleitura | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 31 | bounces_3meses | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | status_mc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | status_email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | referencia | bigint | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_equipamento
Tags semânticas: INSTALACAO, MEDIDOR, TEMPORAL
Temporal: True · Colunas temporais: validade_de_etdz | validade_de_egerr | validade_de_easts | validade_ate_etdz | validade_ate_egerr | validade_ate_easts | data_criacao_etdz | data_modificacao_etdz | data_criacao_egerr | data_modificacao_egerr | data_criacao_easts | data_modificacao_easts · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (48)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | cod_equipamento | bigint | SIM | MEDIDOR | NAO_TEMPORAL |
| 2 | registrador | integer | SIM | OUTRO | NAO_TEMPORAL |
| 3 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | validade_de_etdz | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 5 | validade_de_egerr | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 6 | validade_de_easts | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 7 | validade_ate_etdz | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 8 | validade_ate_egerr | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 9 | validade_ate_easts | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 10 | num_registrador | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 11 | num_equipamento | bigint | SIM | MEDIDOR | NAO_TEMPORAL |
| 12 | num_serie | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | tipo_setor | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | tipo_setor_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | ind_registrador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | ind_registrador_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | cod_ind_registrador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | tipo_registrador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | tipo_registrador_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | conf_antes_virgula_registrador | integer | SIM | OUTRO | NAO_TEMPORAL |
| 21 | conf_depois_virgula_registrador | integer | SIM | OUTRO | NAO_TEMPORAL |
| 22 | tipo_registrador_2 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | tipo_registrador_2_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | tipo_energia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | tipo_energia_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | unidade_medida | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | unidade_medida_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | fator_registrador | numeric | SIM | OUTRO | NAO_TEMPORAL |
| 29 | grupo_registrador | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | num_material | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | tipo_equipamento | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 32 | num_serie_fabricante | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | fabricante_imobilizado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | flag_relevante_calc | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | tipo_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | tipo_tarifa_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | data_criacao_etdz | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 38 | nome_criacao_etdz | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | data_modificacao_etdz | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | nome_modificacao_etdz | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | data_criacao_egerr | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 42 | nome_criacao_egerr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | data_modificacao_egerr | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 44 | nome_modificacao_egerr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | data_criacao_easts | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 46 | nome_criacao_easts | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | data_modificacao_easts | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 48 | nome_modificacao_easts | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_gd_instalacao
Tags semânticas: INSTALACAO, PERDAS, TEMPORAL
Temporal: True · Colunas temporais: data_do_protocolo | data_ligacao_uc | data_projeto_inicio | data_projeto_encerramento | data_direito_adquirido | data_perda_do_direito_adquirido | data_regra_de_transicao | data_irregularidade | data_processamento · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (15)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | data_do_protocolo | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 3 | data_ligacao_uc | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 4 | tipo_de_projeto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | data_projeto_inicio | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 6 | data_projeto_encerramento | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 7 | flag_direito_adquirido | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | data_direito_adquirido | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | flag_perda_do_direito_adquirido | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 10 | data_perda_do_direito_adquirido | timestamp without time zone | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 11 | flag_regra_de_transicao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | data_regra_de_transicao | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | flag_irregularidade | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 14 | data_irregularidade | timestamp without time zone | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 15 | data_processamento | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
bi_brce_cus.bt_brce_implantados_mes
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | 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 (181)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cpnj_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 178 | classe_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 179 | subclasse_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 180 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 181 | dica_localizacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_indicadores_cadastro
Tags semânticas: INSTALACAO, CLIENTE, FATURAMENTO, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL
Temporal: True · Colunas temporais: dia · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (19)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | companyid_c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dia | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 3 | dash | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 5 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | clientesativos | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 10 | despersonalizados | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 11 | telefone | bigint | SIM | CONTATO | NAO_TEMPORAL |
| 12 | celular | bigint | SIM | CONTATO | NAO_TEMPORAL |
| 13 | fixo | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 14 | email | bigint | SIM | CONTATO | NAO_TEMPORAL |
| 15 | suficientes | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 16 | cpf | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 17 | cnpj | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 18 | electrodependant__c | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 19 | faturadigital | bigint | SIM | FATURAMENTO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_instalacao
Tags semânticas: INSTALACAO, CONTRATO, LEITURA, FATURAMENTO, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: validade_de | data_criacao_eanl | data_modificacao_eanl | data_criacao_evbs | data_modificacao_evbs | data_criacao_iflot | data_modificacao_iflot | validade_ate · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (57)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | validade_de | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 3 | validade_ate | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 4 | setor_atividade | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | setor_atividade_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | nivel_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | nivel_tensao_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | tipo_instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 9 | tipo_instalacao_texto | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 10 | motivo_garantia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | motivo_garantia_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | categoria_tarifa_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | sistema_setorial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | sistema_setorial_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | setor_industrial_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | classe_calculo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | classe_calculo_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | subclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | subclasse_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | segmento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | contrato_concessao | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 24 | unidade_leitura | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 25 | lote | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 28 | objeto_ligacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | local_classe_contabil | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 30 | endereco | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | pais | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | regiao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | cidade | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 34 | bairro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | codigo_postal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 37 | numero | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 38 | complemento_01 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 39 | complemento_02 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | numero_local_instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 41 | complemento_03 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | complemento_04 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | complemento_05 | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | domicilio_fiscal | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | domicilio_fiscal_texto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | data_criacao_eanl | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 47 | nome_criacao_eanl | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | data_modificacao_eanl | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 49 | nome_modificacao_eanl | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | data_criacao_evbs | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 51 | nome_criacao_evbs | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | data_modificacao_evbs | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | nome_modificacao_evbs | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | data_criacao_iflot | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | nome_criacao_iflot | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | data_modificacao_iflot | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 57 | nome_modificacao_iflot | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_kpis_qualidade_os
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 (54)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | seqid | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 2 | distribuidora | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | instalacao | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | assetid | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 5 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 6 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 7 | nome | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | nome_mae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | dt_nascimento | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 10 | cpf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | cpf_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 12 | cnpj | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | cnpj_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | inscricao_estadual | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | isento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 16 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 17 | email_n | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 18 | tel_celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 19 | tel_celular_n | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 20 | tel_fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 21 | tel_fixo_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 22 | logradouro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 23 | logradouro_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | numero | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 25 | numero_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | complemento | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | complemento_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | bairro | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | bairro_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 31 | municipio_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 32 | municipio_alt | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 33 | municipio_alt_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 34 | uf | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 35 | uf_alt | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 36 | cep | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 37 | cep_obs | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 38 | cep_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 39 | cep_alt | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 40 | cep_alt_obs | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 41 | cep_alt_n | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 42 | cnae | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 43 | cnae_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | subclasse_codigo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 45 | classe_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 46 | subclasse_n | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | entrega_alt | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 49 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | resultado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | valor_correto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | acao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | dt_processamento | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
| 54 | dt_processamento_yyyymm | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
bi_brce_cus.bt_brce_mega_base_follow_up
Tags semânticas: CLIENTE, MEDIDOR, FATURAMENTO, PERDAS, REDE_GEO, COMUNICACAO, TEMPORAL, ATUALIZACAO, COMPETENCIA
Temporal: True · Colunas temporais: data_normalizacao | referencia_normalizacao | referencia_fatura_anterior | referencia_fatura_atual | data_insert | data_ingesta | referencia_follow_up · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (37)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | cliente_id | integer | SIM | CLIENTE | NAO_TEMPORAL |
| 2 | codigo_pod | integer | SIM | OUTRO | NAO_TEMPORAL |
| 3 | nivel_tensao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | lote | integer | SIM | OUTRO | NAO_TEMPORAL |
| 6 | tipo_medicao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | tipo_de_ligacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | classe | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | subclasse | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 10 | estado | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | municipio_ibge | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 12 | municipio | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 13 | regional | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 14 | unid_operacional | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | sucursal | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 16 | normalizacao_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 17 | medidor_inspecionado_id | integer | SIM | MEDIDOR | NAO_TEMPORAL |
| 18 | tipo_medidor | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 19 | inspecao_origem_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 20 | inspecao_origem_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 21 | inspecao_tipo_policy | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 22 | data_normalizacao | character varying | SIM | PERDAS | EVENTO_OU_VIGENCIA |
| 23 | equipe_normalizacao_desc | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 24 | equipe_normalizacao_id | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 25 | referencia_normalizacao | integer | SIM | PERDAS | COBERTURA_HISTORICA |
| 26 | referencia_follow_up | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
| 27 | origem_fup | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 28 | subcluster | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | projeto | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | status | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | referencia_fatura_anterior | character varying | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 32 | referencia_fatura_atual | character varying | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 33 | energia_total_anterior | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 34 | energia_total_atual | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 35 | calculo_final | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 36 | data_insert | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 37 | data_ingesta | character varying | SIM | ATUALIZACAO_CARGA | ATUALIZACAO_FISICA |
bi_brce_cus.bt_brce_mj_rurais
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | 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 (181)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | double precision | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | double precision | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cpnj_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 178 | classe_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 179 | subclasse_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 180 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 181 | dica_localizacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_order
Tags semânticas: CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, PERDAS, ORDENS, CONTATO, REDE_GEO, COMUNICACAO, TEMPORAL
Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | lastactivitydate | lastvieweddate | lastreferenceddate | ne__delivery_date__c | ne__order_date__c | ne__payback_saved_date__c | ne__point_of_non_return__c | client_birthdate__c | firstdate__c | realdate__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (154)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | id | character varying | NÃO | OUTRO | NAO_TEMPORAL |
| 2 | ownerid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | isdeleted | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 4 | name | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | currencyisocode | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | createddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | createdbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | lastmodifieddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | lastmodifiedbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | systemmodstamp | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 12 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 13 | lastvieweddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 14 | lastreferenceddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 15 | ne__accountid__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 16 | ne__address_line1__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | ne__address_line2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | ne__address_line3__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | ne__arrearage_percentage__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | ne__assetenterprisecalc__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 21 | ne__assetenterpriseid__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 22 | ne__assetstatuscalc__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 23 | ne__asset_account__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 24 | ne__asset_configuration__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 25 | ne__asset__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 26 | ne__billaccid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | ne__billingprofid__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 28 | ne__billingregion__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 29 | ne__billing_account_asset__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 30 | ne__catalogid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | ne__channel__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | ne__city__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | ne__commercialmodelid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | ne__configurationstatus__c | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 35 | ne__configuration_subtype__c | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 36 | ne__configuration_type__c | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 37 | ne__contract_account__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 38 | ne__contract_header__c | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 39 | ne__country_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 40 | ne__country__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 41 | ne__currencycode__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 42 | ne__delivery_date__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 43 | ne__description__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 44 | ne__factor_annual_depreciation_equipment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 45 | ne__factor_annual_depreciation_infrastructur__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 46 | ne__factor_commission_security_family__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 47 | ne__fulfilmentstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | ne__geolocalization__latitude__s | double precision | SIM | REDE_GEO | NAO_TEMPORAL |
| 49 | ne__geolocalization__longitude__s | double precision | SIM | REDE_GEO | NAO_TEMPORAL |
| 50 | ne__geolocalization__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 51 | ne__income_tax_percentage__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 52 | ne__management_committee_percentage__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 53 | ne__monthly_discount_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 54 | ne__months_return_of_investiment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 55 | ne__one_time_fee_total__c | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 56 | ne__opportunityid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 57 | ne__optyid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 58 | ne__orderstatus__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 59 | ne__order_header__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 60 | ne__order_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 61 | ne__parameters__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 62 | ne__parent_order__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 63 | ne__payback_saved_by__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | ne__payback_saved_date__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 65 | ne__payback_status__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | ne__payback__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 67 | ne__point_of_non_return__c | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 68 | ne__postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 69 | ne__promotion_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | ne__province__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | ne__quote__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | ne__recurring_charge_total__c | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 73 | ne__serialnum__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | ne__servaccid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | ne__service_account_asset__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 76 | ne__shippingregion__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | ne__shipping_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | ne__shipping_city__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 79 | ne__shipping_country__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | ne__shipping_state_province__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 81 | ne__shipping_street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 82 | ne__shipping_zip_postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 83 | ne__state_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 84 | ne__state__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | ne__street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 86 | ne__sync_oppty__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 87 | ne__totalrecurringfrequency__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 88 | ne__type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 89 | ne__url_payback__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | ne__van__c | bigint | SIM | OUTRO | NAO_TEMPORAL |
| 91 | ne__van_on_cost__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 92 | ne__version__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 93 | ne__zip_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 94 | ne__rtypename__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 95 | approval_status__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 96 | approved__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 97 | billing_profile__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 98 | selectedcompany__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 99 | shipping_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 101 | point_of_delivery__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 102 | anular__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 103 | anulated__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 104 | approved_to_bill__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 105 | company__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 106 | country__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 107 | intentos_de_envio__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 108 | pod__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | step_1__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 110 | step_2__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 111 | need_delivery__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | address_delivery__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | approval_checkpoint__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 114 | channelsales__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | client_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | client_age__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 117 | client_birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 118 | client_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 119 | client_identity_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | client_identity_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | client_mobilephone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 122 | client_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 123 | client_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 124 | contact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 125 | email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 126 | firstdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 127 | identificationcardtechnical__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | identity_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | location__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 130 | loss_reason__c | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 131 | mobil__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 133 | n_mero_de_factura__c | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 134 | nametec__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 135 | name_of_the_road__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 136 | neighborhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 137 | numero_de_autorizaci_n_redeban__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 138 | observations__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 139 | product__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 140 | producto__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | realdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 142 | region_delivery__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | statedelivery__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | substage__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 146 | time_slot__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | tipo_de_persona__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | delivery_status__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | devolution_causal__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 152 | print__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 153 | recordtypeaux__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | podnumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_padronizacao_uc
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, ORDENS, SOCIAL, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: createddate_pod | createddate_asset | data_foto_yyyymmdd · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (20)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | CNPJDistribuidora | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | NumUCInstAntePadr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | NumUCInstAposPadr | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 4 | Status | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | pod_id__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | createddate_pod | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 9 | createddate_asset | character varying | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 10 | id_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 11 | conta_contrato_salesforce | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 12 | grupo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | numero_cliente_synergia | bigint | SIM | CLIENTE | NAO_TEMPORAL |
| 14 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 15 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 16 | numero_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 17 | estado_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 18 | tipo_ordem | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 19 | tipo_servico | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 20 | data_foto_yyyymmdd | character varying | SIM | COMPETENCIA_REFERENCIA | COBERTURA_HISTORICA |
bi_brce_cus.bt_brce_pointofdelivery
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, LEITURA, FATURAMENTO, COBRANCA, PERDAS, RECLAMACAO, ORDENS, GD, CONTATO, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, RISCO, TEMPORAL, COMPETENCIA
Temporal: True · Colunas temporais: createddate | createdbyid | lastmodifieddate | lastmodifiedbyid | systemmodstamp | cutoffdate__c | manufacturing_date__c | agreementrestrictiondate__c | billingperiod__c | cutrestrictiondate__c | tcestimatedendtime__c | allows_the_use_of_data__c | agreementrestrictionenddate__c | billing_period_indicator__c | createcollectionchargesrestdate__c | createcollectionchargesrestenddate__c | createsuspensioninsuranceorderrestdate__c | createsuspensioninsuranceorderrestenddat__c | create_financial_services_rest_date__c | create_financial_services_rest_end_date__c | create_order_reconnection_rest_date__c | create_order_reconnection_rest_end_date__c | cutoffdatepe__c | cutrestrictionenddate__c | notificationdate__c | pusserdate__c | retirementdate__c | inscriptiondatesic__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS
Cobertura nominal: a · Cobertura real: NAO_MEDIDO a NAO_MEDIDO · Última carga: NAO_MEDIDA
Campos (208)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | id | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 2 | ownerid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 3 | isdeleted | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 4 | name | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 5 | currencyisocode | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 6 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 7 | createddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 8 | createdbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 9 | lastmodifieddate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | lastmodifiedbyid | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 11 | systemmodstamp | timestamp without time zone | SIM | OUTRO | EVENTO_OU_VIGENCIA |
| 12 | ballotname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | block__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | companyid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 16 | condominiumsector__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 17 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 18 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 19 | branchoffice__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 20 | customerrating__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 21 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 22 | cuttingdebt__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 23 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 24 | dangerzone__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 25 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 26 | disciplinarymeasure__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 27 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 28 | electricalsubstationconnection__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | fullelectric__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | grouptype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 33 | housetype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 34 | meterbrand__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 35 | metermodel__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 36 | meternumber__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 37 | meterproperty__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 38 | metertype__c | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | municipalityallocation__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 40 | navigationcontactid__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 41 | networkconnectionpoint__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 42 | opencases__c | double precision | SIM | RECLAMACAO | NAO_TEMPORAL |
| 43 | paymentprocess__c | double precision | SIM | COBRANCA | NAO_TEMPORAL |
| 44 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 45 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 46 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 47 | rationingschedule__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 48 | readingprocess__c | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 49 | readingtype__c | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 50 | repeatedcases__c | double precision | SIM | RECLAMACAO | NAO_TEMPORAL |
| 51 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 52 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 53 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 54 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 55 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | transformertype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 57 | vip__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 58 | company__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 59 | country__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 60 | externalid__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | key__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 62 | sed__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | set__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | market__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | power__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | service_subclass__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 67 | massbreakdown__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 68 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 69 | manufacturing_date__c | double precision | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 70 | agreementrestrictiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 71 | agreementrestrictionreason__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | agreementrestriction__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 73 | asigncondominiumpod__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 74 | billingperiod__c | character varying | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 75 | clientqueries__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 76 | condominium__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | createcase__c | double precision | SIM | RECLAMACAO | NAO_TEMPORAL |
| 78 | cutrestrictiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 79 | cutrestrictionreason__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | cutrestriction__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 81 | hasapportionment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 82 | iscommonservice__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 83 | newclientmeasure__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 84 | populated_center__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 85 | reading_route__c | character varying | SIM | LEITURA | NAO_TEMPORAL |
| 86 | scheduledcut__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 87 | sge_active__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 88 | cnt_cnr__c | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 89 | splicetype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 90 | winterlimit__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | operationalcenter__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | massivebreakdown__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 93 | sacnumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 94 | load__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 95 | tcestimatedendtime__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 96 | podsec__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 97 | electricalsubstation__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 98 | podinbuilding__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 99 | ratetype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 100 | allows_the_use_of_data__c | double precision | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 101 | pod_id__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 102 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 103 | cuttingreason__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 104 | agreementrestrictionenddate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 105 | agreement_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 106 | balance_in_dispute_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 107 | billing_period_indicator__c | double precision | SIM | FATURAMENTO | COBERTURA_HISTORICA |
| 108 | branch__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 109 | businessline__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 110 | bussinesline__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | ciiu_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | cnr_indicator__c | double precision | SIM | PERDAS | NAO_TEMPORAL |
| 113 | central_risk_indicator__c | double precision | SIM | RISCO | NAO_TEMPORAL |
| 114 | cicle__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 115 | collectionstatus__c | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 116 | constraint_agreement_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 117 | createcollectionchargesrestdate__c | timestamp without time zone | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 118 | createcollectionchargesrestenddate__c | timestamp without time zone | SIM | COBRANCA | EVENTO_OU_VIGENCIA |
| 119 | createsuspensioninsuranceorderrestdate__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 120 | createsuspensioninsuranceorderrestenddat__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 121 | createsuspensioninsuranceorderrestreason__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 122 | createsuspensioninsuranceorderrestrition__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 123 | create_collection_charges_rest_reason__c | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 124 | create_collection_charges_restriction__c | double precision | SIM | COBRANCA | NAO_TEMPORAL |
| 125 | create_financial_services_rest_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 126 | create_financial_services_rest_end_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 127 | create_financial_services_rest_reason__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 128 | create_financial_services_restriction__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 129 | create_order_reconnection_rest_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 130 | create_order_reconnection_rest_end_date__c | timestamp without time zone | SIM | ORDENS | EVENTO_OU_VIGENCIA |
| 131 | create_order_reconnection_rest_reason__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 132 | create_order_reconnection_restriction__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 133 | create_suspension_order__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 134 | cutoffdatepe__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 135 | cutrestrictionenddate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 136 | cutting_restrictions_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 137 | electricalconnection__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 138 | essential_loads__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 139 | financial_services_restriction_indicator__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 140 | ggcc__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 141 | invoicenumber__c | double precision | SIM | FATURAMENTO | NAO_TEMPORAL |
| 142 | lote_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | notificationdate__c | timestamp without time zone | SIM | COMUNICACAO | EVENTO_OU_VIGENCIA |
| 144 | observations_agreement__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | observations_collection_charges__c | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 146 | observations_financial_services__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 147 | observations_order_reconnection__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 148 | observations_suspension_insurance_order__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 149 | observations__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | partner__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 151 | payment_in_progress_indicator__c | character varying | SIM | COBRANCA | NAO_TEMPORAL |
| 152 | prefcontactchannel__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 153 | punished_indicator__c | double precision | SIM | SOCIAL | NAO_TEMPORAL |
| 154 | pusserdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 155 | reconnect_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 156 | reinstated_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 157 | restriction_collection_charges_indicator__c | double precision | SIM | COBRANCA | NAO_TEMPORAL |
| 158 | restriction_insured_order_suspension_ind__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 159 | restriction_order_of_reconnection_indica__c | double precision | SIM | ORDENS | NAO_TEMPORAL |
| 160 | retirementdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 161 | return_check_indicator__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 162 | splicecapacity__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 163 | splicepower__c | double precision | SIM | REDE_GEO | NAO_TEMPORAL |
| 164 | stratus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | toidebt__c | double precision | SIM | PERDAS | NAO_TEMPORAL |
| 166 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 167 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 168 | cnt_continuous_operation_power_unit__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 169 | cnt_contract__c | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 170 | cnt_debt__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | cnt_electrodependant_origin__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | cnt_electrodependant_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 173 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 174 | cnt_geracao_distribuida__c | character varying | SIM | GD | NAO_TEMPORAL |
| 175 | cnt_operating_range_of_power_unit__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 176 | cnt_people__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 177 | cnt_percentual_de_participacao__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 178 | cnt_physical_space_for_power_unit__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 179 | cnt_posibility_of_relocation__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 180 | cnt_potency_of_power_unit__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 181 | cnt_sensitive_customer__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 182 | cnt_uniqueaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 183 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 184 | cnt_fpointofdelivery_number__c | double precision | SIM | INSTALACAO | NAO_TEMPORAL |
| 185 | electrodependant_document_number__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 186 | legal_check__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 187 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 188 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 189 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 190 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 191 | client_segment_type2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 192 | segment_type2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 193 | average_active_consumption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 194 | average_reactive_consumption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 195 | technicalzone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 196 | marketer__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 197 | transformer_property__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 198 | cnt_voltage__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 199 | sic_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 200 | inpectionnumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 201 | frontiertype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 202 | inscriptiondatesic__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 203 | enel_attention_executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 204 | pointofdeliveryaddress__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 205 | client_segment_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 206 | literalnetworktype__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 207 | reporttoid__c | character varying | SIM | PERDAS | NAO_TEMPORAL |
| 208 | contract_type__c | character varying | SIM | CONTRATO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_relatorio_de_cadastro
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, SOCIAL, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | 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 (183)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | integer | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | integer | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | integer | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | integer | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | integer | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cpnj_valido | integer | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | integer | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 178 | classe_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 179 | subclasse_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 180 | estado_suministro | character varying | SIM | SOCIAL | NAO_TEMPORAL |
| 181 | dica_localizacao | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 182 | cnt_numero_documento_beneficio__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 183 | uc_unico_id | character varying | SIM | OUTRO | NAO_TEMPORAL |
bi_brce_cus.bt_brce_relatorio_de_cadastro_add
Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, ORDENS, GD, CONTATO, QUALIDADE, REDE_GEO, COMUNICACAO, CONTABIL, TEMPORAL
Temporal: True · Colunas temporais: createddate_pointofdelivery | cutoffdate__c | createddate_asset | lastmodifieddate_asset | installdate | createddate_account | lastmodifieddate_account | lastactivitydate | birthdate__c | createddate_billing_profile | cnt_due_date__c | suscriptiondate__c | startdate_contract | activateddate_contract | createddate_contract | lastmodifieddate_contract | enddate_contract | mainphone__c_datamodif | secondaryphone__c_datamodif | additionalphone__c_datamodif | 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 (181)
| # | Campo | Tipo | Nulo | Conceito sugerido | Uso temporal |
|---|---|---|---|---|---|
| 1 | pointofdeliverynumber__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 2 | dvnumberpointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 3 | id_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 4 | createddate_pointofdelivery | timestamp without time zone | SIM | INSTALACAO | EVENTO_OU_VIGENCIA |
| 5 | companyid__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 6 | billing_type__c | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 7 | connectionstatus__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 8 | connectiontype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 9 | cutoffdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 10 | electrodependant__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 11 | pointofdeliverystatus__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 12 | rate__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 13 | route__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 14 | segmenttype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 15 | servicetype__c | character varying | SIM | ORDENS | NAO_TEMPORAL |
| 16 | company__c_pointofdelivery | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 17 | vip_customer_indicator__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 18 | cnt_free_client__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 19 | cnt_white_rate__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 20 | distributionaddress__c | character varying | SIM | CONTABIL | NAO_TEMPORAL |
| 21 | notificationcontact__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 22 | cnt_lowincometype__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 23 | zone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 24 | blacklist__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 25 | cnt_isgd__c | character varying | SIM | GD | NAO_TEMPORAL |
| 26 | municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 27 | network_type__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 28 | detailaddress__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 29 | feedernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 30 | transformername__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 31 | transformernumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 32 | id_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 33 | contactid | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 34 | accountid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 35 | accountrollupid | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 36 | createddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 37 | lastmodifieddate_asset | timestamp without time zone | SIM | MEDIDOR | EVENTO_OU_VIGENCIA |
| 38 | name_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 39 | installdate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 40 | status_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 41 | description_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 42 | type__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 43 | company__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 44 | externalid__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 45 | ne__status__c_asset | character varying | SIM | MEDIDOR | NAO_TEMPORAL |
| 46 | id_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 47 | name_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 48 | accountnumber | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 49 | tipo_conta | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 50 | createddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 51 | lastmodifieddate_account | timestamp without time zone | SIM | CLIENTE | EVENTO_OU_VIGENCIA |
| 52 | lastactivitydate | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 53 | additionalphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 54 | birthdate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 55 | businessname__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 56 | companyid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 57 | company__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 58 | externalid__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 59 | ne__status__c_account | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 60 | countryb2b__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 61 | accountclientnumber__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 62 | pais__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 63 | executive__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 64 | cnt_responsible_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 65 | cnt_resp_id_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 66 | cnt_resp_id_number__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 67 | cnt_responsible_phone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 68 | cnt_responsible_email__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 69 | cnt_responsible_charge__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 70 | cnt_numorgcntr__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 71 | cnt_fantasy_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 72 | recordtypeid | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 73 | cnt_mothers_full_name__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 74 | cnt_id_type_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 75 | cnt_id_num_2__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 76 | cnt_state_inscription__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 77 | cnt_state_inscription_exemption__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 78 | cnt_municipality_inscription__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 79 | cnt_is_postal_address__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 80 | acceptenelcommunication__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 81 | cnt_customerchannel__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 82 | id_contract__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 83 | id_billing_profile__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 84 | id_asset__c_contract_line | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 85 | pointofdelivery__c | character varying | SIM | INSTALACAO | NAO_TEMPORAL |
| 86 | accountcontract__c | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 87 | currentaccount__c | double precision | SIM | CLIENTE | NAO_TEMPORAL |
| 88 | createddate_billing_profile | timestamp without time zone | SIM | FATURAMENTO | EVENTO_OU_VIGENCIA |
| 89 | name_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 90 | edeenrolment__c | double precision | SIM | OUTRO | NAO_TEMPORAL |
| 91 | delivery_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 92 | cnt_due_date__c | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 93 | edesuscmassive__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 94 | publiccharge__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 95 | lowamount__c | boolean | SIM | OUTRO | NAO_TEMPORAL |
| 96 | type__c_billing_profile | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 97 | suscriptiondate__c | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 98 | id_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 99 | startdate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 100 | activateddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 101 | createddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 102 | lastmodifieddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 103 | enddate_contract | timestamp without time zone | SIM | CONTRATO | EVENTO_OU_VIGENCIA |
| 104 | status_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 105 | description_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 106 | statuscod_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 107 | contractnumber_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 108 | contract_type__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 109 | cnt_economical_activity__c_contract | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 110 | coordinatex__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 111 | coordinatey__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 112 | id_adress | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 113 | literal_municipality__c | character varying | SIM | REDE_GEO | NAO_TEMPORAL |
| 114 | literal_region__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 115 | literal_street_type__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 116 | neighbourhood__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 117 | postal_code__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 118 | street__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 119 | idstreet | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 120 | identitytype__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 121 | clienteativo | integer | SIM | CLIENTE | NAO_TEMPORAL |
| 122 | despersonalizado | integer | SIM | OUTRO | NAO_TEMPORAL |
| 123 | celular | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 124 | fixo | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 125 | com_telefone | integer | SIM | CONTATO | NAO_TEMPORAL |
| 126 | email | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 127 | mainphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 128 | secondaryphone__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 129 | primaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 130 | secondaryemail__c | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 131 | identitynumber__c | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 132 | primaryemail__c_validacao | integer | SIM | CONTATO | NAO_TEMPORAL |
| 133 | secondaryemail__c_dominio | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 134 | secondaryemail__c_validacao | integer | SIM | CONTATO | NAO_TEMPORAL |
| 135 | identitynumber__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 136 | mainphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 137 | secondaryphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 138 | additionalphone__c_tipotelefone | character varying | SIM | CONTATO | NAO_TEMPORAL |
| 139 | mainphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 140 | mainphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 141 | mainphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 142 | mainphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 143 | mainphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 144 | mainphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 145 | secondaryphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 146 | secondaryphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 147 | secondaryphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 148 | secondaryphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 149 | secondaryphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 150 | secondaryphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 151 | additionalphone__c_datamodif | timestamp without time zone | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 152 | additionalphone__c_usuariomodif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 153 | additionalphone__c_usuario_modif_ | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 154 | additionalphone__c_brusuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 155 | additionalphone__c_cargousuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 156 | additionalphone__c_areausuario | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 157 | mainphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 158 | secondaryphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 159 | additionalphone__c_validacao | integer | SIM | QUALIDADE | NAO_TEMPORAL |
| 160 | cnpj_valido | integer | SIM | OUTRO | NAO_TEMPORAL |
| 161 | cpf_valido | integer | SIM | OUTRO | NAO_TEMPORAL |
| 162 | classe_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 163 | subclasse_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 164 | categoria_de_tarifa_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 165 | carga_kw_br | character varying | SIM | TEMPORAL_EVENTO | EVENTO_OU_VIGENCIA |
| 166 | nivel_de_tensao_br | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 167 | parceiro | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 168 | conta_contrato | character varying | SIM | CONTRATO | NAO_TEMPORAL |
| 169 | mov_in | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 170 | mov_out | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 171 | setor_industrial | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 172 | zona_temperatura | character varying | SIM | COMUNICACAO | NAO_TEMPORAL |
| 173 | categoria_tarifa | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 174 | instalacao | bigint | SIM | INSTALACAO | NAO_TEMPORAL |
| 175 | local_consumo | character varying | SIM | FATURAMENTO | NAO_TEMPORAL |
| 176 | rua | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 177 | estado_cliente | character varying | SIM | CLIENTE | NAO_TEMPORAL |
| 178 | classe_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 179 | subclasse_synergia | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 180 | name_first | character varying | SIM | OUTRO | NAO_TEMPORAL |
| 181 | name_last | character varying | SIM | OUTRO | NAO_TEMPORAL |