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 |