Datadictionary OpenWave 3.1.4
Previous topic Chapter index Next topic

View: vwmilinrhoofdsbi

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwmilinrhoofdsbi

 

Fields

Name

Data type

Description

dnkeymilinrichtingen

integer

 

dlhoofdsbi

char(1)

 

dnkeymilsbi

integer

 

dvsbinummer

varchar(11)

 

dvsbilijst

varchar(4)

 

dvsbioms

varchar(100)

 

dnkeymilcodesbi

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwmilinrhoofdsbi (
   dnkeymilinrichtingen,
   dlhoofdsbi,
   dnkeymilsbi,
   dvsbinummer,
   dvsbilijst,
   dvsbioms,
   dnkeymilcodesbi)
AS
SELECT
max(tbmilsbi.dnkeymilinrichtingen) AS dnkeymilinrichtingen,
   max(tbmilsbi.dlhoofdsbi)::character(1) AS dlhoofdsbi,
   max(tbmilsbi.dnkey) AS dnkeymilsbi,
   max(tbmilcodesbi.dvsbinummer::text)::character varying(11) AS dvsbinummer,
   max(tbmilcodesbi.dvsbilijst::text)::character varying(4) AS dvsbilijst,
   max(tbmilcodesbi.dvsbioms::text)::character varying(100) AS dvsbioms,
   max(tbmilcodesbi.dnkey) AS dnkeymilcodesbi
FROM tbmilsbi
  JOIN tbmilcodesbi ON tbmilsbi.dnkeymilcodesbi = tbmilcodesbi.dnkey
WHERE tbmilsbi.dlhoofdsbi = 'T'::bpchar
GROUP BY tbmilsbi.dnkeymilinrichtingen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 17-1-2014 15:30
Previous topic Chapter index Next topic