Datadictionary OpenWave 3.1.11 |
|
View: vwhorecaleicontacten
Datadictionary OpenWave 3.1.11 |
|
View: vwhorecaleicontacten
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhorecaleicontacten
Fields
Name | Data type | Description |
|---|---|---|
dnkeyhorecavergunningen |
integer |
|
dvleivoorl |
varchar(10) |
|
dvleitussenv |
varchar(10) |
|
dvleinaam |
varchar(200) |
|
ddgeboortedatum |
timestamp |
|
dvdebiteurnr |
varchar(20) |
|
dvleitelefoon |
varchar(30) |
|
dvleistraatnaam |
varchar(80) |
|
dvleihuisnummer |
varchar(5) |
|
dvleihuisletter |
char(1) |
|
dvleihuisnrtoev |
varchar(4) |
|
dvleipostcode |
varchar(10) |
|
dvleiwoonplaats |
varchar(80) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyhorecavergunningen,
dvleivoorl,
dvleitussenv,
dvleinaam,
ddgeboortedatum,
dvdebiteurnr,
dvleitelefoon,
dvleistraatnaam,
dvleihuisnummer,
dvleihuisletter,
dvleihuisnrtoev,
dvleipostcode,
dvleiwoonplaats)
AS
SELECT tbhorecacontactennn.dnkeyhorecavergunningen,
tbcontactadressen.dvvoorletters AS dvleivoorl,
tbcontactadressen.dvvoorvoegsel AS dvleitussenv,
tbcontactadressen.dvachternaam AS dvleinaam,
tbcontactadressen.ddgeboortedatum, tbcontactadressen.dvdebiteurnr,
tbcontactadressen.dvtelefoon AS dvleitelefoon,
tbcontactadressen.dvstraatnaam AS dvleistraatnaam,
tbcontactadressen.dvhuisnummer AS dvleihuisnummer,
tbcontactadressen.dvhuisletter AS dvleihuisletter,
tbcontactadressen.dvhuisnummertoevoeging AS dvleihuisnrtoev,
tbcontactadressen.dvpostcode AS dvleipostcode,
tbcontactadressen.dvwoonplaatsnaam AS dvleiwoonplaats
FROM tbhorecacontactennn
JOIN tbcontactadressen ON tbhorecacontactennn.dnkeycontactadressen =
tbcontactadressen.dnkey
WHERE tbhorecacontactennn.dvcodeadressoort = 'LEI'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|