價目表模式 (窗口 ID-337)

窗口: 價目表模式

描述: 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.
計算:

公式是
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