TMOVRATCCULOGFAT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCCUSTO.CODCOLIGADA FKTMOVRATCCULOGFAT_GCCUSTOR
MTAREFA.CODCOLIGADA FKTMOVRATCCULOGFAT_MTAREFAR
TMOVLOGFAT.CODCOLIGADA FKTMOVRATCCULOGFAT_TMOVLOGFATR
MPRJ.CODCOLIGADA FKTMOVRATCCULOGFAT_MPRJR
TTBGRUPOORCAMENTO.CODCOLIGADA FKTMOVRATCCULOGFAT_TTBGRUPOORCR
IDMOV int 4 null
TMOVLOGFAT.IDMOV FKTMOVRATCCULOGFAT_TMOVLOGFATR
CODCCUSTO varchar 25 null
GCCUSTO.CODCCUSTO FKTMOVRATCCULOGFAT_GCCUSTOR
IDPROCESSOFAT int 4 null
TMOVLOGFAT.IDPROCESSOFAT FKTMOVRATCCULOGFAT_TMOVLOGFATR
VALOR RMDVALOR4 17,4 √ null
PERCENTUAL RMDVALOR4 17,4 √ null
CANCELADO smallint 2 √ null
IDPRJ int 4 √ null
MTAREFA.IDPRJ FKTMOVRATCCULOGFAT_MTAREFAR
MPRJ.IDPRJ FKTMOVRATCCULOGFAT_MPRJR
IDTRF int 4 √ null
MTAREFA.IDTRF FKTMOVRATCCULOGFAT_MTAREFAR
CODTBGRUPOORC varchar 40 √ null
TTBGRUPOORCAMENTO.CODTBGRUPOORC FKTMOVRATCCULOGFAT_TTBGRUPOORCR
IDMOVRATCCU int 4 ((0))
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)
PKTMOVRATCCULOGFAT Primary key Asc/Asc/Asc CODCOLIGADA + IDMOVRATCCU + IDPROCESSOFAT
TXTMOVRATCCULOGFATTTRF Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRF

Relationships

Close relationships within degrees of separation