PFITEMLAN

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFITEMLAN_PFUNCR
GCOLIGADA.CODCOLIGADA FKPFITEMLAN_GCOLIGADAR
FLAN.CODCOLIGADA FKPFITEMLAN_FLANR
PFINANCEIRO.CODCOLIGADA FKPFITEMLAN_PFINANCEIROR
IDITEMLAN int 4 null
IDLAN int 4 √ null
FLAN.IDLAN FKPFITEMLAN_FLANR
CHAPA DCHAPA 16 √ null
PFUNC.CHAPA FKPFITEMLAN_PFUNCR
VALOR RMDVALOR4 17,4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCFO varchar 25 √ null
FCFO.CODCFO FKPFITEMLAN_FCFOR
CODCOLCFO DCODCOLIGADA 2 √ null
FCFO.CODCOLIGADA FKPFITEMLAN_FCFOR
IDFINANC int 4 √ null
PFINANCEIRO.IDFINANC FKPFITEMLAN_PFINANCEIROR
MESCOMP smallint 2 √ null
ANOCOMP smallint 2 √ null
NROPERIODO smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFITEMLAN Primary key Asc/Asc CODCOLIGADA + IDITEMLAN

Relationships

Close relationships within degrees of separation