品目マスタ(標準)（Product）｜iDempiere 13 画面リファレンス

品目マスタ(標準)（Product）

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

メニュー: 在庫管理 ▸ 品目マスタ管理 ▸ 品目マスタ(標準)

概要

Maintain Products

The Product Window defines all products used by an organization. These products include those sold to customers, used in the manufacture of products sold to customers and products purchased by an organization.

タブ構成

#	タブ	テーブル	階層	説明
10	品目マスタ	M_Product	0	Define Product
15	BOM	PP_Product_BOM	1	Bill of Material product lines
16	Components	PP_Product_BOMLine	2	Components
30	代替品目	M_Substitute	1	Define Substitute
40	関連品目	M_RelatedProduct	1	Related Product
50	在庫補充	M_Replenish	1	Define Product Replenishment
60	購買情報	M_Product_PO	1	Purchasing
70	取引先	C_BPartner_Product	1	Business Partner specific Information of a Product
90	価格	M_ProductPrice	1	Product Pricing
100	会計	M_Product_Acct	1	Define Accounting Parameters
110	在庫取引管理台帳	M_Transaction	1	Transactions for stored Products
120	翻訳	M_Product_Trl	1
130	現在庫数量管理台帳	M_Storage	1	Where are my units located?
140	計量単位変換	C_UOM_Conversion	1
150	品目原価	M_Cost	1
160	Reserved Quantity Log	M_StorageReservationLog	1
170	Ordered Quantity Log	M_StorageReservationLog	1

品目マスタ タブのフィールド

The Product Tab defines each product and identifies it for use in price lists and orders. The Location is the default location when receiving the stored product.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
検索キー	Value	String	✔	Search key for the record in the format required - must be unique
バージョンNo	VersionNo	String		Version Number
名称	Name	String	✔	Alphanumeric identifier of the entity
説明	Description	String		Optional short description of the record
コメント	Help	Text		Comment or Hint
伝票メモ	DocumentNote	Text		Additional information for a Document
JAN/UPC/EAN	UPC	String		Bar Code (Universal Product Code or its superset European Article Number)
SKU	SKU	String		Stock Keeping Unit
有効	IsActive	Yes-No	✔	The record is active in the system
サマリレベル	IsSummary	Yes-No	✔	This is a summary entity
品目カテゴリ	M_Product_Category_ID	Table Direct	✔	Category of a Product
分類	Classification	String		Classification for grouping
税カテゴリ	C_TaxCategory_ID	Table Direct	✔	Tax Category
収益認識方法	C_RevenueRecognition_ID	Table Direct		Method for recording revenue
数量単位	C_UOM_ID	Table Direct	✔	Unit of Measure
社内担当者	SalesRep_ID	Table		Sales Representative or Company Agent
項目タイプ	ProductType	List	✔	Type of product
メールテンプレート	R_MailText_ID	Table Direct		Text templates for mailings
重量	Weight	Amount		Weight of a product
容量	Volume	Amount		Volume of a product
個別包み	IsOwnBox	Yes-No	✔	Own Box
Customs Tariff Number	CustomsTariffNumber	String		Customs Tariff Number, usually the HS-Code
運賃カテゴリ	M_FreightCategory_ID	Table Direct		Category of the Freight
直送	IsDropShip	Yes-No	✔	Drop Shipments are sent directly to the Drop Shipment Location
在庫管理する	IsStocked	Yes-No	✔	Organization stocks this product
Manufactured	IsManufactured	Yes-No	✔	This product is manufactured
ファントムアイテム	IsPhantom	Yes-No	✔	Phantom Component
カンバン制御	IsKanban	Yes-No	✔	This part is Kanban controlled
パーツタイプ	M_PartType_ID	Table Direct
保管場所	M_Locator_ID	Locator (WH)		Warehouse Locator
棚幅	ShelfWidth	Integer		Shelf width required
棚高さ	ShelfHeight	Amount		Shelf height required
棚奥行	ShelfDepth	Integer		Shelf depth required
パレット入数	UnitsPerPallet	Costs+Prices		Units Per Pallet
部品表	IsBOM	Yes-No	✔	Bill of Materials
検査済み	IsVerified	Yes-No	✔	The BOM configuration has been verified
部品表の構成チェック	Processing	Button		Verify BOM for correctness
Auto Produce	IsAutoProduce	Yes-No	✔	Auto create production to fulfill shipment
Calculate BOM price if Zero	IsBOMPriceOverride	Yes-No	✔
部品表明細を請求書に印刷	IsInvoicePrintDetails	Yes-No	✔	Print detail BOM elements on the invoice
部品表明細をピッキングリストに印刷	IsPickListPrintDetails	Yes-No	✔	Print detail BOM elements on the pick list
購買	IsPurchased	Yes-No	✔	Organization purchases this product
販売	IsSold	Yes-No	✔	Organization sells this product
取扱終了	Discontinued	Yes-No		This product is no longer available
取扱終了日	DiscontinuedAt	Date		Discontinued At indicates Date when product was discontinued
経費タイプ	S_ExpenseType_ID	Table Direct		Expense report type
リソース	S_Resource_ID	Table Direct		Resource
自動で出荷納品伝票を作成しない	IsExcludeAutoDelivery	Yes-No	✔	Exclude from automatic Delivery
画像URL	ImageURL	URL		URL of image
説明 URL	DescriptionURL	URL		URL for the description
保証日数	GuaranteeDays	Integer		Number of days the product is guaranteed or available
最小保証日数	GuaranteeDaysMin	Integer		Minimum number of guarantee days
属性セット	M_AttributeSet_ID	Table Direct		Product Attribute Set
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Values
Copy from product	CopyFrom	Button		Deep copy from other product
Webストア注目商品	IsWebStoreFeatured	Yes-No	✔	If selected, the product is displayed in the initial or any empty search
セルフサービス	IsSelfService	Yes-No	✔	This is a Self-Service entry or this entry can be changed via Self-Service
Group1	Group1	String
Group2	Group2	String

