PFHSTPROVABATMESCC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTPROVABAT.CODCOLIGADA FKPFHSTPROVABATMESCC_PFHSTPROBR
PCCUSTO.CODCOLIGADA FKPFHSTPROVABATMESCC_PCCUSTOR
PFUNC.CODCOLIGADA FKPFHSTPROVABATMESCC_PFUNCR
PFHSTPROVMESCC.CODCOLIGADA FKPFHSTPROVABATMESCC_PFHSTPROMR
ANO smallint 2 null
PFHSTPROVMESCC.ANO FKPFHSTPROVABATMESCC_PFHSTPROMR
PFHSTPROVABAT.ANO FKPFHSTPROVABATMESCC_PFHSTPROBR
MES smallint 2 null
PFHSTPROVABAT.MES FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROVMESCC.MES FKPFHSTPROVABATMESCC_PFHSTPROMR
CHAPA DCHAPA 16 null
PFHSTPROVABAT.CHAPA FKPFHSTPROVABATMESCC_PFHSTPROBR
PFHSTPROVMESCC.CHAPA FKPFHSTPROVABATMESCC_PFHSTPROMR
PFUNC.CHAPA FKPFHSTPROVABATMESCC_PFUNCR
CODCCUSTO varchar 25 null
PFHSTPROVMESCC.CODCCUSTO FKPFHSTPROVABATMESCC_PFHSTPROMR
PCCUSTO.CODCCUSTO FKPFHSTPROVABATMESCC_PCCUSTOR
ANOORIGEM smallint 2 null
PFHSTPROVABAT.ANOORIGEM FKPFHSTPROVABATMESCC_PFHSTPROBR
MESORIGEM smallint 2 null
PFHSTPROVABAT.MESORIGEM FKPFHSTPROVABATMESCC_PFHSTPROBR
VALABATIDO 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)
PKPFHSTPROVABATMESCC Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + ANO + MES + CHAPA + CODCCUSTO + ANOORIGEM + MESORIGEM
IXPFHSTPROVABATMESCC Performance Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOORIGEM + MESORIGEM + CODCCUSTO

Relationships

Close relationships within degrees of separation