テーブル情報
システム名 http://www.as-link.com/  作成者 秦　松甫 
サブシステム名 ERPlus@iDempiere3.1_daily  作成日 2016/3/7 
スキーマ名 adempiere  更新日  
論理テーブル名   RDBMS  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit 9.4.5 
物理テーブル名 rv_t_1099extract     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_pinstance_id numeric(10)  
2 ad_client_id numeric(10)  
3 ad_org_id numeric(10)  
4 isactive character(1)  
5 created timestamp without time zone  
6 createdby numeric(10)  
7 updated timestamp without time zone  
8 updatedby numeric(10)  
9 c_bpartner_id numeric(10)  
10 value character varying(40)  
11 name character varying(120)  
12 taxid character varying(20)  
13 address text  
14 address1 character varying(60)  
15 address2 character varying(60)  
16 address3 character varying(60)  
17 address4 character varying(60)  
18 citystatezip text  
19 city character varying(60)  
20 region character varying(60)  
21 zip character varying(10)  
22 country character varying(60)  
23 cut_year numeric(10)  
24 cut_date timestamp without time zone  
25 amtbucket01 numeric  
26 amtbucket02 numeric  
27 amtbucket03 numeric  
28 amtbucket04 numeric  
29 amtbucket05 numeric  
30 amtbucket06 numeric  
31 amtbucket07 numeric  
32 amtbucket08 numeric  
33 amtbucket09 numeric  
34 amtbucket10 numeric  
35 amtbucket11 numeric  
36 amtbucket12 numeric  
37 amtbucket13 numeric  
38 amtbucket14 numeric  
39 amtbucket15 numeric  
40 amtbucket16 numeric  


ソース
ソース 
 SELECT t.ad_pinstance_id,
    t.ad_client_id,
    t.ad_org_id,
    t.isactive,
    t.created,
    t.createdby,
    t.updated,
    t.updatedby,
    t.c_bpartner_id,
    t.value,
    t.name,
    t.taxid,
    (((((((l.address1)::text || ' '::text) || (l.address2)::text) || ' '::text) || (l.address3)::text) || ' '::text) || (l.address4)::text) AS address,
    l.address1,
    l.address2,
    l.address3,
    l.address4,
    (((((l.city)::text || ', '::text) || (r.name)::text) || ' '::text) || (l.postal)::text) AS citystatezip,
    l.city,
    r.name AS region,
    l.postal AS zip,
    ctry.name AS country,
    t.cut_year,
    t.cut_date,
    COALESCE(t.amtbucket01, (0)::numeric) AS amtbucket01,
    COALESCE(t.amtbucket02, (0)::numeric) AS amtbucket02,
    COALESCE(t.amtbucket03, (0)::numeric) AS amtbucket03,
    COALESCE(t.amtbucket04, (0)::numeric) AS amtbucket04,
    COALESCE(t.amtbucket05, (0)::numeric) AS amtbucket05,
    COALESCE(t.amtbucket06, (0)::numeric) AS amtbucket06,
    COALESCE(t.amtbucket07, (0)::numeric) AS amtbucket07,
    COALESCE(t.amtbucket08, (0)::numeric) AS amtbucket08,
    COALESCE(t.amtbucket09, (0)::numeric) AS amtbucket09,
    COALESCE(t.amtbucket10, (0)::numeric) AS amtbucket10,
    COALESCE(t.amtbucket11, (0)::numeric) AS amtbucket11,
    COALESCE(t.amtbucket12, (0)::numeric) AS amtbucket12,
    COALESCE(t.amtbucket13, (0)::numeric) AS amtbucket13,
    COALESCE(t.amtbucket14, (0)::numeric) AS amtbucket14,
    COALESCE(t.amtbucket15, (0)::numeric) AS amtbucket15,
    COALESCE(t.amtbucket16, (0)::numeric) AS amtbucket16
   FROM (((t_1099extract t
     LEFT JOIN c_location l ON ((t.c_location_id = l.c_location_id)))
     LEFT JOIN c_region r ON ((r.c_region_id = l.c_region_id)))
     LEFT JOIN c_country ctry ON ((ctry.c_country_id = l.c_country_id)))
  WHERE (t.ad_pinstance_id = ( SELECT max(t_1099extract.ad_pinstance_id) AS max
           FROM t_1099extract));


インデックス情報
No インデックス名 カラムリスト ユニーク 備考


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_t_1099extract
3 viewowner adempiere
4 definition SELECT t.ad_pinstance_id,
t.ad_client_id,
t.ad_org_id,
t.isactive,
t.created,
t.createdby,
t.updated,
t.updatedby,
t.c_bpartner_id,
t.value,
t.name,
t.taxid,
(((((((l.address1)::text || ' '::text) || (l.address2)::text) || ' '::text) || (l.address3)::text) || ' '::text) || (l.address4)::text) AS address,
l.address1,
l.address2,
l.address3,
l.address4,
(((((l.city)::text || ', '::text) || (r.name)::text) || ' '::text) || (l.postal)::text) AS citystatezip,
l.city,
r.name AS region,
l.postal AS zip,
ctry.name AS country,
t.cut_year,
t.cut_date,
COALESCE(t.amtbucket01, (0)::numeric) AS amtbucket01,
COALESCE(t.amtbucket02, (0)::numeric) AS amtbucket02,
COALESCE(t.amtbucket03, (0)::numeric) AS amtbucket03,
COALESCE(t.amtbucket04, (0)::numeric) AS amtbucket04,
COALESCE(t.amtbucket05, (0)::numeric) AS amtbucket05,
COALESCE(t.amtbucket06, (0)::numeric) AS amtbucket06,
COALESCE(t.amtbucket07, (0)::numeric) AS amtbucket07,
COALESCE(t.amtbucket08, (0)::numeric) AS amtbucket08,
COALESCE(t.amtbucket09, (0)::numeric) AS amtbucket09,
COALESCE(t.amtbucket10, (0)::numeric) AS amtbucket10,
COALESCE(t.amtbucket11, (0)::numeric) AS amtbucket11,
COALESCE(t.amtbucket12, (0)::numeric) AS amtbucket12,
COALESCE(t.amtbucket13, (0)::numeric) AS amtbucket13,
COALESCE(t.amtbucket14, (0)::numeric) AS amtbucket14,
COALESCE(t.amtbucket15, (0)::numeric) AS amtbucket15,
COALESCE(t.amtbucket16, (0)::numeric) AS amtbucket16
FROM (((t_1099extract t
LEFT JOIN c_location l ON ((t.c_location_id = l.c_location_id)))
LEFT JOIN c_region r ON ((r.c_region_id = l.c_region_id)))
LEFT JOIN c_country ctry ON ((ctry.c_country_id = l.c_country_id)))
WHERE (t.ad_pinstance_id = ( SELECT max(t_1099extract.ad_pinstance_id) AS max
FROM t_1099extract));