rv_query_for_manual

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_language

varchar

2147483647

√

null

ad_window_id

numeric

√

null

ad_window.ad_window_id

Implied Constraint

ad_tab_id

numeric

√

null

ad_field_id

numeric

√

null

type

text

2147483647

√

null

name

varchar

√

null

description

varchar

255

√

null

help

varchar

2000

√

null

seqtab

numeric

√

null

seqfld

numeric

√

null

dbtable

varchar

2147483647

√

null

dbcolumn

text

2147483647

√

null

dbtype

text

2147483647

√

null

adempieretype

text

2147483647

√

null

isbetafunctionality

bpchar

2147483647

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT vt.ad_language,
    vt.ad_window_id,
    0 AS ad_tab_id,
    0 AS ad_field_id,
    'W'::text AS type,
    vt.name,
    vt.description,
    vt.help,
    0 AS seqtab,
    0 AS seqfld,
    ''::character varying AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    w.isbetafunctionality
   FROM (ad_window_vt vt
     JOIN ad_window w ON ((vt.ad_window_id = w.ad_window_id)))
  WHERE (EXISTS ( SELECT 1
           FROM ad_window
          WHERE ((ad_window.ad_window_id = vt.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar))))
UNION
 SELECT t.ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    0 AS ad_field_id,
    'T'::text AS type,
    t.name,
    t.description,
    t.help,
    t.seqno AS seqtab,
    0 AS seqfld,
    tt.tablename AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_tab_vt t,
    ad_table tt,
    pg_tables ut
  WHERE ((EXISTS ( SELECT 1
           FROM ad_tab,
            ad_window
          WHERE ((ad_tab.ad_tab_id = t.ad_tab_id) AND (ad_tab.isactive = 'Y'::bpchar) AND (ad_tab.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar)))) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = ut.tablename))
UNION
 SELECT t.ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    0 AS ad_field_id,
    'T'::text AS type,
    t.name,
    t.description,
    t.help,
    t.seqno AS seqtab,
    0 AS seqfld,
    tt.tablename AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_tab_vt t,
    ad_table tt,
    pg_views uv
  WHERE ((EXISTS ( SELECT 1
           FROM ad_tab,
            ad_window
          WHERE ((ad_tab.ad_tab_id = t.ad_tab_id) AND (ad_tab.isactive = 'Y'::bpchar) AND (ad_tab.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar)))) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = uv.viewname))
UNION
 SELECT f.ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    f.ad_field_id,
    'F'::text AS type,
    f.name,
    f.description,
    f.help,
    t.seqno AS seqtab,
    f.seqno AS seqfld,
    tt.tablename AS dbtable,
    cc.columnname AS dbcolumn,
    ((uc.data_type)::text ||
        CASE uc.data_type
            WHEN 'character varying'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'character'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'numeric'::text THEN
            CASE
                WHEN (uc.numeric_precision IS NULL) THEN ''::text
                ELSE ((('('::text || uc.numeric_precision) ||
                CASE uc.numeric_scale
                    WHEN 0 THEN ''::text
                    ELSE (','::text || uc.numeric_scale)
                END) || ')'::text)
            END
            ELSE ''::text
        END) AS dbtype,
    ( SELECT ad_reference.name
           FROM ad_reference
          WHERE (ad_reference.ad_reference_id = cc.ad_reference_id)) AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_field_vt f,
    ad_tab t,
    ad_table tt,
    pg_tables ut,
    ad_column cc,
    information_schema.columns uc
  WHERE ((f.ad_tab_id = t.ad_tab_id) AND (f.isdisplayed = 'Y'::bpchar) AND (EXISTS ( SELECT 1
           FROM ad_field,
            ad_tab,
            ad_window
          WHERE ((ad_field.ad_tab_id = f.ad_tab_id) AND (ad_field.isactive = 'Y'::bpchar) AND (ad_tab.ad_tab_id = ad_field.ad_tab_id) AND (ad_tab.isactive = 'Y'::bpchar) AND (ad_tab.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar)))) AND (t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = ut.tablename) AND (f.ad_column_id = cc.ad_column_id) AND (lower((tt.tablename)::text) = (uc.table_name)::name) AND (lower((cc.columnname)::text) = (uc.column_name)::name))
UNION
 SELECT f.ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    f.ad_field_id,
    'F'::text AS type,
    f.name,
    f.description,
    f.help,
    t.seqno AS seqtab,
    f.seqno AS seqfld,
    tt.tablename AS dbtable,
    cc.columnname AS dbcolumn,
    ((uc.data_type)::text ||
        CASE uc.data_type
            WHEN 'character varying'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'character'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'numeric'::text THEN
            CASE
                WHEN (uc.numeric_precision IS NULL) THEN ''::text
                ELSE ((('('::text || uc.numeric_precision) ||
                CASE uc.numeric_scale
                    WHEN 0 THEN ''::text
                    ELSE (','::text || uc.numeric_scale)
                END) || ')'::text)
            END
            ELSE ''::text
        END) AS dbtype,
    ( SELECT ad_reference.name
           FROM ad_reference
          WHERE (ad_reference.ad_reference_id = cc.ad_reference_id)) AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_field_vt f,
    ad_tab t,
    ad_table tt,
    pg_views uv,
    ad_column cc,
    information_schema.columns uc
  WHERE ((f.ad_tab_id = t.ad_tab_id) AND (f.isdisplayed = 'Y'::bpchar) AND (EXISTS ( SELECT 1
           FROM ad_field,
            ad_tab,
            ad_window
          WHERE ((ad_field.ad_tab_id = f.ad_tab_id) AND (ad_field.isactive = 'Y'::bpchar) AND (ad_tab.ad_tab_id = ad_field.ad_tab_id) AND (ad_tab.isactive = 'Y'::bpchar) AND (ad_tab.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar)))) AND (t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = uv.viewname) AND (f.ad_column_id = cc.ad_column_id) AND (lower((tt.tablename)::text) = (uc.table_name)::name) AND (lower((cc.columnname)::text) = (uc.column_name)::name))
