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


カラム情報
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 w_inventory_acct numeric(10)  
10 w_invactualadjust_acct numeric(10)  
11 w_differences_acct numeric(10) Yes
12 w_revaluation_acct numeric(10)  
13 p_revenue_acct numeric(10) Yes
14 p_expense_acct numeric(10) Yes
15 p_asset_acct numeric(10) Yes
16 p_purchasepricevariance_acct numeric(10) Yes
17 p_invoicepricevariance_acct numeric(10) Yes
18 p_tradediscountrec_acct numeric(10) Yes
19 p_tradediscountgrant_acct numeric(10) Yes
20 p_cogs_acct numeric(10) Yes
21 c_receivable_acct numeric(10) Yes
22 c_prepayment_acct numeric(10) Yes
23 v_liability_acct numeric(10) Yes
24 v_liability_services_acct numeric(10)  
25 v_prepayment_acct numeric(10) Yes
26 paydiscount_exp_acct numeric(10) Yes
27 writeoff_acct numeric(10) Yes
28 paydiscount_rev_acct numeric(10) Yes
29 unrealizedgain_acct numeric(10) Yes
30 unrealizedloss_acct numeric(10) Yes
31 realizedgain_acct numeric(10) Yes
32 realizedloss_acct numeric(10) Yes
33 withholding_acct numeric(10)  
34 e_prepayment_acct numeric(10)  
35 e_expense_acct numeric(10)  
36 pj_asset_acct numeric(10) Yes
37 pj_wip_acct numeric(10) Yes
38 t_expense_acct numeric(10) Yes
39 t_liability_acct numeric(10)  
40 t_receivables_acct numeric(10)  
41 t_due_acct numeric(10) Yes
42 t_credit_acct numeric(10) Yes
43 b_intransit_acct numeric(10) Yes
44 b_asset_acct numeric(10) Yes
45 b_expense_acct numeric(10)  
46 b_interestrev_acct numeric(10) Yes
47 b_interestexp_acct numeric(10) Yes
48 b_unidentified_acct numeric(10)  
49 b_unallocatedcash_acct numeric(10) Yes
50 b_paymentselect_acct numeric(10) Yes
51 b_settlementgain_acct numeric(10)  
52 b_settlementloss_acct numeric(10)  
53 b_revaluationgain_acct numeric(10)  
54 b_revaluationloss_acct numeric(10)  
55 ch_expense_acct numeric(10) Yes
56 ch_revenue_acct numeric(10)  
57 unearnedrevenue_acct numeric(10)  
58 notinvoicedreceivables_acct numeric(10)  
59 notinvoicedrevenue_acct numeric(10)  
60 notinvoicedreceipts_acct numeric(10) Yes
61 cb_asset_acct numeric(10)  
62 cb_cashtransfer_acct numeric(10)  
63 cb_differences_acct numeric(10)  
64 cb_expense_acct numeric(10)  
65 cb_receipt_acct numeric(10)  
66 processing character(1)  
67 c_receivable_services_acct numeric(10)  
68 p_inventoryclearing_acct numeric(10) Yes
69 p_costadjustment_acct numeric(10) Yes
70 p_wip_acct numeric(10)  
71 p_methodchangevariance_acct numeric(10)  
72 p_usagevariance_acct numeric(10)  
73 p_ratevariance_acct numeric(10)  
74 p_mixvariance_acct numeric(10)  
75 p_floorstock_acct numeric(10)  
76 p_costofproduction_acct numeric(10)  
77 p_labor_acct numeric(10)  
78 p_burden_acct numeric(10)  
79 p_outsideprocessing_acct numeric(10)  
80 p_overhead_acct numeric(10)  
81 p_scrap_acct numeric(10)  
82 p_averagecostvariance_acct numeric(10)   NULL
83 c_acctschema_default_uu character varying(36)   NULL
84 p_landedcostclearing_acct numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_acctschema_default_pkey c_acctschema_id Yes  
2 c_acctschema_default_uu_idx c_acctschema_default_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 cacctschema_default c_acctschema_id adempiere.c_acctschema c_acctschema_id
2 chrevenue_cacctschemadefault ch_revenue_acct adempiere.c_validcombination c_validcombination_id
3 creceivableservices_cacctschem c_receivable_services_acct adempiere.c_validcombination c_validcombination_id
4 paveragecostvariance_cacctsche p_averagecostvariance_acct adempiere.c_validcombination c_validcombination_id
5 pburden_cacctschemadefault p_burden_acct adempiere.c_validcombination c_validcombination_id
6 pcostadjustment_cacctschemadef p_costadjustment_acct adempiere.c_validcombination c_validcombination_id
7 pcostofproduction_cacctschemad p_costofproduction_acct adempiere.c_validcombination c_validcombination_id
8 pfloorstock_cacctschemadefault p_floorstock_acct adempiere.c_validcombination c_validcombination_id
9 pinventoryclearing_cacctschema p_inventoryclearing_acct adempiere.c_validcombination c_validcombination_id
10 plabor_cacctschemadefault p_labor_acct adempiere.c_validcombination c_validcombination_id
11 plandedcostclearingvc_cacctsch p_landedcostclearing_acct adempiere.c_validcombination c_validcombination_id
12 pmethodchangevariance_cacctsch p_methodchangevariance_acct adempiere.c_validcombination c_validcombination_id
13 pmixvariance_cacctschemadefaul p_mixvariance_acct adempiere.c_validcombination c_validcombination_id
14 poutsideprocessing_cacctschema p_outsideprocessing_acct adempiere.c_validcombination c_validcombination_id
15 poverhead_cacctschemadefault p_overhead_acct adempiere.c_validcombination c_validcombination_id
16 pratevariance_cacctschemadefau p_ratevariance_acct adempiere.c_validcombination c_validcombination_id
17 pscrap_cacctschemadefault p_scrap_acct adempiere.c_validcombination c_validcombination_id
18 pusagevariance_cacctschemadefa p_usagevariance_acct adempiere.c_validcombination c_validcombination_id
19 pwip_cacctschemadefault p_wip_acct adempiere.c_validcombination c_validcombination_id
20 vc_basset_cschemadefault b_asset_acct adempiere.c_validcombination c_validcombination_id
21 vc_bexpense_cschemadefault b_expense_acct adempiere.c_validcombination c_validcombination_id
22 vc_binterestexp_cschemadefault b_interestexp_acct adempiere.c_validcombination c_validcombination_id
23 vc_binterestrev_cschemadefault b_interestrev_acct adempiere.c_validcombination c_validcombination_id
24 vc_bintransit_cschemadefault b_intransit_acct adempiere.c_validcombination c_validcombination_id
25 vc_bpaymentselect_cschemadefau b_paymentselect_acct adempiere.c_validcombination c_validcombination_id
26 vc_brevaluationgain_cschemadef b_revaluationgain_acct adempiere.c_validcombination c_validcombination_id
27 vc_brevaluationloss_cschemadef b_revaluationloss_acct adempiere.c_validcombination c_validcombination_id
28 vc_bsettlementgain_cschemadefa b_settlementgain_acct adempiere.c_validcombination c_validcombination_id
29 vc_bsettlementloss_cschemadefa b_settlementloss_acct adempiere.c_validcombination c_validcombination_id
30 vc_bunallocatedcash_cschemadef b_unallocatedcash_acct adempiere.c_validcombination c_validcombination_id
31 vc_bunidentified_cschemadefaul b_unidentified_acct adempiere.c_validcombination c_validcombination_id
32 vc_cbasset_cschemadefault cb_asset_acct adempiere.c_validcombination c_validcombination_id
33 vc_cbcashtransfer_cschemadefau cb_cashtransfer_acct adempiere.c_validcombination c_validcombination_id
34 vc_cbdifferences_cschemadefaul cb_differences_acct adempiere.c_validcombination c_validcombination_id
35 vc_cbexpense_cschemadefault cb_expense_acct adempiere.c_validcombination c_validcombination_id
36 vc_cbreceipt_cschemadefault cb_receipt_acct adempiere.c_validcombination c_validcombination_id
37 vc_chexpense_cschemadefault ch_expense_acct adempiere.c_validcombination c_validcombination_id
38 vc_cprepayment_cschemadefault c_prepayment_acct adempiere.c_validcombination c_validcombination_id
39 vc_creceivable_cschemadefault c_receivable_acct adempiere.c_validcombination c_validcombination_id
40 vc_eexpense_cschemadefault e_expense_acct adempiere.c_validcombination c_validcombination_id
41 vc_eprepayment_cschemadefault e_prepayment_acct adempiere.c_validcombination c_validcombination_id
42 vc_notinvoicedrec_cschemadefau notinvoicedreceivables_acct adempiere.c_validcombination c_validcombination_id
43 vc_notinvoicedreceipts_cschema notinvoicedreceipts_acct adempiere.c_validcombination c_validcombination_id
44 vc_notinvoicedrevenue_cschemad notinvoicedrevenue_acct adempiere.c_validcombination c_validcombination_id
45 vc_passet_cschemadefault p_asset_acct adempiere.c_validcombination c_validcombination_id
46 vc_paydiscountexp_cschemadefau paydiscount_exp_acct adempiere.c_validcombination c_validcombination_id
47 vc_paydiscountrev_cschemadefau paydiscount_rev_acct adempiere.c_validcombination c_validcombination_id
48 vc_pcogs_cschemadefault p_cogs_acct adempiere.c_validcombination c_validcombination_id
49 vc_pexpense_cschemadefault p_expense_acct adempiere.c_validcombination c_validcombination_id
50 vc_pinvoicepv_cschemadefault p_invoicepricevariance_acct adempiere.c_validcombination c_validcombination_id
51 vc_pjasset_cschemadefault pj_asset_acct adempiere.c_validcombination c_validcombination_id
52 vc_pjwip_cschemadefault pj_wip_acct adempiere.c_validcombination c_validcombination_id
53 vc_ppurchasepv_cschemadefault p_purchasepricevariance_acct adempiere.c_validcombination c_validcombination_id
54 vc_prevenue_cschemadefault p_revenue_acct adempiere.c_validcombination c_validcombination_id
55 vc_ptdiscountgrant_cschemadefa p_tradediscountgrant_acct adempiere.c_validcombination c_validcombination_id
56 vc_ptdiscountrec_cschemadefaul p_tradediscountrec_acct adempiere.c_validcombination c_validcombination_id
57 vc_realizedgain_cschemadefault realizedgain_acct adempiere.c_validcombination c_validcombination_id
58 vc_realizedloss_cschemadefault realizedloss_acct adempiere.c_validcombination c_validcombination_id
59 vc_tcredit_cschemadefault t_credit_acct adempiere.c_validcombination c_validcombination_id
60 vc_tdue_cschemadefault t_due_acct adempiere.c_validcombination c_validcombination_id
61 vc_texpense_cschemadefault t_expense_acct adempiere.c_validcombination c_validcombination_id
62 vc_tliability_cschemadefault t_liability_acct adempiere.c_validcombination c_validcombination_id
63 vc_trec_cschemadefault t_receivables_acct adempiere.c_validcombination c_validcombination_id
64 vc_unearnedrevenue_cschemadefa unearnedrevenue_acct adempiere.c_validcombination c_validcombination_id
65 vc_unrealizedgain_cschemadefau unrealizedgain_acct adempiere.c_validcombination c_validcombination_id
66 vc_unrealizedloss_cschemadefau unrealizedloss_acct adempiere.c_validcombination c_validcombination_id
67 vc_vliability_cschemadefault v_liability_acct adempiere.c_validcombination c_validcombination_id
68 vc_vliabilityservices_cschemad v_liability_services_acct adempiere.c_validcombination c_validcombination_id
69 vc_vprepayment_cschemadefault v_prepayment_acct adempiere.c_validcombination c_validcombination_id
70 vc_wdifferences_cschemadefault w_differences_acct adempiere.c_validcombination c_validcombination_id
71 vc_winvactualadjust_cschemadef w_invactualadjust_acct adempiere.c_validcombination c_validcombination_id
72 vc_winventory_cschemadefault w_inventory_acct adempiere.c_validcombination c_validcombination_id
73 vc_withholding_cschemadefault withholding_acct adempiere.c_validcombination c_validcombination_id
74 vc_wrevaluation_cschemadefault w_revaluation_acct adempiere.c_validcombination c_validcombination_id
75 vc_writeoff_cschemadefault writeoff_acct adempiere.c_validcombination c_validcombination_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト


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