VFLUXOREQPROMOCAO

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PMOTMUDSAL.CODCOLIGADA FKVFLUXOREQPROMOCAO_PMOTMUDSALR
PMOTMUDFUNCAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_PMOTMUDFUNR
PFUNCAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_PFUNCAOR
PSECAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_PSECAOR
VFAIXASALARIAL.CODCOLIGADA FKVFLUXOREQPROMOCAO_VFAIXASALR
VNIVELFUNCAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_VNIVELFUNCR
CODREQPROMOCAO varchar 16 null
SEQUENCIAL smallint 2 null
DATAINIVIGENCIA datetime 16,3 √ null
DATAPARECER datetime 16,3 √ null
CODFUNCAOAPROV varchar 10 √ null
PFUNCAO.CODIGO FKVFLUXOREQPROMOCAO_PFUNCAOR
SALARIOAPROV RMDVALOR2 17,2 √ null
CODNIVELAPROV varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVFLUXOREQPROMOCAO_VNIVELFUNCR
CODFAIXAAPROV varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVFLUXOREQPROMOCAO_VFAIXASALR
CODCLIENTEMUDSAL varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVFLUXOREQPROMOCAO_PMOTMUDSALR
CODMEMOOBS int 4 √ null
VMEMO.ID FKVFLUXOREQPROMOCAO_VMEMOR
CODCLIENTEMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVFLUXOREQPROMOCAO_PMOTMUDFUNR
CHAPARESPPARECER DCHAPA 16 null
PFUNC.CHAPA FKVFLUXOREQPROMOCAO_PFUNCR
CODSECAORESPPARECER varchar 35 √ null
PSECAO.CODIGO FKVFLUXOREQPROMOCAO_PSECAOR
CODCOLIGRESPPARECER DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVFLUXOREQPROMOCAO_PFUNCR
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)
PKVFLUXOREQPROMOCAO Primary key Asc/Asc/Asc CODCOLIGADA + CODREQPROMOCAO + SEQUENCIAL

Relationships

Close relationships within degrees of separation