PTTOTSECAO

22 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODQUEBRA varchar 35 null
NOMEQUEBRA varchar 60 √ null
CODCOLIGADA DCODCOLIGADA 2 null
NOMEPERIODO varchar 20 √ null
MESCOMP smallint 2 √ null
ANOCOMP int 4 √ null
MESCAIXA smallint 2 √ null
ANOCAIXA int 4 √ null
PERIODO varchar 50 √ null
CGCQUEBRA varchar 20 √ null
RUAQUEBRA varchar 100 √ null
NUMEROQUEBRA varchar 8 √ null
COMPLEMENTOQUEBRA varchar 30 √ null
BAIRROQUEBRA varchar 30 √ null
ESTADOQUEBRA varchar 2 √ null
CIDADEQUEBRA varchar 32 √ null
TOTBASEINSS RMDVALOR2 17,2 √ null
TOTBASEINSS13 RMDVALOR2 17,2 √ null
TOTBASEFGTS RMDVALOR2 17,2 √ null
TOTBASEIRRF RMDVALOR2 17,2 √ null
NROCENCUSTO varchar 100 √ null
TOTBASEIRRFFERIAS RMDVALOR2 17,2 √ null
TOTBASEFGTS13 RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPTTOTSECAO Primary key Asc/Asc CODCOLIGADA + CODQUEBRA

Diagram producer might be missing

No diagrams were produced please see application output for any errors