PMOTMUDFUNCAO

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTFCO.CODCOLIGADA FKPFHSTFCO_PMOTMUDFUNCAOR
PORCAMENTOPROMOCAO.CODCOLIGADA FKPORCAMENTOPROMOCAO_PMOTMUDFUR
VALTDADFUNCPROG.CODCOLIGADA FKVALTDADFUNCPROG_PMOTMUDFUNCAR
VFLUXOREQPROMOCAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_PMOTMUDFUNR
VMOTIVOREQUISICAO.CODCOLIGADA FKVMOTIVOREQUISI_PMOTMUDFUNCAOR
VREQPROMOCAO.CODCOLREQUISICAO FKVREQPROMOCAO_PMOTMUDFUNCAOR
VREQPROMOCAOPARECER.CODCOLREQUISICAO FKVREQPROMOPAREC_PMOTMUDFUNCAOR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVREQTRANSFPROM_PMOTMUDFUNCAOR
VREQTRANSFPROMOCAOPARECER.CODCOLREQUISICAO FKVREQTRANSFPROMPAR_PMOTMUDFUNR
VTRANSFALTDADFUNCPROG.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PMOTMUR
GCOLIGADA.CODCOLIGADA FKPMOTMUDFUNCAO_GCOLIGADAR
CODCLIENTE varchar 2 null
PFHSTFCO.MOTIVO FKPFHSTFCO_PMOTMUDFUNCAOR
PORCAMENTOPROMOCAO.CODMOTIVO FKPORCAMENTOPROMOCAO_PMOTMUDFUR
VALTDADFUNCPROG.CODMOTMUDFUNCAO FKVALTDADFUNCPROG_PMOTMUDFUNCAR
VFLUXOREQPROMOCAO.CODCLIENTEMUDFUNCAO FKVFLUXOREQPROMOCAO_PMOTMUDFUNR
VMOTIVOREQUISICAO.MOTIVOFUNCAO FKVMOTIVOREQUISI_PMOTMUDFUNCAOR
VREQPROMOCAO.CODMOTMUDFUNCAO FKVREQPROMOCAO_PMOTMUDFUNCAOR
VREQPROMOCAOPARECER.CODMOTMUDFUNCAO FKVREQPROMOPAREC_PMOTMUDFUNCAOR
VREQTRANSFPROMOCAO.CODMOTMUDFUNCAO FKVREQTRANSFPROM_PMOTMUDFUNCAOR
VREQTRANSFPROMOCAOPARECER.CODMOTMUDFUNCAO FKVREQTRANSFPROMPAR_PMOTMUDFUNR
VTRANSFALTDADFUNCPROG.CODMOTMUDFUNCAO FKVTRANSFALTDADFUNCPROG_PMOTMUR
CODINTERNO varchar 2 null
PTPFINAGRI.CODINTERNO Implied ConstraintR
DESCRICAO varchar 50 √ null
PODEALTERAR smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPMOTMUDFUNCAO Primary key Asc/Asc CODCOLIGADA + CODCLIENTE

Relationships

Close relationships within degrees of separation