Window: Import Price List
[Created: 17/03/2009 - Updated: 03/06/2021 ]
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
[Created: 17/03/2009 - Updated: 17/03/2009 ]
Description: Import Price Lists
Help:
Tab Level: 0
Table 10: Import Price List - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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. ./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 |