テーブル情報
システム名 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_costdetail     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 isactive character(1)  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 updated timestamp without time zone  
7 updatedby numeric(10)  
8 m_product_id numeric(10)  
9 value character varying(40)  
10 name character varying(255)  
11 upc character varying(30)  
12 isbom character(1)  
13 producttype character(1)  
14 m_product_category_id numeric(10)  
15 m_inoutline_id numeric(10)  
16 c_invoiceline_id numeric(10)  
17 m_attributesetinstance_id numeric(10)  
18 m_attributeset_id numeric(10)  
19 lot character varying(40)  
20 serno character varying(40)  
21 c_acctschema_id numeric(10)  
22 c_currency_id numeric(10)  
23 amt numeric  
24 qty numeric  
25 description character varying(255)  
26 processed character(1)  
27 c_orderline_id numeric(10)  
28 c_projectissue_id numeric(10)  
29 cumulatedamt numeric  
30 cumulatedqty numeric  
31 currentcostprice numeric  
32 currentqty numeric  
33 deltaamt numeric  
34 deltaqty numeric  
35 issotrx character(1)  
36 m_costdetail_id numeric(10)  
37 m_costelement_id numeric(10)  
38 m_inventoryline_id numeric(10)  
39 m_movementline_id numeric(10)  
40 m_productionline_id numeric(10)  
41 pp_cost_collector_id numeric(10)  
42 m_product_ad_org_id numeric(10)  
43 classification character varying(12)  
44 m_product_copyfrom character(1)  
45 m_product_created timestamp without time zone  
46 m_product_createdby numeric(10)  
47 c_revenuerecognition_id numeric(10)  
48 c_subscriptiontype_id numeric(10)  
49 c_taxcategory_id numeric(10)  
50 c_uom_id numeric(10)  
51 m_product_description character varying(255)  
52 descriptionurl character varying(120)  
53 discontinued character(1)  
54 discontinuedat timestamp without time zone  
55 documentnote character varying(2000)  
56 group1 character varying(255)  
57 group2 character varying(255)  
58 guaranteedays numeric(10)  
59 guaranteedaysmin numeric(10)  
60 help character varying(2000)  
61 imageurl character varying(120)  
62 m_product_isactive character(1)  
63 isdropship character(1)  
64 isexcludeautodelivery character(1)  
65 isinvoiceprintdetails character(1)  
66 ispicklistprintdetails character(1)  
67 ispurchased character(1)  
68 isselfservice character(1)  
69 issold character(1)  
70 isstocked character(1)  
71 m_product_issummary character(1)  
72 isverified character(1)  
73 iswebstorefeatured character(1)  
74 lowlevel numeric(10)  
75 m_product_m_attributeset_id numeric(10)  
76 m_product_m_asi_id numeric(10)  
77 m_freightcategory_id numeric(10)  
78 m_locator_id numeric(10)  
79 m_product_processing character(1)  
80 r_mailtext_id numeric(10)  
81 m_product_salesrep_id numeric(10)  
82 s_expensetype_id numeric(10)  
83 shelfdepth numeric(10)  
84 shelfheight numeric  
85 shelfwidth numeric(10)  
86 sku character varying(30)  
87 s_resource_id numeric(10)  
88 unitsperpack numeric(10)  
89 unitsperpallet numeric  
90 m_product_updated timestamp without time zone  
91 m_product_updatedby numeric(10)  
92 versionno character varying(20)  
93 volume numeric  
94 weight numeric  
95 c_acctschema_ad_org_id numeric(10)  
96 c_acctschema_description character varying(255)  
97 c_acctschema_name character varying(60)  
98 m_asi_ad_org_id numeric(10)  
99 m_asi_created timestamp without time zone  
100 m_asi_createdby numeric(10)  
101 m_asi_description character varying(255)  
102 guaranteedate timestamp without time zone  
103 m_asi_isactive character(1)  
104 m_lot_id numeric(10)  
105 m_asi_updated timestamp without time zone  
106 m_asi_updatedby numeric(10)  


