TCTEHISTORICO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKTCTEHISTORICO_GCOLIGADAR
TCTE.CODCOLIGADA FKTCTEHISTORICO_TCTER
IDMOV int 4 √ null
IDHISTORICO int 4 null
STATUS varchar 1 null
PROTOCOLO varchar 15 √ null
DATASTATUS DDATETIME 16,3 null
CODUSUARIO varchar 20 null
OBSERVACAO varchar 1000 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCTE int 4 null
TCTE.IDCTE FKTCTEHISTORICO_TCTER
TIPOOPERACAO varchar 1 √ null
TIPOEVENTO varchar 100 √ null
AMBIENTE varchar 100 √ null
IDEVENTOTSS varchar 100 √ null
XMLENVIO varchar 2147483647 √ null
XMLRETORNO varchar 2147483647 √ null
LOTEEVENTO varchar 50 √ null
STATUSEVENTORESP varchar 3 √ null
STATUSEVENTORESPDESC varchar 300 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTCTEHISTORICO Primary key Asc/Asc/Asc CODCOLIGADA + IDCTE + IDHISTORICO

Relationships

Close relationships within degrees of separation