Adempiere/Processes/Import/PriceList

From WikiQSS

Description of column in Price List Importer.

Column DB ColumnName 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