Datadictionary OpenWave 3.1.11 |
|
View: vwkoptoestadv
Datadictionary OpenWave 3.1.11 |
|
View: vwkoptoestadv
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwkoptoestadv
Fields
Name | Data type | Description |
|---|---|---|
dvcodeadviesinst |
char(4) |
|
dnkeysoortomg |
integer |
|
dnkeysrttoest |
integer |
|
dvbehandelfase |
char(1) |
|
dnbehrappel |
integer |
|
dvbeheenheid |
char(1) |
|
dvadviesinstantie |
varchar(40) |
|
dvtoestemmingnaam |
varchar(100) |
|
dvcodedefbehandelaar |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dvcodeadviesinst,
dnkeysoortomg,
dnkeysrttoest,
dvbehandelfase,
dnbehrappel,
dvbeheenheid,
dvadviesinstantie,
dvtoestemmingnaam,
dvcodedefbehandelaar)
AS
SELECT tbkoptoestadv.dvcodeadviesinst, tbkoptoestadv.dnkeysoortomg,
tbkoptoestadv.dnkeysrttoest, tbkoptoestadv.dvbehandelfase,
tbkoptoestadv.dnbehrappel, tbkoptoestadv.dvbeheenheid,
tbadviesinstanties.dvomschrijving AS dvadviesinstantie,
tbsrttoestemming.dvtoestemmingnaam, tbadviesinstanties.dvcodedefbehandelaar
FROM tbkoptoestadv
JOIN tbadviesinstanties ON tbkoptoestadv.dvcodeadviesinst = tbadviesinstanties.dvcode
JOIN tbsrttoestemming ON tbkoptoestadv.dnkeysrttoest = tbsrttoestemming.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|