VREQTRANSFERENCIA

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFERENCIACOMPL.CODCOLREQUISICAO FKVREQTRANSCOMPL_VREQTRANSFERER
VREQTRANSFERENCIAPARECER.CODCOLREQUISICAO FKVREQTRANSFPARECER_VREQTRANSFR
VREQTRANSFERENCIARATEIOCC.CODCOLREQUISICAO FKVREQTRANSTEIOCC_VREQTRANSFERR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFERENC_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKVREQTRANSFERENCIA_PSECAOR
HATENDIMENTOBASE.CODCOLIGADA FKVREQTRANSFER_HATENDIMENTOEXTR
GFILIAL.CODCOLIGADA FKVREQTRANSFERENCIA_GFILIALR
IDREQ int 4 null
VREQTRANSFERENCIACOMPL.IDREQ FKVREQTRANSCOMPL_VREQTRANSFERER
VREQTRANSFERENCIAPARECER.IDREQ FKVREQTRANSFPARECER_VREQTRANSFR
VREQTRANSFERENCIARATEIOCC.IDREQ FKVREQTRANSTEIOCC_VREQTRANSFERR
TIPOREQPAI int 4 √ null
IDREQPAI int 4 √ null
JUSTIFICATIVA MEMO 2147483647 null
DATAABERTURA datetime 16,3 null
DATACANCELAMENTO datetime 16,3 √ null
DATACONCLUSAO datetime 16,3 √ null
CODCOLREQUISITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQTRANSF_PFUNCREQUISITANTER
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQTRANSF_PFUNCREQUISITANTER
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQTRANSFER_HATENDIMENTOEXTR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQTRANSFER_HATENDIMENTOEXTR
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQTRANSFERENCIA_VREQSTATUSR
DATAPREVISTA datetime 16,3 √ null
CRIASUBSTITUICAO smallint 2 null
CHAPA varchar 16 √ null
PFUNC.CHAPA FKVREQTRANSFERENCIA_PFUNCR
CODCOLORG DCODCOLIGADA 2 null
VPOSICAO.CODCOLIGADA FKVREQTRANSFERENCIA_VPOSICAOR
PFUNC.CODCOLIGADA FKVREQTRANSFERENCIA_PFUNCR
PSECAO.CODCOLIGADA FKVREQTRANSFERENCIA_PSECAOORGR
GFILIAL.CODCOLIGADA FKVREQTRANSFERENCIA_GFILIALORGR
CODFILIALORG smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFERENCIA_GFILIALORGR
CODSECAOORG varchar 35 null
PSECAO.CODIGO FKVREQTRANSFERENCIA_PSECAOORGR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFERENCIA_GFILIALR
CODSECAO varchar 35 null
PSECAO.CODIGO FKVREQTRANSFERENCIA_PSECAOR
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFERENC_PMOTMUDSECAOR
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
CODCOLHIERARQUIAORIGEM DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSF_VHIERORIGEMR
IDHIERARQUIAORIGEM int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSF_VHIERORIGEMR
CODCOLHIERARQUIADESTINO DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSF_VHIERDESTINOR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSF_VHIERDESTINOR
IDPOSICAOORIGEM int 4 √ null
VPOSICAO.IDPOSICAO FKVREQTRANSFERENCIA_VPOSICAOR

Indexes

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

Relationships

Close relationships within degrees of separation