VREQTRANSFERENCIAPARECER

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFERENCIA.CODCOLREQUISICAO FKVREQTRANSFPARECER_VREQTRANSFR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFPAREC_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKVREQTRANSFPARECER_PSECAOR
GFILIAL.CODCOLIGADA FKVREQTRANSFPARECER_GFILIALR
IDPARECER int 4 null
IDREQ int 4 null
VREQTRANSFERENCIA.IDREQ FKVREQTRANSFPARECER_VREQTRANSFR
CODCOLSOLICITANTE DCODCOLIGADA 2 null
CHAPASOLICITANTE varchar 16 null
PARECER MEMO 2147483647 null
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQTRANSFPARECER_VREQSTATUSR
DATAPARECER datetime 16,3 null
DATAPREVISTA datetime 16,3 √ null
SUSPENSAO DLOGICO 2 null
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFPARECER_GFILIALR
CODSECAO varchar 35 null
PSECAO.CODIGO FKVREQTRANSFPARECER_PSECAOR
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFPAREC_PMOTMUDSECAOR
CRIASUBSTITUICAO DLOGICO 2 null
TRANSFERIRVAGA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLHIERARQUIADESTINO DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFERENCIAPARECER_VHR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFERENCIAPARECER_VHR

Indexes

Constraint Name Type Sort Column(s)
PKVREQTRANSFERENCIAPARECER Primary key Asc/Asc/Asc CODCOLREQUISICAO + IDPARECER + IDREQ

Relationships

Close relationships within degrees of separation