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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_bpartner_location_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 name character varying(60) Yes
10 isbillto character(1) Yes 'Y'
11 isshipto character(1) Yes 'Y'
12 ispayfrom character(1) Yes 'Y'
13 isremitto character(1) Yes 'Y'
14 phone character varying(40)  
15 phone2 character varying(40)  
16 fax character varying(40)  
17 isdn character varying(40)  
18 c_salesregion_id numeric(10)  
19 c_bpartner_id numeric(10) Yes
20 c_location_id numeric(10)  
21 c_bpartner_location_uu character varying(36)   NULL
22 customeraddressid character varying(60)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_bpartner_location_pkey c_bpartner_location_id Yes  
2 c_bpartner_location_uu_idx c_bpartner_location_uu Yes  
3 c_bplocation_bpartner c_bpartner_id    
4 c_bplocation_updated updated    


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 c_buspartner_locationclient ad_client_id adempiere.ad_client ad_client_id
2 c_buspartner_locationorg ad_org_id adempiere.ad_org ad_org_id
3 cbpartner_cbplocation c_bpartner_id adempiere.c_bpartner c_bpartner_id
4 clocation_cbplocation c_location_id adempiere.c_location c_location_id
5 csalesregion_bpartnerlocation c_salesregion_id adempiere.c_salesregion c_salesregion_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 billlocation_mshippingtransact c_bpartner_location_id adempiere.m_shippingtransaction bill_location_id
2 c_bplocation_cinvoice c_bpartner_location_id adempiere.c_invoice c_bpartner_location_id
3 cbolocation_iorder c_bpartner_location_id adempiere.i_order c_bpartner_location_id
4 cbpartnerloc_crfqtopicsubr c_bpartner_location_id adempiere.c_rfq_topicsubscriber c_bpartner_location_id
5 cbpartnerloc_mdistlistline c_bpartner_location_id adempiere.m_distributionlistline c_bpartner_location_id
6 cbpartnerlocation_aassetchange c_bpartner_location_id adempiere.a_asset_change c_bpartner_location_id
7 cbpartnerlocation_cbpshippinga c_bpartner_location_id adempiere.c_bp_shippingacct c_bpartner_location_id
8 cbpartnerlocation_cdunningrune c_bpartner_location_id adempiere.c_dunningrunentry c_bpartner_location_id
9 cbpartnerlocation_corder c_bpartner_location_id adempiere.c_order c_bpartner_location_id
10 cbpartnerlocation_ddorder c_bpartner_location_id adempiere.dd_order c_bpartner_location_id
11 cbpartnerlocation_iasset c_bpartner_location_id adempiere.i_asset c_bpartner_location_id
12 cbpartnerlocation_ibpartner c_bpartner_location_id adempiere.i_bpartner c_bpartner_location_id
13 cbpartnerlocation_mpackage c_bpartner_location_id adempiere.m_package c_bpartner_location_id
14 cbpartnerlocation_mshippingtra c_bpartner_location_id adempiere.m_shippingtransaction c_bpartner_location_id
15 cbpartnerlocation_soline c_bpartner_location_id adempiere.c_orderline c_bpartner_location_id
16 cbpartnerlocation_tdrdetail c_bpartner_location_id adempiere.t_distributionrundetail c_bpartner_location_id
17 cbpartnerlocbillto_iorder c_bpartner_location_id adempiere.i_order billto_id
18 cbplocation_aasset c_bpartner_location_id adempiere.a_asset c_bpartner_location_id
19 cbplocation_aduser c_bpartner_location_id adempiere.ad_user c_bpartner_location_id
20 cbplocation_cbprelation c_bpartner_location_id adempiere.c_bp_relation c_bpartner_location_id
21 cbplocation_cbprelationbp c_bpartner_location_id adempiere.c_bp_relation c_bpartnerrelation_location_id
22 cbplocation_cinvoicebline c_bpartner_location_id adempiere.c_invoicebatchline c_bpartner_location_id
23 cbplocation_cproject c_bpartner_location_id adempiere.c_project c_bpartner_location_id
24 cbplocation_crfq c_bpartner_location_id adempiere.c_rfq c_bpartner_location_id
25 cbplocation_crfqresponse c_bpartner_location_id adempiere.c_rfqresponse c_bpartner_location_id
26 cbplocation_iinvoice c_bpartner_location_id adempiere.i_invoice c_bpartner_location_id
27 cbplocation_mdistributionrun c_bpartner_location_id adempiere.m_distributionrun c_bpartner_location_id
28 cbplocationbill_corder c_bpartner_location_id adempiere.c_order bill_location_id
29 cbplocationpay_corder c_bpartner_location_id adempiere.c_order pay_location_id
30 dropshiplocation_corder c_bpartner_location_id adempiere.c_order dropship_location_id
31 dropshiplocation_minout c_bpartner_location_id adempiere.m_inout dropship_location_id
32 holdaddress_mpackage c_bpartner_location_id adempiere.m_package holdaddress_id
33 holdaddress_mshippingtransacti c_bpartner_location_id adempiere.m_shippingtransaction holdaddress_id
34 returnlocation_minout c_bpartner_location_id adempiere.m_inout returnlocation_id
35 returnlocation_mshippingtransa c_bpartner_location_id adempiere.m_shippingtransaction returnlocation_id
36 vbplocation_minout c_bpartner_location_id adempiere.m_inout c_bpartner_location_id


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