View vwinrprepjongstedatumverleend

Datadictionary OpenWave 3.1.11

View: vwinrprepjongstedatumverleend

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinrprepjongstedatumverleend

Fields

Name	Data type	Description
ddjongstedatum	timestamp
dnkeymilinrichtingen	integer

Rules

Name	Event	Instead	Condition	Description
_RETURN	SELECT

Definition

CREATE VIEW public.vwinrprepjongstedatumverleend ( ddjongstedatum, dnkeymilinrichtingen) AS SELECT max(vwinrichtingpreparaties.dddatum) AS ddjongstedatum, vwinrichtingpreparaties.dnkeymilinrichtingen FROM vwinrichtingpreparaties WHERE vwinrichtingpreparaties.dvstatus = 'V'::bpchar GROUP BY vwinrichtingpreparaties.dnkeymilinrichtingen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50