View source for Adempiere/Processes/Import/PriceList

Description of column in Price List Importer.

{| border="1"
!style="background:#efefef;" | Column
!style="background:#efefef;" | DB ColumnName
!style="background:#efefef;" | Description

|-
| Name
| Name
| Name of Price List – it will be created in case it doesn't exist

|-
| Description
| Description
| Just used in case the price list is new, ignored if price list already exists

|-
| Price Precision
| PricePrecision
| Just used in case the price list is new, ignored if price list already exists

|-
| Price includes Tax
| IsTaxIncluded
| Just used in case the price list is new, ignored if price list already exists

|-
| Sales Price list
| IsSOPriceList
| Just used in case the price list is new, ignored if price list already exists

|-
| Enforce price limit
| EnforcePriceLimit
| Just used in case the price list is new, ignored if price list already exists

|-
| ISO Currency Code
| ISO_Code_ISO
| Just used in case the price list is new, ignored if price list already exists

|-
| Valid from
| ValidFrom
| Used to determine the Price List Version, it's created if it doesn't exist, name is created concatenating price list name + valid from date, price list schema is assigned to the first found (not used in this process, but as is a mandatory field it needs to be filled)

|-
| Product Key
| ProductValue
| Used to determine the product

|-
| Business Partner Key
| BusinessPartnerValue
| If filled then system will insert a Product Price Vendor Break – or update if it already exist one with that Break Value

|-
| Break Value
| BreakValue
| Used to determine if the product price vendor break already exists or it must be created

|-
| List Price
| PriceList
| Inserted or updated price list amount (it's taking into account depending on the parameter Import List Price)

|-
| Standard Price
| PriceStd
| Inserted or updated price standard amount (it's taking into account depending on the parameter Import Standard Price)

|-
| Limit Price
| PriceLimit
| Inserted or updated price limit amount (it's taking into account depending on the parameter Import Limit Price)

|-
| UOM EDI X12 Code
| X12DE355
| UOM Code – not used – to be used in future if price list by UOM is implemented

|}