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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 a_asset_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(60) Yes
11 description character varying(255)  
12 help character varying(2000)  
13 a_asset_group_id numeric(10) Yes
14 m_product_id numeric(10) Yes
15 serno character varying(255)  
16 lot character varying(255)  
17 versionno character varying(20)  
18 guaranteedate timestamp without time zone  
19 assetservicedate timestamp without time zone  
20 isowned character(1) Yes 'Y'
21 assetdepreciationdate timestamp without time zone  
22 uselifeyears numeric(10)  
23 uselifemonths numeric(10)  
24 lifeuseunits numeric  
25 useunits numeric  
26 isdisposed character(1) Yes 'N'
27 assetdisposaldate timestamp without time zone  
28 isinposession character(1) Yes 'Y'
29 locationcomment character varying(255)  
30 m_locator_id numeric(10)  
31 c_bpartner_id numeric(10)  
32 c_bpartner_location_id numeric(10)  
33 c_location_id numeric(10)  
34 processing character(1)   'N'
35 isdepreciated character(1) Yes 'Y'
36 isfullydepreciated character(1) Yes 'N'
37 ad_user_id numeric(10)  
38 m_attributesetinstance_id numeric(10)   0
39 qty numeric  
40 c_project_id numeric(10)  
41 c_bpartnersr_id numeric(10)  
42 m_inoutline_id numeric(10)  
43 lastmaintenencedate timestamp without time zone  
44 nextmaintenencedate timestamp without time zone  
45 lastmaintenanceuseunit numeric(10)  
46 nextmaintenanceuseunit numeric(10)  
47 leaseterminationdate timestamp without time zone  
48 lease_bpartner_id numeric(10)  
49 lastmaintenancenote character varying(60)  
50 lastmaintenancedate timestamp without time zone  
51 lastmaintenanceunit numeric(10)  
52 nextmaintenenceunit numeric(10)  
53 a_asset_createdate timestamp without time zone  
54 a_asset_revaldate timestamp without time zone  
55 a_parent_asset_id numeric(10)  
56 a_qty_current numeric  
57 a_qty_original numeric  
58 a_asset_uu character varying(36)   NULL
59 a_asset_class_id numeric(10)   NULL
60 a_asset_status character varying(2) Yes 'NW'
61 a_asset_action character varying(2) Yes 'MD'
62 processed character(1) Yes 'N'
63 assetactivationdate timestamp without time zone  
64 inventoryno character varying(30)   NULL
65 a_asset_type_id numeric(10)  
66 a_assettype character varying(3) Yes 'MFX'
67 c_activity_id numeric(10)   NULL
68 manufacturer character varying(30)   NULL
69 manufacturedyear numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 a_asset_pkey a_asset_id Yes  
2 a_asset_uu_idx a_asset_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 aassetclass_aasset a_asset_class_id adempiere.a_asset_class a_asset_class_id
2 aassetgroup_aasset a_asset_group_id adempiere.a_asset_group a_asset_group_id
3 aassettype_aasset a_asset_type_id adempiere.a_asset_type a_asset_type_id
4 aduser_aasset ad_user_id adempiere.ad_user ad_user_id
5 aparentasset_aasset a_parent_asset_id adempiere.a_asset a_asset_id
6 cactivity_aasset c_activity_id adempiere.c_activity c_activity_id
7 cbpartner_aasset c_bpartner_id adempiere.c_bpartner c_bpartner_id
8 cbpartnersr_aasset c_bpartnersr_id adempiere.c_bpartner c_bpartner_id
9 cbplocation_aasset c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
10 clocation_aasset c_location_id adempiere.c_location c_location_id
11 cproject_aasset c_project_id adempiere.c_project c_project_id
12 leasebpartner_aasset lease_bpartner_id adempiere.c_bpartner c_bpartner_id
13 mattributesetinstance_aasset m_attributesetinstance_id adempiere.m_attributesetinstance m_attributesetinstance_id
14 minoutline_aasset m_inoutline_id adempiere.m_inoutline m_inoutline_id
15 mlocator_aasset m_locator_id adempiere.m_locator m_locator_id
16 mproduct_aasset m_product_id adempiere.m_product m_product_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 aasset_aassetacct a_asset_id adempiere.a_asset_acct a_asset_id
2 aasset_aassetaddition a_asset_id adempiere.a_asset_addition a_asset_id
3 aasset_aassetchange a_asset_id adempiere.a_asset_change a_asset_id
4 aasset_aassetdelivery a_asset_id adempiere.a_asset_delivery a_asset_id
5 aasset_aassetdisposed a_asset_id adempiere.a_asset_disposed a_asset_id
6 aasset_aassetinfofin a_asset_id adempiere.a_asset_info_fin a_asset_id
7 aasset_aassetinfolic a_asset_id adempiere.a_asset_info_lic a_asset_id
8 aasset_aassetproduct a_asset_id adempiere.a_asset_product a_asset_id
9 aasset_aassetretirement a_asset_id adempiere.a_asset_retirement a_asset_id
10 aasset_aassetreval a_asset_id adempiere.a_asset_reval a_asset_id
11 aasset_aassettransfer a_asset_id adempiere.a_asset_transfer a_asset_id
12 aasset_aassetuse a_asset_id adempiere.a_asset_use a_asset_id
13 aasset_adepreciationexp a_asset_id adempiere.a_depreciation_exp a_asset_id
14 aasset_adepreciationworkfile a_asset_id adempiere.a_depreciation_workfile a_asset_id
15 aasset_adissue a_asset_id adempiere.ad_issue a_asset_id
16 aasset_aregistration a_asset_id adempiere.a_registration a_asset_id
17 aasset_cinvoiceline a_asset_id adempiere.c_invoiceline a_asset_id
18 aasset_factacct a_asset_id adempiere.fact_acct a_asset_id
19 aasset_gljournalline a_asset_id adempiere.gl_journalline a_asset_id
20 aasset_ifixedasset a_asset_id adempiere.i_fixedasset a_asset_id
21 aasset_moperationresource a_asset_id adempiere.m_operationresource a_asset_id
22 aasset_ppordernodeasset a_asset_id adempiere.pp_order_node_asset a_asset_id
23 aasset_ppwfnodeasset a_asset_id adempiere.pp_wf_node_asset a_asset_id
24 aasset_rissueproject a_asset_id adempiere.r_issueproject a_asset_id
25 aasset_rissuesystem a_asset_id adempiere.r_issuesystem a_asset_id
26 aasset_rrequest a_asset_id adempiere.r_request a_asset_id
27 aasset_rrequestaction a_asset_id adempiere.r_requestaction a_asset_id
28 aassettrade_aassetdisposed a_asset_id adempiere.a_asset_disposed a_asset_trade_id
29 aendasset_adepreciationbuild a_asset_id adempiere.a_depreciation_build a_end_asset_id
30 aendasset_adepreciationforecas a_asset_id adempiere.a_depreciation_forecast a_end_asset_id
31 aparentasset_aasset a_asset_id adempiere.a_asset a_parent_asset_id
32 aparentasset_aassetchange a_asset_id adempiere.a_asset_change a_parent_asset_id
33 astartasset_adepreciationbuild a_asset_id adempiere.a_depreciation_build a_start_asset_id
34 astartasset_adepreciationforec a_asset_id adempiere.a_depreciation_forecast a_start_asset_id


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