價目表模式 (窗口 ID-337)
出自iDempiere zh
窗口: 價目表模式
描述: Maintain Price List Schema
幫助: Price List schema defines calculation rules for price lists
TAB: 價目表模式
描述: Price List Schema
幫助 Price List schema defines calculation rules for price lists
File:價目表模式 - 價目表模式 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Name | 名稱 | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name character varying(60) NOT NULL String |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Active | 有效 | 本記錄有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
| Valid from | 開始有效 | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom timestamp without time zone NOT NULL Date |
| Discount Type | 折扣類型 | Type of trade discount calculation | Type of procedure used to calculate the trade discount percentage | DiscountType character(1) NOT NULL List |
| Renumber | 重記數 | 折扣條目重記數 | null | Processing character(1) Button |
TAB: 折扣明細
描述: Trade Discount Price List Lines
幫助 Pricelists are created based on Product Purchase and Category Discounts.
The parameters listed here allow to copy and calculate pricelists.
計算:
-
<李>Copy and convert price from referenced price list
<李>結果加號額外費
<李>結果減折扣
<李>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)
<李>把產生的價格弄圓
-
公式是
NewPrice = (Convert(BasePrice) + Surcharge) * (100-Discount) 100;
是否 MinMargin<> 0 then NewPrice = Max (NewPrice, Convert(OrigLimitPrice) + MinMargin);
是否 MaxMargin<> 0 then NewPrice = Min (NewPrice, Convert(OrigLimitPrice) + MaxMargin);
例子:(假定同種幣種)
Original Prices: List=300, Standard=250, Limit=200;
New List Price: Base=List, Surcharge=0, Discount=0, Round File:價目表模式 - 折扣明細 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Price List Schema | 打折模式 | Schema to calculate the trade discount percentage | After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. | M_DiscountSchema_ID numeric(10) NOT NULL Table |
| Active | 有效 | 本記錄有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
| Sequence | 序列 | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo numeric(10) NOT NULL Integer |
| Currency Type | Currency Type | Currency Conversion Rate Type | The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. | C_ConversionType_ID numeric(10) NOT NULL Table Direct |
| Conversion Date | 轉變日期 | Date for selecting conversion rate | The Conversion Date identifies the date used for currency conversion. The conversion rate chosen must include this date in it's date range | ConversionDate timestamp without time zone NOT NULL Date |
| Business Partner | 業務夥伴 | 標識業務夥伴 | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID numeric(10) Search |
| Product | 產品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Search |
| Product Category | 產品分類 | Category this product is part of | Identifies the category which this product belongs to. Product categories are used for pricing. | M_Product_Category_ID numeric(10) Table Direct |
| Classification | 分類 | 分類為配列 | The Classification can be used to optionally group products. | Classification character varying(12) String |
| Group1 | Group1 | null | null | Group1 character varying(255) String |
| Group2 | Group2 | null | null | Group2 character varying(255) String |
| List price Base | 列表價格基礎 | Price used as the basis for price list calculations | The List Price Base indicates the price to use as the basis for the calculation of a new price list. | List_Base character(1) NOT NULL List |
| List price min Margin | 列表價格最小差額 | 產品最小量差額 | The List Price Min Margin indicates the minimum margin for a product. The margin is calculated by subtracting the original list price from the newly calculated price. If this field contains 0.00 then it is ignored. | List_MinAmt numeric NOT NULL Amount |
| List price Surcharge Amount | 列表價格額外費 | 列表價格額外費 | The List Price Surcharge Amount indicates the amount to be added to the price prior to multiplication. | List_AddAmt numeric NOT NULL Amount |
| List price max Margin | 列表價格最大差額 | 產品的最大的差額 | The List Price Max Margin indicates the maximum margin for a product. The margin is calculated by subtracting the original list price from the newly calculated price. If this field contains 0.00 then it is ignored. | List_MaxAmt numeric NOT NULL Amount |
| List price Discount % | 列表價格折扣 % | Discount from list price as a percentage | The List Price Discount Percentage indicates the percentage discount which will be subtracted from the base price. A negative amount indicates the percentage which will be added to the base price. | List_Discount numeric NOT NULL Number |
| List price Rounding | 列表價格圓整 | Rounding rule for final list price | The List Price Rounding indicates how the final list price will be rounded. | List_Rounding character(1) NOT NULL List |
| Fixed List Price | 固定的列表價格 | Fixes List Price (not calculated) | null | List_Fixed numeric Amount |
| Standard price Base | 標準價格基礎 | Base price for calculating new standard price | The Standard Price Base indicates the price to use as the basis for the calculation of a new price standard. | Std_Base character(1) NOT NULL List |
| Standard price min Margin | 標準價格最小差額 | Minimum margin allowed for a product | The Standard Price Min Margin indicates the minimum margin for a product. The margin is calculated by subtracting the original Standard price from the newly calculated price. If this field contains 0.00 then it is ignored. | Std_MinAmt numeric NOT NULL Amount |
| Standard price Surcharge Amount | 標準價格額外費 | 加到價格中作為額外費的金額 | The Standard Price Surcharge Amount indicates the amount to be added to the price prior to multiplication. | Std_AddAmt numeric NOT NULL Amount |
| Standard max Margin | 標準最大差額 | Maximum margin allowed for a product | The Standard Price Max Margin indicates the maximum margin for a product. The margin is calculated by subtracting the original Standard price from the newly calculated price. If this field contains 0.00 then it is ignored. | Std_MaxAmt numeric NOT NULL Amount |
| Standard price Discount % | 標準價格折扣 % | Discount percentage to subtract from base price | The Standard Price Discount Percentage indicates the percentage discount which will be subtracted from the base price. A negative amount indicates the percentage which will be added to the base price. | Std_Discount numeric NOT NULL Number |
| Standard price Rounding | 標準價格圓整 | Rounding rule for calculated price | The Standard Price Rounding indicates how the final Standard price will be rounded. | Std_Rounding character(1) NOT NULL List |
| Fixed Standard Price | 固定的標準價格 | Fixed Standard Price (not calculated) | null | Std_Fixed numeric Amount |
| Limit price Base | 限制價格基礎 | Base price for calculation of the new price | Identifies the price to be used as the base for calculating a new price list. | Limit_Base character(1) NOT NULL List |
| Limit price min Margin | 限制價格最小差額 | Minimum difference to original limit price; ignored if zero | Indicates the minimum margin for a product. The margin is calculated by subtracting the original limit price from the newly calculated price. If this field contains 0.00 then it is ignored. | Limit_MinAmt numeric NOT NULL Amount |
| Limit price Surcharge Amount | 限制價格額外費 | Amount added to the converted copied price before multiplying | Indicates the amount to be added to the Limit price prior to multiplication. | Limit_AddAmt numeric NOT NULL Amount |
| Limit price max Margin | 限制價格最大差額 | Maximum difference to original limit price; ignored if zero | Indicates the maximum margin for a product. The margin is calculated by subtracting the original limit price from the newly calculated price. If this field contains 0.00 then it is ignored. | Limit_MaxAmt numeric NOT NULL Amount |
| Limit price Discount % | 限制價格折扣 % | Discount in percent to be subtracted from base, if negative it will be added to base price | Indicates the discount in percent to be subtracted from base, if negative it will be added to base price | Limit_Discount numeric NOT NULL Number |
| Limit price Rounding | 限制價格圓整 | 最後的結果圓整 | A drop down list box which indicates the rounding (if any) will apply to the final prices in this price list. | Limit_Rounding character(1) NOT NULL List |
| Fixed Limit Price | 固定的限制價格 | Fixed Limit Price (not calculated) | null | Limit_Fixed numeric Amount |
.png){kind=link}
.png){kind=link}