Kontenplan

TODO: Belegorientierets Buchen

Die 83 Basiskonten werden auch Standardkonten/default accounts genannt. 10 davon beziehen sich auf das Hauptbuch/general ledger. Sie haben fest programmierte Namen, die man in Spalten der Tabellen c_acctschema_default oder c_acctschema_gl wiederfindet. Die Namen enden mit _acct und haben oft einen Prefix, der auf die Verwendung verweist.

Die meisten Bezeichnungen lehnen sich an die Kontobezeichnung im US-Kontenrahmen AccountingUS.xls an. Dieser Kontenrahmen wird als Referenz in ADempiere gepflegt.

select * from ad_table where name like '%_Acct'
order by tablename;
:
"C_BankAccount_Acct"
"C_BP_Customer_Acct"
"C_BP_Employee_Acct"
"C_BP_Group_Acct"
"C_BP_Vendor_Acct"
"C_CashBook_Acct"
"C_Charge_Acct"
"C_Currency_Acct"
"C_InterOrg_Acct"
"C_Project_Acct"
"C_Tax_Acct"
"C_Withholding_Acct"
"M_Product_Acct"
"M_Product_Category_Acct"
"M_Warehouse_Acct"
;
-- zugeordnete SKR 03 Konten
select e.value,e.name,e.description 
 , v.c_validcombination_id,v.combination,v.description,v.account_id 
 from c_validcombination v
 join c_elementvalue e on c_elementvalue_id=v.account_id
where v.ad_client_id=1000000
order by e.value --v.c_validcombination_id
;
-- suchen nach commitmentoffset_acct (bzw alle aus c_acctschema_gl)
select e.value,e.name,e.description 
 , v.c_validcombination_id,v.combination,v.description,v.account_id 
 from c_validcombination v
 join c_elementvalue e on c_elementvalue_id=v.account_id
where v.ad_client_id=1000000 
  and v.c_validcombination_id in( 
    select commitmentoffset_acct from c_acctschema_gl where ad_client_id=1000000 )
;
--
select ad_client_id
,commitmentoffset_acct
,commitmentoffsetsales_acct
,currencybalancing_acct
,incomesummary_acct
,intercompanyduefrom_acct
,intercompanydueto_acct
,ppvoffset_acct
,retainedearning_acct
,suspensebalancing_acct
,suspenseerror_acct
 from c_acctschema_gl gl
 where gl.ad_client_id=1000000

-- suchen nach w_inventory_acct (bzw alle aus c_acctschema_gl)
select e.value,e.name,e.description 
 , v.c_validcombination_id,v.combination,v.description,v.account_id 
 from c_validcombination v
 join c_elementvalue e on c_elementvalue_id=v.account_id
where v.ad_client_id=1000000 
  and v.c_validcombination_id in( 
    select w_inventory_acct from c_acctschema_default where ad_client_id=1000000 )
;

