Datadictionary OpenWave 3.1.11 |
|
View: vwleges_soort
Datadictionary OpenWave 3.1.11 |
|
View: vwleges_soort
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwleges_soort
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dnkeylegessoort |
integer |
|
dnjaar |
integer |
|
dfvastbedrag |
double precision |
|
dfpromillage |
double precision |
|
dfcategoriebodem |
double precision |
|
dfcategorieplafond |
double precision |
|
dffactor |
double precision |
|
dddatumvanaf |
timestamp |
|
dddatumtotmet |
timestamp |
|
dfafrondinggetal |
double precision |
|
dnafrondingmethode |
integer |
|
dfminimum |
double precision |
|
dfmaximum |
double precision |
|
dnsoortkey |
integer |
|
ddvervaldatum |
timestamp |
|
dvsoortoms |
varchar(100) |
|
dnkeyafhankelijkvan |
integer |
|
dlbonusmalus |
char(1) |
|
dnberekenwijze |
integer |
|
ddrekenvervaldatum |
timestamp |
|
dlopslagaanvul |
char(1) |
|
dlkortingdigi |
char(1) |
|
dlkortingaantact |
char(1) |
|
dlberafrgehgetal |
char(1) |
|
dvgemeentecode |
varchar(4) |
|
dfafrnabergetal |
double precision |
|
dnafrnabermethode |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
dnkeylegessoort,
dnjaar,
dfvastbedrag,
dfpromillage,
dfcategoriebodem,
dfcategorieplafond,
dffactor,
dddatumvanaf,
dddatumtotmet,
dfafrondinggetal,
dnafrondingmethode,
dfminimum,
dfmaximum,
dnsoortkey,
ddvervaldatum,
dvsoortoms,
dnkeyafhankelijkvan,
dlbonusmalus,
dnberekenwijze,
ddrekenvervaldatum,
dlopslagaanvul,
dlkortingdigi,
dlkortingaantact,
dlberafrgehgetal,
dvgemeentecode,
dfafrnabergetal,
dnafrnabermethode)
AS
SELECT a.dnkey, a.dnkeylegessoort, a.dnjaar, a.dfvastbedrag, a.dfpromillage,
a.dfcategoriebodem, a.dfcategorieplafond, a.dffactor, a.dddatumvanaf,
a.dddatumtotmet, a.dfafrondinggetal, a.dnafrondingmethode, a.dfminimum,
a.dfmaximum, b.dnkey AS dnsoortkey, b.ddvervaldatum,
b.dvomschrijving AS dvsoortoms, b.dnkeyafhankelijkvan, b.dlbonusmalus,
b.dnberekenwijze, a.ddvervaldatum AS ddrekenvervaldatum, b.dlopslagaanvul,
b.dlkortingdigi, b.dlkortingaantact, a.dlberafrgehgetal, b.dvgemeentecode,
a.dfafrnabergetal, a.dnafrnabermethode
FROM tblegesberekeningen 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 |
|