TMDE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TMDEEVENTHISTORICO.CODCOLIGADA FKTMDEEVENTHISTORICO_TMDER
GFILIAL.CODCOLIGADA FKTMDE_GFILIALR
IDMDE int 4 null
TMDEEVENTHISTORICO.IDMDE FKTMDEEVENTHISTORICO_TMDER
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKTMDE_GFILIALR
EVENTO varchar 1 √ null
CHAVEACESSO varchar 44 √ null
DATAEMISSAO DDATETIME 16,3 √ null
DATAAUTORIZACAO DDATETIME 16,3 √ null
NUMERO varchar 15 √ null
VALORTOTALNFE RMDVALOR4 17,4 √ null
CODCOLCFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKTMDE_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKTMDE_FCFOR
TIPOOPDOC varchar 1 √ null
SITDOC varchar 1 √ null
SITUACAOCONFIRMACAO char 1 √ null
JUSTIFEVENTO varchar 255 √ null
AMBIENTE varchar 1 √ null
CORRECAOCCE varchar 1000 √ null
XMLRET varchar 2147483647 √ null
STATUSEVENTO varchar 80 √ null
STATUSRESP varchar 50 √ null
STATUSRESPDESC varchar 100 √ null
TIPOINCLUSAO varchar 1 √ null
OBSERVACAO varchar 2147483647 √ null
IDEVENTOTSS varchar 100 √ 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)
PKTMDE Primary key Asc/Asc CODCOLIGADA + IDMDE

Relationships

Close relationships within degrees of separation