Enel Brasil

ENEL RJ · bi_brrj_cus · objetos 21-40

Objetos e campos Redshift de ENEL RJ, schema bi_brrj_cus.
Base RCO / Objetos / ENEL RJ / bi_brrj_cus
20 objetos nesta página. Conteúdo gerado diretamente do catálogo estruturado e do arquivo RAG do pacote oficial.
bi_brrj_cus.bt_brrj_kpis_qualidade_osbi_brrj_cus.bt_brrj_mj_ruraisbi_brrj_cus.bt_brrj_padronizacao_ucbi_brrj_cus.bt_brrj_relatorio_de_cadastrobi_brrj_cus.bt_brrj_relatorio_de_cadastro_addbi_brrj_cus.bt_brrj_relatorio_de_cadastro_bkp_20240823bi_brrj_cus.bt_brrj_relatorio_de_cadastro_dzbi_brrj_cus.bt_brrj_siase_archive_201801bi_brrj_cus.bt_brrj_siase_archive_201801_v3bi_brrj_cus.bt_brrj_siase_archive_201802bi_brrj_cus.bt_brrj_siase_archive_201802_v3bi_brrj_cus.bt_brrj_siase_archive_201803bi_brrj_cus.bt_brrj_siase_archive_201803_v3bi_brrj_cus.bt_brrj_siase_archive_201804bi_brrj_cus.bt_brrj_siase_archive_201804_v3bi_brrj_cus.bt_brrj_siase_archive_201805bi_brrj_cus.bt_brrj_siase_archive_201805_v3bi_brrj_cus.bt_brrj_siase_archive_201806_v3bi_brrj_cus.bt_brrj_siase_archive_201807bi_brrj_cus.bt_brrj_siase_archive_201807_v3
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_kpis_qualidade_os

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

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

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

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

Campos (54)

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

bi_brrj_cus.bt_brrj_mj_rurais

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

Tags semânticas: INSTALACAO, CLIENTE, 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)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
180estado_suministrocharacter varyingSIMSOCIALNAO_TEMPORAL
181dica_localizacaocharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_padronizacao_uc

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

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, 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)

#CampoTipoNuloConceito sugeridoUso temporal
1CNPJDistribuidoracharacter varyingSIMOUTRONAO_TEMPORAL
2NumUCInstAntePadrcharacter varyingSIMOUTRONAO_TEMPORAL
3NumUCInstAposPadrcharacter varyingSIMOUTRONAO_TEMPORAL
4Statuscharacter varyingSIMOUTRONAO_TEMPORAL
5id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6pod_id__ccharacter varyingSIMOUTRONAO_TEMPORAL
7createddate_podcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
8id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
9createddate_assetcharacter varyingSIMMEDIDOREVENTO_OU_VIGENCIA
10id_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
11conta_contrato_salesforcecharacter varyingSIMCONTRATONAO_TEMPORAL
12grupocharacter varyingSIMOUTRONAO_TEMPORAL
13numero_cliente_synergiabigintSIMCLIENTENAO_TEMPORAL
14estado_suministrocharacter varyingSIMSOCIALNAO_TEMPORAL
15estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
16numero_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
17estado_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
18tipo_ordemcharacter varyingSIMORDENSNAO_TEMPORAL
19tipo_servicocharacter varyingSIMORDENSNAO_TEMPORAL
20data_foto_yyyymmddcharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_relatorio_de_cadastro

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

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, 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)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
180estado_suministrocharacter varyingSIMSOCIALNAO_TEMPORAL
181dica_localizacaocharacter varyingSIMOUTRONAO_TEMPORAL
182cnt_numero_documento_beneficio__ccharacter varyingSIMOUTRONAO_TEMPORAL
183uc_unico_idcharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_relatorio_de_cadastro_add

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

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, 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)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
180name_firstcharacter varyingSIMOUTRONAO_TEMPORAL
181name_lastcharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_relatorio_de_cadastro_bkp_20240823

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

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, 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 | carga_kw_br | cnt_due_date__c · Status histórico: EXIGE_MIN_MAX_NOS_DADOS

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

Campos (179)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'pending'}

bi_brrj_cus.bt_brrj_relatorio_de_cadastro_dz

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

Tags semânticas: INSTALACAO, CLIENTE, CONTRATO, MEDIDOR, FATURAMENTO, 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 (179)

