DLAFEXTERIOR

1557 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DLAF.CODCOLIGADA FKDLAFEXTERIOR_DLAFR
DLAFAGRUP.CODCOLIGADA FKDLAFEXTERIOR_DLAFAGRUPR
IDLAF int 4 √ null
DLAF.IDLAF FKDLAFEXTERIOR_DLAFR
NUMERODE varchar 20 √ null
DATADE datetime 16,3 √ null
NATUREZAEXPORTACAO smallint 2 √ null
CONHECIMENTOEMBARQUE varchar 25 √ null
DATACONHECIMENTO datetime 16,3 √ null
TIPOCONHECIMENTO smallint 2 √ null
DATAAVERBACAO datetime 16,3 √ null
NUMDESPACHO varchar 12 √ null
VALORDESPACHO RMDVALOR4 17,4 √ null
NUMERODI varchar 15 √ null
DATADI datetime 16,3 √ null
DATADESEMBARACO datetime 16,3 √ null
NATUREZAIMPORTACAO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDLAFAGRUP int 4 null
DLAFAGRUP.IDLAFAGRUP FKDLAFEXTERIOR_DLAFAGRUPR

Indexes

Constraint Name Type Sort Column(s)
PKDLAFEXTERIOR Primary key Asc/Asc CODCOLIGADA + IDLAFAGRUP

Relationships

Close relationships within degrees of separation