价目表模式 (窗口 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


      Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。