PFHSTPROVMESCC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTPROVABATMESCC.CODCOLIGADA FKPFHSTPROVABATMESCC_PFHSTPROMR
PFHSTPROV.CODCOLIGADA FKPFHSTPROVMESCC_PFHSTPROVR
PCCUSTO.CODCOLIGADA FKPFHSTPROVMESCC_PCCUSTOR
PFUNC.CODCOLIGADA FKPFHSTPROVMESCC_PFUNCR
CHAPA DCHAPA 16 null
PFHSTPROVABATMESCC.CHAPA FKPFHSTPROVABATMESCC_PFHSTPROMR
PFUNC.CHAPA FKPFHSTPROVMESCC_PFUNCR
PFHSTPROV.CHAPA FKPFHSTPROVMESCC_PFHSTPROVR
ANO smallint 2 null
PFHSTPROVABATMESCC.ANO FKPFHSTPROVABATMESCC_PFHSTPROMR
PFHSTPROV.ANO FKPFHSTPROVMESCC_PFHSTPROVR
MES smallint 2 null
PFHSTPROVABATMESCC.MES FKPFHSTPROVABATMESCC_PFHSTPROMR
PFHSTPROV.MES FKPFHSTPROVMESCC_PFHSTPROVR
CODCCUSTO varchar 25 null
PFHSTPROVABATMESCC.CODCCUSTO FKPFHSTPROVABATMESCC_PFHSTPROMR
PCCUSTO.CODCCUSTO FKPFHSTPROVMESCC_PCCUSTOR
VALPROVFER RMDVALOR2 17,2 √ null
VALPROV13 RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

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

Relationships

Close relationships within degrees of separation