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