Datadictionary OpenWave 3.1.11

View: vwdmszaaktypecodes

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwdmszaaktypecodes

Fields

Rules

Definition

CREATE VIEW public.vwdmszaaktypecodes (
   dvmodule,
   dvtabel,
   dnkey,
   dvcode,
   dvdmszaaktypecode)
AS
       (        (        (        (        (
SELECT 'W'::character(1) AS dvmodule,
                                                   'tbsoortomgverg'::character
                                                       varying(19) AS dvtabel,
                                                   tbsoortomgverg.dnkey,
                                                   NULL::character varying(1)
                                                       AS dvcode,
                                                   tbsoortomgverg.dvdmszaaktypecode
FROM tbsoortomgverg
WHERE tbsoortomgverg.dvdmszaaktypecode IS NOT NULL
UNION
SELECT 'E'::character(1) AS dvmodule,
                                                   'tbsoortmilverg'::character
                                                       varying(19) AS dvtabel,
                                                   tbsoortmilverg.dnkey,
                                                   NULL::character varying(1)
                                                       AS dvcode,
                                                   tbsoortmilverg.dvdmszaaktypecode
FROM tbsoortmilverg
WHERE tbsoortmilverg.dvdmszaaktypecode IS NOT NULL)
UNION
SELECT 'C'::character(1) AS dvmodule,
                                           'tbsoorthorverg'::character
                                               varying(19) AS dvtabel,
                                           tbsoorthorverg.dnkey,
                                           NULL::character varying(1) AS dvcode,
                                           tbsoorthorverg.dvdmszaaktypecode
FROM tbsoorthorverg
WHERE tbsoorthorverg.dvdmszaaktypecode IS NOT NULL)
UNION
SELECT 'O'::character(1) AS dvmodule,
                                   'tbsoortovverg'::character varying(19) AS dvtabel,
                                   NULL::integer AS dnkey,
                                   tbsoortovverg.dvcode,
                                   tbsoortovverg.dvdmszaaktypecode
FROM tbsoortovverg
WHERE tbsoortovverg.dvdmszaaktypecode IS NOT NULL)
UNION
SELECT 'B'::character(1) AS dvmodule,
                           'tbsoortplan'::character varying(19) AS dvtabel,
                           tbsoortplan.dnkey,
                           NULL::character varying(1) AS dvcode,
                           tbsoortplan.dvdmszaaktypecode
FROM tbsoortplan
WHERE tbsoortplan.dvdmszaaktypecode IS NOT NULL)
UNION
SELECT 'I'::character(1) AS dvmodule,
                   'tbsoortinfoaanvraag'::character varying(19) AS dvtabel,
                   tbsoortinfoaanvraag.dnkey,
                   NULL::character varying(1) AS dvcode,
                   tbsoortinfoaanvraag.dvdmszaaktypecode
FROM tbsoortinfoaanvraag
WHERE tbsoortinfoaanvraag.dvdmszaaktypecode IS NOT NULL)
UNION
SELECT 'H'::character(1) AS dvmodule,
           'tbsoorthhzaak'::character varying(19) AS dvtabel,
           tbsoorthhzaak.dnkey, NULL::character varying(1) AS dvcode,
           tbsoorthhzaak.dvdmszaaktypecode
FROM tbsoorthhzaak
WHERE tbsoorthhzaak.dvdmszaaktypecode IS NOT NULL;

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