会計スキーマ（Accounting Schema）｜iDempiere 13 画面リファレンス

会計スキーマ（Accounting Schema）

iDempiere 13 標準ウィンドウ（AD_Window_ID: 125）

メニュー: 会計管理 ▸ 会計設定 ▸ 会計スキーマ

概要

Maintain Accounting Schema - For changes to become effective you must re-login

The Accounting Schema Window defines an accounting method and the elements that will comprise an account structure. Create and activate elements for detailed accounting for Business Partners, Products, Locations, etc. Review and change the GL and Default accounts. The actual accounts used in transactions depend on the executing organization; Most of the information is derived from the context.

タブ構成

#	タブ	テーブル	階層	説明
10	会計スキーマ	C_AcctSchema	0	Define your Account Schema Structure
20	会計スキーマエレメント	C_AcctSchema_Element	1	Define the dimensions of your Account Key
30	総勘定元帳	C_AcctSchema_GL	1	Accounts for GL
40	デフォルト	C_AcctSchema_Default	1	Default Accounts

会計スキーマ タブのフィールド

The Accounting Schema Tab defines the controls used for accounting. You can define multiple accounting schema per tenant (for parallel accounting).
Postings are generated for an accounting schema, if the schema is valid and you have defined GL and Default accounts and after completion of the Add / Copy Accounts process.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
名称	Name	String	✔	Alphanumeric identifier of the entity
説明	Description	String		Optional short description of the record
有効	IsActive	Yes-No	✔	The record is active in the system
GAAP	GAAP	List	✔	Generally Accepted Accounting Principles
委託タイプ	CommitmentType	List	✔	Create Commitment and/or Reservations for Budget Control
発生主義	IsAccrual	Yes-No	✔	Indicates if Accrual or Cash Based accounting will be used
在庫評価方法	CostingMethod	List	✔	Indicates how Costs will be calculated
原価タイプ	M_CostType_ID	Table Direct	✔	Type of Cost (e.g. Current, Plan, Future)
在庫評価レベル	CostingLevel	List	✔	The lowest level to accumulate Costing Information
通貨	C_Currency_ID	Table Direct	✔	The Currency for this record
明示的原価調整	IsExplicitCostAdjustment	Yes-No	✔	Post the cost adjustment explicitly
自動期間管理	AutoPeriodControl	Yes-No	✔	If selected, the periods are automatically opened and closed
期間	C_Period_ID	Table Direct		Period of the Calendar
過去日数	Period_OpenHistory	Integer		Number of days to be able to post in the past (based on system date)
未来日数	Period_OpenFuture	Integer		Number of days to be able to post to a future date (based on system date)
Back-Date Days	BackDateDay	Integer		Number of days to be able to post a back-date transaction (based on system date)
エレメントセパレータ	Separator	String	✔	Element Separator
勘定科目別名を使う	HasAlias	Yes-No	✔	Ability to select (partial) account combinations by an Alias
割引転記	IsTradeDiscountPosted	Yes-No	✔	Generate postings for trade discounts
決済が等しい場合転記	IsPostIfClearingEqual	Yes-No		Post if Clearing Equal
税金修正	TaxCorrectionType	List	✔	Type of Tax Correction
マイナス転記許可	IsAllowNegativePosting	Yes-No		マイナス金額の転記を許可するかどうか制御するフラグ。
組織のみ	AD_OrgOnly_ID	Table		Create posting entries only for this organization
GL/デフォルト作成	Processing	Button		Copy matching account element values from existing Accounting Schema
Start Date	StartDate	Date		First effective day (inclusive)
End Date	EndDate	Date		Last effective date (inclusive)

会計スキーマエレメント タブのフィールド

The Account Schema Dimensions Tab defines the dimensions that comprise the account key. A name is defined which will display in documents. Also the order of the dimensions and if they are balanced and mandatory are indicated.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
会計スキーマ	C_AcctSchema_ID	Table Direct	✔	Rules for accounting
名称	Name	String	✔	Alphanumeric identifier of the entity
有効	IsActive	Yes-No	✔	The record is active in the system
タイプ	ElementType	List	✔	Element Type (account or user defined)
エレメント	C_Element_ID	Table Direct	✔	Accounting Element
バランス済み	IsBalanced	Yes-No	✔
必須	IsMandatory	Yes-No	✔	Data entry is required in this column
シーケンスNo	SeqNo	Integer	✔	Method of ordering records; lowest number comes first
組織	Org_ID	Table	✔	Organizational entity within tenant
勘定科目エレメント	C_ElementValue_ID	Search		Account Element
品目	M_Product_ID	Search		Product, Service, Item
取引先	C_BPartner_ID	Search		Identifies a Business Partner
住所	C_Location_ID	Location (Address)		Location or Address
販売地域	C_SalesRegion_ID	Table Direct		Sales coverage region
プロジェクト	C_Project_ID	Search		Financial Project
営業活動	C_Campaign_ID	Table Direct		キャンペーン、営業活動
アクティビティ	C_Activity_ID	Table Direct		Business Activity
カラム	AD_Column_ID	Table Direct		Column in the table
Charge	C_Charge_ID	Table Direct		Additional document charges
Asset	A_Asset_ID	Search		Asset used internally or by customers
Warehouse	M_Warehouse_ID	Table Direct		Storage Warehouse and Service Point
Column 2	AD_Column2_ID	Table		Column in the table
Employee	C_Employee_ID	Search		Identifies a Business Partner
Department	C_Department_ID	Table Direct
Cost Center	C_CostCenter_ID	Table Direct
Attribute Set Instance	M_AttributeSetInstance_ID	Table Direct		Attribute Set Instance

総勘定元帳 タブのフィールド

