Datadictionary OpenWave 3.1.11 |
|
View: vwhandhhpccontacten
Datadictionary OpenWave 3.1.11 |
|
View: vwhandhhpccontacten
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhandhhpccontacten
Fields
Name | Data type | Description |
|---|---|---|
dnkeyhandhavingen |
integer |
|
dvhpcvoorl |
varchar(10) |
|
dvhpctussenv |
varchar(10) |
|
dvhpcnaam |
varchar(200) |
|
dvhpcbedrijfsnaam |
varchar(200) |
|
dvdebiteurnr |
varchar(20) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyhandhavingen,
dvhpcvoorl,
dvhpctussenv,
dvhpcnaam,
dvhpcbedrijfsnaam,
dvdebiteurnr)
AS
SELECT tbhandhcontactennn.dnkeyhandhavingen,
tbcontactadressen.dvvoorletters AS dvhpcvoorl,
tbcontactadressen.dvvoorvoegsel AS dvhpctussenv,
tbcontactadressen.dvachternaam AS dvhpcnaam,
tbcontactadressen.dvbedrijfsnaam AS dvhpcbedrijfsnaam,
tbcontactadressen.dvdebiteurnr
FROM tbhandhcontactennn
JOIN tbcontactadressen ON tbhandhcontactennn.dnkeycontactadressen =
tbcontactadressen.dnkey
WHERE tbhandhcontactennn.dvcodeadressoort = 'HPC'::bpchar;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|