Import Price List (Window ID-53071)

From iDempiere en

Table of Contents

Window: Import Price List

Description: Import Price Lists

Help: 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

Description: Import Price Lists

Help:

Import Price List - Import Price List - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Import Price List I_PriceList.I_PriceList_ID
numeric(10)
ID
Imported Has this import been processed The Imported check box indicates if this import has been processed. I_PriceList.I_IsImported
character(1)
Yes-No
Price List Unique identifier of a Price List Price Lists are used to determine the pricing, margin and cost of items purchased or sold. I_PriceList.M_PriceList_ID
numeric(10)
Table Direct
Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_PriceList.I_ErrorMsg
character varying(2000)
String
Tenant Tenant for this installation. A Tenant is a company or a legal entity. You cannot share data between Tenants. I_PriceList.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within tenant An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. I_PriceList.AD_Org_ID
numeric(10)
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. I_PriceList.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. I_PriceList.Description
character varying(255)
String
ISO Currency Code Three letter ISO 4217 Code of the Currency For details - http://www.unece.org/trade/rec/rec09en.htm I_PriceList.ISO_Code
character varying(3)
String
Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record I_PriceList.C_Currency_ID
numeric(10)
Table Direct
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. /tmp/script_gen_wiki_files_Window_TEMPLATE_PAGE_pg.sh.005. Enter the number of decimals or -1 for no rounding. I_PriceList.PricePrecision
numeric
Integer
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. I_PriceList.IsSOPriceList
character(1)
Yes-No
Price includes Tax Tax is included in the price The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price. I_PriceList.IsTaxIncluded
character(1)
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 and Invoices. This can be overwritten, if the role allows this. I_PriceList.EnforcePriceLimit
character(1)
Yes-No
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. I_PriceList.M_PriceList_Version_ID
numeric(10)
Table Direct
Valid from Valid from including this date (first day) The Valid From date indicates the first day of a date range I_PriceList.ValidFrom
timestamp without time zone
Date
Product Key Key of the Product I_PriceList.ProductValue
character varying(40)
String
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. I_PriceList.M_Product_ID
numeric(10)
Search
List Price List Price The List Price is the official List Price in the document currency. I_PriceList.PriceList
numeric
Costs+Prices
Standard Price Standard Price The Standard Price indicates the standard or normal price for a product on this price list I_PriceList.PriceStd
numeric
Costs+Prices
Limit Price Lowest price for a product The Price Limit indicates the lowest price for a product stated in the Price List Currency. I_PriceList.PriceLimit
numeric
Costs+Prices
Business Partner Key The Key of the Business Partner I_PriceList.BPartner_Value
character varying(40)
String
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson I_PriceList.C_BPartner_ID
numeric(10)
Search
Break Value Low Value of trade discount break level Starting Quantity or Amount Value for break level I_PriceList.BreakValue
numeric
Number
UOM Code UOM EDI X12 Code The Unit of Measure Code indicates the EDI X12 Code Data Element 355 (Unit or Basis for Measurement) I_PriceList.X12DE355
character varying(4)
String
UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure I_PriceList.C_UOM_ID
numeric(10)
Table Direct
Import Price Lists Imports price lists from a file into the application I_PriceList.Processing
character(1)
Button
Processed The document has been processed The Processed checkbox indicates that a document has been processed. I_PriceList.Processed
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.