Datadictionary OpenWave 3.1.11 |
|
View: vwhandhovertredingen
Datadictionary OpenWave 3.1.11 |
|
View: vwhandhovertredingen
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhandhovertredingen
Fields
Name | Data type | Description |
|---|---|---|
dnovertredingkey |
integer |
|
dvovertreding |
varchar(200) |
|
ddovertredingvervaldat |
timestamp |
|
dvwetbasis |
varchar(200) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnovertredingkey,
dvovertreding,
ddovertredingvervaldat,
dvwetbasis)
AS
SELECT tbhandhovertreding.dnkey AS dnovertredingkey,
tbhandhovertreding.dvomschrijving AS dvovertreding,
tbhandhovertreding.ddvervaldatum AS ddovertredingvervaldat,
tbhandhwetbasis.dvomschrijving AS dvwetbasis
FROM tbhandhovertreding
JOIN tbhandhwetbasis ON tbhandhovertreding.dnkeyhandhwetbasis =
tbhandhwetbasis.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|