价目表 (窗口 ID-146)

窗口: 价目表

描述: 维护产品价目表

幫助: 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.

TAB: 价目表

描述: 定义价目表

幫助 Price lists determine currency of the document as well as tax treatment.

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
Default	缺省值	缺省值	The Default Checkbox indicates if this record will be used as a default value.	IsDefault character(1) NOT NULL Yes-No
Currency	货币	币种为该笔记录	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID numeric(10) NOT NULL Table Direct
Price Precision	Price Precision	Precision (number of decimals) for the Price	The prices of the price list are rounded to the precision entered. This allows to have prices with below currency precision, e.g. $0.005. Enter the number of decimals or -1 for no rounding.	PricePrecision numeric(10) NOT NULL Integer
Sales Price list	销售价目表	这是销售价目表	The Sales Price List check box indicates if this price list is used for sales transactions.	IsSOPriceList character(1) NOT NULL Yes-No
Price includes Tax	价格包括税	价格已包含税	The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price.	IsTaxIncluded character(1) NOT NULL Yes-No
Enforce price limit	强制价格限制	Do not allow prices below the limit price	The Enforce Price Limit check box indicates that prices cannot be below the limit price in Orders. Invoices are not checked.	EnforcePriceLimit character(1) NOT NULL Yes-No

TAB: 版本

描述: 维护价目表版本

幫助 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.

名稱	名稱	描述	幫助	產品規格
Price List Version	价目表版本	Identifies a unique instance of a Price List	Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for.	M_PriceList_Version_ID numeric(10) NOT NULL ID
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	价目表	Unique identifier of a Price List	Price Lists are used to determine the pricing, margin and cost of items purchased or sold.	M_PriceList_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
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
Base Price List	基本价格列表	Source for Price list calculations	The Base Price List identifies the Base Pricelist used for calculating prices (the source)	M_Pricelist_Version_Base_ID numeric(10) Table
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
Create Price List	产生价格目录	基于这个版本的叁数价格创建价格	Create Prices for this pricelist version in the sequence of the Discount Schema Price List. Lines with a higher sequence overwrite existing prices. The sequence should be from generic to specific.	ProcCreate character(1) Button

TAB: 产品价格

描述: 维护产品价格

幫助 The Price List Tab displays the prices for a product based on the selected price list.

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 Version	价目表版本	Identifies a unique instance of a Price List	Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for.	M_PriceList_Version_ID numeric(10) NOT NULL Table Direct
Product	产品	Product, Service, Item	Identifies an item which is either purchased or sold in this organization.	M_Product_ID numeric(10) NOT NULL Search
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
List Price	公开报价	公开报价	The List Price is the official List Price in the document currency.	PriceList numeric NOT NULL Costs+Prices
Standard Price	标准价格	标准价格	The Standard Price indicates the standard or normal price for a product on this price list	PriceStd numeric NOT NULL Costs+Prices
Limit Price	限制价格	产品的最低价格	The Price Limit indicates the lowest price for a product stated in the Price List Currency.	PriceLimit numeric NOT NULL Costs+Prices

TAB: Product Price Break

描述: null

幫助 null

File:价目表 - Product Price Break - 窗口 (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 Version	价目表版本	Identifies a unique instance of a Price List	Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for.	M_PriceList_Version_ID numeric(10) NOT NULL Table Direct
Product	产品	Product, Service, Item	Identifies an item which is either purchased or sold in this organization.	M_Product_ID numeric(10) NOT NULL Search
Business Partner	业务伙伴	标识业务伙伴	A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson	C_BPartner_ID numeric(10) NOT NULL Search
Break Value	休息价值	Low Value of trade discount break level	Starting Quantity or Amount Value for break level	BreakValue numeric NOT NULL Number
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
List Price	公开报价	公开报价	The List Price is the official List Price in the document currency.	PriceList numeric NOT NULL Costs+Prices
Standard Price	标准价格	标准价格	The Standard Price indicates the standard or normal price for a product on this price list	PriceStd numeric NOT NULL Costs+Prices
Limit Price	限制价格	产品的最低价格	The Price Limit indicates the lowest price for a product stated in the Price List Currency.	PriceLimit numeric NOT NULL Costs+Prices