VREQTRANSFLOTE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFLOTECOMPL.CODCOLREQUISICAO FKVREQTRANSFLOTECOMPL_VREQTRANR
VREQTRANSFLOTEFUNC.CODCOLREQUISICAO FKVREQTRANSFLOTEFUNC_VREQTRANSR
VREQTRANSFLOTEPARECER.CODCOLREQUISICAO FKVREQTRANSFLOTEPARECER_VREQTRR
VREQTRANSFLOTERATEIOCC.CODCOLREQUISICAO FKVREQTRANSRATEIOCC_VREQTRANSFR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFLOTE_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKVREQTRANSFLOTE_PSECAOR
HATENDIMENTOBASE.CODCOLIGADA FKVREQTRANSFLOTE_HATENDIMENTOBR
GFILIAL.CODCOLIGADA FKVREQTRANSFLOTE_GFILIALR
IDREQ int 4 null
VREQTRANSFLOTECOMPL.IDREQ FKVREQTRANSFLOTECOMPL_VREQTRANR
VREQTRANSFLOTEFUNC.IDREQ FKVREQTRANSFLOTEFUNC_VREQTRANSR
VREQTRANSFLOTEPARECER.IDREQ FKVREQTRANSFLOTEPARECER_VREQTRR
VREQTRANSFLOTERATEIOCC.IDREQ FKVREQTRANSRATEIOCC_VREQTRANSFR
JUSTIFICATIVA varchar 2147483647 null
DATAABERTURA DDATETIME 16,3 null
DATACANCELAMENTO DDATETIME 16,3 √ null
DATACONCLUSAO DDATETIME 16,3 √ null
CODCOLREQUISITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQTRANSFLOTE_PFUNCR
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQTRANSFLOTE_PFUNCR
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQTRANSFLOTE_HATENDIMENTOBR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQTRANSFLOTE_HATENDIMENTOBR
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQTRANSFLOTE_VREQSTATUSR
DATAPREVISTA DDATETIME 16,3 √ null
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFLOTE_GFILIALR
CODSECAO varchar 35 null
PSECAO.CODIGO FKVREQTRANSFLOTE_PSECAOR
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFLOTE_PMOTMUDSECAOR
CRIASUBSTITUICAO smallint 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 FKVREQTRANSFLOTE_VHIERARQUIAR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFLOTE_VHIERARQUIAR

Indexes

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

Relationships

Close relationships within degrees of separation