TPARFILIAL

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCERTIFICADODIGITAL.CODCOLIGADA FKTPARFILIAL_DCERTIFDIGITCTER
GFORMULA.CODCOLIGADA FKTPARFILIAL_GFORMULAR
GFILIAL.CODCOLIGADA FKTPARFILIAL_GFILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKTPARFILIAL_GFILIALR
LOCALCERTIFICADONFE varchar 255 √ null
AMBIENTENFE smallint 2 √ null
VERSAONFE varchar 10 √ null
TEMPOCONTINGENCIA int 4 √ null
MODALIDADENFE smallint 2 √ null
URLTOTVSSERVICES varchar 250 √ null
TIPOCERTIFICADONFE smallint 2 √ null
LOCALPRIVATEKEYNFE varchar 255 √ null
SENHAPRIVATEKEYNFE varchar 80 √ null
HSMSLOT varchar 4 √ null
HSMLABEL varchar 50 √ null
HSMMODULE varchar 100 √ null
HSMLABELKEY varchar 50 √ null
AMBIENTENFEMUNICIP smallint 2 √ null
VERSAONFEMUNICIP varchar 10 √ null
URLSERVICONFEMUNICIP varchar 300 √ null
VERSAODPEC varchar 10 √ null
IDCLASSIFMUNICNFSE smallint 2 √ null
USUARIONEOGRID varchar 255 √ null
SENHANEOGRID varchar 255 √ null
LOCALCERTIFICADOCTE varchar 255 √ null
TIPOCERTIFICADOCTE smallint 2 √ null
LOCALPRIVATEKEYCTE varchar 255 √ null
SENHAPRIVATEKEYCTE varchar 80 √ null
HSMSLOTCTE varchar 4 √ null
HSMLABELCTE varchar 50 √ null
HSMMODULECTE varchar 100 √ null
HSMLABELKEYCTE varchar 50 √ null
VERSAOCTE varchar 10 √ null
AMBIENTECTE smallint 2 √ null
MODALIDADECTE smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
AMBIENTECCE smallint 2 √ ((2))
VERCCELAYOUT varchar 10 √ ((1))
VERCCELAYEVEN varchar 10 √ ((1))
VERCCEEVEN varchar 10 √ ((1))
VERCCE varchar 10 √ ((1))
HORAVERAOCCE smallint 2 √ ((2))
HORARIOCCE smallint 2 √ ((2))
AMBIENTEMDE smallint 2 √ null
VERSAOMDE varchar 10 √ null
AMBIENTENEOGRID smallint 2 √ null
TIPODOCNEOGRID int 4 √ null
LOGINPREFEITURA varchar 255 √ null
SENHAPREFEITURA varchar 255 √ null
AUTORIZACAOPREFEITURA varchar 255 √ null
MAXLOTENFSE smallint 2 √ null
VERSAOCTERODO varchar 10 √ null
VERSAOCTEFERRO varchar 10 √ null
VERSAOCTEAQUA varchar 10 √ null
VERSAOCTEAEREO varchar 10 √ null
AMBIENTEMDFE smallint 2 √ null
MODALIDADEMDFE smallint 2 √ null
VMDFE varchar 10 √ null
VMDFERODO varchar 10 √ null
VMDFEFERRO varchar 10 √ null
VMDFEAQUA varchar 10 √ null
VMDFEAERO varchar 10 √ null
VMDFELAYOUT varchar 10 √ null
VMDFELAYEVEN varchar 10 √ null
VERSAOEVENTOMDE varchar 10 √ null
VERSAOEVENTOCTE varchar 10 √ null
HSMIDHEX varchar 250 √ null
HSMIDHEXCTE varchar 250 √ null
NUMRETDOCNEOGRID smallint 2 ((10))
CANCELAMENTOCTEPOREVENTO int 4 √ null
CODTMVCTECOLABAUT varchar 10 √ null
URLSEFAZNFCE varchar 250 √ null
VERSAOLAYOUTNFCE varchar 10 √ null
AMBIENTENFCE smallint 2 √ null
MODALIDADENFCE smallint 2 √ null
URLQRCODENFCE varchar 250 √ null
CSCNFCE varchar 50 √ null
IDCSCNFCE varchar 20 √ null
NOVAINTERFACETCOLAB int 4 √ null
TIPORECEBIMENTONFE varchar 1 √ null
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKTPARFILIAL_GFORMULAR
CODFRMTIPOMOVNFE varchar 8 √ null
GFORMULA.CODIGO FKTPARFILIAL_GFORMULAR
BUSCAUNIDADEPEDIDOCOLAB smallint 2 √ null
RETIRAACENTOS smallint 2 ((0))
VERSAOCTEOS varchar 10 √ null
AMBIENTECTEOS smallint 2 √ null
MODALIDADECTEOS smallint 2 √ null
NAOINCLUIRMOVIMENTOAUTO smallint 2 √ null
IDCERTIFICADONFE int 4 √ null
DCERTIFICADODIGITAL.IDCERTIFICADO FKTPARFILIAL_DCERTIFDIGITNFER
IDCERTIFICADOCTE int 4 √ null
DCERTIFICADODIGITAL.IDCERTIFICADO FKTPARFILIAL_DCERTIFDIGITCTER
CLIENTID varchar 255 √ null
CLIENTSECRET varchar 255 √ null
NFSEOBSSELECAODISCRIMINACAO varchar 50 √ null
NFSEOBSSELECAODESCRICAO varchar 50 √ null
NFSEOBSSELECAOOBSERVACAO varchar 50 √ null
NAOINCLUIRMOVIMENTOAUTOCTE smallint 2 √ null
CNPJASSINATURANFSE varchar 20 √ null
URLSEFAZCTE varchar 250 √ null
URLSEFAZCTEOS varchar 250 √ null
URLSEFAZMDFE varchar 250 √ null
CLIENTIDTSS varchar 40 √ null
CLIENTSECRETTSS varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTPARFILIAL Primary key Asc/Asc CODCOLIGADA + CODFILIAL

Relationships

Close relationships within degrees of separation