The General Ledger Tab defines error and balance handling to use as well as the necessary accounts for posting to General Ledger.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
会計スキーマ	C_AcctSchema_ID	Table Direct	✔	Rules for accounting
有効	IsActive	Yes-No	✔	The record is active in the system
貸借調整に記帳する	UseSuspenseBalancing	Yes-No	✔
貸借調整勘定	SuspenseBalancing_Acct	Account
為替四捨五入調整に記帳する	UseCurrencyBalancing	Yes-No	✔
通貨四捨五入調整科目	CurrencyBalancing_Acct	Account		Account used when a currency is out of balance
社内取引債務勘定	IntercompanyDueTo_Acct	Account	✔	Intercompany Due To / Payable Account
社内取引債権勘定	IntercompanyDueFrom_Acct	Account	✔	Intercompany Due From / Receivables Account
発注入荷差異オフセット勘定	PPVOffset_Acct	Account	✔	Purchase Price Variance Offset Account
手数料オフセット科目	CommitmentOffset_Acct	Account	✔	Budgetary Commitment Offset Account
Commitment Offset Sales	CommitmentOffsetSales_Acct	Account	✔	Budgetary Commitment Offset Account for Sales

デフォルト タブのフィールド

The Defaults Tab displays the Default accounts for an Accounting Schema. These values will display when a new document is opened. The user can override these defaults within the document.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
会計スキーマ	C_AcctSchema_ID	Table Direct	✔	Rules for accounting
未実現利益科目	UnrealizedGain_Acct	Account	✔	Unrealized Gain Account for currency revaluation
未実現損失科目	UnrealizedLoss_Acct	Account	✔	Unrealized Loss Account for currency revaluation
為替差益科目	RealizedGain_Acct	Account	✔	Realized Gain Account
為替差損科目	RealizedLoss_Acct	Account	✔	Realized Loss Account
未請求債務勘定	NotInvoicedReceipts_Acct	Account	✔	Account for not-invoiced Material Receipts
前受収益勘定	UnEarnedRevenue_Acct	Account		Account for unearned revenue
売上割引勘定	PayDiscount_Exp_Acct	Account	✔	Payment Discount Expense Account
仕入割引勘定	PayDiscount_Rev_Acct	Account	✔	Payment Discount Revenue Account
貸倒損失勘定	WriteOff_Acct	Account	✔	Account for Receivables write-off
得意先債権勘定	C_Receivable_Acct	Account	✔	Account for Customer Receivables
仕入先債務勘定	V_Liability_Acct	Account	✔	Account for Vendor Liability
得意先前受勘定	C_Prepayment_Acct	Account	✔	Account for customer prepayments
仕入先前払勘定	V_Prepayment_Acct	Account	✔	Account for Vendor Prepayments
品目資産勘定	P_Asset_Acct	Account	✔	Account for Product Asset (Inventory)
品目費用勘定	P_Expense_Acct	Account	✔	品目費用勘定
原価調整勘定	P_CostAdjustment_Acct	Account	✔	Product Cost Adjustment Account
仕入仮勘定	P_InventoryClearing_Acct	Account	✔	Product Inventory Clearing Account
売上原価勘定	P_COGS_Acct	Account	✔	Account for Cost of Goods Sold
品目売上勘定	P_Revenue_Acct	Account	✔	Account for Product Revenue (Sales Account)
発注入荷差異勘定	P_PurchasePriceVariance_Acct	Account	✔	Difference between Standard Cost and Purchase Price (PPV)
入荷請求差異勘定	P_InvoicePriceVariance_Acct	Account	✔	Difference between Costs and Invoice Price (IPV)
仕入値引勘定	P_TradeDiscountRec_Acct	Account	✔	Trade Discount Receivable Account
売上値引勘定	P_TradeDiscountGrant_Acct	Account	✔	Trade Discount Granted Account
賃率差異勘定	P_RateVariance_Acct	Account	✔	The Rate Variance account is the account used Manufacturing Order
平均原価差異勘定	P_AverageCostVariance_Acct	Account		Average Cost Variance
荷揚コスト勘定	P_LandedCostClearing_Acct	Account		Product Landed Cost Clearing Account
棚卸減耗勘定	W_Differences_Acct	Account	✔	Warehouse Differences Account
銀行資産勘定	B_Asset_Acct	Account	✔	Bank Asset Account
銀行通過中勘定	B_InTransit_Acct	Account	✔	Bank In Transit Account
支払選択勘定	B_PaymentSelect_Acct	Account	✔	AP Payment Selection Clearing Account
未配分現金勘定	B_UnallocatedCash_Acct	Account	✔	未割当現金決済勘定
銀行支払利息勘定	B_InterestExp_Acct	Account	✔	Bank Interest Expense Account
銀行受取利息勘定	B_InterestRev_Acct	Account	✔	Bank Interest Revenue Account
仮受税金勘定	T_Due_Acct	Account	✔	Account for Tax you have to pay
仮払税金勘定	T_Credit_Acct	Account	✔	Account for Tax you can reclaim
税金費用勘定	T_Expense_Acct	Account	✔	Account for paid tax you cannot reclaim
料金費用勘定	Ch_Expense_Acct	Account	✔	Charge Account
プロジェクト資産科目	PJ_Asset_Acct	Account	✔	Project Asset Account
作業実施中科目	PJ_WIP_Acct	Account	✔	Account for Work in Progress
勘定科目コピー	Processing	Button		Add missing Accounts - or Copy&Overwrite Accounts (DANGEROUS!!)

このページについて

iDempiere 13 標準のアプリケーション辞書（AD: Application Dictionary）から自動生成した画面リファレンスです。日本語訳が存在しない項目は英語表記のまま掲載しています。運用手順を含む詳細マニュアルは iDempiere ガイド を参照してください。