Import Price List (jendela ID-53071)

jendela: Import Price List

deskripsi: Import Price Lists

membantu: The Import Price List Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.

TAB: Import Price List

deskripsi: Import Price Lists

membantu null

Berkas:Import Price List - Import Price List - jendela (iDempiere 1.0.0).png

nama	nama	deskripsi	membantu	spesifikasi
Import Price List	Import Price List	null	null	I_PriceList_ID numeric(10) NOT NULL ID
Imported	Imported	Has this import been processed	The Imported check box indicates if this import has been processed.	I_IsImported character(1) NOT NULL Yes-No
Price List	Daftar Harga	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) Table Direct
Import Error Message	Import Error Message	Messages generated from import process	The Import Error Message displays any error messages generated during the import process.	I_ErrorMsg character varying(2000) String
Client	Client	Client/Tenant for this installation.	A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.	AD_Client_ID numeric(10) Table Direct
Organization	Organization	Organizational entity within client	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) Table Direct
Name	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) String
Description	Penjelasan	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
ISO Currency Code	ISO Currency Code	Three letter ISO 4217 Code of the Currency	For details - http://www.unece.org/trade/rec/rec09en.htm	ISO_Code character varying(3) String
Currency	Mata Uang	The Currency for this record	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID numeric(10) 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 Integer
Sales Price list	Sales Price list	This is a Sales Price List	The Sales Price List check box indicates if this price list is used for sales transactions.	IsSOPriceList character(1) Yes-No
Price includes Tax	Harga Termasuk Pajak	Tax is included in the price	The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price.	IsTaxIncluded character(1) Yes-No
Enforce price limit	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 and Invoices. Ths can be overwritten, if the role allows this.	EnforcePriceLimit character(1) Yes-No
Price List Version	Versi Daftar Harga	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) Table Direct
Valid from	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 Date
Product Key	Product Key	Key of the Product	null	ProductValue character varying(40) String
Product	Produk	Product, Service, Item	Identifies an item which is either purchased or sold in this organization.	M_Product_ID numeric(10) Table Direct
List Price	List Price	List Price	The List Price is the official List Price in the document currency.	PriceList numeric Costs+Prices
Standard Price	Standard Price	Standard Price	The Standard Price indicates the standard or normal price for a product on this price list	PriceStd numeric Costs+Prices
Limit Price	Limit Price	Lowest price for a product	The Price Limit indicates the lowest price for a product stated in the Price List Currency.	PriceLimit numeric Costs+Prices
Business Partner Key	Business Partner Key	The Key of the Business Partner	null	BPartner_Value character varying(40) String
Business Partner	Partner Bisnis	Identifies a 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
Break Value	Break Value	Low Value of trade discount break level	Starting Quantity or Amount Value for break level	BreakValue numeric Number
UOM Code	UOM Code	UOM EDI X12 Code	The Unit of Measure Code indicates the EDI X12 Code Data Element 355 (Unit or Basis for Measurement)	X12DE355 character varying(4) String
UOM	UOM	Unit of Measure	The UOM defines a unique non monetary Unit of Measure	C_UOM_ID numeric(10) Table Direct
Import Price Lists	Import Price Lists	Imports price lists from a file into the application	null	Processing character(1) Button
Processed	Processed	The document has been processed	The Processed checkbox indicates that a document has been processed.	Processed character(1) Yes-No