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


カラム情報
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 pp_order_id numeric(10)  
9 documentno character varying(60)  
10 docstatus character(2)  
11 m_warehouse_id numeric(10)  
12 m_product_id numeric(10)  
13 qtyentered numeric  
14 qtyreject numeric  
15 qtyscrap numeric  
16 qtybatchs numeric  
17 qtybatchsize numeric  
18 dateordered timestamp without time zone  
19 datepromised timestamp without time zone  
20 datestart timestamp without time zone  
21 datestartschedule timestamp without time zone  
22 datefinish timestamp without time zone  
23 datefinishschedule timestamp without time zone  
24 dateconfirm timestamp without time zone  
25 datedelivered timestamp without time zone  
26 lot character varying(20)  
27 pp_product_bom_id numeric(10)  
28 ad_workflow_id numeric(10)  
29 weight numeric  
30 c_doctypetarget_id numeric(10)  
31 m_attributesetinstance_id numeric(10)  
32 planner_id numeric(10)  
33 priorityrule character(1)  
34 ad_orgtrx_id numeric(10)  
35 user1_id numeric(10)  
36 user2_id numeric(10)  
37 c_doctype_id numeric(10)  
38 line numeric(10)  
39 description character varying(510)  
40 s_resource_id numeric(10)  
41 floatbefored numeric  
42 floatafter numeric  
43 c_uom_id numeric(10)  
44 qtyordered numeric  
45 qtydelivered numeric  
46 yield numeric  
47 c_project_id numeric(10)  
48 c_campaign_id numeric(10)  
49 c_activity_id numeric(10)  
50 isapproved character(1)  
51 isprinted character(1)  
52 isselected character(1)  
53 processed character(1)  
54 assay numeric  
55 isqtypercentage character(1)  
56 ordertype character varying(1)  
57 issotrx character(1)  
58 scheduletype character varying(1)  
59 serno character varying(20)  


ソース
ソース 
 SELECT o.ad_client_id,
    o.ad_org_id,
    o.isactive,
    o.created,
    o.createdby,
    o.updated,
    o.updatedby,
    o.pp_order_id,
    o.documentno,
    o.docstatus,
    o.m_warehouse_id,
    o.m_product_id,
    o.qtyentered,
    o.qtyreject,
    o.qtyscrap,
    o.qtybatchs,
    o.qtybatchsize,
    o.dateordered,
    o.datepromised,
    o.datestart,
    o.datestartschedule,
    o.datefinish,
    o.datefinishschedule,
    o.dateconfirm,
    o.datedelivered,
    o.lot,
    o.pp_product_bom_id,
    o.ad_workflow_id,
    ( SELECT p.weight
           FROM m_product p
          WHERE (p.m_product_id = o.m_product_id)) AS weight,
    o.c_doctypetarget_id,
    o.m_attributesetinstance_id,
    o.planner_id,
    o.priorityrule,
    o.ad_orgtrx_id,
    o.user1_id,
    o.user2_id,
    o.c_doctype_id,
    o.line,
    o.description,
    o.s_resource_id,
    o.floatbefored,
    o.floatafter,
    o.c_uom_id,
    o.qtyordered,
    o.qtydelivered,
    o.yield,
    o.c_project_id,
    o.c_campaign_id,
    o.c_activity_id,
    o.isapproved,
    o.isprinted,
    o.isselected,
    o.processed,
    o.assay,
    o.isqtypercentage,
    o.ordertype,
    o.issotrx,
    o.scheduletype,
    o.serno
   FROM pp_order o;


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_pp_order
3 viewowner adempiere
4 definition SELECT o.ad_client_id,
o.ad_org_id,
o.isactive,
o.created,
o.createdby,
o.updated,
o.updatedby,
o.pp_order_id,
o.documentno,
o.docstatus,
o.m_warehouse_id,
o.m_product_id,
o.qtyentered,
o.qtyreject,
o.qtyscrap,
o.qtybatchs,
o.qtybatchsize,
o.dateordered,
o.datepromised,
o.datestart,
o.datestartschedule,
o.datefinish,
o.datefinishschedule,
o.dateconfirm,
o.datedelivered,
o.lot,
o.pp_product_bom_id,
o.ad_workflow_id,
( SELECT p.weight
FROM m_product p
WHERE (p.m_product_id = o.m_product_id)) AS weight,
o.c_doctypetarget_id,
o.m_attributesetinstance_id,
o.planner_id,
o.priorityrule,
o.ad_orgtrx_id,
o.user1_id,
o.user2_id,
o.c_doctype_id,
o.line,
o.description,
o.s_resource_id,
o.floatbefored,
o.floatafter,
o.c_uom_id,
o.qtyordered,
o.qtydelivered,
o.yield,
o.c_project_id,
o.c_campaign_id,
o.c_activity_id,
o.isapproved,
o.isprinted,
o.isselected,
o.processed,
o.assay,
o.isqtypercentage,
o.ordertype,
o.issotrx,
o.scheduletype,
o.serno
FROM pp_order o;