BOM タブのフィールド

The Bill of Materials tab defines those products that are generated from other products. A Bill of Material (BOM) is one or more Products or BOMs.

Available Quantity:

• Stored BOMs have to be created via “Production”
• The available quantity of a non-stored BOMs is dynamically calculated
• The attribute “Stored” is defined in the “Product” tab

Price:

• BOMs must be listed in Pricelists
• If the price is 0.00, the price is dynamically calculated

Printing:

• Usually, only the BOM information is printed
• For invoices, delivery slips and pick lists, you have the option to print the details
• In the details, the quantity is listed - and the price, if this is dynamically calculated

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute		Product Attribute Set Instance
検索キー	Value	String	✔	Search key for the record in the format required - must be unique
名称	Name	Text	✔	Alphanumeric identifier of the entity
説明	Description	String		Optional short description of the record
コメント	Help	Text		Comment or Hint
有効	IsActive	Yes-No	✔	The record is active in the system
リビジョン	Revision	String
部品表タイプ	BOMType	List		Type of BOM
部品表使用用途	BOMUse	List		The use of the Bill of Material
Copy BOM Lines From	CopyFrom	Button		Copy BOM Lines from an exising BOM

Components タブのフィールド

Components of Bill of Materials

フィールド	カラム	型	必須	説明
明細番号	Line	Integer	✔	Unique line for this document
部品表(BOM & Formula)	PP_Product_BOM_ID	Search	✔	BOM & Formula
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute		Product Attribute Set Instance
構成品目タイプ	ComponentType	List		Component Type for a Bill of Material or Formula
説明	Description	String		Optional short description of the record
コメント	Help	Text		Comment or Hint
有効	IsActive	Yes-No	✔	The record is active in the system
Quantity	QtyBOM	Number		Indicate the Quantity use in this BOM
Feature	Feature	String		Indicated the Feature for Product Configure

代替品目 タブのフィールド

