TCTE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCTEHISTORICO.CODCOLIGADA FKTCTEHISTORICO_TCTER
TCTEMOV.CODCOLIGADA FKTCTE_TCTEMOVR
IDMOV int 4 √ null
STATUS varchar 1 null
CHAVEACESSO varchar 44 √ null
FORMATODACTE smallint 2 √ null
XMLCTE MEMO 2147483647 √ null
PROTOCOLO varchar 15 √ null
DATAAUTORIZACAO DDATETIME 16,3 √ null
EMITIDACONTIGENCIA smallint 2 ((0))
DADOSCTECONTINGENCIA varchar 44 √ null
DACTEIMPRESSA smallint 2 ((0))
EMAILENVIADO smallint 2 ((0))
NUMFORMSEGURANCA varchar 12 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCTE int 4 null
TCTEHISTORICO.IDCTE FKTCTEHISTORICO_TCTER
TCTEMOV.IDCTE FKTCTE_TCTEMOVR
STATUSEPEC char 1 √ null
XMLEPEC MEMO 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation