TLAF

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKTLOTLIBER_GCOLIGADAR
DLOTE.CODCOLIGADA FKTLAF_DLOTER
TTMV.CODCOLIGADA FKTLAF_TTMVR
CODLAF varchar 15 null
DESCRICAO varchar 35 √ null
DATA datetime 16,3 √ null
CODUSUARIO varchar 20 √ null
FILIALINICIO smallint 2 √ null
DLOTE.CODFILIAL FKTLAF_DLOTER
PERIODOINICIAL datetime 16,3 √ null
PERIODOFINAL datetime 16,3 √ null
NUMNOTAINICIAL char 15 √ null
NUMNOTAFINAL char 15 √ null
TIPOEXPORTACAO char 1 √ null
TIPOMOVIMENTO varchar 1 √ null
DLOTE.TIPOLF FKTLAF_DLOTER
QUANTIDADE int 4 √ null
GERADO varchar 1 √ null
LOTE int 4 √ null
DLOTE.NUMLOTE FKTLAF_DLOTER
STATUS varchar 1 √ null
STATUSMOVIMENTO varchar 1 √ null
CODTMV varchar 10 √ null
TTMV.CODTMV FKTLAF_TTMVR
ESCRITURARMOVGERADODESDOBR smallint 2 √ (1)
CODUSUARIOMOV varchar 20 √ 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)
PKTLOTLIBER Primary key Asc/Asc CODCOLIGADA + CODLAF

Relationships

Close relationships within degrees of separation