Datadictionary OpenWave 3.1.11 |
|
View: vwmilinrhoofdsbi
Datadictionary OpenWave 3.1.11 |
|
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(11) |
|
dvsbilijst |
varchar(20) |
|
dvsbioms |
varchar(1000) |
|
dnkeymilcodesbi |
integer |
|
dvbestmodcodebranche |
varchar(10) |
|
dvbestmodomsbranche |
varchar(50) |
|
dvbestmodhoortbij |
char(1) |
|
dfbestmodeffectfactor |
double precision |
|
dfbestmodnalevingfactor |
double precision |
|
dfbestmodtotaalfactor |
double precision |
|
dnmilcat |
double precision |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeymilinrichtingen,
dlhoofdsbi,
dnkeymilsbi,
dvsbinummer,
dvsbilijst,
dvsbioms,
dnkeymilcodesbi,
dvbestmodcodebranche,
dvbestmodomsbranche,
dvbestmodhoortbij,
dfbestmodeffectfactor,
dfbestmodnalevingfactor,
dfbestmodtotaalfactor,
dnmilcat)
AS
SELECT tbmilsbi.dnkeymilinrichtingen,
max(tbmilsbi.dlhoofdsbi)::character(1) AS dlhoofdsbi,
max(tbmilsbi.dnkey) AS dnkeymilsbi,
max(tbmilcodesbi.dvsbinummer::text)::character varying(11) AS dvsbinummer,
max(tbmilcodesbi.dvsbilijst::text)::character varying(20) AS dvsbilijst,
max(tbmilcodesbi.dvsbioms::text)::character varying(1000) AS dvsbioms,
max(tbmilcodesbi.dnkey) AS dnkeymilcodesbi,
max(tbinspbesturingsmodel.dvcodebranche::text)::character varying(10) AS
dvbestmodcodebranche,
max(tbinspbesturingsmodel.dvomsbranche::text)::character varying(50) AS
dvbestmodomsbranche,
max(tbinspbesturingsmodel.dvhoortbij)::character(1) AS dvbestmodhoortbij,
max(tbinspbesturingsmodel.dfeffectfactor) AS dfbestmodeffectfactor,
max(tbinspbesturingsmodel.dfnalevingfactor) AS dfbestmodnalevingfactor,
max(tbinspbesturingsmodel.dfeffectfactor *
tbinspbesturingsmodel.dfnalevingfactor) AS dfbestmodtotaalfactor,
max(tbmilcodesbi.dnmilcat) AS dnmilcat
FROM tbmilsbi
JOIN tbmilcodesbi ON tbmilsbi.dnkeymilcodesbi = tbmilcodesbi.dnkey
LEFT JOIN tbinspbesturingsmodel ON tbmilcodesbi.dnkeyinspbesturingsmodel =
tbinspbesturingsmodel.dnkey
WHERE tbmilsbi.dlhoofdsbi = 'T'::bpchar
GROUP BY tbmilsbi.dnkeymilinrichtingen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|