TNFEENTRADA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKTNFEENTRADA_GCOLIGADAR
TMOV.CODCOLIGADA FKTNFEENTRADA_TMOVR
GFILIAL.CODCOLIGADA FKTNFEENTRADA_GFILIALR
ID int 4 null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKTNFEENTRADA_GFILIALR
CODCOLCFO DCODCOLIGADA 2 √ null
FCFO.CODCOLIGADA FKTNFEENTRADA_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKTNFEENTRADA_FCFOR
CHAVEACESSO varchar 45 √ null
DATAEMISSAO DDATETIME 16,3 √ null
NUMERO varchar 20 √ null
DATAAUTORIZACAO DDATETIME 16,3 √ null
DATAATUALIZACAO DDATETIME 16,3 √ null
STATUS varchar 1 √ null
IDMOV int 4 √ null
TMOV.IDMOV FKTNFEENTRADA_TMOVR
XML MEMO 2147483647 √ null
IMPORTADOSSEFAZ bit 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOXML int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTNFEENTRADA Primary key Asc ID

Relationships

Close relationships within degrees of separation