価格表(Price List)|iDempiere 13 画面リファレンス
価格表(Price List)
Section titled “価格表(Price List)”iDempiere 13 標準ウィンドウ(AD_Window_ID: 146)
メニュー: 在庫管理 ▸ 品目マスタ管理 ▸ 価格表
Maintain Product Price Lists
The Price List Window allows you to generate product price lists for your Business Partners. Price lists determine currency and tax treatment. Price list versions allow to maintain parallel lists for different date ranges. The most current pricelist version is used based on the document date.
All pricelists have three prices: List, Standard and Limit
First step is to create a base price list. You can manually add products and enter the prices or create them automatically. The base price list is often the purchase price list with list price (‘official’ retail price), the standard price (your purchase price). The limit price can be used to check your final purchase costs after discounts, rebates, etc.
Pricelists can be calculated and copied. To speed up the calculation, the parameters are stored an used when creating a new price list version.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | 価格表 | M_PriceList | 0 | Define Price Lists |
| 20 | バージョン | M_PriceList_Version | 1 | Maintain price list versions |
| 30 | 品目価格 | M_ProductPrice | 2 | Maintain Product Prices |
| 40 | 取引先別分岐価格設定 | M_ProductPriceVendorBreak | 2 | |
| 50 | 翻訳 | M_PriceList_Version_Trl | 2 | |
| 60 | 翻訳 | M_PriceList_Trl | 1 |
価格表 タブのフィールド
Section titled “価格表 タブのフィールド”Price lists determine currency of the document as well as tax treatment.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | 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 | |
| ベース価格表 | BasePriceList_ID | Table | Pricelist to be used, if product not found on this pricelist | |
| デフォルト | IsDefault | Yes-No | ✔ | Default value |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 価格精度 | PricePrecision | Integer | ✔ | Precision (number of decimals) for the Price |
| 販売用価格表 | IsSOPriceList | Yes-No | ✔ | This is a Sales Price List |
| 税込 | IsTaxIncluded | Yes-No | ✔ | Tax is included in the price |
| 限度価格チェック | EnforcePriceLimit | Yes-No | ✔ | Do not allow prices below the limit price |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
バージョン タブのフィールド
Section titled “バージョン タブのフィールド”Price lists are automatically created based on Product Purchasing Information and the Vendor Category Discount. The other alternative is to copy them from existing pricelists and the re-calculate them. You can also re-calculate the pricelist by referencing no pricelist or referencing the same pricelist. If no base price list is selected, the Procuct Purchase records are used as reference.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 価格表 | M_PriceList_ID | Table Direct | ✔ | Unique identifier of a Price List |
| 名称 | 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 |
| プライスリストスキーマ | M_DiscountSchema_ID | Table | ✔ | プライスリスト計算のためのスキーマ |
| ベース価格表 | M_Pricelist_Version_Base_ID | Table | Source for Price list calculations | |
| 有効開始日 | ValidFrom | Date | ✔ | Valid from including this date (first day) |
| 品目価格自動作成 | ProcCreate | Button | 品目価格を自動作成します。 |
品目価格 タブのフィールド
Section titled “品目価格 タブのフィールド”The Price List Tab displays the prices for a product based on the selected price list.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 価格表バージョン | M_PriceList_Version_ID | Table Direct | ✔ | Identifies a unique instance of a Price List |
| 品目 | M_Product_ID | Search | ✔ | Product, Service, Item |
| 有効 | 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 |
取引先別分岐価格設定 タブのフィールド
Section titled “取引先別分岐価格設定 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 価格表バージョン | M_PriceList_Version_ID | Table Direct | ✔ | Identifies a unique instance of a Price List |
| 品目 | M_Product_ID | Search | ✔ | Product, Service, Item |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| 分岐値 | BreakValue | Number | ✔ | Low Value of trade discount break level |
| 有効 | 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 |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 価格表バージョン | M_PriceList_Version_ID | Search | ✔ | Identifies a unique instance of a Price List |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 価格表 | M_PriceList_ID | Search | ✔ | Unique identifier of a Price List |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record |