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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_order_id numeric(10) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'Y'
5 created timestamp without time zone Yes now()
6 createdby numeric(10) Yes
7 updated timestamp without time zone Yes now()
8 updatedby numeric(10) Yes
9 issotrx character(1) Yes 'Y'
10 documentno character varying(30) Yes
11 docstatus character(2) Yes
12 docaction character(2) Yes
13 processing character(1)  
14 processed character(1) Yes 'N'
15 c_doctype_id numeric(10) Yes
16 c_doctypetarget_id numeric(10) Yes
17 description character varying(255)  
18 isapproved character(1) Yes 'Y'
19 iscreditapproved character(1) Yes 'N'
20 isdelivered character(1) Yes 'N'
21 isinvoiced character(1) Yes 'N'
22 isprinted character(1) Yes 'N'
23 istransferred character(1) Yes 'N'
24 isselected character(1) Yes 'N'
25 salesrep_id numeric(10)  
26 dateordered timestamp without time zone Yes
27 datepromised timestamp without time zone  
28 dateprinted timestamp without time zone  
29 dateacct timestamp without time zone Yes
30 c_bpartner_id numeric(10) Yes
31 c_bpartner_location_id numeric(10) Yes
32 poreference character varying(20)  
33 isdiscountprinted character(1) Yes 'Y'
34 c_currency_id numeric(10) Yes
35 paymentrule character(1) Yes
36 c_paymentterm_id numeric(10) Yes
37 invoicerule character(1) Yes
38 deliveryrule character(1) Yes
39 freightcostrule character(1) Yes
40 freightamt numeric   0
41 deliveryviarule character(1) Yes
42 m_shipper_id numeric(10)  
43 c_charge_id numeric(10)  
44 chargeamt numeric   0
45 priorityrule character(1) Yes
46 totallines numeric Yes 0
47 grandtotal numeric Yes 0
48 m_warehouse_id numeric(10) Yes
49 m_pricelist_id numeric(10) Yes
50 istaxincluded character(1) Yes 'N'
51 c_campaign_id numeric(10)  
52 c_project_id numeric(10)  
53 c_activity_id numeric(10)  
54 posted character(1) Yes 'N'
55 c_payment_id numeric(10)  
56 c_cashline_id numeric(10)  
57 sendemail character(1) Yes 'N'
58 ad_user_id numeric(10)  
59 copyfrom character(1)  
60 isselfservice character(1) Yes 'N'
61 ad_orgtrx_id numeric(10)  
62 user1_id numeric(10)  
63 user2_id numeric(10)  
64 c_conversiontype_id numeric(10)  
65 bill_bpartner_id numeric(10)  
66 bill_location_id numeric(10)  
67 bill_user_id numeric(10)  
68 pay_bpartner_id numeric(10)  
69 pay_location_id numeric(10)  
70 ref_order_id numeric(10)  
71 isdropship character(1) Yes 'N'
72 volume numeric  
73 weight numeric  
74 ordertype character varying(510)  
75 c_pos_id numeric(10)  
76 amounttendered numeric(22, 2)  
77 amountrefunded numeric(22, 2)  
78 link_order_id numeric(10)  
79 m_freightcategory_id numeric(10)   NULL
80 dropship_bpartner_id numeric(10)  
81 dropship_location_id numeric(10)  
82 dropship_user_id numeric(10)  
83 promotioncode character varying(30)  
84 c_ordersource_id numeric(10)  
85 processedon numeric  
86 ispayschedulevalid character(1) Yes 'N'
87 c_cashplanline_id numeric(10)   NULL
88 c_order_uu character varying(36)   NULL
89 shippingrateinquiry character(1)   NULL
90 ispriviledgedrate character(1) Yes 'N'
91 c_opportunity_id numeric(10)   NULL
92 quotationorder_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_order_bpartner c_bpartner_id    
2 c_order_documentno documentno,c_doctype_id,c_bpartner_id Yes  
3 c_order_pkey c_order_id Yes  
4 c_order_processed processed,ad_client_id    
5 c_order_uu_idx c_order_uu Yes  
6 idxc_order_proc_on posted,processed,processedon,ad_client_id    


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adorg_corder ad_org_id adempiere.ad_org ad_org_id
2 adorgtrx_corder ad_orgtrx_id adempiere.ad_org ad_org_id
3 aduser_corder ad_user_id adempiere.ad_user ad_user_id
4 aduser_sr_corder salesrep_id adempiere.ad_user ad_user_id
5 aduserbill_corder bill_user_id adempiere.ad_user ad_user_id
6 c_doctype_corder c_doctype_id adempiere.c_doctype c_doctype_id
7 c_order__c_orders_c_ordersou c_ordersource_id adempiere.c_ordersource c_ordersource_id
8 cactivity_corder c_activity_id adempiere.c_activity c_activity_id
9 cbpartner_corder c_bpartner_id adempiere.c_bpartner c_bpartner_id
10 cbpartnerbill_corder bill_bpartner_id adempiere.c_bpartner c_bpartner_id
11 cbpartnerlocation_corder c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
12 cbpartnerpay_corder pay_bpartner_id adempiere.c_bpartner c_bpartner_id
13 cbplocationbill_corder bill_location_id adempiere.c_bpartner_location c_bpartner_location_id
14 cbplocationpay_corder pay_location_id adempiere.c_bpartner_location c_bpartner_location_id
15 ccampaign_corder c_campaign_id adempiere.c_campaign c_campaign_id
16 ccashline_corder c_cashline_id adempiere.c_cashline c_cashline_id
17 ccashplanline_corder c_cashplanline_id adempiere.c_cashplanline c_cashplanline_id
18 ccharge_corder c_charge_id adempiere.c_charge c_charge_id
19 cconversiontype_corder c_conversiontype_id adempiere.c_conversiontype c_conversiontype_id
20 ccurrency_corder c_currency_id adempiere.c_currency c_currency_id
21 cdoctypetarget_corder c_doctypetarget_id adempiere.c_doctype c_doctype_id
22 celemenrvalueuser2_corder user2_id adempiere.c_elementvalue c_elementvalue_id
23 celementvalueuser1_corder user1_id adempiere.c_elementvalue c_elementvalue_id
24 copportunity_corder c_opportunity_id adempiere.c_opportunity c_opportunity_id
25 corder_ref ref_order_id adempiere.c_order c_order_id
26 cpayment_corder c_payment_id adempiere.c_payment c_payment_id
27 cpaymentterm_soheader c_paymentterm_id adempiere.c_paymentterm c_paymentterm_id
28 cpos_corder c_pos_id adempiere.c_pos c_pos_id
29 cproject_corder c_project_id adempiere.c_project c_project_id
30 dropshipbpartner_corder dropship_bpartner_id adempiere.c_bpartner c_bpartner_id
31 dropshiplocation_corder dropship_location_id adempiere.c_bpartner_location c_bpartner_location_id
32 dropshipuser_corder dropship_user_id adempiere.ad_user ad_user_id
33 linkorder_corder link_order_id adempiere.c_order c_order_id
34 mfreightcategory_order m_freightcategory_id adempiere.m_freightcategory m_freightcategory_id
35 mpricelist_soheader m_pricelist_id adempiere.m_pricelist m_pricelist_id
36 mshipper_corder m_shipper_id adempiere.m_shipper m_shipper_id
37 mwarehouse_corder m_warehouse_id adempiere.m_warehouse m_warehouse_id
38 quotationorder_corder quotationorder_id adempiere.c_order c_order_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 corder_bbuyersfunds c_order_id adempiere.b_buyerfunds c_order_id
2 corder_bsellerfunds c_order_id adempiere.b_sellerfunds c_order_id
3 corder_callocation c_order_id adempiere.c_allocationline c_order_id
4 corder_cinvoice c_order_id adempiere.c_invoice c_order_id
5 corder_copportunity c_order_id adempiere.c_opportunity c_order_id
6 corder_corderlandedcost c_order_id adempiere.c_orderlandedcost c_order_id
7 corder_corderline c_order_id adempiere.c_orderline c_order_id
8 corder_corderpayschedule c_order_id adempiere.c_orderpayschedule c_order_id
9 corder_cordertax c_order_id adempiere.c_ordertax c_order_id
10 corder_cpayment c_order_id adempiere.c_payment c_order_id
11 corder_cpaymenttransaction c_order_id adempiere.c_paymenttransaction c_order_id
12 corder_cpospayment c_order_id adempiere.c_pospayment c_order_id
13 corder_cprojectline c_order_id adempiere.c_projectline c_order_id
14 corder_cprojectphase c_order_id adempiere.c_projectphase c_order_id
15 corder_crecurring c_order_id adempiere.c_recurring c_order_id
16 corder_crecurringrun c_order_id adempiere.c_recurring_run c_order_id
17 corder_crfq c_order_id adempiere.c_rfq c_order_id
18 corder_crfqresponse c_order_id adempiere.c_rfqresponse c_order_id
19 corder_ddorder c_order_id adempiere.dd_order c_order_id
20 corder_iorder c_order_id adempiere.i_order c_order_id
21 corder_minout c_order_id adempiere.m_inout c_order_id
22 corder_mrma c_order_id adempiere.m_rma c_order_id
23 corder_mshippingtransaction c_order_id adempiere.m_shippingtransaction c_order_id
24 corder_ppmrp c_order_id adempiere.pp_mrp c_order_id
25 corder_ref c_order_id adempiere.c_order ref_order_id
26 corder_rrequest c_order_id adempiere.r_request c_order_id
27 corder_rrequestaction c_order_id adempiere.r_requestaction c_order_id
28 corderpo_cprojectline c_order_id adempiere.c_projectline c_orderpo_id
29 linkorder_corder c_order_id adempiere.c_order link_order_id
30 quotationorder_corder c_order_id adempiere.c_order quotationorder_id
31 reforder_ddorder c_order_id adempiere.dd_order ref_order_id


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