テーブル定義書 http://www.as-link.com/ ERPlus@iDempiere3.1

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