MCRONOGFINAN

707 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTAREFA.CODCOLIGADA FKMCRONOGFINAN_MTRFR
GCOLIGADA.CODCOLIGADA FKMCRONOGFINAN_GCOLIGADAR
MPRJ.CODCOLIGADA FKMCRONOGFINAN_MPRJR
IDPRJ int 4 null
MTAREFA.IDPRJ FKMCRONOGFINAN_MTRFR
MPRJ.IDPRJ FKMCRONOGFINAN_MPRJR
IDTRF int 4 null
MTAREFA.IDTRF FKMCRONOGFINAN_MTRFR
PERIODO int 4 null
VALORPREVISTO decimal 23,4 √ null
VALORREALIZADO decimal 23,4 √ 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)
PKMCRONOGFINAN Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRF + PERIODO
MXMCRONOGFINANTRF Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRF

Relationships

Close relationships within degrees of separation