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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 m_product_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(255) Yes
11 description character varying(255)  
12 documentnote character varying(2000)  
13 help character varying(2000)  
14 upc character varying(30)  
15 sku character varying(30)  
16 c_uom_id numeric(10) Yes
17 salesrep_id numeric(10)  
18 issummary character(1) Yes 'N'
19 isstocked character(1) Yes 'Y'
20 ispurchased character(1) Yes 'Y'
21 issold character(1) Yes 'Y'
22 isbom character(1) Yes 'N'
23 isinvoiceprintdetails character(1) Yes 'N'
24 ispicklistprintdetails character(1) Yes 'N'
25 isverified character(1) Yes 'N'
26 c_revenuerecognition_id numeric(10)  
27 m_product_category_id numeric(10) Yes
28 classification character varying(12)  
29 volume numeric   0
30 weight numeric   0
31 shelfwidth numeric(10)  
32 shelfheight numeric  
33 shelfdepth numeric(10)  
34 unitsperpallet numeric  
35 c_taxcategory_id numeric(10) Yes
36 s_resource_id numeric(10)  
37 discontinued character(1)   'N'
38 discontinuedby timestamp without time zone  
39 processing character(1)  
40 s_expensetype_id numeric(10)  
41 producttype character(1) Yes 'I'
42 imageurl character varying(120)  
43 descriptionurl character varying(120)  
44 guaranteedays numeric(10)  
45 r_mailtext_id numeric(10)  
46 versionno character varying(20)  
47 m_attributeset_id numeric(10)  
48 m_attributesetinstance_id numeric(10)   0
49 downloadurl character varying(120)  
50 m_freightcategory_id numeric(10)  
51 m_locator_id numeric(10)  
52 guaranteedaysmin numeric(10)  
53 iswebstorefeatured character(1) Yes 'N'
54 isselfservice character(1) Yes 'Y'
55 c_subscriptiontype_id numeric(10)  
56 isdropship character(1) Yes 'N'
57 isexcludeautodelivery character(1) Yes 'N'
58 group1 character varying(255)  
59 group2 character varying(255)  
60 istoformule character(1)  
61 lowlevel numeric(10) Yes (0)
62 unitsperpack numeric(10) Yes 1
63 discontinuedat timestamp without time zone  
64 copyfrom character(1)   NULL
65 m_product_uu character varying(36)   NULL
66 m_parttype_id numeric(10)   NULL
67 iskanban character(1) Yes 'N'
68 ismanufactured character(1) Yes 'N'
69 isphantom character(1)   'N'
70 isownbox character(1) Yes 'N'


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 m_product_expensetype s_expensetype_id Yes  
2 m_product_name name    
3 m_product_pkey m_product_id Yes  
4 m_product_productcategory m_product_category_id    
5 m_product_resource s_resource_id Yes  
6 m_product_upc upc    
7 m_product_uu_idx m_product_uu Yes  
8 m_product_value ad_client_id,value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 ad_org_mproduct ad_org_id adempiere.ad_org ad_org_id
2 adclient_mproduct ad_client_id adempiere.ad_client ad_client_id
3 crevrecognition_mproduct c_revenuerecognition_id adempiere.c_revenuerecognition c_revenuerecognition_id
4 csubscriptiontype_mproduct c_subscriptiontype_id adempiere.c_subscriptiontype c_subscriptiontype_id
5 ctaxcategory_mproduct c_taxcategory_id adempiere.c_taxcategory c_taxcategory_id
6 cuom_mproduct c_uom_id adempiere.c_uom c_uom_id
7 mattributeset_mproduct m_attributeset_id adempiere.m_attributeset m_attributeset_id
8 mattrsetinst_mproduct m_attributesetinstance_id adempiere.m_attributesetinstance m_attributesetinstance_id
9 mfreightcategory_mproduct m_freightcategory_id adempiere.m_freightcategory m_freightcategory_id
10 mlocator_mproduct m_locator_id adempiere.m_locator m_locator_id
11 mparttype_mproduct m_parttype_id adempiere.m_parttype m_parttype_id
12 mproduct_mproductcategory m_product_category_id adempiere.m_product_category m_product_category_id
13 rmailtext_mproduct r_mailtext_id adempiere.r_mailtext r_mailtext_id
14 salesrep_mproduct salesrep_id adempiere.ad_user ad_user_id
15 sexpensetype_mproduct s_expensetype_id adempiere.s_expensetype s_expensetype_id
16 sresource_mproduct s_resource_id adempiere.s_resource s_resource_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 m_product_fact_acct m_product_id adempiere.fact_acct m_product_id
2 m_product_m_product_acct m_product_id adempiere.m_product_acct m_product_id
3 m_product_productpo m_product_id adempiere.m_product_po m_product_id
4 m_product_replenish m_product_id adempiere.m_replenish m_product_id
5 mproduct_aasset m_product_id adempiere.a_asset m_product_id
6 mproduct_aassetaddition m_product_id adempiere.a_asset_addition m_product_id
7 mproduct_aassetproduct m_product_id adempiere.a_asset_product m_product_id
8 mproduct_aregistration m_product_id adempiere.a_registration m_product_id
9 mproduct_aregproduct m_product_id adempiere.a_registrationproduct m_product_id
10 mproduct_bomproduct m_product_id adempiere.m_product_bom m_productbom_id
11 mproduct_btopictype m_product_id adempiere.b_topictype m_product_id
12 mproduct_btopictypemember m_product_id adempiere.b_topictype m_productmember_id
13 mproduct_caschemaelement m_product_id adempiere.c_acctschema_element m_product_id
14 mproduct_cbpproduct m_product_id adempiere.c_bpartner_product m_product_id
15 mproduct_ccashplanline m_product_id adempiere.c_cashplanline m_product_id
16 mproduct_ccommissionline m_product_id adempiere.c_commissionline m_product_id
17 mproduct_cinvoiceline m_product_id adempiere.c_invoiceline m_product_id
18 mproduct_clandedcost m_product_id adempiere.c_landedcost m_product_id
19 mproduct_clandedcostalloc m_product_id adempiere.c_landedcostallocation m_product_id
20 mproduct_corderline m_product_id adempiere.c_orderline m_product_id
21 mproduct_cphase m_product_id adempiere.c_phase m_product_id
22 mproduct_cposkey m_product_id adempiere.c_poskey m_product_id
23 mproduct_cprojectissue m_product_id adempiere.c_projectissue m_product_id
24 mproduct_cprojectline m_product_id adempiere.c_projectline m_product_id
25 mproduct_cprojectphase m_product_id adempiere.c_projectphase m_product_id
26 mproduct_cprojecttask m_product_id adempiere.c_projecttask m_product_id
27 mproduct_crfqline m_product_id adempiere.c_rfqline m_product_id
28 mproduct_crfqtsubonly m_product_id adempiere.c_rfq_topicsubscriberonly m_product_id
29 mproduct_cservicelevel m_product_id adempiere.c_servicelevel m_product_id
30 mproduct_csubscription m_product_id adempiere.c_subscription m_product_id
31 mproduct_ctask m_product_id adempiere.c_task m_product_id
32 mproduct_ctaxdefinition m_product_id adempiere.c_taxdefinition m_product_id
33 mproduct_cuomconversion m_product_id adempiere.c_uom_conversion m_product_id
34 mproduct_ddorderline m_product_id adempiere.dd_orderline m_product_id
35 mproduct_factacctsummary m_product_id adempiere.fact_acct_summary m_product_id
36 mproduct_gldist m_product_id adempiere.gl_distribution m_product_id
37 mproduct_gldistline m_product_id adempiere.gl_distributionline m_product_id
38 mproduct_gljournalline m_product_id adempiere.gl_journalline m_product_id
39 mproduct_iasset m_product_id adempiere.i_asset m_product_id
40 mproduct_ifajournal m_product_id adempiere.i_fajournal m_product_id
41 mproduct_ifixedasset m_product_id adempiere.i_fixedasset m_product_id
42 mproduct_iinventory m_product_id adempiere.i_inventory m_product_id
43 mproduct_imovement m_product_id adempiere.i_movement m_product_id
44 mproduct_iorder m_product_id adempiere.i_order m_product_id
45 mproduct_ipricelist m_product_id adempiere.i_pricelist m_product_id
46 mproduct_iproduct m_product_id adempiere.i_product m_product_id
47 mproduct_iproductplanning m_product_id adempiere.i_productplanning m_product_id
48 mproduct_mbom m_product_id adempiere.m_bom m_product_id
49 mproduct_mbomalternative m_product_id adempiere.m_bomalternative m_product_id
50 mproduct_mbomproduct m_product_id adempiere.m_bomproduct m_productbom_id
51 mproduct_mbpprice m_product_id adempiere.m_bp_price m_product_id
52 mproduct_mcommodityshipment m_product_id adempiere.m_commodityshipment m_product_id
53 mproduct_mcost m_product_id adempiere.m_cost m_product_id
54 mproduct_mcostdetail m_product_id adempiere.m_costdetail m_product_id
55 mproduct_mcostqueue m_product_id adempiere.m_costqueue m_product_id
56 mproduct_mdemandline m_product_id adempiere.m_demandline m_product_id
57 mproduct_mdiscountsbreak m_product_id adempiere.m_discountschemabreak m_product_id
58 mproduct_mdiscountsline m_product_id adempiere.m_discountschemaline m_product_id
59 mproduct_mdistributionrun m_product_id adempiere.m_distributionrunline m_product_id
60 mproduct_medi m_product_id adempiere.m_edi m_product_id
61 mproduct_mforecastline m_product_id adempiere.m_forecastline m_product_id
62 mproduct_minoutline m_product_id adempiere.m_inoutline m_product_id
63 mproduct_minventorycount m_product_id adempiere.m_transaction m_product_id
64 mproduct_minventoryline m_product_id adempiere.m_inventoryline m_product_id
65 mproduct_mlot m_product_id adempiere.m_lot m_product_id
66 mproduct_mmatchinv m_product_id adempiere.m_matchinv m_product_id
67 mproduct_mmatchpo m_product_id adempiere.m_matchpo m_product_id
68 mproduct_mmovementline m_product_id adempiere.m_movementline m_product_id
69 mproduct_mpackageline m_product_id adempiere.m_packageline m_product_id
70 mproduct_mproductbom m_product_id adempiere.m_product_bom m_product_id
71 mproduct_mproductdownload m_product_id adempiere.m_productdownload m_product_id
72 mproduct_mproduction m_product_id adempiere.m_production m_product_id
73 mproduct_mproductionline m_product_id adempiere.m_productionline m_product_id
74 mproduct_mproductionplan m_product_id adempiere.m_productionplan m_product_id
75 mproduct_mproductoperation m_product_id adempiere.m_productoperation m_product_id
76 mproduct_mproductprice m_product_id adempiere.m_productprice m_product_id
77 mproduct_mproductpricevendorbr m_product_id adempiere.m_productpricevendorbreak m_product_id
78 mproduct_mproductqualitytest m_product_id adempiere.m_product_qualitytest m_product_id
79 mproduct_mproducttrl m_product_id adempiere.m_product_trl m_product_id
80 mproduct_mpromotiongroupline m_product_id adempiere.m_promotiongroupline m_product_id
81 mproduct_mrelated_product m_product_id adempiere.m_relatedproduct m_product_id
82 mproduct_mrelatedproduct m_product_id adempiere.m_relatedproduct relatedproduct_id
83 mproduct_mrequisitionline m_product_id adempiere.m_requisitionline m_product_id
84 mproduct_mrmaline m_product_id adempiere.m_rmaline m_product_id
85 mproduct_mstorageonhand m_product_id adempiere.m_storageonhand m_product_id
86 mproduct_mstoragereservation m_product_id adempiere.m_storagereservation m_product_id
87 mproduct_mtrxalloc m_product_id adempiere.m_transactionallocation m_product_id
88 mproduct_ogljournal m_product_id adempiere.i_gljournal m_product_id
89 mproduct_pagoalrestriction m_product_id adempiere.pa_goalrestriction m_product_id
90 mproduct_pareportcolumn m_product_id adempiere.pa_reportcolumn m_product_id
91 mproduct_pareportsource m_product_id adempiere.pa_reportsource m_product_id
92 mproduct_ppcostcollector m_product_id adempiere.pp_cost_collector m_product_id
93 mproduct_ppmrp m_product_id adempiere.pp_mrp m_product_id
94 mproduct_pporder m_product_id adempiere.pp_order m_product_id
95 mproduct_pporderbom m_product_id adempiere.pp_order_bom m_product_id
96 mproduct_pporderbomline m_product_id adempiere.pp_order_bomline m_product_id
97 mproduct_ppordercost m_product_id adempiere.pp_order_cost m_product_id
98 mproduct_ppordernodeproduct m_product_id adempiere.pp_order_node_product m_product_id
99 mproduct_ppproductbom m_product_id adempiere.pp_product_bom m_product_id
100 mproduct_ppproductbomline m_product_id adempiere.pp_product_bomline m_product_id
101 mproduct_ppproductplanning m_product_id adempiere.pp_product_planning m_product_id
102 mproduct_ppwfnodeproduct m_product_id adempiere.pp_wf_node_product m_product_id
103 mproduct_qmspecification m_product_id adempiere.qm_specification m_product_id
104 mproduct_rcategory m_product_id adempiere.r_category m_product_id
105 mproduct_rrequest m_product_id adempiere.r_request m_product_id
106 mproduct_rrequestaction m_product_id adempiere.r_requestaction m_product_id
107 mproduct_stimeexpenseline m_product_id adempiere.s_timeexpenseline m_product_id
108 mproduct_strainingclass m_product_id adempiere.s_training_class m_product_id
109 mproduct_substitute m_product_id adempiere.m_substitute m_product_id
110 mproduct_substitutesub m_product_id adempiere.m_substitute substitute_id
111 mproduct_tdrdetail m_product_id adempiere.t_distributionrundetail m_product_id
112 mproduct_tinventoryvalue m_product_id adempiere.t_inventoryvalue m_product_id
113 mproduct_treplenish m_product_id adempiere.t_replenish m_product_id
114 mproduct_ttransaction m_product_id adempiere.t_transaction m_product_id
115 mproduct_vc m_product_id adempiere.c_validcombination m_product_id
116 mproduct_wbasketline m_product_id adempiere.w_basketline m_product_id
117 mproductfreight_adclientinfo m_product_id adempiere.ad_clientinfo m_productfreight_id
118 mproductspent_rrequest m_product_id adempiere.r_request m_productspent_id
119 mproductspent_rrequestaction m_product_id adempiere.r_requestaction m_productspent_id
120 mproductspent_rrequestupdate m_product_id adempiere.r_requestupdate m_productspent_id
121 nproduct_iinvoice m_product_id adempiere.i_invoice m_product_id


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