PESOCIALEMPREGADOR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CLASSTRIB smallint 2 √ null
NATJURIDICA smallint 2 √ null
CNAE int 4 √ null
INDCOOPERATIVA smallint 2 √ null
INDCONSTRUTORA smallint 2 √ null
ALIQUOTARAT smallint 2 √ null
TPPROCESSORAT char 1 √ null
NRPROCESSORAT varchar 30 √ null
TPPROCESSOFAP char 1 √ null
NRPROCESSOFAP varchar 30 √ null
SIGLAMINISTERIO varchar 8 √ null
NRCERTIFICADO varchar 40 √ null
DTEMISSAOCERTIFICADO DDATETIME 16,3 √ null
DTVENCTOCERTIFICADO DDATETIME 16,3 √ null
NRPROTRENOVACAO varchar 40 √ null
DTPROTRENOVACAO DDATETIME 16,3 √ null
DTDOU DDATETIME 16,3 √ null
PAGDOU smallint 2 √ null
NOMECONTATO varchar 80 √ null
CPFCONTATO varchar 15 √ null
DDDCONTATO smallint 2 √ null
TELEFONECONTATO int 4 √ null
DDDCELULARCONTATO smallint 2 √ null
CELULARCONTATO int 4 √ null
DDDFAXCONTATO smallint 2 √ null
FAXCONTATO int 4 √ null
EMAILCONTATO varchar 60 √ null
BANCO varchar 3 √ null
AGENCIA varchar 15 √ null
TPCONTABANCARIA smallint 2 √ null
NRCONTABANCARIA varchar 20 √ null
UTILIZAFINANCIAMENTO smallint 2 √ ((0))
DEBITOAUTOMATICO smallint 2 √ ((0))
AVISOSSMS smallint 2 √ ((0))
AGENDARECOLHIMENTO smallint 2 √ ((0))
INDACORDO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SOCIOOSTENSIVO smallint 2 √ null
SITUACAOESPECIAL smallint 2 √ null
INDOPTREGELETRONICO smallint 2 √ ((0))
INDDESFOLHA smallint 2 √ null
SITPESSOAFISICA smallint 2 √ null
DTINICIOATIVIDADES DDATETIME 16,3 √ null
INDENTED int 4 √ null
INDETT int 4 √ null
NRREGETT varchar 30 √ null
IDEMINLEI varchar 70 √ null
CPFEMPREGADOR varchar 15 √ null
NOMECOLIGADA varchar 100 √ null
DTENCERRAMENTOEMPRESA datetime2 16,7 √ null
INDOPCCP smallint 2 √ null
INDMEEPP int 4 ((0))
CNPJENTEFEDERATIVORESPONSAVEL varchar 20 √ null
DTTRANSFORMSOCIEDADEFINSLUCRO datetime 16,3 √ null
INDTRIBFOLHAPISCOFINS smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPESOCIALEMPREGADOR Primary key Asc CODCOLIGADA

Diagram producer might be missing

No diagrams were produced please see application output for any errors