PFHSTCOMPRAVT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFHSTCOMPRAVT_PFUNCR
PVALETR.CODCOLIGADA FKPFHSTCOMPRAVT_PVALETRR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTCOMPRAVT_PFUNCR
ANOCOMP smallint 2 null
MESCOMP smallint 2 null
CODLINHA varchar 20 null
PVALETR.CODIGO FKPFHSTCOMPRAVT_PVALETRR
DATAINICIAL DDATETIME 16,3 null
DATAFINAL DDATETIME 16,3 null
VIAGENSDIARIAS smallint 2 null
TIPOCALCULO smallint 2 null
DIASPERIODO smallint 2 null
TARIFA RMDVALOR2 17,2 null
TOTALVALESENTREGUE smallint 2 null
VALORTOTALENTREGUE RMDVALOR2 17,2 null
ALTERADOMANUAL smallint 2 √ null
CODSECAO varchar 35 null
REJEITADO smallint 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)
PKPFHSTCOMPRAVT Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + CODLINHA + DATAINICIAL + VIAGENSDIARIAS

Relationships

Close relationships within degrees of separation