Datadictionary OpenWave 3.1.25 |
|
View: vwhorecaavrcontacten
Datadictionary OpenWave 3.1.25 |
|
View: vwhorecaavrcontacten
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhorecaavrcontacten
Fields
Name | Data type | Description |
|---|---|---|
dnkeyhorecavergunningen |
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) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwhorecaavrcontacten
Definition
dnkeyhorecavergunningen,
dvavrvoorl,
dvavrtussenv,
dvavrnaam,
dvavrbedrijfsnaam,
dvdebiteurnr,
dvavrstraatnaam,
dvavrhuisnummer,
dvavrhuisletter,
dvavrhuisnrtoev,
dvavrpostcode,
dvavrwoonplaats)
AS
SELECT tbhorecacontactennn.dnkeyhorecavergunningen,
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
FROM tbhorecacontactennn
JOIN tbcontactadressen ON tbhorecacontactennn.dnkeycontactadressen =
tbcontactadressen.dnkey
WHERE tbhorecacontactennn.dvcodeadressoort = 'AVR'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|