TMOVLOGFAT

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TITMMOVLOGFAT.CODCOLIGADA FKTITMMOVLOGFAT_TMOVLOGFATR
TMOVRATCCULOGFAT.CODCOLIGADA FKTMOVRATCCULOGFAT_TMOVLOGFATR
TMOVRATDEPLOGFAT.CODCOLIGADA FKTMOVRATDEPLOGFAT_TMOVLOGFATR
TTRBMOVLOGFAT.CODCOLIGADA FKTTRBMOVLOGFAT_TMOVLOGFATR
TMOV.CODCOLIGADA FKTMOVLOGFAT_TMOVR
IDMOV int 4 null
TITMMOVLOGFAT.IDMOV FKTITMMOVLOGFAT_TMOVLOGFATR
TMOVRATCCULOGFAT.IDMOV FKTMOVRATCCULOGFAT_TMOVLOGFATR
TMOVRATDEPLOGFAT.IDMOV FKTMOVRATDEPLOGFAT_TMOVLOGFATR
TTRBMOVLOGFAT.IDMOV FKTTRBMOVLOGFAT_TMOVLOGFATR
TMOV.IDMOV FKTMOVLOGFAT_TMOVR
IDPROCESSOFAT int 4 null
TITMMOVLOGFAT.IDPROCESSOFAT FKTITMMOVLOGFAT_TMOVLOGFATR
TMOVRATCCULOGFAT.IDPROCESSOFAT FKTMOVRATCCULOGFAT_TMOVLOGFATR
TMOVRATDEPLOGFAT.IDPROCESSOFAT FKTMOVRATDEPLOGFAT_TMOVLOGFATR
TTRBMOVLOGFAT.IDPROCESSOFAT FKTTRBMOVLOGFAT_TMOVLOGFATR
VALORBRUTO RMDVALOR4 17,4 √ null
VALORLIQUIDO DVALOR4 17,4 √ null
VALOROUTROS DVALOR4 17,4 √ null
PERCENTUALFRETE RMDVALOR4 17,4 √ null
VALORFRETE RMDVALOR4 17,4 √ null
PERCENTUALSEGURO RMDVALOR4 17,4 √ null
VALORSEGURO RMDVALOR4 17,4 √ null
PERCENTUALDESC RMDVALOR4 17,4 √ null
VALORDESC RMDVALOR4 17,4 √ null
PERCENTUALDESP RMDVALOR4 17,4 √ null
VALORDESP RMDVALOR4 17,4 √ null
PERCENTUALEXTRA1 RMDVALOR4 17,4 √ null
VALOREXTRA1 RMDVALOR4 17,4 √ null
PERCENTUALEXTRA2 RMDVALOR4 17,4 √ null
VALOREXTRA2 RMDVALOR4 17,4 √ null
VALORADIANTAMENTO RMDVALOR4 17,4 √ null
VALORDESCCONDICIONAL RMDVALOR4 17,4 √ null
VALORDESPCONDICIONAL RMDVALOR4 17,4 √ null
VALORRATEIOLAN RMDVALOR4 17,4 √ null
CANCELADO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VALORRECEBIDOFATPARC RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTMOVLOGFAT Primary key Asc/Asc/Asc CODCOLIGADA + IDMOV + IDPROCESSOFAT

Relationships

Close relationships within degrees of separation