PFHSTBEM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFHSTBEM_PFUNCR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTBEM_PFUNCR
DTMUDANCA datetime 16,3 null
DTACORDOBEM datetime 16,3 √ null
PERCENTUALREDUCAOBEM RMDVALOR2 17,2 √ null
DURACAOBEM smallint 2 √ null
VALORREDUZIDOBEM RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOADESAOBEM varchar 1 √ null
DTCANCELAMENTOBEM datetime 16,3 √ null
DTANTECIPACAOBEM datetime 16,3 √ null
DIASPRORROGACAOBEM int 4 √ null
DTPRORROGACAOBEM datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFHSTBEM Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + DTMUDANCA

Relationships

Close relationships within degrees of separation