View source | Discuss this page | Page history | Printable version   

CloudERP IDL Price Lists

Introduction

Price lists are the different prices products can have. These prices are grouped by price lists.

Input file definition

Field name Type Nullable Description Accepted values Comment
Organization String(40) No Indicates the organization to be used when processing documents. [Organization search key]
PriceListName String(60) No A unique identifier for a Price List. [Price List name] If it does not exists any price list with this name, a new price list will be created with this name. If it exist the price list will be used (not updated).
IsDefault Boolean Yes Indicates if the prices list is the default. {'TRUE', 'FALSE'}
IsTaxInc Boolean Yes Indicates if the prices include tax. This is also known as the gross price. {'TRUE', 'FALSE'}
IsSales Boolean Yes Indicates if this price list is used for sales transactions or purchase. {'TRUE', 'FALSE'}
Currency String(32) No* Indicates the currency to be used when processing this document. [Currency ISO code]
EnforcePriceLimit Boolean Yes Indicates that prices cannot be below the limit price in Orders. Invoices are not checked. {'TRUE', 'FALSE'}
PriceListVersionName String(60) No A non-unique identifier for a Price List Version. [Price List Version name] If it does not exists any price list version with this name, a new price list version will be created with this name. If it exist, the price list version will be used (not updated).
DiscountSchema String(60) No* After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. [Discount Schema name]
ValidFrom Date No The Valid From date indicates the first day of a date range. yyyy-MM-dd format. yyyy-MM-dd format.
BasePriceListVersion String(60) Yes The Base Price List identifies the Base Pricelist used for calculating prices (the source). [Price List Version name]
ProductName String(60) No A non-unique identifier for a Product. [Product search key] If it does not exists the process will not pass the validation. If a product and the price list version exist the prices will be updated.
ListPrice BigDecimal Yes Is the official price stated by the selected pricelist and the currency of the document. Decimal separator = . If null, database default value = 0.0
StandardPrice BigDecimal Yes Indicates the standard or normal price for a product on this price list Decimal separator = . If null, database default value = 0.0
PriceLimit BigDecimal Yes Indicates the lowest price for a product stated in the Price List Currency. Decimal separator = . If null, database default value = 0.0

* This fields can be NULL if they have a default value associated.

Default Value definition

Field name Type Accepted values Examples
Organization String(40) [search_key] column from [AD_Org] table
Currency String(3) [iso_code] column from [c_currency] table EUR, USD, GBP, ...
IsTaxIncluded Boolean TRUE / True / true / FALSE / False / false True


IsSalesPriceList Boolean TRUE / True / true / FALSE / False / false True
EnforcePriceLimit Boolean TRUE / True / true / FALSE / False / false True
DiscountSchema String(60) [name] column from [m_discountschema] table Discount Schema 2006
BasePriceListVersion String(60) [name] column from [m_pricelist_version] table Mafalda Sales
IsDefault Boolean TRUE / True / true / FALSE / False / false True

Retrieved from "http://wiki.openbravo.com/wiki/CloudERP_IDL_Price_Lists"

This page has been accessed 734 times. This page was last modified on 18 June 2014, at 08:58. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.