UNION
 SELECT 'en_US_base'::character varying AS ad_language,
    ad_window.ad_window_id,
    0 AS ad_tab_id,
    0 AS ad_field_id,
    'W'::text AS type,
    ad_window.name,
    ad_window.description,
    ad_window.help,
    0 AS seqtab,
    0 AS seqfld,
    ''::character varying AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    ad_window.isbetafunctionality
   FROM ad_window
  WHERE (ad_window.isactive = 'Y'::bpchar)
UNION
 SELECT 'en_US_base'::character varying AS ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    0 AS ad_field_id,
    'T'::text AS type,
    t.name,
    t.description,
    t.help,
    t.seqno AS seqtab,
    0 AS seqfld,
    tt.tablename AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_tab t,
    ad_table tt,
    pg_tables ut,
    ad_window
  WHERE ((t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = ut.tablename) AND (t.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar))
UNION
 SELECT 'en_US_base'::character varying AS ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    0 AS ad_field_id,
    'T'::text AS type,
    t.name,
    t.description,
    t.help,
    t.seqno AS seqtab,
    0 AS seqfld,
    tt.tablename AS dbtable,
    ''::text AS dbcolumn,
    ''::text AS dbtype,
    ''::text AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_tab t,
    ad_table tt,
    pg_views uv,
    ad_window
  WHERE ((t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = uv.viewname) AND (t.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar))
UNION
 SELECT 'en_US_base'::character varying AS ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    f.ad_field_id,
    'F'::text AS type,
    f.name,
    f.description,
    f.help,
    t.seqno AS seqtab,
    f.seqno AS seqfld,
    tt.tablename AS dbtable,
    cc.columnname AS dbcolumn,
    ((uc.data_type)::text ||
        CASE uc.data_type
            WHEN 'character varying'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'character'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'numeric'::text THEN
            CASE
                WHEN (uc.numeric_precision IS NULL) THEN ''::text
                ELSE ((('('::text || uc.numeric_precision) ||
                CASE uc.numeric_scale
                    WHEN 0 THEN ''::text
                    ELSE (','::text || uc.numeric_scale)
                END) || ')'::text)
            END
            ELSE ''::text
        END) AS dbtype,
    ( SELECT ad_reference.name
           FROM ad_reference
          WHERE (ad_reference.ad_reference_id = cc.ad_reference_id)) AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_field f,
    ad_tab t,
    ad_table tt,
    pg_tables ut,
    ad_column cc,
    information_schema.columns uc,
    ad_window
  WHERE ((f.ad_tab_id = t.ad_tab_id) AND (f.isdisplayed = 'Y'::bpchar) AND (f.isactive = 'Y'::bpchar) AND (t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = ut.tablename) AND (f.ad_column_id = cc.ad_column_id) AND (lower((tt.tablename)::text) = (uc.table_name)::name) AND (lower((cc.columnname)::text) = (uc.column_name)::name) AND (t.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar))
UNION
 SELECT 'en_US_base'::character varying AS ad_language,
    t.ad_window_id,
    t.ad_tab_id,
    f.ad_field_id,
    'F'::text AS type,
    f.name,
    f.description,
    f.help,
    t.seqno AS seqtab,
    f.seqno AS seqfld,
    tt.tablename AS dbtable,
    cc.columnname AS dbcolumn,
    ((uc.data_type)::text ||
        CASE uc.data_type
            WHEN 'character varying'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'character'::text THEN (('('::text || uc.character_maximum_length) || ')'::text)
            WHEN 'numeric'::text THEN
            CASE
                WHEN (uc.numeric_precision IS NULL) THEN ''::text
                ELSE ((('('::text || uc.numeric_precision) ||
                CASE uc.numeric_scale
                    WHEN 0 THEN ''::text
                    ELSE (','::text || uc.numeric_scale)
                END) || ')'::text)
            END
            ELSE ''::text
        END) AS dbtype,
    ( SELECT ad_reference.name
           FROM ad_reference
          WHERE (ad_reference.ad_reference_id = cc.ad_reference_id)) AS adempieretype,
    ''::bpchar AS isbetafunctionality
   FROM ad_field f,
    ad_tab t,
    ad_table tt,
    ad_column cc,
    pg_views uv,
    information_schema.columns uc,
    ad_window
  WHERE ((f.ad_tab_id = t.ad_tab_id) AND (f.isdisplayed = 'Y'::bpchar) AND (f.isactive = 'Y'::bpchar) AND (t.isactive = 'Y'::bpchar) AND (t.ad_table_id = tt.ad_table_id) AND (lower((tt.tablename)::text) = uv.viewname) AND (f.ad_column_id = cc.ad_column_id) AND (lower((tt.tablename)::text) = (uc.table_name)::name) AND (lower((cc.columnname)::text) = (uc.column_name)::name) AND (t.ad_window_id = ad_window.ad_window_id) AND (ad_window.isactive = 'Y'::bpchar));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views