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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_bpartner_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 value character varying(40) Yes
10 name character varying(120) Yes
11 name2 character varying(60)  
12 description character varying(255)  
13 issummary character(1) Yes 'N'
14 c_bp_group_id numeric(10) Yes
15 isonetime character(1) Yes 'N'
16 isprospect character(1) Yes 'N'
17 isvendor character(1) Yes 'N'
18 iscustomer character(1) Yes 'Y'
19 isemployee character(1) Yes 'N'
20 issalesrep character(1) Yes 'N'
21 referenceno character varying(40)  
22 duns character(11)  
23 url character varying(120)  
24 ad_language character varying(6)  
25 taxid character varying(20)  
26 istaxexempt character(1)   'N'
27 c_invoiceschedule_id numeric(10)  
28 rating character(1)  
29 salesvolume numeric(10)  
30 numberemployees numeric(10)  
31 naics character(6)  
32 firstsale timestamp without time zone  
33 acqusitioncost numeric   0
34 potentiallifetimevalue numeric   0
35 actuallifetimevalue numeric   0
36 shareofcustomer numeric(10)  
37 paymentrule character(1)  
38 so_creditlimit numeric   0
39 so_creditused numeric   0
40 c_paymentterm_id numeric(10)  
41 m_pricelist_id numeric(10)  
42 m_discountschema_id numeric(10)  
43 c_dunning_id numeric(10)  
44 isdiscountprinted character(1)   'Y'
45 so_description character varying(255)  
46 poreference character varying(20)  
47 paymentrulepo character(1)  
48 po_pricelist_id numeric(10)  
49 po_discountschema_id numeric(10)  
50 po_paymentterm_id numeric(10)  
51 documentcopies numeric(10)  
52 c_greeting_id numeric(10)  
53 invoicerule character(1)  
54 deliveryrule character(1)  
55 freightcostrule character(1)  
56 deliveryviarule character(1)  
57 salesrep_id numeric(10)  
58 sendemail character(1) Yes 'N'
59 bpartner_parent_id numeric(10)  
60 invoice_printformat_id numeric(10)  
61 socreditstatus character(1)   'O'
62 shelflifeminpct numeric(10)  
63 ad_orgbp_id numeric(10)  
64 flatdiscount numeric  
65 totalopenbalance numeric  
66 dunninggrace date  
67 c_taxgroup_id numeric(10)  
68 logo_id numeric(10)   NULL
69 ispotaxexempt character(1) Yes 'N'
70 ismanufacturer character(1)   'N'
71 c_bpartner_uu character varying(36)   NULL
72 customerprofileid character varying(60)   NULL
73 default1099box_id numeric(10)   NULL
74 is1099vendor character(1) Yes 'N'


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_bpartner_bporg ad_orgbp_id    
2 c_bpartner_name name    
3 c_bpartner_pkey c_bpartner_id Yes  
4 c_bpartner_uu_idx c_bpartner_uu Yes  
5 c_bpartner_value ad_client_id,value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 ad_language_c_buspartner ad_language adempiere.ad_language ad_language
2 adclient_cbpartner ad_client_id adempiere.ad_client ad_client_id
3 adorg_cbpartner ad_org_id adempiere.ad_org ad_org_id
4 adorg_cbpartnerorg ad_orgbp_id adempiere.ad_org ad_org_id
5 adprintformatinv_cbpartner invoice_printformat_id adempiere.ad_printformat ad_printformat_id
6 adusersalesrep_cbpartner salesrep_id adempiere.ad_user ad_user_id
7 cbpartner_cpbartnerparent bpartner_parent_id adempiere.c_bpartner c_bpartner_id
8 cbpgroup_cbpartner c_bp_group_id adempiere.c_bp_group c_bp_group_id
9 cdunning_cbpartner c_dunning_id adempiere.c_dunning c_dunning_id
10 cgreeting_cbpartner c_greeting_id adempiere.c_greeting c_greeting_id
11 cinvoiceschedule_cbpartner c_invoiceschedule_id adempiere.c_invoiceschedule c_invoiceschedule_id
12 cpaymentterm_cbpartner c_paymentterm_id adempiere.c_paymentterm c_paymentterm_id
13 cpopaymentterm_cbpartner po_paymentterm_id adempiere.c_paymentterm c_paymentterm_id
14 ctaxgroup_cbpartner c_taxgroup_id adempiere.c_taxgroup c_taxgroup_id
15 default1099box_cbpartner default1099box_id adempiere.c_1099box c_1099box_id
16 logo_cbpartner logo_id adempiere.ad_image ad_image_id
17 mdiscounts_cbpartner m_discountschema_id adempiere.m_discountschema m_discountschema_id
18 mdiscountspo_cbpartner po_discountschema_id adempiere.m_discountschema m_discountschema_id
19 mpricelist_cbpartner m_pricelist_id adempiere.m_pricelist m_pricelist_id
20 mpricelistpo_cbuspartner po_pricelist_id adempiere.m_pricelist m_pricelist_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 benefici_cwithholding c_bpartner_id adempiere.c_withholding beneficiary
2 c_bpartner_cbpedi c_bpartner_id adempiere.c_bp_edi c_bpartner_id
3 c_bpartner_rrequest c_bpartner_id adempiere.r_request c_bpartner_id
4 c_buspartner_c_bp_vendor_acct c_bpartner_id adempiere.c_bp_vendor_acct c_bpartner_id
5 c_buspartner_fact_acct c_bpartner_id adempiere.fact_acct c_bpartner_id
6 c_buspartner_m_product_po c_bpartner_id adempiere.m_product_po c_bpartner_id
7 cbpartner_aasset c_bpartner_id adempiere.a_asset c_bpartner_id
8 cbpartner_aassetchange c_bpartner_id adempiere.a_asset_change c_bpartner_id
9 cbpartner_aassetinfofin c_bpartner_id adempiere.a_asset_info_fin c_bpartner_id
10 cbpartner_adarchive c_bpartner_id adempiere.ad_archive c_bpartner_id
11 cbpartner_aduser c_bpartner_id adempiere.ad_user c_bpartner_id
12 cbpartner_adwfnode c_bpartner_id adempiere.ad_wf_node c_bpartner_id
13 cbpartner_aregistration c_bpartner_id adempiere.a_registration c_bpartner_id
14 cbpartner_callocationline c_bpartner_id adempiere.c_allocationline c_bpartner_id
15 cbpartner_cbankstatementline c_bpartner_id adempiere.c_bankstatementline c_bpartner_id
16 cbpartner_cbpbankaccount c_bpartner_id adempiere.c_bp_bankaccount c_bpartner_id
17 cbpartner_cbplocation c_bpartner_id adempiere.c_bpartner_location c_bpartner_id
18 cbpartner_cbpproduct c_bpartner_id adempiere.c_bpartner_product c_bpartner_id
19 cbpartner_cbprelation c_bpartner_id adempiere.c_bp_relation c_bpartner_id
20 cbpartner_cbprelationbp c_bpartner_id adempiere.c_bp_relation c_bpartnerrelation_id
21 cbpartner_cbpshippingacct c_bpartner_id adempiere.c_bp_shippingacct c_bpartner_id
22 cbpartner_cbpwithholding c_bpartner_id adempiere.c_bp_withholding c_bpartner_id
23 cbpartner_ccashplan c_bpartner_id adempiere.c_cashplan c_bpartner_id
24 cbpartner_ccashplanline c_bpartner_id adempiere.c_cashplanline c_bpartner_id
25 cbpartner_ccharge c_bpartner_id adempiere.c_charge c_bpartner_id
26 cbpartner_ccommission c_bpartner_id adempiere.c_commission c_bpartner_id
27 cbpartner_ccommissionline c_bpartner_id adempiere.c_commissionline c_bpartner_id
28 cbpartner_cdunningrunentry c_bpartner_id adempiere.c_dunningrunentry c_bpartner_id
29 cbpartner_cinvoice c_bpartner_id adempiere.c_invoice c_bpartner_id
30 cbpartner_cinvoicebatchline c_bpartner_id adempiere.c_invoicebatchline c_bpartner_id
31 cbpartner_copportunity c_bpartner_id adempiere.c_opportunity c_bpartner_id
32 cbpartner_corder c_bpartner_id adempiere.c_order c_bpartner_id
33 cbpartner_cpayment c_bpartner_id adempiere.c_payment c_bpartner_id
34 cbpartner_cpaymenttransaction c_bpartner_id adempiere.c_paymenttransaction c_bpartner_id
35 cbpartner_cpayselectioncheck c_bpartner_id adempiere.c_payselectioncheck c_bpartner_id
36 cbpartner_cpbartnerparent c_bpartner_id adempiere.c_bpartner bpartner_parent_id
37 cbpartner_cproject c_bpartner_id adempiere.c_project c_bpartner_id
38 cbpartner_crfq c_bpartner_id adempiere.c_rfq c_bpartner_id
39 cbpartner_crfqresponse c_bpartner_id adempiere.c_rfqresponse c_bpartner_id
40 cbpartner_crfqtopicsubr c_bpartner_id adempiere.c_rfq_topicsubscriber c_bpartner_id
41 cbpartner_csubscription c_bpartner_id adempiere.c_subscription c_bpartner_id
42 cbpartner_ctaxdeclline c_bpartner_id adempiere.c_taxdeclarationline c_bpartner_id
43 cbpartner_ctaxdefinition c_bpartner_id adempiere.c_taxdefinition c_bpartner_id
44 cbpartner_ddorder c_bpartner_id adempiere.dd_order c_bpartner_id
45 cbpartner_factacctsummary c_bpartner_id adempiere.fact_acct_summary c_bpartner_id
46 cbpartner_gldist c_bpartner_id adempiere.gl_distribution c_bpartner_id
47 cbpartner_gldistline c_bpartner_id adempiere.gl_distributionline c_bpartner_id
48 cbpartner_gljournalline c_bpartner_id adempiere.gl_journalline c_bpartner_id
49 cbpartner_hrattribute c_bpartner_id adempiere.hr_attribute c_bpartner_id
50 cbpartner_hrcontract c_bpartner_id adempiere.hr_contract c_bpartner_id
51 cbpartner_hremployee c_bpartner_id adempiere.hr_employee c_bpartner_id
52 cbpartner_hrmovement c_bpartner_id adempiere.hr_movement c_bpartner_id
53 cbpartner_hrprocess c_bpartner_id adempiere.hr_process c_bpartner_id
54 cbpartner_iasset c_bpartner_id adempiere.i_asset c_bpartner_id
55 cbpartner_ibankstatement c_bpartner_id adempiere.i_bankstatement c_bpartner_id
56 cbpartner_ibpartner c_bpartner_id adempiere.i_bpartner c_bpartner_id
57 cbpartner_ifajournal c_bpartner_id adempiere.i_fajournal c_bpartner_id
58 cbpartner_igljournal c_bpartner_id adempiere.i_gljournal c_bpartner_id
59 cbpartner_ihrmovement c_bpartner_id adempiere.i_hr_movement c_bpartner_id
60 cbpartner_iinvoice c_bpartner_id adempiere.i_invoice c_bpartner_id
61 cbpartner_imovement c_bpartner_id adempiere.i_movement c_bpartner_id
62 cbpartner_iorder c_bpartner_id adempiere.i_order c_bpartner_id
63 cbpartner_ipayment c_bpartner_id adempiere.i_payment c_bpartner_id
64 cbpartner_ipricelist c_bpartner_id adempiere.i_pricelist c_bpartner_id
65 cbpartner_iproduct c_bpartner_id adempiere.i_product c_bpartner_id
66 cbpartner_iproductplanning c_bpartner_id adempiere.i_productplanning c_bpartner_id
67 cbpartner_mbpprice c_bpartner_id adempiere.m_bp_price c_bpartner_id
68 cbpartner_mdiscountsline c_bpartner_id adempiere.m_discountschemaline c_bpartner_id
69 cbpartner_mdistlistline c_bpartner_id adempiere.m_distributionlistline c_bpartner_id
70 cbpartner_mdistributionrun c_bpartner_id adempiere.m_distributionrun c_bpartner_id
71 cbpartner_minout c_bpartner_id adempiere.m_inout c_bpartner_id
72 cbpartner_mmovement c_bpartner_id adempiere.m_movement c_bpartner_id
73 cbpartner_mproduction c_bpartner_id adempiere.m_production c_bpartner_id
74 cbpartner_mproductpricevendorb c_bpartner_id adempiere.m_productpricevendorbreak c_bpartner_id
75 cbpartner_mpromotionpreconditi c_bpartner_id adempiere.m_promotionprecondition c_bpartner_id
76 cbpartner_mrequisitionline c_bpartner_id adempiere.m_requisitionline c_bpartner_id
77 cbpartner_mrma c_bpartner_id adempiere.m_rma c_bpartner_id
78 cbpartner_mshipper c_bpartner_id adempiere.m_shipper c_bpartner_id
79 cbpartner_mshippingtransaction c_bpartner_id adempiere.m_shippingtransaction c_bpartner_id
80 cbpartner_pagoalrestriction c_bpartner_id adempiere.pa_goalrestriction c_bpartner_id
81 cbpartner_pareportcolumn c_bpartner_id adempiere.pa_reportcolumn c_bpartner_id
82 cbpartner_pareportsource c_bpartner_id adempiere.pa_reportsource c_bpartner_id
83 cbpartner_paslagoal c_bpartner_id adempiere.pa_sla_goal c_bpartner_id
84 cbpartner_ppmrp c_bpartner_id adempiere.pp_mrp c_bpartner_id
85 cbpartner_ppordernode c_bpartner_id adempiere.pp_order_node c_bpartner_id
86 cbpartner_qssjournalgeneratorl c_bpartner_id adempiere.gl_journalgeneratorline c_bpartner_id
87 cbpartner_rrequestaction c_bpartner_id adempiere.r_requestaction c_bpartner_id
88 cbpartner_soline c_bpartner_id adempiere.c_orderline c_bpartner_id
89 cbpartner_stimeexpense c_bpartner_id adempiere.s_timeexpense c_bpartner_id
90 cbpartner_stimeexpenseline c_bpartner_id adempiere.s_timeexpenseline c_bpartner_id
91 cbpartner_taging c_bpartner_id adempiere.t_aging c_bpartner_id
92 cbpartner_tdrdetail c_bpartner_id adempiere.t_distributionrundetail c_bpartner_id
93 cbpartner_vc c_bpartner_id adempiere.c_validcombination c_bpartner_id
94 cbpartner_wadvertisement c_bpartner_id adempiere.w_advertisement c_bpartner_id
95 cbpartner_wbasket c_bpartner_id adempiere.w_basket c_bpartner_id
96 cbpartner_wclickcount c_bpartner_id adempiere.w_clickcount c_bpartner_id
97 cbpartner_wcountercount c_bpartner_id adempiere.w_countercount c_bpartner_id
98 cbpartnerbill_corder c_bpartner_id adempiere.c_order bill_bpartner_id
99 cbpartnercashtrx_adclientinfo c_bpartner_id adempiere.ad_clientinfo c_bpartnercashtrx_id
100 cbpartnercashtrx_cpos c_bpartner_id adempiere.c_pos c_bpartnercashtrx_id
101 cbpartnerpay_corder c_bpartner_id adempiere.c_order pay_bpartner_id
102 cbpartnersr_aasset c_bpartner_id adempiere.a_asset c_bpartnersr_id
103 cbpartnersr_cproject c_bpartner_id adempiere.c_project c_bpartnersr_id
104 cbpartnersr_ifixedasset c_bpartner_id adempiere.i_fixedasset c_bpartnersr_id
105 cbuspartner_c_bpemployeeacct c_bpartner_id adempiere.c_bp_employee_acct c_bpartner_id
106 cbuspartner_caschemaelement c_bpartner_id adempiere.c_acctschema_element c_bpartner_id
107 cbuspartner_cbpcustomer_acct c_bpartner_id adempiere.c_bp_customer_acct c_bpartner_id
108 ccashbpartner_uposterminal c_bpartner_id adempiere.u_posterminal c_cashbpartner_id
109 ctemplatebpartner_uposterminal c_bpartner_id adempiere.u_posterminal c_templatebpartner_id
110 dropshipbpartner_corder c_bpartner_id adempiere.c_order dropship_bpartner_id
111 dropshipbpartner_minout c_bpartner_id adempiere.m_inout dropship_bpartner_id
112 leasebpartner_aasset c_bpartner_id adempiere.a_asset lease_bpartner_id
113 returnbpartner_minout c_bpartner_id adempiere.m_inout returnbpartner_id
114 returnbpartner_mshippingtransa c_bpartner_id adempiere.m_shippingtransaction returnbpartner_id


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