CREATE TABLE c_acctschema_default
(
...
  w_inventory_acct 
  w_invactualadjust_acct 
  w_differences_acct 
  w_revaluation_acct 

  p_revenue_acct 
  p_expense_acct 
  p_asset_acct 
  p_purchasepricevariance_acct 
  p_invoicepricevariance_acct 
  p_tradediscountrec_acct 
  p_tradediscountgrant_acct 
  p_cogs_acct 

  c_receivable_acct 
  c_prepayment_acct 

  v_liability_acct 
  v_liability_services_acct 
  v_prepayment_acct 

  paydiscount_exp_acct 
  writeoff_acct 
  paydiscount_rev_acct 
  unrealizedgain_acct 
  unrealizedloss_acct 
  realizedgain_acct 
  realizedloss_acct 
  withholding_acct 

  e_prepayment_acct 
  e_expense_acct 

  pj_asset_acct 
  pj_wip_acct 

  t_expense_acct 
  t_liability_acct 
  t_receivables_acct 
  t_due_acct 
  t_credit_acct 

  b_intransit_acct 
  b_asset_acct 
  b_expense_acct 
  b_interestrev_acct 
  b_interestexp_acct 
  b_unidentified_acct 
  b_unallocatedcash_acct 
  b_paymentselect_acct 
  b_settlementgain_acct 
  b_settlementloss_acct 
  b_revaluationgain_acct 
  b_revaluationloss_acct 

  ch_expense_acct | 4900 Sonstige betriebliche Aufwendungen 
  ch_revenue_acct 

  unearnedrevenue_acct 
  notinvoicedreceivables_acct 
  notinvoicedrevenue_acct 
  notinvoicedreceipts_acct | "Not invoiced receipts" Default Level 1 -> BP_Group     3200 Wareneingang 

  cb_asset_acct 
  cb_cashtransfer_acct 
  cb_differences_acct 
  cb_expense_acct 
  cb_receipt_acct 

  c_receivable_services_acct 

  p_inventoryclearing_acct 
  p_costadjustment_acct 
  p_wip_acct 
  p_methodchangevariance_acct 
  p_usagevariance_acct 
  p_ratevariance_acct 
  p_mixvariance_acct 
  p_floorstock_acct 
  p_costofproduction_acct 
  p_labor_acct 
  p_burden_acct 
  p_outsideprocessing_acct 
  p_overhead_acct 
  p_scrap_acct 
  p_averagecostvariance_acct

PreviousInstallation NextBuchführungsschema

Last updated 6 years ago

select * from ad_table where name like '%_Acct' order by tablename; : "C_BankAccount_Acct" "C_BP_Customer_Acct" "C_BP_Employee_Acct" "C_BP_Group_Acct" "C_BP_Vendor_Acct" "C_CashBook_Acct" "C_Charge_Acct" "C_Currency_Acct" "C_InterOrg_Acct" "C_Project_Acct" "C_Tax_Acct" "C_Withholding_Acct" "M_Product_Acct" "M_Product_Category_Acct" "M_Warehouse_Acct" ; -- zugeordnete SKR 03 Konten select e.value,e.name,e.description , v.c_validcombination_id,v.combination,v.description,v.account_id from c_validcombination v join c_elementvalue e on c_elementvalue_id=v.account_id where v.ad_client_id=1000000 order by e.value --v.c_validcombination_id ; -- suchen nach commitmentoffset_acct (bzw alle aus c_acctschema_gl) select e.value,e.name,e.description , v.c_validcombination_id,v.combination,v.description,v.account_id from c_validcombination v join c_elementvalue e on c_elementvalue_id=v.account_id where v.ad_client_id=1000000 and v.c_validcombination_id in( select commitmentoffset_acct from c_acctschema_gl where ad_client_id=1000000 ) ; -- select ad_client_id ,commitmentoffset_acct ,commitmentoffsetsales_acct ,currencybalancing_acct ,incomesummary_acct ,intercompanyduefrom_acct ,intercompanydueto_acct ,ppvoffset_acct ,retainedearning_acct ,suspensebalancing_acct ,suspenseerror_acct from c_acctschema_gl gl where gl.ad_client_id=1000000 -- suchen nach w_inventory_acct (bzw alle aus c_acctschema_gl) select e.value,e.name,e.description , v.c_validcombination_id,v.combination,v.description,v.account_id from c_validcombination v join c_elementvalue e on c_elementvalue_id=v.account_id where v.ad_client_id=1000000 and v.c_validcombination_id in( select w_inventory_acct from c_acctschema_default where ad_client_id=1000000 ) ; CREATE TABLE c_acctschema_default ( ... w_inventory_acct w_invactualadjust_acct w_differences_acct w_revaluation_acct p_revenue_acct p_expense_acct p_asset_acct p_purchasepricevariance_acct p_invoicepricevariance_acct p_tradediscountrec_acct p_tradediscountgrant_acct p_cogs_acct c_receivable_acct c_prepayment_acct v_liability_acct v_liability_services_acct v_prepayment_acct paydiscount_exp_acct writeoff_acct paydiscount_rev_acct unrealizedgain_acct unrealizedloss_acct realizedgain_acct realizedloss_acct withholding_acct e_prepayment_acct e_expense_acct pj_asset_acct pj_wip_acct t_expense_acct t_liability_acct t_receivables_acct t_due_acct t_credit_acct b_intransit_acct b_asset_acct b_expense_acct b_interestrev_acct b_interestexp_acct b_unidentified_acct b_unallocatedcash_acct b_paymentselect_acct b_settlementgain_acct b_settlementloss_acct b_revaluationgain_acct b_revaluationloss_acct ch_expense_acct | 4900 Sonstige betriebliche Aufwendungen ch_revenue_acct unearnedrevenue_acct notinvoicedreceivables_acct notinvoicedrevenue_acct notinvoicedreceipts_acct | "Not invoiced receipts" Default Level 1 -> BP_Group 3200 Wareneingang cb_asset_acct cb_cashtransfer_acct cb_differences_acct cb_expense_acct cb_receipt_acct c_receivable_services_acct p_inventoryclearing_acct p_costadjustment_acct p_wip_acct p_methodchangevariance_acct p_usagevariance_acct p_ratevariance_acct p_mixvariance_acct p_floorstock_acct p_costofproduction_acct p_labor_acct p_burden_acct p_outsideprocessing_acct p_overhead_acct p_scrap_acct p_averagecostvariance_acct