ソース
ソース 
 SELECT c.ad_client_id,
    c.ad_org_id,
    c.isactive,
    c.created,
    c.createdby,
    c.updated,
    c.updatedby,
    p.m_product_id,
    p.value,
    p.name,
    p.upc,
    p.isbom,
    p.producttype,
    p.m_product_category_id,
    c.m_inoutline_id,
    c.c_invoiceline_id,
    asi.m_attributesetinstance_id,
    asi.m_attributeset_id,
    asi.lot,
    asi.serno,
    acct.c_acctschema_id,
    acct.c_currency_id,
    c.amt,
    c.qty,
    c.description,
    c.processed,
    c.c_orderline_id,
    c.c_projectissue_id,
    c.cumulatedamt,
    c.cumulatedqty,
    c.currentcostprice,
    c.currentqty,
    c.deltaamt,
    c.deltaqty,
    c.issotrx,
    c.m_costdetail_id,
    c.m_costelement_id,
    c.m_inventoryline_id,
    c.m_movementline_id,
    c.m_productionline_id,
    c.pp_cost_collector_id,
    p.ad_org_id AS m_product_ad_org_id,
    p.classification,
    p.copyfrom AS m_product_copyfrom,
    p.created AS m_product_created,
    p.createdby AS m_product_createdby,
    p.c_revenuerecognition_id,
    p.c_subscriptiontype_id,
    p.c_taxcategory_id,
    p.c_uom_id,
    p.description AS m_product_description,
    p.descriptionurl,
    p.discontinued,
    p.discontinuedat,
    p.documentnote,
    p.group1,
    p.group2,
    p.guaranteedays,
    p.guaranteedaysmin,
    p.help,
    p.imageurl,
    p.isactive AS m_product_isactive,
    p.isdropship,
    p.isexcludeautodelivery,
    p.isinvoiceprintdetails,
    p.ispicklistprintdetails,
    p.ispurchased,
    p.isselfservice,
    p.issold,
    p.isstocked,
    p.issummary AS m_product_issummary,
    p.isverified,
    p.iswebstorefeatured,
    p.lowlevel,
    p.m_attributeset_id AS m_product_m_attributeset_id,
    p.m_attributesetinstance_id AS m_product_m_asi_id,
    p.m_freightcategory_id,
    p.m_locator_id,
    p.processing AS m_product_processing,
    p.r_mailtext_id,
    p.salesrep_id AS m_product_salesrep_id,
    p.s_expensetype_id,
    p.shelfdepth,
    p.shelfheight,
    p.shelfwidth,
    p.sku,
    p.s_resource_id,
    p.unitsperpack,
    p.unitsperpallet,
    p.updated AS m_product_updated,
    p.updatedby AS m_product_updatedby,
    p.versionno,
    p.volume,
    p.weight,
    acct.ad_org_id AS c_acctschema_ad_org_id,
    acct.description AS c_acctschema_description,
    acct.name AS c_acctschema_name,
    asi.ad_org_id AS m_asi_ad_org_id,
    asi.created AS m_asi_created,
    asi.createdby AS m_asi_createdby,
    asi.description AS m_asi_description,
    asi.guaranteedate,
    asi.isactive AS m_asi_isactive,
    asi.m_lot_id,
    asi.updated AS m_asi_updated,
    asi.updatedby AS m_asi_updatedby
   FROM (((m_costdetail c
     JOIN m_product p ON ((c.m_product_id = p.m_product_id)))
     JOIN c_acctschema acct ON ((c.c_acctschema_id = acct.c_acctschema_id)))
     JOIN m_attributesetinstance asi ON ((c.m_attributesetinstance_id = asi.m_attributesetinstance_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_costdetail
3 viewowner adempiere
4 definition SELECT c.ad_client_id,
c.ad_org_id,
c.isactive,
c.created,
c.createdby,
c.updated,
c.updatedby,
p.m_product_id,
p.value,
p.name,
p.upc,
p.isbom,
p.producttype,
p.m_product_category_id,
c.m_inoutline_id,
c.c_invoiceline_id,
asi.m_attributesetinstance_id,
asi.m_attributeset_id,
asi.lot,
asi.serno,
acct.c_acctschema_id,
acct.c_currency_id,
c.amt,
c.qty,
c.description,
c.processed,
c.c_orderline_id,
c.c_projectissue_id,
c.cumulatedamt,
c.cumulatedqty,
c.currentcostprice,
c.currentqty,
c.deltaamt,
c.deltaqty,
c.issotrx,
c.m_costdetail_id,
c.m_costelement_id,
c.m_inventoryline_id,
c.m_movementline_id,
c.m_productionline_id,
c.pp_cost_collector_id,
p.ad_org_id AS m_product_ad_org_id,
p.classification,
p.copyfrom AS m_product_copyfrom,
p.created AS m_product_created,
p.createdby AS m_product_createdby,
p.c_revenuerecognition_id,
p.c_subscriptiontype_id,
p.c_taxcategory_id,
p.c_uom_id,
p.description AS m_product_description,
p.descriptionurl,
p.discontinued,
p.discontinuedat,
p.documentnote,
p.group1,
p.group2,
p.guaranteedays,
p.guaranteedaysmin,
p.help,
p.imageurl,
p.isactive AS m_product_isactive,
p.isdropship,
p.isexcludeautodelivery,
p.isinvoiceprintdetails,
p.ispicklistprintdetails,
p.ispurchased,
p.isselfservice,
p.issold,
p.isstocked,
p.issummary AS m_product_issummary,
p.isverified,
p.iswebstorefeatured,
p.lowlevel,
p.m_attributeset_id AS m_product_m_attributeset_id,
p.m_attributesetinstance_id AS m_product_m_asi_id,
p.m_freightcategory_id,
p.m_locator_id,
p.processing AS m_product_processing,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.sku,
p.s_resource_id,
p.unitsperpack,
p.unitsperpallet,
p.updated AS m_product_updated,
p.updatedby AS m_product_updatedby,
p.versionno,
p.volume,
p.weight,
acct.ad_org_id AS c_acctschema_ad_org_id,
acct.description AS c_acctschema_description,
acct.name AS c_acctschema_name,
asi.ad_org_id AS m_asi_ad_org_id,
asi.created AS m_asi_created,
asi.createdby AS m_asi_createdby,
asi.description AS m_asi_description,
asi.guaranteedate,
asi.isactive AS m_asi_isactive,
asi.m_lot_id,
asi.updated AS m_asi_updated,
asi.updatedby AS m_asi_updatedby
FROM (((m_costdetail c
JOIN m_product p ON ((c.m_product_id = p.m_product_id)))
JOIN c_acctschema acct ON ((c.c_acctschema_id = acct.c_acctschema_id)))
JOIN m_attributesetinstance asi ON ((c.m_attributesetinstance_id = asi.m_attributesetinstance_id)));