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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 documentno character varying(30) Yes
2 ad_orgtrx_id numeric(10)  
3 ad_org_id numeric(10) Yes
4 ad_user_id numeric(10)  
5 c_activity_id numeric(10)  
6 c_bpartner_id numeric(10) Yes
7 c_bpartner_location_id numeric(10) Yes
8 c_campaign_id numeric(10)  
9 c_charge_id numeric(10)  
10 c_doctype_id numeric(10) Yes
11 c_invoice_id numeric(10)  
12 c_order_id numeric(10)  
13 c_project_id numeric(10)  
14 chargeamt numeric  
15 createconfirm character(1)  
16 createfrom character(1)  
17 createpackage character(1)  
18 created timestamp without time zone Yes statement_timestamp()
19 createdby numeric(10) Yes
20 dd_order_id numeric(10) Yes (PK)
21 dateordered timestamp without time zone Yes
22 dateprinted timestamp without time zone  
23 datepromised timestamp without time zone Yes
24 datereceived timestamp without time zone  
25 deliveryrule character(1) Yes 'A'
26 deliveryviarule character(1) Yes 'P'
27 description character varying(255)  
28 docaction character(2) Yes 'CO'
29 docstatus character(2) Yes 'DR'
30 freightamt numeric  
31 freightcostrule character(1) Yes 'I'
32 generateto character(1)  
33 isactive character(1) Yes 'Y'
34 isapproved character(1) Yes
35 isdelivered character(1)  
36 isdropship character(1)  
37 isindispute character(1) Yes
38 isintransit character(1) Yes
39 isprinted character(1) Yes
40 issotrx character(1) Yes
41 isselected character(1)  
42 m_shipper_id numeric(10)  
43 m_warehouse_id numeric(10) Yes
44 nopackages numeric(10)  
45 poreference character varying(20)  
46 pickdate timestamp without time zone  
47 posted character(1) Yes
48 priorityrule character(1) Yes '5'
49 processed character(1) Yes
50 processing character(1)  
51 ref_order_id numeric(10)  
52 salesrep_id numeric(10)  
53 sendemail character(1) Yes
54 shipdate timestamp without time zone  
55 trackingno character varying(60)  
56 updated timestamp without time zone Yes statement_timestamp()
57 updatedby numeric(10) Yes
58 user1_id numeric(10)  
59 user2_id numeric(10)  
60 volume numeric  
61 ad_client_id numeric(10) Yes
62 weight numeric  
63 processedon numeric  
64 dd_order_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 dd_order_key dd_order_id Yes  
2 dd_order_uu_idx dd_order_uu Yes  
3 idxdd_order_proc_on posted,processed,processedon,ad_client_id    


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adorgtrx_ddorder ad_orgtrx_id adempiere.ad_org ad_org_id
2 aduser_ddorder ad_user_id adempiere.ad_user ad_user_id
3 cactivity_ddorder c_activity_id adempiere.c_activity c_activity_id
4 cbpartner_ddorder c_bpartner_id adempiere.c_bpartner c_bpartner_id
5 cbpartnerlocation_ddorder c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
6 ccampaign_ddorder c_campaign_id adempiere.c_campaign c_campaign_id
7 ccharge_ddorder c_charge_id adempiere.c_charge c_charge_id
8 cdoctype_ddorder c_doctype_id adempiere.c_doctype c_doctype_id
9 cinvoice_ddorder c_invoice_id adempiere.c_invoice c_invoice_id
10 corder_ddorder c_order_id adempiere.c_order c_order_id
11 cproject_ddorder c_project_id adempiere.c_project c_project_id
12 mshipper_ddorder m_shipper_id adempiere.m_shipper m_shipper_id
13 mwarehouse_ddorder m_warehouse_id adempiere.m_warehouse m_warehouse_id
14 reforder_ddorder ref_order_id adempiere.c_order c_order_id
15 salesrep_ddorder salesrep_id adempiere.ad_user ad_user_id
16 user1_ddorder user1_id adempiere.c_elementvalue c_elementvalue_id
17 user2_ddorder user2_id adempiere.c_elementvalue c_elementvalue_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 ddorder_ddorderline dd_order_id adempiere.dd_orderline dd_order_id
2 ddorder_mmovement dd_order_id adempiere.m_movement dd_order_id
3 ddorder_ppmrp dd_order_id adempiere.pp_mrp dd_order_id


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 tablename dd_order
3 tableowner adempiere
4 tablespace
5 hasindexes True
6 hasrules False
7 hastriggers True