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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_acctschema_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 description character varying(255)  
11 gaap character(2) Yes
12 isaccrual character(1) Yes 'Y'
13 costingmethod character(1) Yes
14 c_currency_id numeric(10) Yes
15 autoperiodcontrol character(1) Yes 'N'
16 c_period_id numeric(10)  
17 period_openhistory numeric(10)  
18 period_openfuture numeric(10)  
19 separator character(1) Yes
20 hasalias character(1) Yes 'Y'
21 hascombination character(1) Yes 'Y'
22 istradediscountposted character(1) Yes 'N'
23 isdiscountcorrectstax character(1) Yes 'N'
24 m_costtype_id numeric(10)  
25 costinglevel character(1) Yes 'C'
26 isadjustcogs character(1) Yes 'N'
27 ad_orgonly_id numeric(10)  
28 ispostservices character(1) Yes 'N'
29 isexplicitcostadjustment character(1) Yes 'N'
30 commitmenttype character(1) Yes 'N'
31 processing character(1)  
32 taxcorrectiontype character(1)  
33 isallownegativeposting character(1)   'Y'
34 ispostifclearingequal character(1)   'Y'
35 c_acctschema_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_acctschema_name ad_client_id,name Yes  
2 c_acctschema_pkey c_acctschema_id Yes  
3 c_acctschema_uu_idx c_acctschema_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 ad_client_c_acctschema ad_client_id adempiere.ad_client ad_client_id
2 ad_org_c_acctschema ad_org_id adempiere.ad_org ad_org_id
3 adorgonly_cacctschema ad_orgonly_id adempiere.ad_org ad_org_id
4 c_currency_c_acctschema c_currency_id adempiere.c_currency c_currency_id
5 cperiod_cacctschema c_period_id adempiere.c_period c_period_id
6 mcosttype_cacctschema m_costtype_id adempiere.m_costtype m_costtype_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 c_acctschema_gl_journal c_acctschema_id adempiere.gl_journal c_acctschema_id
2 cacctschema1_adclientinfo c_acctschema_id adempiere.ad_clientinfo c_acctschema1_id
3 cacctschema_aassetacct c_acctschema_id adempiere.a_asset_acct c_acctschema_id
4 cacctschema_aassetchange c_acctschema_id adempiere.a_asset_change c_acctschema_id
5 cacctschema_aassetchangeamt c_acctschema_id adempiere.a_asset_change_amt c_acctschema_id
6 cacctschema_aassetgroupacct c_acctschema_id adempiere.a_asset_group_acct c_acctschema_id
7 cacctschema_aassetrevalentry c_acctschema_id adempiere.a_asset_reval_entry c_acctschema_id
8 cacctschema_aassettransfer c_acctschema_id adempiere.a_asset_transfer c_acctschema_id
9 cacctschema_adepreciationentry c_acctschema_id adempiere.a_depreciation_entry c_acctschema_id
10 cacctschema_afundingmodeacct c_acctschema_id adempiere.a_fundingmode_acct c_acctschema_id
11 cacctschema_cacctprocessor c_acctschema_id adempiere.c_acctprocessor c_acctschema_id
12 cacctschema_cacctschemagl c_acctschema_id adempiere.c_acctschema_gl c_acctschema_id
13 cacctschema_caschemaelement c_acctschema_id adempiere.c_acctschema_element c_acctschema_id
14 cacctschema_cbankaccountacct c_acctschema_id adempiere.c_bankaccount_acct c_acctschema_id
15 cacctschema_cbpcustomeracct c_acctschema_id adempiere.c_bp_customer_acct c_acctschema_id
16 cacctschema_cbpemployeeacct c_acctschema_id adempiere.c_bp_employee_acct c_acctschema_id
17 cacctschema_cbpgroupacct c_acctschema_id adempiere.c_bp_group_acct c_acctschema_id
18 cacctschema_cbpvendoracct c_acctschema_id adempiere.c_bp_vendor_acct c_acctschema_id
19 cacctschema_ccashbookacct c_acctschema_id adempiere.c_cashbook_acct c_acctschema_id
20 cacctschema_cchargeacct c_acctschema_id adempiere.c_charge_acct c_acctschema_id
21 cacctschema_ccurrencyacct c_acctschema_id adempiere.c_currency_acct c_acctschema_id
22 cacctschema_cinterorgacct c_acctschema_id adempiere.c_interorg_acct c_acctschema_id
23 cacctschema_cprojectacct c_acctschema_id adempiere.c_project_acct c_acctschema_id
24 cacctschema_crevrecplan c_acctschema_id adempiere.c_revenuerecognition_plan c_acctschema_id
25 cacctschema_ctaxacct c_acctschema_id adempiere.c_tax_acct c_acctschema_id
26 cacctschema_ctaxdeclacct c_acctschema_id adempiere.c_taxdeclarationacct c_acctschema_id
27 cacctschema_cvalidcombination c_acctschema_id adempiere.c_validcombination c_acctschema_id
28 cacctschema_cwithholdingacct c_acctschema_id adempiere.c_withholding_acct c_acctschema_id
29 cacctschema_default c_acctschema_id adempiere.c_acctschema_default c_acctschema_id
30 cacctschema_factacct c_acctschema_id adempiere.fact_acct c_acctschema_id
31 cacctschema_factacctsummary c_acctschema_id adempiere.fact_acct_summary c_acctschema_id
32 cacctschema_glbudgetcontrol c_acctschema_id adempiere.gl_budgetcontrol c_acctschema_id
33 cacctschema_gldist c_acctschema_id adempiere.gl_distribution c_acctschema_id
34 cacctschema_glfund c_acctschema_id adempiere.gl_fund c_acctschema_id
35 cacctschema_hrconceptacct c_acctschema_id adempiere.hr_concept_acct c_acctschema_id
36 cacctschema_iasset c_acctschema_id adempiere.i_asset c_acctschema_id
37 cacctschema_ifajournal c_acctschema_id adempiere.i_fajournal c_acctschema_id
38 cacctschema_igljournal c_acctschema_id adempiere.i_gljournal c_acctschema_id
39 cacctschema_mcost c_acctschema_id adempiere.m_cost c_acctschema_id
40 cacctschema_mcostdetail c_acctschema_id adempiere.m_costdetail c_acctschema_id
41 cacctschema_mcostqueue c_acctschema_id adempiere.m_costqueue c_acctschema_id
42 cacctschema_mprodcatacct c_acctschema_id adempiere.m_product_category_acct c_acctschema_id
43 cacctschema_mproductacct c_acctschema_id adempiere.m_product_acct c_acctschema_id
44 cacctschema_mwarehouseacct c_acctschema_id adempiere.m_warehouse_acct c_acctschema_id
45 cacctschema_paratio c_acctschema_id adempiere.pa_ratio c_acctschema_id
46 cacctschema_pareport c_acctschema_id adempiere.pa_report c_acctschema_id
47 cacctschema_ppordercost c_acctschema_id adempiere.pp_order_cost c_acctschema_id
48 cacctschema_qssjournalgenerato c_acctschema_id adempiere.gl_journalgenerator c_acctschema_id


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