The Substitute Tab defines products which may be used as a replacement for the selected product.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
名称	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
代理人(代替品）	Substitute_ID	Search	✔	Entity which can be used in place of this entity

関連品目 タブのフィールド

Related Product - e.g. for promotions

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
名称	Name	String	✔	Alphanumeric identifier of the entity
説明	Description	Text		Optional short description of the record
有効	IsActive	Yes-No	✔	The record is active in the system
関連品目タイプ	RelatedProductType	List	✔
関連品目	RelatedProduct_ID	Search	✔	Related Product

在庫補充 タブのフィールド

The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
倉庫	M_Warehouse_ID	Table Direct	✔	Storage Warehouse and Service Point
保管場所	M_Locator_ID	Table Direct		Warehouse Locator
有効	IsActive	Yes-No	✔	The record is active in the system
補充タイプ	ReplenishType	List	✔	Method for re-ordering a product
最小在庫レベル	Level_Min	Amount	✔	Minimum Inventory level for this product
最大在庫レベル	Level_Max	Amount	✔	Maximum Inventory level for this product
補充元倉庫	M_WarehouseSource_ID	Table		Optional Warehouse to replenish from
バッチサイズ数量	QtyBatchSize	Quantity

購買情報 タブのフィールド

The Purchasing Tab define the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
取引先	C_BPartner_ID	Search	✔	Identifies a Business Partner
品質レイティング	QualityRating	Integer		Method for rating vendors
有効	IsActive	Yes-No	✔	The record is active in the system
現在の仕入先	IsCurrentVendor	Yes-No	✔	Use this Vendor for pricing and stock replenishment
JAN/UPC/EAN	UPC	String		Bar Code (Universal Product Code or its superset European Article Number)
通貨	C_Currency_ID	Table Direct		The Currency for this record
営業定価	PriceList	Costs+Prices		List Price
価格有効日	PriceEffective	Date		Effective Date of Price
仕入価格	PricePO	Costs+Prices		Price based on a purchase order
使用料金	RoyaltyAmt	Amount		(Included) Amount for copyright, etc.
最終発注価格	PriceLastPO	Costs+Prices		Price of the last purchase order for the product
最終請求価格	PriceLastInv	Costs+Prices		Price of the last invoice for the product
数量単位	C_UOM_ID	Table Direct		Unit of Measure
最小注文数量	Order_Min	Quantity		Minimum order quantity in UOM
注文パック数量	Order_Pack	Quantity		Package order size in UOM (e.g. order set of 5 units)
納品予定日数	DeliveryTime_Promised	Integer		Promised days between order and delivery
実納品時間	DeliveryTime_Actual	Integer		Actual days between order and delivery
注文毎の固定費	CostPerOrder	Costs+Prices		Fixed Cost Per Order
仕入先の項目コード	VendorProductNo	String	✔	Product Key of the Business Partner
仕入先の項目カテゴリ	VendorCategory	String		Product Category of the Business Partner
製造業者	Manufacturer	String		Manufacturer of the Product
取扱終了	Discontinued	Yes-No		This product is no longer available
取扱終了日	DiscontinuedAt	Date		Discontinued At indicates Date when product was discontinued

取引先 タブのフィールド

Note that some information is for reference only! The

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
取引先	C_BPartner_ID	Search	✔	Identifies a Business Partner
説明	Description	String		Optional short description of the record
有効	IsActive	Yes-No	✔	The record is active in the system
仕入先の項目コード	VendorProductNo	String		Product Key of the Business Partner
仕入先の項目カテゴリ	VendorCategory	String		Product Category of the Business Partner
製造業者	Manufacturer	String		Manufacturer of the Product
品質レイティング	QualityRating	Number		Method for rating vendors
最小保管期間率 %	ShelfLifeMinPct	Integer	✔	Minimum Shelf Life in percent based on Product Instance Guarantee Date
最小保管期間	ShelfLifeMinDays	Integer	✔	Minimum Shelf Life in days based on Product Instance Guarantee Date
製造業者	IsManufacturer	Yes-No	✔	Indicate role of this Business partner as Manufacturer

価格 タブのフィールド

The Pricing Tab displays the List, Standard and Limit prices for each price list a product is contained in.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
価格表バージョン	M_PriceList_Version_ID	Table Direct	✔	Identifies a unique instance of a Price List
有効	IsActive	Yes-No	✔	The record is active in the system
営業定価	PriceList	Costs+Prices	✔	List Price
実績価格	PriceStd	Costs+Prices	✔	Standard Price
限度価格	PriceLimit	Costs+Prices	✔	Lowest price for a product

会計 タブのフィールド

The Accounting Tab defines the defaults to use when generating accounting transactions for orders and invoices which contain this product.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
会計スキーマ	C_AcctSchema_ID	Table Direct	✔	Rules for accounting
有効	IsActive	Yes-No	✔	The record is active in the system
品目資産勘定	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

在庫取引管理台帳 タブのフィールド

The Transaction Tab displays the transactions that have been processed for this product.

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Set Instance
有効	IsActive	Yes-No	✔	The record is active in the system
保管場所	M_Locator_ID	Locator (WH)	✔	Warehouse Locator
移動数量	MovementQty	Quantity	✔	Quantity of a product moved.
移動日付	MovementDate	Date	✔	Date a product was moved in or out of inventory
移動タイプ	MovementType	List	✔	Method of moving the inventory
入出荷明細	M_InOutLine_ID	Search		入出荷明細
棚卸伝票明細	M_InventoryLine_ID	Search		Unique line in an Inventory document
在庫移動伝票明細	M_MovementLine_ID	Search		Inventory Move document Line
生産伝票明細	M_ProductionLine_ID	Search		Document Line representing a production
プロジェクト発行	C_ProjectIssue_ID	Search		Project Issues (Material, Labor)
Manufacturing Cost Collector	PP_Cost_Collector_ID	Search

翻訳 タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
言語	AD_Language	Table	✔	Language for this entity
名称	Name	String	✔	Alphanumeric identifier of the entity
説明	Description	String		Optional short description of the record
伝票メモ	DocumentNote	String		Additional information for a Document
有効	IsActive	Yes-No	✔	The record is active in the system
翻訳する	IsTranslated	Yes-No	✔	This column is translated

現在庫数量管理台帳 タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
在庫入庫日付	DateMaterialPolicy	Date		Time used for LIFO and FIFO Material Policy
保管場所	M_Locator_ID	Locator (WH)	✔	Warehouse Locator
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Set Instance
有効	IsActive	Yes-No	✔	The record is active in the system
手持在庫数量	QtyOnHand	Quantity	✔	On Hand Quantity
最終棚卸日付	DateLastInventory	Date		Date of Last Inventory Count
注文数量	QtyOrdered	Quantity	✔	Ordered Quantity
引当数量	QtyReserved	Quantity	✔	Reserved Quantity

計量単位変換 タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search		Product, Service, Item
有効	IsActive	Yes-No	✔	The record is active in the system
数量単位	C_UOM_ID	Table Direct	✔	Unit of Measure
変換先数量単位	C_UOM_To_ID	Table	✔	Target or destination Unit of Measure
掛算レート	MultiplyRate	Number	✔	Rate to multiple the source by to calculate the target.
割算レート	DivideRate	Number	✔	To convert Source number to Target number, the Source is divided

品目原価 タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Table Direct	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Set Instance
会計スキーマ	C_AcctSchema_ID	Table Direct	✔	Rules for accounting
原価タイプ	M_CostType_ID	Table Direct	✔	Type of Cost (e.g. Current, Plan, Future)
原価要素	M_CostElement_ID	Table Direct	✔	Product Cost Element
説明	Description	Text		Optional short description of the record
有効	IsActive	Yes-No	✔	The record is active in the system
在庫評価方法	CostingMethod	List		Indicates how Costs will be calculated
現在の原価	CurrentCostPrice	Costs+Prices	✔	The currently used cost price
現在の原価(構成品目合計)	CurrentCostPriceLL	Costs+Prices	✔	Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
将来の原価	FutureCostPrice	Costs+Prices	✔
将来の原価(構成品目合計)	FutureCostPriceLL	Costs+Prices
パーセント	Percent	Integer		Percentage
現在数量	CurrentQty	Quantity	✔	Current Quantity
Cost Frozen	IsCostFrozen	Yes-No		Indicated that the Standard Cost is frozen
蓄積金額	CumulatedAmt	Amount		Total Amount
合計数量	CumulatedQty	Quantity		Total Quantity
処理済み	Processed	Yes-No		The document has been processed

Reserved Quantity Log タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Search	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
倉庫	M_Warehouse_ID	Table Direct	✔	Storage Warehouse and Service Point
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Set Instance
伝票タイプ	C_DocType_ID	Table Direct		Document type or rules
伝票番号	DocumentNo	String		Document sequence number of the document
行番号	LineNo	Integer		Line No
テーブル	AD_Table_ID	Table Direct	✔	Database Table information
レコードID	Record_ID	Record ID	✔	Direct internal record ID
Old Current Quantity	OldQty	Quantity	✔	Old current quantity before the processing of M_CostDetail
差異数量	DeltaQty	Quantity	✔	Quantity Difference
New Current Quantity	NewQty	Quantity	✔	New current quantity after processing of M_CostDetail
作成日	Created	Date+Time	✔	Date this record was created

Ordered Quantity Log タブのフィールド

フィールド	カラム	型	必須	説明
クライアント	AD_Client_ID	Search	✔	Tenant for this installation.
組織	AD_Org_ID	Table Direct	✔	Organizational entity within tenant
倉庫	M_Warehouse_ID	Table Direct	✔	Storage Warehouse and Service Point
品目	M_Product_ID	Search	✔	Product, Service, Item
属性セットインスタンス	M_AttributeSetInstance_ID	Product Attribute	✔	Product Attribute Set Instance
伝票タイプ	C_DocType_ID	Table Direct		Document type or rules
伝票番号	DocumentNo	String		Document sequence number of the document
行番号	LineNo	Integer		Line No
テーブル	AD_Table_ID	Table Direct	✔	Database Table information
レコードID	Record_ID	Record ID	✔	Direct internal record ID
Old Current Quantity	OldQty	Quantity	✔	Old current quantity before the processing of M_CostDetail
差異数量	DeltaQty	Quantity	✔	Quantity Difference
New Current Quantity	NewQty	Quantity	✔	New current quantity after processing of M_CostDetail
作成日	Created	Date+Time	✔	Date this record was created

このページについて

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