#CampoTipoNuloConceito sugeridoUso temporal
1pointofdeliverynumber__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
2dvnumberpointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
3id_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
4createddate_pointofdeliverytimestamp without time zoneSIMINSTALACAOEVENTO_OU_VIGENCIA
5companyid__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
6billing_type__ccharacter varyingSIMFATURAMENTONAO_TEMPORAL
7connectionstatus__ccharacter varyingSIMOUTRONAO_TEMPORAL
8connectiontype__ccharacter varyingSIMOUTRONAO_TEMPORAL
9cutoffdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10electrodependant__ccharacter varyingSIMOUTRONAO_TEMPORAL
11pointofdeliverystatus__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
12rate__ccharacter varyingSIMOUTRONAO_TEMPORAL
13route__ccharacter varyingSIMOUTRONAO_TEMPORAL
14segmenttype__ccharacter varyingSIMOUTRONAO_TEMPORAL
15servicetype__ccharacter varyingSIMORDENSNAO_TEMPORAL
16company__c_pointofdeliverycharacter varyingSIMINSTALACAONAO_TEMPORAL
17vip_customer_indicator__cdouble precisionSIMCLIENTENAO_TEMPORAL
18cnt_free_client__cdouble precisionSIMOUTRONAO_TEMPORAL
19cnt_white_rate__cdouble precisionSIMOUTRONAO_TEMPORAL
20distributionaddress__ccharacter varyingSIMCONTABILNAO_TEMPORAL
21notificationcontact__ccharacter varyingSIMCONTATONAO_TEMPORAL
22cnt_lowincometype__cbooleanSIMOUTRONAO_TEMPORAL
23zone__ccharacter varyingSIMOUTRONAO_TEMPORAL
24blacklist__cbooleanSIMOUTRONAO_TEMPORAL
25cnt_isgd__ccharacter varyingSIMGDNAO_TEMPORAL
26municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
27network_type__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
28detailaddress__ccharacter varyingSIMOUTRONAO_TEMPORAL
29feedernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
30transformername__ccharacter varyingSIMOUTRONAO_TEMPORAL
31transformernumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
32id_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
33contactidcharacter varyingSIMCONTATONAO_TEMPORAL
34accountidcharacter varyingSIMCLIENTENAO_TEMPORAL
35accountrollupidcharacter varyingSIMCLIENTENAO_TEMPORAL
36createddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
37lastmodifieddate_assettimestamp without time zoneSIMMEDIDOREVENTO_OU_VIGENCIA
38name_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
39installdatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
40status_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
41description_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
42type__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
43company__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
44externalid__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
45ne__status__c_assetcharacter varyingSIMMEDIDORNAO_TEMPORAL
46id_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
47name_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
48accountnumbercharacter varyingSIMCLIENTENAO_TEMPORAL
49tipo_contacharacter varyingSIMOUTRONAO_TEMPORAL
50createddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
51lastmodifieddate_accounttimestamp without time zoneSIMCLIENTEEVENTO_OU_VIGENCIA
52lastactivitydatetimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
53additionalphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
54birthdate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
55businessname__ccharacter varyingSIMOUTRONAO_TEMPORAL
56companyid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
57company__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
58externalid__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
59ne__status__c_accountcharacter varyingSIMCLIENTENAO_TEMPORAL
60countryb2b__ccharacter varyingSIMOUTRONAO_TEMPORAL
61accountclientnumber__ccharacter varyingSIMCLIENTENAO_TEMPORAL
62pais__ccharacter varyingSIMOUTRONAO_TEMPORAL
63executive__ccharacter varyingSIMOUTRONAO_TEMPORAL
64cnt_responsible_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
65cnt_resp_id_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
66cnt_resp_id_number__ccharacter varyingSIMOUTRONAO_TEMPORAL
67cnt_responsible_phone__ccharacter varyingSIMOUTRONAO_TEMPORAL
68cnt_responsible_email__ccharacter varyingSIMCONTATONAO_TEMPORAL
69cnt_responsible_charge__ccharacter varyingSIMOUTRONAO_TEMPORAL
70cnt_numorgcntr__ccharacter varyingSIMOUTRONAO_TEMPORAL
71cnt_fantasy_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
72recordtypeidcharacter varyingSIMOUTRONAO_TEMPORAL
73cnt_mothers_full_name__ccharacter varyingSIMOUTRONAO_TEMPORAL
74cnt_id_type_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
75cnt_id_num_2__ccharacter varyingSIMOUTRONAO_TEMPORAL
76cnt_state_inscription__ccharacter varyingSIMOUTRONAO_TEMPORAL
77cnt_state_inscription_exemption__ccharacter varyingSIMOUTRONAO_TEMPORAL
78cnt_municipality_inscription__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
79cnt_is_postal_address__ccharacter varyingSIMOUTRONAO_TEMPORAL
80acceptenelcommunication__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
81cnt_customerchannel__ccharacter varyingSIMCLIENTENAO_TEMPORAL
82id_contract__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
83id_billing_profile__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
84id_asset__c_contract_linecharacter varyingSIMCONTRATONAO_TEMPORAL
85pointofdelivery__ccharacter varyingSIMINSTALACAONAO_TEMPORAL
86accountcontract__ccharacter varyingSIMCLIENTENAO_TEMPORAL
87currentaccount__cdouble precisionSIMCLIENTENAO_TEMPORAL
88createddate_billing_profiletimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
89name_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
90edeenrolment__cdouble precisionSIMOUTRONAO_TEMPORAL
91delivery_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
92cnt_due_date__ccharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
93edesuscmassive__cbooleanSIMOUTRONAO_TEMPORAL
94publiccharge__cbooleanSIMOUTRONAO_TEMPORAL
95lowamount__cbooleanSIMOUTRONAO_TEMPORAL
96type__c_billing_profilecharacter varyingSIMFATURAMENTONAO_TEMPORAL
97suscriptiondate__ctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
98id_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
99startdate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
100activateddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
101createddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
102lastmodifieddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
103enddate_contracttimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
104status_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
105description_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
106statuscod_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
107contractnumber_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
108contract_type__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
109cnt_economical_activity__c_contractcharacter varyingSIMCONTRATONAO_TEMPORAL
110coordinatex__ccharacter varyingSIMOUTRONAO_TEMPORAL
111coordinatey__ccharacter varyingSIMOUTRONAO_TEMPORAL
112id_adresscharacter varyingSIMOUTRONAO_TEMPORAL
113literal_municipality__ccharacter varyingSIMREDE_GEONAO_TEMPORAL
114literal_region__ccharacter varyingSIMOUTRONAO_TEMPORAL
115literal_street_type__ccharacter varyingSIMOUTRONAO_TEMPORAL
116neighbourhood__ccharacter varyingSIMOUTRONAO_TEMPORAL
117postal_code__ccharacter varyingSIMOUTRONAO_TEMPORAL
118street__ccharacter varyingSIMOUTRONAO_TEMPORAL
119idstreetcharacter varyingSIMOUTRONAO_TEMPORAL
120identitytype__ccharacter varyingSIMOUTRONAO_TEMPORAL
121clienteativodouble precisionSIMCLIENTENAO_TEMPORAL
122despersonalizadodouble precisionSIMOUTRONAO_TEMPORAL
123celularcharacter varyingSIMCONTATONAO_TEMPORAL
124fixocharacter varyingSIMOUTRONAO_TEMPORAL
125com_telefonedouble precisionSIMCONTATONAO_TEMPORAL
126emailcharacter varyingSIMCONTATONAO_TEMPORAL
127mainphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
128secondaryphone__ccharacter varyingSIMOUTRONAO_TEMPORAL
129primaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
130secondaryemail__ccharacter varyingSIMCONTATONAO_TEMPORAL
131identitynumber__ccharacter varyingSIMOUTRONAO_TEMPORAL
132primaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
133secondaryemail__c_dominiocharacter varyingSIMCONTATONAO_TEMPORAL
134secondaryemail__c_validacaodouble precisionSIMCONTATONAO_TEMPORAL
135identitynumber__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
136mainphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
137secondaryphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
138additionalphone__c_tipotelefonecharacter varyingSIMCONTATONAO_TEMPORAL
139mainphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
140mainphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
141mainphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
142mainphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
143mainphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
144mainphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
145secondaryphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
146secondaryphone__c_usuariomodif_character varyingSIMOUTRONAO_TEMPORAL
147secondaryphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
148secondaryphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
149secondaryphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
150secondaryphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
151additionalphone__c_datamodiftimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
152additionalphone__c_usuariomodifcharacter varyingSIMOUTRONAO_TEMPORAL
153additionalphone__c_usuario_modif_character varyingSIMOUTRONAO_TEMPORAL
154additionalphone__c_brusuariocharacter varyingSIMOUTRONAO_TEMPORAL
155additionalphone__c_cargousuariocharacter varyingSIMOUTRONAO_TEMPORAL
156additionalphone__c_areausuariocharacter varyingSIMOUTRONAO_TEMPORAL
157mainphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
158secondaryphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
159additionalphone__c_validacaodouble precisionSIMQUALIDADENAO_TEMPORAL
160cpnj_validodouble precisionSIMOUTRONAO_TEMPORAL
161cpf_validodouble precisionSIMOUTRONAO_TEMPORAL
162classe_brcharacter varyingSIMOUTRONAO_TEMPORAL
163subclasse_brcharacter varyingSIMOUTRONAO_TEMPORAL
164categoria_de_tarifa_brcharacter varyingSIMOUTRONAO_TEMPORAL
165carga_kw_brcharacter varyingSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
166nivel_de_tensao_brcharacter varyingSIMOUTRONAO_TEMPORAL
167parceirocharacter varyingSIMCLIENTENAO_TEMPORAL
168conta_contratocharacter varyingSIMCONTRATONAO_TEMPORAL
169mov_incharacter varyingSIMOUTRONAO_TEMPORAL
170mov_outcharacter varyingSIMOUTRONAO_TEMPORAL
171setor_industrialcharacter varyingSIMOUTRONAO_TEMPORAL
172zona_temperaturacharacter varyingSIMCOMUNICACAONAO_TEMPORAL
173categoria_tarifacharacter varyingSIMOUTRONAO_TEMPORAL
174instalacaobigintSIMINSTALACAONAO_TEMPORAL
175local_consumocharacter varyingSIMFATURAMENTONAO_TEMPORAL
176ruacharacter varyingSIMOUTRONAO_TEMPORAL
177estado_clientecharacter varyingSIMCLIENTENAO_TEMPORAL
178classe_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
179subclasse_synergiacharacter varyingSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201801

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201801_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201802

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201802_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201803

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201803_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201804

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201804_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201805

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201805_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201806_v3

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

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

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

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

