Datadictionary OpenWave 3.1.11 |
|
View: vwomgavrcontacten
Datadictionary OpenWave 3.1.11 |
|
View: vwomgavrcontacten
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwomgavrcontacten
Fields
Name | Data type | Description |
|---|---|---|
dnkeyomgvergunningen |
integer |
|
dvavrvoorl |
varchar(10) |
|
dvavrtussenv |
varchar(10) |
|
dvavrnaam |
varchar(200) |
|
dvavrbedrijfsnaam |
varchar(200) |
|
dvdebiteurnr |
varchar(20) |
|
dvavrstraatnaam |
varchar(80) |
|
dvavrhuisnummer |
varchar(5) |
|
dvavrhuisletter |
char(1) |
|
dvavrhuisnrtoev |
varchar(4) |
|
dvavrpostcode |
varchar(10) |
|
dvavrwoonplaats |
varchar(80) |
|
dnkeycontactadressen |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyomgvergunningen,
dvavrvoorl,
dvavrtussenv,
dvavrnaam,
dvavrbedrijfsnaam,
dvdebiteurnr,
dvavrstraatnaam,
dvavrhuisnummer,
dvavrhuisletter,
dvavrhuisnrtoev,
dvavrpostcode,
dvavrwoonplaats,
dnkeycontactadressen)
AS
SELECT tbomgvergcontactennn.dnkeyomgvergunningen,
tbcontactadressen.dvvoorletters AS dvavrvoorl,
tbcontactadressen.dvvoorvoegsel AS dvavrtussenv,
tbcontactadressen.dvachternaam AS dvavrnaam,
tbcontactadressen.dvbedrijfsnaam AS dvavrbedrijfsnaam,
tbcontactadressen.dvdebiteurnr,
tbcontactadressen.dvstraatnaam AS dvavrstraatnaam,
tbcontactadressen.dvhuisnummer AS dvavrhuisnummer,
tbcontactadressen.dvhuisletter AS dvavrhuisletter,
tbcontactadressen.dvhuisnummertoevoeging AS dvavrhuisnrtoev,
tbcontactadressen.dvpostcode AS dvavrpostcode,
tbcontactadressen.dvwoonplaatsnaam AS dvavrwoonplaats,
tbcontactadressen.dnkey AS dnkeycontactadressen
FROM tbomgvergcontactennn
JOIN tbcontactadressen ON tbomgvergcontactennn.dnkeycontactadressen =
tbcontactadressen.dnkey
WHERE tbomgvergcontactennn.dvcodeadressoort = 'AVR'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|