Datadictionary OpenWave 3.1.25 |
|
View: vwlegeswizard
Datadictionary OpenWave 3.1.25 |
|
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 |
|
|
|
Indices
There are no indices for table vwlegeswizard
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 5-1-2022 14:13 |
|