Datadictionary OpenWave 3.1.11 |
|
View: vwlegeswizard
Datadictionary OpenWave 3.1.11 |
|
View: vwlegeswizard
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwlegeswizard
Fields
Name | Data type | Description |
|---|---|---|
dnkeyomgvergunningen |
integer |
|
dflegesbedrag |
double precision |
|
dnlegesmoment |
integer |
|
dlkortingdigi |
char(1) |
|
dlkortingaantact |
char(1) |
|
dlopslagaanvul |
char(1) |
|
dltmvbutianv |
char(1) |
|
dltmvbutiatb |
char(1) |
|
dltmvbutwv |
char(1) |
|
dltmvbutbbb |
char(1) |
|
dltmvbuwel |
char(1) |
|
dnkeytoestemmingen |
integer |
|
dnkeylegessoort |
integer |
|
dvgemeentecode |
varchar(4) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyomgvergunningen,
dflegesbedrag,
dnlegesmoment,
dlkortingdigi,
dlkortingaantact,
dlopslagaanvul,
dltmvbutianv,
dltmvbutiatb,
dltmvbutwv,
dltmvbutbbb,
dltmvbuwel,
dnkeytoestemmingen,
dnkeylegessoort,
dvgemeentecode)
AS
SELECT a.dnkeyomgvergunningen,
CASE
WHEN a.dflegesbedrag IS NULL THEN 0::double precision
ELSE a.dflegesbedrag
END AS dflegesbedrag,
a.dnlegesmoment, b.dlkortingdigi, b.dlkortingaantact, b.dlopslagaanvul,
b.dltmvbutianv, b.dltmvbutiatb, b.dltmvbutwv, b.dltmvbutbbb, b.dltmvbuwel,
a.dnkeytoestemmingen, a.dnkeylegessoort, b.dvgemeentecode
FROM tblegesregels a
JOIN tblegessoort b ON a.dnkeylegessoort = b.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|