プライスリストスキーマ（Price List Schema）｜iDempiere 13 画面リファレンス
プライスリストスキーマ（Price List Schema）
Section titled “プライスリストスキーマ（Price List Schema）”iDempiere 13 標準ウィンドウ（AD_Window_ID: 337）
メニュー: 在庫管理 ▸ 品目マスタ管理 ▸ プライスリストスキーマ
Maintain Price List Schema
Price List schema defines calculation rules for price lists
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | プライスリストスキーマ | M_DiscountSchema | 0 | Price List Schema |
| 20 | プライスリストスキーマ明細 | M_DiscountSchemaLine | 1 | Trade Discount Price List Lines |
プライスリストスキーマ タブのフィールド
Section titled “プライスリストスキーマ タブのフィールド”Price List schema defines calculation rules for price lists
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | 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 |
| 有効開始日 | ValidFrom | Date | ✔ | Valid from including this date (first day) |
| 割引タイプ | DiscountType | List | ✔ | Type of trade schema calculation |
| 再計算 | Processing | Button | Renumber Discount entries |
プライスリストスキーマ明細 タブのフィールド
Section titled “プライスリストスキーマ明細 タブのフィールド”Pricelists are created based on Product Purchase and Category Discounts.
The parameters listed here allow to copy and calculate pricelists.
The calculation:
- Copy and convert price from referenced price list
- result plus Surcharge Amount
- result minus Discount
- if resulting price is less than the original limit price plus min Margin, use this price (only if Margin is not zero)
- if resulting price is more than the original limit price plus max Margin, use this price (only if Margin us not zero)
- Round resulting price
NewPrice = (Convert(BasePrice) + Surcharge) * (100-Discount) / 100;
if MinMargin <> 0 then NewPrice = Max (NewPrice, Convert(OrigLimitPrice) + MinMargin);
if MaxMargin <> 0 then NewPrice = Min (NewPrice, Convert(OrigLimitPrice) + MaxMargin);
Example: (assuming same currency)
Original Prices: List=300, Standard=250, Limit=200;
New List Price: Base=List, Surcharge=0, Discount=0, Round
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| プライスリストスキーマ | M_DiscountSchema_ID | Table | ✔ | プライスリスト計算のためのスキーマ |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| 説明 | Description | String | Optional short description of the record | |
| 通貨レートタイプ | C_ConversionType_ID | Table Direct | ✔ | Currency Conversion Rate Type |
| 換算日付 | ConversionDate | Date | ✔ | Date for selecting conversion rate |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| Ignore Current Vendor Flag | IsIgnoreIsCurrentVendor | Yes-No | ✔ | take all PO prices into account |
| 品目 | M_Product_ID | Search | Product, Service, Item | |
| 品目カテゴリ | M_Product_Category_ID | Table Direct | Category of a Product | |
| 分類 | Classification | String | Classification for grouping | |
| Group1 | Group1 | String | ||
| Group2 | Group2 | String | ||
| 仕入先の項目カテゴリ | VendorCategory | String | Product Category of the Business Partner | |
| 定価の基準金額 | List_Base | List | ✔ | Price used as the basis for price list calculations |
| 定価の最小金額 | List_MinAmt | Amount | ✔ | Minimum margin for a product |
| 定価への付加金額 | List_AddAmt | Amount | ✔ | List Price Surcharge Amount |
| 定価の最大金額 | List_MaxAmt | Amount | ✔ | Maximum margin for a product |
| 定価の割引 % | List_Discount | Number | ✔ | Discount from list price as a percentage |
| 定価の丸め処理 | List_Rounding | List | ✔ | Rounding rule for final list price |
| 定価の固定金額 | List_Fixed | Amount | Fixes List Price (not calculated) | |
| 標準価格の基準金額 | Std_Base | List | ✔ | Base price for calculating new standard price |
| 標準価格の最小金額 | Std_MinAmt | Amount | ✔ | Minimum margin allowed for a product |
| 標準価格への付加金額 | Std_AddAmt | Amount | ✔ | Amount added to a price as a surcharge |
| 標準最大金額 | Std_MaxAmt | Amount | ✔ | Maximum margin allowed for a product |
| 標準価格の割引 % | Std_Discount | Number | ✔ | Discount percentage to subtract from base price |
| 標準価格の丸め処理 | Std_Rounding | List | ✔ | Rounding rule for calculated price |
| 標準価格の固定金額 | Std_Fixed | Amount | Fixed Standard Price (not calculated) | |
| 限度価格の基準金額 | Limit_Base | List | ✔ | Base price for calculation of the new price |
| 限度価格の最小金額 | Limit_MinAmt | Amount | ✔ | Minimum difference to original limit price; ignored if zero |
| 限度価格への付加金額 | Limit_AddAmt | Amount | ✔ | Amount added to the converted/copied price before multiplying |
| 限度価格最大金額 | Limit_MaxAmt | Amount | ✔ | Maximum difference to original limit price; ignored if zero |
| 限度価格の割引% | Limit_Discount | Number | ✔ | Discount in percent to be subtracted from base, if negative it will be added to base price |
| 限度価格の丸め処理 | Limit_Rounding | List | ✔ | Rounding of the final result |
| 限度価格の固定金額 | Limit_Fixed | Amount | Fixed Limit Price (not calculated) |