PFHSTPROVFORMULAMESCC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PCCUSTO.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_PCCUSTR
PFUNC.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_PFUNCR
GFORMULA.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_GFORMUR
PFHSTPROVFORMULA.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_PFHSTPR
CHAPA DCHAPA 16 null
PFHSTPROVFORMULA.CHAPA FKPFHSTPROVFORMULAMESCC_PFHSTPR
PFUNC.CHAPA FKPFHSTPROVFORMULAMESCC_PFUNCR
ANO smallint 2 null
PFHSTPROVFORMULA.ANO FKPFHSTPROVFORMULAMESCC_PFHSTPR
MES smallint 2 null
PFHSTPROVFORMULA.MES FKPFHSTPROVFORMULAMESCC_PFHSTPR
CODAPLICACAO varchar 1 null
GFORMULA.APLICACAO FKPFHSTPROVFORMULAMESCC_GFORMUR
CODCCUSTO varchar 25 null
PCCUSTO.CODCCUSTO FKPFHSTPROVFORMULAMESCC_PCCUSTR
CODFORMULA varchar 8 null
GFORMULA.CODIGO FKPFHSTPROVFORMULAMESCC_GFORMUR
PFHSTPROVFORMULA.CODFORMULA FKPFHSTPROVFORMULAMESCC_PFHSTPR
VALFORMULA RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

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

Relationships

Close relationships within degrees of separation