PFHSTPROV

6479 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTPROVABAT.CODCOLIGADA FKPFHSTPROVABAT_PFHSTPROVR
PFHSTPROVMESCC.CODCOLIGADA FKPFHSTPROVMESCC_PFHSTPROVR
PFUNC.CODCOLIGADA FKPFHSTPROV_FUNCR
ANO smallint 2 null
PFHSTPROVABAT.ANO FKPFHSTPROVABAT_PFHSTPROV2R
PFHSTPROVABAT.ANOORIGEM FKPFHSTPROVABAT_PFHSTPROVR
PFHSTPROVMESCC.ANO FKPFHSTPROVMESCC_PFHSTPROVR
MES smallint 2 null
PFHSTPROVABAT.MES FKPFHSTPROVABAT_PFHSTPROV2R
PFHSTPROVABAT.MESORIGEM FKPFHSTPROVABAT_PFHSTPROVR
PFHSTPROVMESCC.MES FKPFHSTPROVMESCC_PFHSTPROVR
CHAPA DCHAPA 16 null
PFHSTPROVABAT.CHAPA FKPFHSTPROVABAT_PFHSTPROV2R
PFHSTPROVMESCC.CHAPA FKPFHSTPROVMESCC_PFHSTPROVR
PFUNC.CHAPA FKPFHSTPROV_FUNCR
DTVENCFER datetime 16,3 √ null
VALPROVFER RMDVALOR2 17,2 √ null
VALPROV13 RMDVALOR2 17,2 √ null
NROAVOSVENCFERDEC RMDVALOR2 17,2 √ null
NROAVOSPROPORCDEC RMDVALOR2 17,2 √ null
NROAVOS13DEC RMDVALOR2 17,2 √ null
VALPROVCOMABATFER RMDVALOR2 17,2 √ null
VALPROVSEMABATFER RMDVALOR2 17,2 √ null
MEDIASFERVENC RMDVALOR2 17,2 √ null
MEDIASFERPROP RMDVALOR2 17,2 √ null
MEDIAS13SAL RMDVALOR2 17,2 √ null
EDITADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VALPROVFERPROP RMDVALOR2 17,2 √ null
VALPROVFERVENC RMDVALOR2 17,2 √ null
VALPROVFERMES RMDVALOR2 17,2 √ null
EXECIDFER varchar 40 √ null
EXECID13 varchar 40 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VALPROVFERDOBRO RMDVALOR2 17,2 √ null

Indexes

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

Relationships

Close relationships within degrees of separation