Campos (130)

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

bi_brrj_cus.bt_brrj_siase_archive_201807

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

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

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

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

Campos (130)

#CampoTipoNuloConceito sugeridoUso temporal
1tipofaturamentocharacter varyingSIMFATURAMENTONAO_TEMPORAL
2descricaoclassecharacter varyingSIMOUTRONAO_TEMPORAL
3descricaosubclassecharacter varyingSIMOUTRONAO_TEMPORAL
4opcaocompraencharacter varyingSIMOUTRONAO_TEMPORAL
5codigosubgrupotarifariocharacter varyingSIMOUTRONAO_TEMPORAL
6modalidadetarifariacharacter varyingSIMOUTRONAO_TEMPORAL
7tipoconsfatcharacter varyingSIMOUTRONAO_TEMPORAL
8dataemissaofaturatimestamp without time zoneSIMFATURAMENTOEVENTO_OU_VIGENCIA
9datavencimentotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
10dataleituraatualtimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
11dataleituraanteriortimestamp without time zoneSIMLEITURAEVENTO_OU_VIGENCIA
12dataligacaouctimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
13dataencerramentocontratotimestamp without time zoneSIMCONTRATOEVENTO_OU_VIGENCIA
14dataconcbentarifariotimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
15datarevisaocadastraltimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
16dataatualizacaomultifamiliartimestamp without time zoneSIMTEMPORAL_EVENTOEVENTO_OU_VIGENCIA
17mesreferenciacharacter varyingSIMCOMPETENCIA_REFERENCIACOBERTURA_HISTORICA
18codusuariocharacter varyingSIMINSTALACAONAO_TEMPORAL
19nomeclientecharacter varyingSIMCLIENTENAO_TEMPORAL
20tipopessoacharacter varyingSIMOUTRONAO_TEMPORAL
21numcpfcnpjcharacter varyingSIMOUTRONAO_TEMPORAL
22numranicharacter varyingSIMOUTRONAO_TEMPORAL
23enderecocharacter varyingSIMOUTRONAO_TEMPORAL
24numcepcharacter varyingSIMREDE_GEONAO_TEMPORAL
25localizacaouccharacter varyingSIMOUTRONAO_TEMPORAL
26codigoibgecharacter varyingSIMREDE_GEONAO_TEMPORAL
27codigofaturacharacter varyingSIMFATURAMENTONAO_TEMPORAL
28codigocnaecharacter varyingSIMOUTRONAO_TEMPORAL
29numnischaracter varyingSIMSOCIALNAO_TEMPORAL
30codigofamiliacharacter varyingSIMOUTRONAO_TEMPORAL
31cooperadocharacter varyingSIMOUTRONAO_TEMPORAL
32numnbcharacter varyingSIMOUTRONAO_TEMPORAL
33codmedidorcharacter varyingSIMMEDIDORNAO_TEMPORAL
34demativacontratpontanumericSIMOUTRONAO_TEMPORAL
35demativacontratforapontanumericSIMOUTRONAO_TEMPORAL
36demativacontratnaoseaplicanumericSIMOUTRONAO_TEMPORAL
37demativafatpontanumericSIMOUTRONAO_TEMPORAL
38demativafatforapontanumericSIMOUTRONAO_TEMPORAL
39demativafatnaoseaplicanumericSIMOUTRONAO_TEMPORAL
40consativofattepontanumericSIMOUTRONAO_TEMPORAL
41consativofatteforapontanumericSIMOUTRONAO_TEMPORAL
42consativofatteintermnumericSIMOUTRONAO_TEMPORAL
43consativofattenaoseaplicanumericSIMOUTRONAO_TEMPORAL
44consativofattepontaresnumericSIMOUTRONAO_TEMPORAL
45consativofatteforapontaresnumericSIMOUTRONAO_TEMPORAL
46consativofattenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
47consativofattusdpontanumericSIMOUTRONAO_TEMPORAL
48consativofattusdforapontanumericSIMOUTRONAO_TEMPORAL
49consativofattusdintermnumericSIMOUTRONAO_TEMPORAL
50consativofattusdnaoseaplicanumericSIMOUTRONAO_TEMPORAL
51consativofattusdpontaresnumericSIMOUTRONAO_TEMPORAL
52consativofattusdforapontaresnumericSIMOUTRONAO_TEMPORAL
53consativofattusdnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
54modalidadegdcharacter varyingSIMGDNAO_TEMPORAL
55saldoanteriorcreditosnumericSIMCOBRANCANAO_TEMPORAL
56totalcredexpciclofatnumericSIMREDE_GEONAO_TEMPORAL
57saldoatualizadocreditosnumericSIMCOBRANCAEVENTO_OU_VIGENCIA
58creditosutilizadosnumericSIMCOBRANCANAO_TEMPORAL
59multanumericSIMOUTRONAO_TEMPORAL
60jurosnumericSIMOUTRONAO_TEMPORAL
61encargosconexaonumericSIMOUTRONAO_TEMPORAL
62valorcompensacaonumericSIMGDNAO_TEMPORAL
63multaencerramentonumericSIMOUTRONAO_TEMPORAL
64servicoscobraveisnumericSIMORDENSNAO_TEMPORAL
65valortotalfaturanumericSIMFATURAMENTONAO_TEMPORAL
66icmsnumericSIMCONTABILNAO_TEMPORAL
67pisnumericSIMCONTABILNAO_TEMPORAL
68cofinsnumericSIMCONTABILNAO_TEMPORAL
69basecalculoicmsnumericSIMCONTABILNAO_TEMPORAL
70basecalculopiscofinsnumericSIMCONTABILNAO_TEMPORAL
71cipnumericSIMOUTRONAO_TEMPORAL
72demativaregpontanumericSIMOUTRONAO_TEMPORAL
73demativaregforapontanumericSIMOUTRONAO_TEMPORAL
74demativaregnaoseaplicanumericSIMOUTRONAO_TEMPORAL
75demativaultpontanumericSIMOUTRONAO_TEMPORAL
76demativaultforapontanumericSIMOUTRONAO_TEMPORAL
77demativaultnaoseaplicanumericSIMOUTRONAO_TEMPORAL
78demativacomppontanumericSIMOUTRONAO_TEMPORAL
79demativacompforapontanumericSIMOUTRONAO_TEMPORAL
80demativacompnaoseaplicanumericSIMOUTRONAO_TEMPORAL
81rcpontanumericSIMOUTRONAO_TEMPORAL
82rcforapontanumericSIMOUTRONAO_TEMPORAL
83rcnaoseaplicanumericSIMOUTRONAO_TEMPORAL
84consativomedtepontanumericSIMOUTRONAO_TEMPORAL
85consativomedteforapontanumericSIMOUTRONAO_TEMPORAL
86consativomedteintermnumericSIMOUTRONAO_TEMPORAL
87consativomedtenaoseaplicanumericSIMOUTRONAO_TEMPORAL
88consativomedtepontaresnumericSIMOUTRONAO_TEMPORAL
89consativomedteforapontaresnumericSIMOUTRONAO_TEMPORAL
90consativomedtenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
91enelativainjpontanumericSIMOUTRONAO_TEMPORAL
92enelativainjforapontanumericSIMOUTRONAO_TEMPORAL
93enelativainjintermediarionumericSIMOUTRONAO_TEMPORAL
94enelativainjreservadonumericSIMOUTRONAO_TEMPORAL
95enelativainjnaoseaplicanumericSIMOUTRONAO_TEMPORAL
96subscarfinumericSIMOUTRONAO_TEMPORAL
97subsgerfinumericSIMOUTRONAO_TEMPORAL
98subsdistnumericSIMOUTRONAO_TEMPORAL
99subsaguaesgotonumericSIMOUTRONAO_TEMPORAL
100subsruralnumericSIMCOMUNICACAONAO_TEMPORAL
101subsirrigacaonumericSIMOUTRONAO_TEMPORAL
102subsbaixarendanumericSIMSOCIALNAO_TEMPORAL
103receitatusdkwpontanumericSIMOUTRONAO_TEMPORAL
104receitatusdkwforapontanumericSIMOUTRONAO_TEMPORAL
105receitatusdkwnaoseaplicanumericSIMOUTRONAO_TEMPORAL
106receitatusdmwhpontanumericSIMOUTRONAO_TEMPORAL
107receitatusdmwhforapontanumericSIMOUTRONAO_TEMPORAL
108receitatusdmwhnaoseaplicanumericSIMOUTRONAO_TEMPORAL
109receitatusdmwhintermediarionumericSIMOUTRONAO_TEMPORAL
110receitatusdmwhpontaresnumericSIMOUTRONAO_TEMPORAL
111receitatusdmwhforapontaresnumericSIMOUTRONAO_TEMPORAL
112receitatusdmwhnaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
113receitatepontanumericSIMOUTRONAO_TEMPORAL
114receitateforapontanumericSIMOUTRONAO_TEMPORAL
115receitatenaoseaplicanumericSIMOUTRONAO_TEMPORAL
116receitateintermediarionumericSIMOUTRONAO_TEMPORAL
117receitatepontaresnumericSIMOUTRONAO_TEMPORAL
118receitateforapontaresnumericSIMOUTRONAO_TEMPORAL
119receitatenaoseaplicaresnumericSIMOUTRONAO_TEMPORAL
120receitabandeirasnumericSIMOUTRONAO_TEMPORAL
121receitaultdemativanumericSIMOUTRONAO_TEMPORAL
122erenumericSIMOUTRONAO_TEMPORAL
123drenumericSIMOUTRONAO_TEMPORAL
124consreativopontanumericSIMOUTRONAO_TEMPORAL
125consreativoforapontanumericSIMOUTRONAO_TEMPORAL
126consreativointermediarionumericSIMOUTRONAO_TEMPORAL
127consreativonaoseaplicanumericSIMOUTRONAO_TEMPORAL
128demreativapontanumericSIMOUTRONAO_TEMPORAL
129demreativaforapontanumericSIMOUTRONAO_TEMPORAL
130demreativanaoseaplicanumericSIMOUTRONAO_TEMPORAL
{'physical_metadata': 'confirmed', 'semantic_classification': 'suggested', 'physical_history_measurement': 'partially_available'}

bi_brrj_cus.bt_brrj_siase_archive_201807_v3

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

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

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

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

Campos (130)

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