Datadictionary OpenWave 3.1.25 |
|
View: vwmilinrhoofdsbi
Datadictionary OpenWave 3.1.25 |
|
View: vwmilinrhoofdsbi
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmilinrhoofdsbi
Fields
Name | Data type | Description |
|---|---|---|
dnkeymilinrichtingen |
integer |
|
dlhoofdsbi |
char(1) |
|
dnkeymilsbi |
integer |
|
dvsbinummer |
varchar(40) |
|
dvsbilijst |
varchar(20) |
|
dvsbioms |
varchar(1000) |
|
dnkeymilcodesbi |
integer |
|
dvbestmodcodebranche |
varchar(10) |
|
dvbestmodomsbranche |
varchar(150) |
|
dvbestmodhoortbij |
char(1) |
|
dfbestmodeffectfactor |
double precision |
|
dfbestmodnalevingfactor |
double precision |
|
dfbestmodtotaalfactor |
double precision |
|
dnmilcat |
double precision |
|
dvcodecontrolefreq |
varchar(20) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwmilinrhoofdsbi
Definition
dnkeymilinrichtingen,
dlhoofdsbi,
dnkeymilsbi,
dvsbinummer,
dvsbilijst,
dvsbioms,
dnkeymilcodesbi,
dvbestmodcodebranche,
dvbestmodomsbranche,
dvbestmodhoortbij,
dfbestmodeffectfactor,
dfbestmodnalevingfactor,
dfbestmodtotaalfactor,
dnmilcat,
dvcodecontrolefreq)
AS
SELECT a.dnkeymilinrichtingen,
a.dlhoofdsbi,
a.dnkey AS dnkeymilsbi,
b.dvsbinummer,
b.dvsbilijst,
b.dvsbioms,
b.dnkey AS dnkeymilcodesbi,
c.dvcodebranche AS dvbestmodcodebranche,
c.dvomsbranche AS dvbestmodomsbranche,
c.dvhoortbij AS dvbestmodhoortbij,
c.dfeffectfactor AS dfbestmodeffectfactor,
c.dfnalevingfactor AS dfbestmodnalevingfactor,
c.dfeffectfactor * c.dfnalevingfactor AS dfbestmodtotaalfactor,
b.dnmilcat,
d.dvcode AS dvcodecontrolefreq
FROM tbmilsbi a
JOIN tbmilcodesbi b ON a.dnkeymilcodesbi = b.dnkey AND a.dlhoofdsbi = 'T'::bpchar
LEFT JOIN tbinspbesturingsmodel c ON b.dnkeyinspbesturingsmodel = c.dnkey
LEFT JOIN tbmilurgentie d ON c.dnkeymilurgentie = d.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|