Datadictionary OpenWave 3.1.32
 Previous topic Chapter index Next topic

View: vwfrmsysstandardschermaanroepen

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

View van alle schermaanroepen uit tbsysstandardtable en tbsysstandardbutton

 

Fields

Name

Data type

Description

dvschermnaam

varchar

Een dvlistscreenfilename of dvdetailscreenfilename of dvfilterscreenfilename uit tbsysstandardtabel of een parameter uit tbstandaardbutton die begint met md

dvapitype

varchar(20)

tbstandardtable of tbstandardbutton

dvcodesysstandard

varchar(40)

Codering van tbsysstandardtable waarvandaan scherm wordt aangeroepen (al of niet via tbsystandardbutton)

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwfrmsysstandardschermaanroepen

 

Definition

CREATE VIEW public.vwfrmsysstandardschermaanroepen (
   dvschermnaam,
   dvapitype,
   dvcodesysstandard)
AS
SELECT tbsysstandardtable.dvlistscreenfilename AS dvschermnaam,
   'tbsysstandardtable'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardtable
WHERE lower(tbsysstandardtable.dvlistscreenfilename::text) ~~ 'mdlc_%'::text
UNION
SELECT tbsysstandardtable.dvdetailscreenfilename AS dvschermnaam,
   'tbsysstandardtable'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardtable
WHERE lower(tbsysstandardtable.dvdetailscreenfilename::text) ~~ 'mddc_%'::text
UNION
SELECT tbsysstandardtable.dvfilterscreenfilename AS dvschermnaam,
   'tbsysstandardtable'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardtable
WHERE lower(tbsysstandardtable.dvfilterscreenfilename::text) ~~ 'mdfc_%'::text
UNION
SELECT tbsysstandardbutton.dvparam1 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam1::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam2 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam2::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam3 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam3::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam4 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam4::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam5 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam5::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam6 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam6::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam7 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam7::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam8 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam8::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam9 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam9::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam10 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam10::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam11 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam11::text) ~~ 'md%'::text
UNION
SELECT tbsysstandardbutton.dvparam12 AS dvschermnaam,
   'tbsysstandardbutton'::character varying(20) AS dvapitype,
   tbsysstandardtable.dvcode AS dvcodesysstandard
FROM tbsysstandardbutton
    JOIN tbsysstandardtable ON tbsysstandardbutton.dnkeysysstandardtable =
        tbsysstandardtable.dnkey
WHERE lower(tbsysstandardbutton.dvparam12::text) ~~ 'md%'::text;

COMMENT ON VIEW public.vwfrmsysstandardschermaanroepen
IS 'View van alle schermaanroepen uit tbsysstandardtable en tbsysstandardbutton';

COMMENT ON COLUMN public.vwfrmsysstandardschermaanroepen.dvschermnaam
IS 'Een dvlistscreenfilename of dvdetailscreenfilename of dvfilterscreenfilename uit tbsysstandardtabel of een parameter uit tbstandaardbutton die begint met md';

COMMENT ON COLUMN public.vwfrmsysstandardschermaanroepen.dvapitype
IS 'tbstandardtable of tbstandardbutton';

COMMENT ON COLUMN public.vwfrmsysstandardschermaanroepen.dvcodesysstandard
IS 'Codering van tbsysstandardtable waarvandaan scherm wordt aangeroepen (al of niet via tbsystandardbutton)'; 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49
 Previous topic Chapter index Next topic