レポート列セット（Report Column Set）｜iDempiere 13 画面リファレンス

レポート列セット（Report Column Set）

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

メニュー: 会計管理 ▸ 会計レポート ▸ レポート列セット

概要

Maintain Financial Report Column Sets

The Report Column Set defines what data is printed in the columns of a report.

タブ構成

#	タブ	テーブル	階層	説明
10	レポート列セット	PA_ReportColumnSet	0	Maintain Financial Report Column Sets
20	レポート列	PA_ReportColumn	1	Maintain Financial Report Column
30	翻訳	PA_ReportColumn_Trl	2

レポート列セット タブのフィールド

Column Sets are the combination of Columns to be included in a Financial Report

フィールド	カラム	型	必須	説明
クライアント	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
カラムコピー	Processing	Button	✔	Copy Report Columns from other Column Set

レポート列 タブのフィールド

A column represents a column in a Financial Report

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
レポート列セット	PA_ReportColumnSet_ID	Table Direct	✔	Collection of Columns for Report
名称	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
印刷	IsPrinted	Yes-No	✔	Indicates if this document / line is printed
シーケンスNo	SeqNo	Integer	✔	Method of ordering records; lowest number comes first
転記タイプ	PostingType	List	✔	The type of posted amount for the transaction
予算	GL_Budget_ID	Table Direct		General Ledger Budget
金額タイプ	PAAmountType	List		PA Amount Type for reporting
期間タイプ	PAPeriodType	List		PA Period Type
カラムタイプ	ColumnType	List	✔
相対期間	RelativePeriod	Number		Period offset (0 is current)
相対期間 (To)	RelativePeriodTo	Number		Period offset (0 is current)
計算	CalculationType	List
演算数 1	Oper_1_ID	Table		First operand for calculation
演算数 2	Oper_2_ID	Table		Second operand for calculation
Operand 2 Line Name	Oper_2_LineName	String		Name of the financial report line to take values from
タイプ	ElementType	List		Element Type (account or user defined)
組織	Org_ID	Table		Organizational entity within tenant
Include Nulls in Org	IsIncludeNullsOrg	Yes-No	✔	Include nulls in the selection of the organization
取引組織	AD_OrgTrx_ID	Table		Performing or initiating organization
Include Nulls in Org Trx	IsIncludeNullsOrgTrx	Yes-No	✔	Include nulls in the selection of the organization transaction
勘定科目エレメント	C_ElementValue_ID	Search		Account Element
Include Nulls in Account	IsIncludeNullsElementValue	Yes-No	✔	Include nulls in the selection of the account
品目	M_Product_ID	Search		Product, Service, Item
Include Nulls in Product	IsIncludeNullsProduct	Yes-No	✔	Include nulls in the selection of the product
営業活動	C_Campaign_ID	Table Direct		キャンペーン、営業活動
Include Nulls in Campaign	IsIncludeNullsCampaign	Yes-No	✔	Include nulls in the selection of the campaign
取引先	C_BPartner_ID	Search		Identifies a Business Partner
Include Nulls in BPartner	IsIncludeNullsBPartner	Yes-No	✔	Include nulls in the selection of the business partner
プロジェクト	C_Project_ID	Table Direct		Financial Project
Include Nulls in Project	IsIncludeNullsProject	Yes-No	✔	Include nulls in the selection of the project
住所	C_Location_ID	Location (Address)		Location or Address
Include Nulls in Location	IsIncludeNullsLocation	Yes-No	✔	Include nulls in the selection of the location
販売地域	C_SalesRegion_ID	Table Direct		Sales coverage region
Include Nulls in Sales Region	IsIncludeNullsSalesRegion	Yes-No	✔	Include nulls in the selection of the sales region
アクティビティ	C_Activity_ID	Table Direct		Business Activity
Include Nulls in Activity	IsIncludeNullsActivity	Yes-No	✔	Include nulls in the selection of the activity
ユーザーエレメント1	UserElement1_ID	ID		User defined accounting Element
Include Nulls in User Element 1	IsIncludeNullsUserElement1	Yes-No	✔	Include nulls in the selection of the user element 1
ユーザーエレメント2	UserElement2_ID	ID		User defined accounting Element
Include Nulls in User Element 2	IsIncludeNullsUserElement2	Yes-No	✔	Include nulls in the selection of the user element 2
フォーマットパターン	FormatPattern	String		The pattern used to format a number or date.
反対の符号を許可	IsAllowOppositeSign	Yes-No		Allow column values to be displayed with the opposite sign
乗数	Multiplier	Number		Type Multiplier (Credit = -1)
丸め係数	RoundFactor	Integer

翻訳 タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
レポートカラム	PA_ReportColumn_ID	Table Direct	✔	Column in Report
言語	AD_Language	Table	✔	Language for this entity
名称	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
翻訳する	IsTranslated	Yes-No	✔	This column is translated

このページについて

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