Datadictionary OpenWave 3.1.11 |
|
View: vwinfoavrcontacten
Datadictionary OpenWave 3.1.11 |
|
View: vwinfoavrcontacten
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwinfoavrcontacten
Fields
Name | Data type | Description |
|---|---|---|
dnkeyinfoaanvraag |
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
dnkeyinfoaanvraag,
dvavrvoorl,
dvavrtussenv,
dvavrnaam,
dvavrbedrijfsnaam,
dvdebiteurnr,
dvavrstraatnaam,
dvavrhuisnummer,
dvavrhuisletter,
dvavrhuisnrtoev,
dvavrpostcode,
dvavrwoonplaats,
dnkeycontactadressen)
AS
SELECT tbinfocontactennn.dnkeyinfoaanvraag,
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 tbinfocontactennn
JOIN tbcontactadressen ON tbinfocontactennn.dnkeycontactadressen =
tbcontactadressen.dnkey
WHERE tbinfocontactennn.dvcodeadressoort = 'AVR'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|