PFHSTPROVABAT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTPROVABATMESCC.CODCOLIGADA FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROV.CODCOLIGADA FKPFHSTPROVABAT_PFHSTPROVR
PFUNC.CODCOLIGADA FKPFHSTPROVABAT_PFUNCR
ANOORIGEM smallint 2 null
PFHSTPROVABATMESCC.ANOORIGEM FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROV.ANO FKPFHSTPROVABAT_PFHSTPROVR
MESORIGEM smallint 2 null
PFHSTPROVABATMESCC.MESORIGEM FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROV.MES FKPFHSTPROVABAT_PFHSTPROVR
CHAPA DCHAPA 16 null
PFHSTPROVABATMESCC.CHAPA FKPFHSTPROVABATMESCC_PFHSTPROBR
PFUNC.CHAPA FKPFHSTPROVABAT_PFUNCR
PFHSTPROV.CHAPA FKPFHSTPROVABAT_PFHSTPROV2R
VALABATTOTAL RMDVALOR2 17,2 √ null
VALABATREST RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
ANO smallint 2 ((2018))
PFHSTPROVABATMESCC.ANO FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROV.ANO FKPFHSTPROVABAT_PFHSTPROV2R
MES smallint 2 ((1))
PFHSTPROVABATMESCC.MES FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROV.MES FKPFHSTPROVABAT_PFHSTPROV2R

Indexes

Constraint Name Type Sort Column(s)
PKPFHSTPROVABAT Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + ANOORIGEM + MESORIGEM + CHAPA + ANO + MES

Relationships

Close relationships within degrees of separation